This course introduces participants to the critical task of planning and implementing database backup and recovery strategies. The class addresses backup and recovery techniques and examines various backup, failure, restore, and recovery scenarios.In hands-on exercises participants examine backup methodologies based on business requirements in a mission critical enterprise. Participants utilize multiple strategies and Oracle tools such as Recovery Manager to perform backups, and restore and recovery operations.
Course Objectives:
Configure a standby database to minimize primary database down-time
Diagnose and troubleshoot database problems and failures
List the key issues involved when defining an effective backup and recovery strategy
List the components of the recovery manager architecture
List the different Oracle backup methods and use appropriate restore and recovery operations to resolve database failure (complete and incomplete recovery)
Develop confidence of recovery techniques through various workshop scenarios
List the Oracle architecture components related to backup and recovery operations
Implement different types of backup methods using the various Oracle database tools (e.g. physical backups with and without RMAN, and logical backups)
Course Topics:
Backup and Recovery Considerations
Defining business, operational, and technical requirements for a Backup and Recovery Strategy
Understanding the importance of obtaining management concurrence for a Backup and Recovery Plan
Identifying the components of a Disaster Recovery Plan
Listing advantages and disadvantages of possible database configurations that support Recoverability
Discussing the importance of testing a Backup and Recovery Strategy
Oracle Recovery Structures and Processes
Describing the Oracle Processes, File Structures, and Memory Components
Observing the importance of Checkpoints, Redo Logs, and Archives
Multiplexing Control Files and Redo Logs
Describing Bounded Recovery Time
Listing the types of failure that may occur in an Oracle Database Environment
Describing the structures for Instance and Media Recovery
Describing the concept of Deferred Transaction Recovery Parallelism on Demand
Oracle Backup and Recovery Configuration
Configuring a database in Noarchivelog Mode
Configuring a database in Archivelog Mode
Configuring Multiple Archival (of Redo Log) Processes
Remote Archival of Redo Logs
Performing Manual Archive of Log Files
Enabling/Disabling Automatic Archiving
Configuring multiple Archival Destinations and Processes
Physical Backup Without RMAN
Describing the recovery implications of Closed and Opened Database Backups
Performing backup of Closed Database
Performing backup of Opened Database in Archivelog Mode
Identifying the backup implications of Operations with
Performing backup of Control Files using Different Methods
Discussing backup Issues Associated with
Listing the Data Dictionary Views useful for Backup Operations
Complete Recovery of an Oracle Database
Noting implications of media failure with a database in Noarchivelog Mode
Recovering (Restoring) a database in Noarchivelog Mode after Media Failure
Noting implications of Instance Failure with an Archivelog Mode Database
Describing a Complete Recovery Operation
Performing recovery of a database in Archivelog Mode after Media Failure
Incomplete Recovery of an Oracle Database with Archiving
Identifying the situations to use an Incomplete Recovery to Recover the Database
Performing an Incomplete Database Recovery
Recovering after Losing Current and Active Redo Log Files
Describing and Performing a Tablespace-Point-in-Time Recovery
Oracle Export/Import Utilities
Using the Export Utility to create a Complete Logical Backup of a Database Object
Using the Export Utility to create an incremental backup of a Database Object
Invoking direct-path method export
Export and Transportable Tablespaces
Using the Import Utility to Recover a Database Object
Additional Recovery Issues
Starting Oracle with Missing Data Files
Parallelizing Recovery Operation
Recovering Read-Only Tablespaces
Recovering from Loss of Control Files
Recovering with Missing Data Files Backup
Oracle Utilities for Troubleshooting
Early detection of block corruption
Using DBMS_REPAIR for recovering a Table/Index with Block Corruption
Using the DBVERIFY utility to validate the structure of an Oracle Database File
Using LOGMINER to analyze the Log Files
Configuring Checksum Operations
Using Log and Trace Files to diagnose problems associated with Backup and Recovery Operations
Oracle Recovery Manager Architecture
Components of RMAN
Advantages of RMAN
Command interface to Stop and Start Database
Content of Recovery Catalog
Media Management Layer and Tape Catalog
Connecting to Recovery Manager
Oracle Recovery Catalog Maintenance
Creating a Recovery Catalog
Using Recovery Manager to register, resynch, and reset a database
Maintaining the Recovery Catalog using change, delete, and catalog Commands
Querying the Recovery Catalog to generate reports and lists
Creating and Executing scripts to perform Backup and Recovery Operations
Creating, storing, and running scripts
Physical Backups Using RMAN
Identifying types of RMAN Backups
Describing backup concepts using RMAN
Performing Incremental and Cumulative Backups
Troubleshooting Backup Problems
Viewing Information from the Data Dictionary
Restore and Recover Using RMAN
Restoring a Database in Noarchivelog Mode
Restoring a Tablespace in an Opened Database
Relocation of Data Files: Recovering from Disk Corruption
Incomplete Recovery of a Database
Oracle Standby Database
Explaining the use of a Standby Database
Configuring Initialization Parameters
Creating, maintaining, and activating a Standby Database
Understanding the effects of changing the structure of the Primary Database
Observing the impact of Nologging Actions on the Primary Database
Listing the steps to configure the Archival to a Standby Database
Configuring to have Sustained Recovery of Standby Database
Describing the steps to setup the Standby Database in Read-Only Mode
