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
    • Use RMAN stand-alone and job commands

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
    • Multiplex redo log files

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 IPOST II
    • Create backup sets and image copies – 
    • Create backups of read-only tablespaces – 
    • 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
    • Create multi-section backups of very large files – POST I
    • Create proxy copies
    • Create duplexed backup sets – POST I
    • 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 – POST I
    • Use ADRCI
    • 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 IPOST II
  • 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 – POST I
    • Tune RMAN backup performance – POST I

Creating Multitenant Container and Pluggable Databases

  • Configure and create a CDB – POST I
  • Create a PDB using different methods – POST IPOST II
  • Unplug and drop a PDB – POST I
  • 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 – POST I
  • Duplicate PDBs using RMAN

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

  • Use Data Pump – POST IPOST 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

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
    • 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 – 
    • Recover from media failures – POST I
    • Perform complete and incomplete or “point-in-time” recoveries using RMAN – POST I POST IIPOST III

Using Oracle Secure Backup

  • Configure and use Oracle Secure Backup

Using Flashback Database

  • Perform Flashback Database
    • Configure Flashback Database
    • Perform Flashback Database

Duplicating a Database

  • Choose a technique for duplicating a database
    • 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
  • Duplicate a database based on a running instance

Managing Pluggable and Container Databases

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

Managing a CDB and PDBs

  • Establish connections to CDB/PDB
  • 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
  • Perform Database Replay
Esse Blog é reconhecido pela
Sou um
Certificações
Sou articulista

Clique para seguir este blog e receber notificações via email de novos posts.

Tércio Costa

Tércio Costa

Meu nome é Tércio Costa, sou formado em Ciências da Computação pela UFPB, tenho a certificação OCA 12c, Oracle SQL Expert e OCP PL/SQL, mantendo um blog reconhecido pela OTN(oraclepress.wordpress.com), no qual também publico artigos técnicos no portal OTN, no portal http://www.profissionaloracle.com.br/gpo e na revista SQL Magazine. Além de tudo isto sou um Oracle ACE por estar sempre contribuindo para a comunidade com um bom nível de expertise.

Links Pessoais

Serviços verificados

Visualizar Perfil Completo →

Total de Visualizações da Página
  • 180.683 Visualizações
%d blogueiros gostam disto: