COLD BACKUP Explained

July 30, 2012 admin Oracle

Determine the files you will need:
The datafiles:
SQL> select name from v$datafile
The control files:
SQL> select name from v$controlfile
The temp datafiles:
SQL> select name from v$tempfile
The online redo logs:
SQL> select member from v$logfile
The parameter file (spfile):
SQL> show parameter spfile;

Take a few backup precautions:
Backup the control file:
alter database backup controlfile to ‘${CONTROLFILE_DIR}/backup_control.ctl’;
alter database backup controlfile to trace;
create pfile from spfile;

May also want:
$ORACLE_HOME/network/admin (*.ora files)

A cold backup requires the database to be shut down. That means, as opposed to a hot backup, users cannot do anything on the database. So, first, SHUTDOWN the database.

Then copy all necessary files to the same location on the new system.

Startup the cloned database.

view_fra.sql TAR / TAR.Z