Course Description
This Oracle online training course teaches you how to address Oracle Backup and Recovery issues. You will learn how to perform user managed backups and recoveries as well as Oracle managed backup and recoveries(RMAN).
In This Course You Will Learn:
- Perform User Managed backup and recoveries
- Perform Oracle Managed backup and recoveries
- Configure RMAN
- Create and configure the recovery catalog
Prerequisites
You need to have equivalent experience or have taken the following GogoTraining courses:
Outline
Module 00: Oracle Backup and Recovery Online Training - Course Introduction
Module 01: Backup methods
- User Managed Backups
- Oracle Managed Backups Types of Failures
- Types of Recoveries
Module 02: Recovery Configuration
- Configuring the Database for Archivelog
- Configuring the Database for No-Archivelog
- Configuring the Flash Recovery Area
Module 03: Configuring RMAN
- RMAN Default Settings
- Command Line
- Enterprise Manager
Module 04: RMAN Backups
- Full RMAN Backup
- Compressed Backups
- Uncompressed Backups
- Partial RMAN Backup
- Incremental Backups
- Change Tracking File
Module 05: Managing Backups
- Backup Reports
- Backup Maintenance
- Backup Catalog
- Backup Crosscheck
Module 06: RMAN Complete Recovery
- RMAN Complete Recovery
- Database Recovery
- Tablespace Recovery
- Datafile Recovery
Module 07: RMAN In-Complete Recovery
- Time Based Recovery
- Sequence Based Recovery
- SCN Based Recovery
Module 08: Non-Database File Recovery
- Spfile Recovery
- Controlfile Recovery
- Incremental Recovery
- Flash Recovery Area for a Fast Recovery
Module 09: User Managed Backup
- Configuring User Managed Backups
- Perform a User Managed Backup
Module 10: User Managed Recovery
- User Managed Complete Recovery
- User Managed Incomplete Recovery
Module 11: Configuring Flashback
- Flashback Query
- Flashback Drop
- Flashback Database
Module 12: Performing Flashback Recoveries
- Flashback Query
- Flashback Drop
- Flashback Transaction Query
- Flashback Versions Query
Module 13: Performing Flashback Database
- Determining the FRA Size
- FRA Retention
- Performing a Flashback Database
Module 14: RMAN Duplicate Command
- Setting up for a Duplicate Database
- Creating the Duplicate spfiles
- Performing the Duplicate Command.
Module 15: RMAN Recovery Catalog
- Configuring for the Recovery Catalog
- Creating the Recovery Catalog
Module 16: Backups with the Recovery Catalog
- Registering the Database with the Recovery Catalog
- Performing Backups with the Recovery Catalog
Module17: Recoveries with the Recovery Catalog
- Identifying Type of Recoveries with the Recovery Catalog
- Performing Recoveries with the Recovery Catalog
Module 18: Recovery Catalog Maintenance
- Registering Additional Databases with the Recovery Catalog
- Cataloging Additional Backups with the Recovery Catalog
- Recovery Catalog Scripts
Module 19: DataPump
- Configuring Datapump
- DataPump Exports
- DataPump Imports
Module 20: Tuning RMAN
- RMAN Sessions
- RMAN Channels
- RMAN Job Progress
Module 21: Oracle Backup and Recovery Online Training - Course Summary