OCP 12c – 1Z0-063

Backup and Recovery

Oracle Data Protection Solutions

  • Explain Oracle backup and recovery solutions
    • Describe types of database failures – POST I
    • Describe the tools available for backup and recovery tasks  – POST I
    • Describe RMAN and maximum availability architecture – POST I
    • Use the SYSBACK privilege – POST I
    • Use RMAN stand-alone and job commands – POST I

Configuring for Recoverability

  • Configure and manage RMAN settings
    • Configure persistent settings for RMAN – POST I
    • View persistent settings – POST I
    • Specify a retention policy – POST I
  • Configure the Fast Recovery Area
    • Explain the Fast Recovery Area – POST I
    • Configure the Fast Recovery Area – POST I
  • Configure control files and redo log files for recoverability
    • Multiplex control files – POST I
    • Multiplex redo log files – POST I

Implementing Backup Strategies

  • Use various RMAN backup types and strategies
    • Enable ARCHIVELOG mode – POST I
    • Create tape and disk based backups 
    • Create whole database backups – POST II
    • Create consistent and inconsistent backups – POST I , POST II
    • Create backup sets and image copies – POST I
    • Create backups of read-only tablespaces – POST I
    • Employ best practices for data warehouse backups – POST I

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

  • Use techniques to improve backups
    • Create compressed backups – POST I
    • Create multi-section backups of very large files – POST I
    • Create proxy copies – POST I
    • Create duplexed backup sets – POST I
    • Create backups of backup sets – POST I
    • Create archival backups – POST I
  • Perform backup of non-database files
    • Back up a control file to trace – POST I
    • Back up archived redo log files – POST I
    • Back up ASM diskgroup metadata – POST I

Diagnosing Failures

  • Describe the Automatic Diagnostic Workflow
    • Use the Automatic Diagnostic Repository – POST I
    • Use ADRCI – POST I
    • Find and interpret message output and error stacks
    • Use the Data Recovery Advisor – POST I
  • Handle block corruption
    • Detect block corruption using RMAN – POST I
    • Perform block recovery using RMAN – POST I

Recovering Files Using RMAN

  • Perform recovery for spfile, control file, redo log files – POST I , POST II
  • Perform table recovery from backups – POST I
  • Perform recovery of index and read-only tablespaces, temp file
  • Restore a database to a new host – POST I

Using Flashback Technologies

  • Describe the Flashback technologies
  • Use Flashback to query data
    • Use Flashback Query – POST I
    • Use Flashback Version Query – POST I
    • Use Flashback Transaction Query – POST I
    • Flash back a transaction – POST I 
  • Perform Flashback Table operations
    • Perform Flashback Table – POST I
    • Restore tables from the recycle bin – POST I
  • Describe and use Flashback Data Archive
    • Use Flashback Data Archive – POST I
    • Use DBMS_FLASHBACK_ARCHIVE package – POST I

Transporting Data

  • Describe and use transportable tablespaces and databases – POST I, POST II, POST III, POST IV, POST V
    • 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 – POST I
    • Diagnose performance bottlenecks – POST I
    • Tune RMAN backup performance – POST I

Creating Multitenant Container and Pluggable Databases

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 – POST I
  • Recover PDB from PDB datafiles loss – 
  • Use Data Recovery Advisor – POST I
  • Duplicate PDBs using RMAN – POST I

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

  • Use Data Pump – POST I, POST II
  • Use SQL*Loader – POST I
  • Audit operations – POST I
  • Use Other Products with CDB and PDBs – Database Vault, Data Guard, LogMiner – 

Performing Basic Backup and Recovery

  • Back up and recover a NOARCHIVELOG database – POST I
  • Perform backup and recovery in NOARCHIVELOG mode – POST I
  • Use SQL in RMAN – POST I

Using the RMAN Recovery Catalog – POST I

  • Create and use an RMAN recovery catalog
    • Configure a recovery catalog
    • Register target databases in a recovery catalog
    • Catalog additional backup files
    • Resynchronize a recovery catalog
    • Use and maintain RMAN stored scripts
    • Upgrade and drop a recovery catalog
  • Protect the RMAN recovery catalog
    • Back up the recovery catalog
    • Re-create an unrecoverable recovery catalog
    • Export and import the recovery catalog

Performing Backups

  • Perform full and incremental backups
    • Create full and incremental backups – POST I ,POST II
    • Use the Oracle-suggested backup strategy – POST I
  • Manage backups
    • Configure and monitor block change tracking – POST I
    • Report on backups using LIST, REPORT commands – POST I
    • Manage backups using CROSSCHECK, DELETE commands – POST I

Using RMAN-Encrypted Backups

  • Create RMAN-encrypted backups – POST I, POST II
    • Use transparent-mode encryption
    • Use password-mode encryption
    • Use dual-mode encryption
    • Restore encrypted backups

Performing Restore and Recovery Operations

  • Describe and tune instance recovery – POST I
  • Perform complete and incomplete recovery – POST I, POST II
    • Use RMAN RESTORE and RECOVER commands – POST I
    • Restore ASM disk groups – POST I
    • Recover from media failures – POST I
    • Perform complete and incomplete or “point-in-time” recoveries using RMAN – POST I POST II , POST III

Using Oracle Secure Backup

  • Configure and use Oracle Secure Backup – 

Using Flashback Database

  • Perform Flashback Database – POST I
    • Configure Flashback Database
    • Perform Flashback Database

Duplicating a Database

  • Choose a technique for duplicating a database – POST I
    • From an active database, connected to the target and auxiliary instances
    • From backup, connected to the target and auxiliary instances
    • From backup, connected to the auxiliary instance, not connected to the target, but with recovery catalog connection
    • From backup, connected to the auxiliary instance, not connected to the target and the recovery catalog
    • Duplicate a database with RMAN
  • Create a backup-up based duplicate database – POST I, POST II
  • Duplicate a database based on a running instance – POST I, POST II

Managing Pluggable and Container Databases

Multitenant Container and Pluggable Database Architecture
  • Describe the multitenant container database architecture – POST I, POST II
  • Explain pluggable database provisioning – POST I, POST II

Managing a CDB and PDBs

  • Establish connections to CDB/PDB – POST I
  • Start up and shut down a CDB and open and close PDBs – POST I
  • Evaluate the impact of parameter value changes

Managing Security in a CDB and PDBs

  • Manage common and local users – POST I
  • Manage common and local privileges –POST I
  • Manage common and local roles – POST I
  • Enable common users to access data in specific PDBs – POST I

Managing Performance

  • Monitor operations and performance in a CDB and PDBs
  • Manage allocation of resources between PDBs and within a PDB – POST I
  • Perform Database Replay – POST I