Oracle Database 12c - Backup and Recovery: Perform Recovery and Secure Backup


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/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.

Target Audience
Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures

Prerequisites
none

Expected Duration (hours)
2.1

Lesson Objectives

Oracle Database 12c - Backup and Recovery: Perform Recovery and Secure Backup

  • 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
  • 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
  • perform recovery of a database in a given scenario
  • 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
  • install, configure, and use Oracle Secure Backup
  • Course Number:
    od_bkpr_a04_it_enus

    Expertise Level
    Intermediate