Oracle 12c Database Backup and Recovery

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

Lab 1: Configuring the database for backup

Lab 2: Basic Database Media Recovery

Lab 3: Archivelog Setup

Lab 4: Recovery Manager Configuration

Lab 5: Recovery Manager Backups

Lab 6: Database Recovery using RMAN

Lab 7: Flashback Database

Lab 8: Flashback for User Errors

Lab 9: Dealing with Block Corruption