Database Reference
In-Depth Information
SQL>connect / as sysdba
SQL>startup mount;
Step 5: 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.
Step 6: Open the database
Now you have full database backup or in other words Whole
Database Backup. It's time to make the database available to the
users you executing the following statement.
ALTER DATABASE OPEN;
This completes our User-Managed Offline/Cold Database
Backup. Let's see now how we can perform User-Managed
Online/Hot Database Backup.
User-Managed Online Backup:
The other names given to this kind of backup are viz.,
Open/Hot/Inconsistent database backup. The SCN will be
different in all the backed up data files that's why once you
Search WWH ::
Custom Search