Oracle Cloud Infrastructure Architect Associate exam tests varieties of topics like
- Identity and Access Management
- Networking
- Compute
- Storage
- Database
A good place to learn about the topics are
And there is a book specifically written for the exam and is available in Oreilly
In this blog, I am sharing the notes I have taken for the topic
Database
Database
- Contains two part
- Database instance - running s/w in memory and maintaining structure
- Database file - the persisted file
- Variants
- DBCS
- Autonomous DB
- DBCS
- Variants
- VM DB
- two variants
- 1 Node
- 2 Node RAC - Real Application Cluster
- BareMetal
- Supports only one node
- Exadata
- Supports both 1 and 2 Node
- RAC contains two database instance accessing the same database file
- DataGuard provide physical replication of database file
- Autonomous DB
- Autonomous Data Warehouse
- Autonomous Transaction Processing (ATP)
- Difference between ADW and ATP is ATP contains additional Developer Cloud Service like Java Cloud Service, Container CS etc
- Editions
- Standard Edition (SE)
- Enterprise Edition (EE)
- Enterprise Edition High Performance (EE-HP) - provided by OCI - has options like Multitenant, Partitioning,
- Enterprise Edition Extreme Performance (EE-EP) - provided by OCI - has additional inmemory DB, active DataGuard etc
- ASM - Automatic Storage Management
- has two disk groups
- DATA - used for data file, log file, control file
- RECO - used for recovery related, archive logs
- SPARSE - only in Exa based DB used to store snapshots
- ASM redundancy refers to number of copies
- EXTERNAL - 0 additional copy
- NORMAL - 1 additional copy
- HIGH - 2 additional copy
- Grid Infrastructure -GI Specialized software for supporting DB that uses ASM and RAC
- RMAN - Recovery Manager is used for performing backup, restore and recovery
- DBCS has only 2 redundancy option - NORMAL, HIGH
- DBCS in Baremetal cannot be a RAC
- DBCS in ExaData has redundancy HIGH always and cannot be changed
- Exadata
- Quarter - 2 nodes and 3 storage block
- Half - 4 nodes and 6 storage blocks
- Full - 8 nodes and 12 storage blocks
- Each node in Exadata are connected by infiniband
- Configuring the SPARCE will reduce the storage availability of database file
- a two node RAC requires 10 IP address, so the CIDR should be /28 which gives 16 IPs
- dbcli
- is available only in OIC
- used for creating backups, recover, rotating keys, manage storage, upgrades,
- DBCS Backup
- Two types
- Managed Backup
- Unmanaged Backup
- RMAN or dbcli can be used for taking backups
- backup can be stored in Object store or FRA (Fast Recovery Area) storage
- Licencing
- Named User Plus
- Processor based
- Autonomous
- ATP - tuned for high-volume data access
- ADW - tuned for high-volume data scanning
- ADB Tuning
- statistics
- ADB Administration and Monitoring
- Monitors CPU, Storage Utilization and current SQL getting executed
- Allows
- Download client wallet
- Set resource mgt rules
- manage oracle machine learnign users
- Data Guard
- Both DB system must be in same compartment
- Primary and Secondary should be of same shape and type
- The Database version etc should be same
- can be configured in different modes
- maximum performance
- maximum protection
- maximum availability
- Migration methods
- Zero Downtime Migration (ZDM),
- Maximum Availability Architecture (MAA), - APPLICABLE FOR ADW, ATP
- Data Pump - APPLICABLE FOR ADW, ATP
- SQL Developer, - APPLICABLE FOR ADW, ATP
- Data Transfer Service (discussed earlier),
- RMAN,
- Remote Cloning
- Plug/Unplug
No comments:
Post a Comment