• Online, Self-Paced
Course Description

Numerous issues, such as media failures, user errors, and application errors, can cause an Oracle 12c database to become partially or fully inoperable. Because of this, data protection is the main purpose of a backup and recovery strategy. Oracle Database 12c offers RMAN data repair techniques that can be incorporated into backup and recovery strategies to respond to data loss. One of these is the Data Recovery Advisor, which can diagnose, advise, and repair some failures automatically. RMAN also offers block media recovery, point-in-time recovery as well as complete and incomplete recovery. This course will discuss how Data Recovery Advisor is used, how block corruption is handled, and the concepts regarding how various restores and recoveries are performed. This course is one of a series in the Skillsoft learning path that helps prepare the learner for the Backup and Recovery portion of the Oracle exam 1Z0-063, Oracle Database 12c: Advanced Administration.

Learning Objectives

Diagnosing Failures

  • start the course
  • explain the Automatic Diagnostic Repository and workflow
  • identify how to use ADRCI and the V$DIAG_INFO view for ADR information
  • describe how to interpret RMAN message output and error stacks
  • use Data Recovery Advisor in Enterprise Manager Cloud Control to diagnose and repair failures
  • use Data Recovery Advisor RMAN command line to diagnose and repair failures
  • use the Data Recovery Advisor views
  • repair a database failure
  • detect and handle block corruption
  • identify the parameters that can be set to detect block corruption
  • repair block corruption
  • perform block media recovery
  • identify the characteristics of automatic block repair

Practice: Diagnosing and Repairing Failures

  • diagnose database failures and repair them

Restore and Recovery Concepts

  • identify how to recover from a file loss or data failure
  • describe the restore and recover commands
  • describe the phases of instance recovery
  • tune the instance recovery process
  • describe complete and incomplete recovery

Practice: Restoring and Recovering Concepts

  • understand the restore and recovery concepts

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration