Course Content
BACKUP AND RECOVERY CONSIDERATIONS
- Plan and Implement a Backup and Recovery Strategy
- Define a Disaster Recovery Plan
- Test a Backup and Recovery Plan
- Advantages and Disadvantages of Different Backup Methods
- Data Recovery Strategy
- Backup Strategy
- Validate the Recovery Strategy
ORACLE RECOVERY STRUCTURES AND PROCESSES
- Architectural Components of Backup and Restore
- Redo logs, Checkpoints and Archives
- Multiplexing Control files and Redo Logs
- Types of Failure in an Oracle Database
- Flash Recovery Area
USING ARCHIVELOG AND NOARCHIVELOG MODES
- The Archive Modes of a Database
- Configure a Database in Archivelog Mode
- Configure a Database in Noarchivelog Mode
- Configure Multiple Redo Log Archive Processes
- Configure Multiple Archival Destinations
FLASHBACK
- Configure and Use Flashback Database
- Monitor Flashback Database
- Flash Recovery Area Space Usage
- Flashback Query
- Retrieve Row History with Flashback Versions Query
- Audit or Recover From Transactions with Flashback Transactions Query
- Flashback Table
- Recover Dropped Tables with Flashback Drop
- The Recycle Bin
- Recover Tables to a Point In Time With Flashback Table
- Flashback Database
- Flashback Restore Points
- Flashback Transaction Backout
- Oracle Total Recall
RECOVERY MANAGER OVERVIEW
- RMAN Features and Components
- Connect to RMAN
- Start Up and Shut Down a Target Database Using RMAN
CREATE AND CONFIGURE A RECOVERY CATALOG
- Create a Recovery Catalog
- Register a Database
- Unregister a Database
- Control File Information
- RESYNC CATALOG Command
- Virtual Private Catalogs
- Merge Catalogs
- Backup a Recovery Catalog
- Use a Flashback Recovery Area
- Configure Persistent RMAN Settings
- Set Retention Policies
- Configure Control File Autobackups
BACKUP WITH RMAN
- Channel Allocation
- Types of RMAN Backup
- Backup Commands
- Backup Sets Parallelization
- Compressed Backups
- Performing Backups
- Full Closed and Open Backups
- Incremental and Cumulative Backups
- The Copy Command
- Block Change Tracking
- Backup Validate
- Troubleshooting
CREATE A DUPLICATE DATABASE WITH RMAN
- Database Duplication
- Duplication Options
- Create Files for the Duplicate Database
- Prepare the Auxiliary Instance for Duplication
- Create a Duplicate Database
- Create a Duplicate Database with Enterprise Manager
- Clone a Running Database
- Use EM to Clone a Running Database
- Targetless Duplication of a Database
MAINTAIN A RECOVERY CATALOG
- Reset Command
- Change the Availability Status of Backups and Copies
- Catalog Backups Made with Operating System Commands
- Generate Reports and Lists
- Cross Check Backups and Copies
- Delete Backups
- Update the Repository after Backup Deletion
- Drop Database and Archival Backups
- Use Data Dictionary Tables
RESTORE AND RECOVER WITH RMAN
- Perform Recovery in Noarchivelog Mode
- Perform Complete Recovery in Archivelog Mode
- Perform Incomplete Recovery
- Use the Flash Recovery Area for Fast Recovery
- Restore and Recover a tablespace
- Automatic Tempfile Recovery
- Restore and Recover Datafiles
- Recover a Datafile Not Backed Up
- Restore the Server Parameter File
- Restore the Control File from Auto-Backup
- Restore and Recover the Database on a New Host
MONITOR, TUNE AND TROUBLESHOOT BACKUP AND RECOVERY
- Tune recovery Manager Overview
- Tune RMAN Backup Performance
- Instance Recovery Performance Tuning
- Understand RMAN Output Messages
- Troubleshoot RMAN
