• Online, Self-Paced
Course Description

When a failure occurs within an Oracle 12c database, a restore or recovery operation needs to take place. Using RMAN restore operations database, you can restore tablespaces, control files, redo log, and the server parameter file if they are corrupted or lost within the database. This course will discuss and show how to perform the different types of restore operations, including when the database is in ARCHIVELOG or NOARCHIVELOG mode. It will also show how to recover from the loss of control files and password files, redo log files, as well as how to restore a database to a new host and perform disaster recovery. This course will also describe what Oracle Secure Backup is and how it can be integrated with RMAN to perform backups and restores. 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

Performing Recovery

  • start the course
  • identify the commands that can be used to verify backups are available
  • restore in NOARCHIVELOG mode
  • perform complete recovery
  • recover from the loss of a data file in ARCHIVELOG mode
  • restore ASM disk groups
  • recover image copies of a database
  • perform point-in-time recovery
  • perform incomplete recovery

Performing Advanced Recovery

  • recover from the loss of an spfile
  • recover from a control file failure
  • recovering from the loss of a control file and from all control files
  • recover from the loss of a redo log file
  • recover from the loss of a redo log group
  • recreate the password authentication file
  • recover index and read-only tablespaces
  • describe the procedure to restore a database to a new host
  • describe disaster recovery
  • restore an encrypted backup

Practice: Performing Database Recovery

  • perform recovery of a database in a given scenario

Oracle Secure Backup

  • describe RMAN and OSB integration
  • install Oracle Secure Backup
  • configure OSB for RMAN
  • perform and manage tape backups
  • configure OSB and perform a backup to tape

Practice: Installing and Configuring OSB

  • install, configure, and use Oracle Secure Backup

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.