Database Reference
In-Depth Information
'C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF',
'C:\ORACLE\ORADATA\ORCL\USERS01.DBF',
'C:\ORACLE\ORADATA\ORCL\REVEAL_DATA_01.DBF',
'C:\ORACLE\ORADATA\ORCL\REVEAL_INDEX_01.DBF',
'C:\ORACLE\ORADATA\ORCL\USERS02.DBF'
CHARACTER SET WE8MSWIN1252;
You will notice that this output includes the data file names, the location and names of
the online redo logs, and other information needed by the
CREATE CONTROLFILE
command.
The trace file contains other output that will be required to complete the recovery process,
so you should back up the trace file as it is. In Chapter 2, we will address the process of
recovering from a control-file loss using the output contained in the trace files.
Exam objectives are subject to change at any time without prior notice and
at Oracle's sole discretion. Please visit Oracle's Training and Certification
website (
http://www.oracle.com/education/certification/)
for the
most current exam-objectives listing.
Summary
Backups in Oracle can be a big deal. There are a number of different situations you will find
yourself in, and finding a strategy to use depends on your knowledge of how to do backup
and recovery. That's why the OCP exam has a great deal of backup and recovery focus.
We started this chapter introducing you to the Oracle architecture. This knowledge is criti-
cal to understanding what is required for any kind of Oracle database backup and recovery.
At the time we wrote this topic, the Oracle 12
c
OCP exam contents with respect to
manual backups and recovery specifically say “Backup and recover a NOARCHIVELOG
database.”
In this chapter we covered that particular topic in depth.
Then, we moved a little deeper to give you a firm understanding of more complex backup
procedures, such as online backups and point-in-time recovery. We did this because later
chapters will be discussing these kinds of backups and restores in the context of Oracle's
backup tool called Recovery Manager (RMAN). You will understand RMAN operations
much better if you understand the basic things that Oracle does under the covers to facilitate
database recovery.
It is probably clear to you that recovery in Oracle can be quite complex. It becomes even
harder when you are actually doing it under the gun, when people are breathing down your
neck to get that database up. So, build your skills in this area now. They will serve you well
in the future.
Search WWH ::
Custom Search