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;
Tags:
Biotechnology
