Database Reference
In-Depth Information
Step 4: Backup the Control File
Control file can be backed up using the following statement and
at the desired location.
ALTER DATABASE BACKUP CONTROLFILE TO 'c:\staging\ctl.bak';
The backup created in this fashion will be the binary copy of the
control file. We can also take the backup of control file, which
will be in text format in the following manner.
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
As a result of this statement the text version of control file will
get
copied
to
the
location/folder
specified
in
USER_DUMP_DEST init.ora parameter.
Note: It's recommended to backup Archived Redo Log files,
Redo log files and parameter file to get a complete database
backup.
User-Managed Complete Recovery
User-Managed Complete Recovery is done in two different ways
and it all depends on the mode in which you are running the
Oracle server. You can run Oracle server either in
ARCHIVELOG mode or NOARCHIVELOG mode.
The way we do the recovery in NOARCHIVELOG mode is
different from the way we do recovery in ARCHIVELOG mode.
Let's have a look on each procedure as follows.
Search WWH ::
Custom Search