Oracle 12c Database Backup and Recovery 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.

    No classes are currenty scheduled for this course.

    Call (919) 283-1653 to get a class scheduled online or in your area!

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
  • 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

  • Block media recovery
  • Using RMAN for block corruption recovery

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • Backup and recover the database
  • Monitor, troubleshoot, and maintain the database
  • Configure and use recovery manager

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

  • Knowledge of SQL
  • Database administrators
  • Support engineers
  • Technical consultants
  • Systems administrators
  • Network managers

Ready to Jumpstart Your IT Career?