Oracle 12c: Database Backup and Recovery

Live Online & Classroom Enterprise Training

Location: Bangalore, India | Dubai, UAE

Industry Experienced Instructor  |  Remote Labs  |  Lab Access Post Training

Need help finding the right training?

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