Database Reference
In-Depth Information
We discussed Oracle's strategy for data warehouse backups. This strategy provides the
ability to just perform one full database backup and then forever after you perform incre-
mental backups of the database, which are used to update the database backup itself.
We also talked about Oracle Secure Backup, which is a new topical area in the Oracle
Database 12 c OCP exam. We discussed downloading, installing, and configuring OSB.
We also discussed tablespace point-in-time recovery, which is a very powerful feature
provided by Oracle RMAN.
Oracle 12 c provides the ability to recover tables and partitions from RMAN backups.
We discussed that in detail in this chapter. This feature alone might well remove the need
to have regular Data Pump exports of your database for backup purposes.
We then moved on to discuss backup considerations of ASM metadata. We showed you
how to back up and restore the ASM metadata. We also discussed Oracle's Data Recovery
Advisor, which can help you to figure out the best way to restore and recover your database.
Finally, we discussed Oracle Multitenant and some of the considerations that you need
to understand with respect to backup and recovery through RMAN. We also discussed
Oracle Data Pump with respect to Oracle Multitenant.
Exam Essentials
Describe database incarnations. Understand how to use the SET DATABASE INCARNATION
command. Know what a database incarnation is and when a given incarnation changes.
Describe database duplication. There are two kinds of database duplication, active and
backup-based. Understand that when you use backup-based duplication: the backup set
pieces must be available on the host to which you are duplicating. Understand that active
database duplication occurs over the network. Know how to set up for database duplication.
Describe tablespace point-in-time recovery. Be able to list the benefits of tablespace
point-in-time recovery. Understand how to perform a tablespace point-in-time recovery
and what the restrictions are.
Describe disaster-recovery basics. Understand how to restore a system from a complete
disaster using both RMAN-based backup sets and user-managed recovery.
Describe Oracle Database 12 c multitenant operations with respect to backup and recovery.
Understand how to use RMAN to back up and restore Oracle Database 12 c multitenant
databases including CDBs and individual PDBs.
Duplicate multitenant databases with RMAN. Understand how to duplicate an entire CDB
or one or more PDBs to another CDB using RMAN.
Describe Oracle Database 12 c multitenant operations with respect to Oracle Data Pump.
Understand how to use Oracle Data Pump to export PDBs and how to use Oracle Data
Pump to import into PDBs.
Search WWH ::




Custom Search