Database Reference
In-Depth Information
Exam Essentials
The following topics are specifically listed as essential test items and part of the content of
the Oracle Database 12 c OCP exam.
Explain Oracle backup and recovery solutions. Understand the different Oracle backup
and recovery solutions. Understand concepts such as multiplexing control files and online
redo logs. Understand various high availability and disaster recovery options that are avail-
able for you to use.
Back up and recover a NOARCHIVELOG database. Understand how to restore and
recover your database in NOARCHIVELOG mode. Understand that you have to shut down
the database and that you have to restore all the data files, the control files, and the online
redo logs from your backup.
The following topics are not specifically listed as essential test items or part of the content
of the Oracle Database 12 c OCP exam. However, these topics are covered in this chapter
because they are key foundational concepts to understanding topics that are covered in the
Oracle Database 12 c OCP exam.
Understand the Oracle Database backup and recovery architecture. Understand the
underlying architecture that the Oracle Database uses to facilitate the backup and recovery
of the physical Oracle Database.
Restore and recover your database to the point of failure in ARCHIVELOG mode.
Understand how to restore and recover your database in ARCHIVELOG mode. Understand
that you can recover the entire database or just a given tablespace or data file. Understand
which recoveries can be done with the database up and which require that the database be
shut down.
Restore and recover your database to a different point in time. Understand how to
perform point-in-time recovery with your database. Understand how to restore the data
files. Understand the types of recovery that are available (time-based, change-based, and
SCN-based). Understand how to use the RECOVER DATABASE command to perform point-
in-time recovery and how to open the database after recovery has been completed.
Recover your database in the event of a lost online redo log. Understand how to recover
your database if you lose an inactive or current online redo log file. Understand the benefit of
using the ALTER SYSTEM CHECKPOINT command if you have lost an online redo log group and
the database is still running. Understand how to use the ALTER DATABASE CLEAR command
to clear unarchived redo log files and to recreate lost online redo log files. Understand the
impacts of losing the current or an active online redo log file.
Recover your database in the event of a lost control file. Understand how to recover
your database if you lose one or more control files. Learn how to recover a lost con-
trol file by using a backup control file. Learn how to recover a lost control file by using
the CREATE CONTROLFILE command contained in the trace file resulting from the ALTER
DATABASE BACKUP CONTROLFILE TO TRACE command.
Search WWH ::




Custom Search