What you should know to pass this test:
Know the background processes and structures Oracle uses in
backup and recovery. Know how archiving works and what are the backup and
recovery implications of the two archiving methods. Know how to change a
database from one archiving method to the other.
Understand the purposes and features of the Recovery Manager
(RMAN). Know how to set it up, configure it, its commands, and its advantages
and limitations.
Know how to maintain an RMAN catalog database and what
commands are used to register new files with RMAN. Also know what commands are
used to register a database with RMAN and to resync RMAN with a target database
after incomplete recovery of a target database.
Be able to perform recoveries under a wide variety of
conditions:
- With and without RMAN
- With NOARCHIVELOG and ARCHIVELOG
mode databases
- With the database closed or open
- For a full database or
just a tablespace or a data file
- For the SYSTEM tablespace
- With
an archive log missing
- Up to the last committed transaction
- To any prior
point in time
Understand the in's and out's of all
recovery approaches and when and how to use them. Know the dictionary views
pertaining to backup and recovery and what they can tell you.
Understand the uses and differences between DBVERIFY,
LogMiner, DBMS_REPAIR, ANAYLZE, and checksum settings. Know how fast-start and
parallel recovery features work. Know how to start an Oracle database that is
missing a data file and how to recover from lost or corrupted control
files.
Be able to state the advantages and disadvantages of doing
logical backups and recoveries with the Export and Import utilities. Know all
the key parameters to these utilities, how to run them, and when to use them.
Understand the purposes and uses of a Standby database. Know
the modes in which this database runs and when each mode is appropriate and how
to switch between them.
Email this Article
Print this Article
