Backup and Recovery

Oracle Data Protection Solutions

• Explain Oracle backup and recovery solutions

  • Describe types of database failures

  • Describe the tools available for backup and recovery tasks

  • Describe RMAN and maximum availability architecture

  • Use the SYSBACK privilege

  • Use RMAN stand-alone and job commands

Configuring for Recoverability

• Configure and manage RMAN settings

  • Configure persistent settings for RMAN

  • View persistent settings

  • Specify a retention policy

• Configure the Fast Recovery Area

  • Explain the Fast Recovery Area

  • Configure the Fast Recovery Area

• Configure control files and redo log files for recoverability

  • Multiplex control files

  • Multiplex redo log files

Implementing Backup Strategies

• Use various RMAN backup types and strategies

  • Enable ARCHIVELOG mode

  • Create tape and disk based backups

  • Create whole database backups

  • Create consistent and inconsistent backups

  • Create backup sets and image copies

  • Create backups of read-only tablespaces

  • Employ best practices for data warehouse backups

Configuring RMAN Backup Options and Creating Backup of Non-Database Files

• Use techniques to improve backups

  • Create compressed backups

  • Create multi-section backups of very large files

  • Create proxy copies

  • Create duplexed backup sets

  • Create backups of backup sets

  • Create archival backups

• Perform backup of non-database files

  • Back up a control file to trace

  • Back up archived redo log files

  • Back up ASM diskgroup metadata

Diagnosing Failures

• Describe the Automatic Diagnostic Workflow

  • Use the Automatic Diagnostic Repository

  • Use ADRCI

  • Find and interpret message output and error stacks

  • Use the Data Recovery Advisor

• Handle block corruption

  • Detect block corruption using RMAN

  • Perform block recovery using RMAN

Recovering Files Using RMAN

• Perform recovery for spfile, control file, redo log files

• Perform table recovery from backups

• Perform recovery of index and read-only tablespaces, temp file

• Restore a database to a new host

Using Flashback Technologies

• Describe the Flashback technologies

  • Configure a database to use Flashback technologies

  • Guarantee undo retention

• Use Flashback to query data

  • Use Flashback Query

  • Use Flashback Version Query

  • Use Flashback Transaction Query

  • Flash back a transaction

• Perform Flashback Table operations

  • Perform Flashback Table

  • Restore tables from the recycle bin

• Describe and use Flashback Data Archive

  • Use Flashback Data Archive

  • Use DBMS_FLASHBACK_ARCHIVE package

Transporting Data

• Describe and use transportable tablespaces and databases

  • Transport tablespaces between databases using image copies or backup sets

  • Transport databases using data files or backup sets

  • Transport data across platforms

Monitoring and Tuning of RMAN Operations

• Tune RMAN performance

  • Interpret RMAN error stacks

  • Diagnose performance bottlenecks

  • Tune RMAN backup performance

Creating Multitenant Container and Pluggable Databases

• Configure and create a CDB

• Create a PDB using different methods

• Unplug and drop a PDB

• Migrate a non-CDB database to PDB

Managing Storage in a CDB and PDBs

• Manage permanent and temporary tablespaces in CDB and PDBs

Managing Availability

• Perform backups of a CDB and PDBs

• Recover PDB from PDB datafiles loss

• Use Data Recovery Advisor

• Duplicate PDBs using RMAN

Moving Data, Performing Security Operations and Interacting with Other Oracle Products

• Use Data Pump

• Use SQL*Loader

• Audit operations

• Use Other Products with CDB and PDBs - Database Vault, Data Guard, LogMiner