Course Details
In this course, you’ll learn about backup and recovery techniques, which includes hands-on exercises to reinforce the material covered. This course is designed to help you prepare you for the Oracle Certified Associate and Oracle Certified Professional exams.
Course Prerequisites
- Knowledge of SQL
Course Agenda
1. Backup and Recovery Concepts
- Describe the basics of database backup, restore, and recovery
- List the types of failure that may occur in an Oracle database
- Describe ways to tune instance recovery
- Identify the importance of checkpoints, redo log files, and archived log file
- Configure ARCHIVELOG mode
- Flashback Database / Table / Query
2. Database Backups
- Create consistent database backups and incremental backups
- Automate database backups
- Monitor the flash recovery area
- Back your database up without shutting it down
3. Database Recovery
- Recover from loss of a control file, a redo log file, data files, temp files and undo tablespaces
4. Recovery Manager Configuration
- Parameters affecting RMAN
- Use of a flashback recovery area
- The CONFIGURE command
- Persistent settings
- NOCATALOG / CATALOG mode
- Channel allocation
- Controlfile autobackup
- Retention policies
5. Recovery Manager Operations
- Using the BACKUP command
- Creating backup sets / image copies
- Parallelization
- Compressed backups
- Whole database copying
- Incremental backups
- Block change tracking
- RMAN backup monitoring
- REPORT and LIST commands
6. Non-Critical Loss Recovery
- Password and network files
- Read-Only tablespaces
- Temporary tablespaces
- Index tablespaces
- Redo log members / control files
7. Database Recovery
- Recovering the control file
- Reasons for incomplete recovery
- Recovery after RESETLOGS
- Incomplete recovery using RMAN
- Incomplete recovery using SQL
8. Flashback Database
- When to use
- Configuration and use
- Monitoring flashback database
- Flash recovery area maintenance
- Flash recovery area monitoring
9. User Error Recovery
- The new recycle bin
- Querying dropped tables
- Flashback versions query
- Flashback transaction query
10. Block Corruption Management
- DBVERIFY and ANALYZE
- DBMS_REPAIR
- Block media recovery
- DBMS_BLOCK_CHECKING parameter
- Using RMAN for block corruption recovery