Loading Course Schedule...
PT5068
Summary
This class will teach the fundamentals of Oracle Real Application Clusters (RAC), Data Guard and RMAN. Students will learn the architecture, installation and configuration of RAC, Data Guard and RMAN. This class is excellent for introducing DBAs started with these key Oracle technologies.
Prerequisites
Students must have a fundamental background in Oracle database administration.
Duration
5 Days/Lecture & Lab
Topics
- High Availability in Oracle 10g
- The Oracle Maximum Availability Architecture (MAA)
- Benefits of MMA
- Introduction to RAC
- RAC features and capability
- The reasons to use RAC
- Oracle10g RAC Architecture
- Enterprise RAC across multiple tiers
- Cluster Ready Services (CRS)
- Services
- Background processes
- Global repository directory
- Shared files
- Raw devices
- Global Enqueue Service
- Global Cache Service
- Minimum requirements
- Installation considerations
- Configuration options
- Cache fusion
- Cluster ready services
- Moving from a single-instance to RAC
- The EM Cluster Database Home Page
- Starting and Stopping RAC Instances
- Configuring RAC Initialization Files
- Adding nodes to a Cluster
- Adding and removing instances from a cluster
- Quiescing RAC Databases
- Managing alerts with OEM
- Automatic Storage Management (ASM)
- Setting up ASM
- Starting and stopping ASM instances
- Managing ASM instances
- Managing ASM with database control
- Managing redo log groups in RAC
- Managing undo tablespaces in RAC
- Use SRVCTL to manage ASM instances
- Migrating database files to ASM
- Manage and recover the OCR file and voting disk
- SRVCTL command options
- OEM features for RAC
- Parameter files versus shared parameter files
- Database Resource Manager
- Fusion Resource States
- Automatic Resource Remastering
- Load Balancing
- The Data Guard Architecture
- Fundamentals of a Physical Standby Database
- Fundamentals of a Logical Standby Database
- Standby database modes
- Working with multiple standby databases
- Log transport and apply
- Log writing process
- No data loss
- No data divergence
- SYNC versus ASYNC transmission
- AFFIRM versus NOAFFIRM
- Redo log reception
- Role Management Services
- Archive log gap detection
- Archive log gap resolution
- Data protection modes
- Configuring Data Guard
- Setting initialization parameters
- Performance tuning Data Guard
- Troubleshooting Data Guard
- The Data Guard Broker architecture
- Data Guard Broker components
- Configuring the Data Guard Broker
- Creating a physical standby database
- Managing a physical standby database
- Physical standby configurations
- Creating a logical standby database
- Managing a logical standby database
- Logical versus physical standby
- Logical standby configurations
- Performing switchover and Failover
- Graceful failover
- Forced failover
- The Recovery Manager architecture
- RMAN fundamentals
- Setting up RAC backup and recovery with RMAAN