If your primary database is huge in size and has to be up all the time (24X7), but you want to make a cold backup. No problem, you can set up a physical standby database on another machine (site), and then use RMAN or traditional cold back up method to do a cold backup. The following are steps for doing a cold backup of standby database then restoring the backup to another host:

1, Shutdown standby database (server A):

sqlplus /nolog

connect sys/change_on_install@crm as sysdba
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
shutdown immediate;
exit;

2, Do a cold backup: copy data files, control files, init file, and redo log files to another server (server B).

3, Start standby database on server A:

sqlplus /nolog

connect sys/change_on_install@crm as sysdba
startup nomount;
alter database mount standby database;
recover managed standby database disconnect from session;
exit;

4, Create service, password file, spfile file for restoring cold backup files on server B:

oradim -DELETE -SRVC OracleServiceCRM

oradim -new -SRVC OracleServiceCRM -startmode M

del C:\oracle\ora92\database\PWDCRM.ora
orapwd file=C:\oracle\ora92\database\PWDCRM.ora password=change_on_install entries=30

sqlplus /nolog

connect sys/change_on_install@crm as sysdba
create spfile='C:\oracle\ora92\database\SPFILECRM.ORA' from pfile='C:\oracle\job\crmstandby\initCRM.ora';

5, Start Oracle database on server B

rem start service (windows) or process (*nix).

connect sys/change_on_install@crm as sysdba
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
recover managed standby database disconnect from session;

Use the following command if archive logs were copied manually from primary site to standby site for point-in-time recovery:

RECOVER STANDBY DATABASE;

Then convert standby database to primary database:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE ACTIVATE STANDBY DATABASE;
SHUTDOWN IMMEDIATE;
STARTUP;
exit;

6, Make sure archive log destination is correct.

7, Create temporary data files for each temporary tablespace, use “reuse” option:

ALTER TABLESPACE temporary ADD DATAFILE 'K\oradata\crm\temp02.dbf' SIZE 2000M reuse;