Standby database

[Avoiding the Red Zone]

Hi

Please follow this procedure :

On current primary:
shutdown primary and transfer all datafiles to standby host
startup mount;
alter database create standby controlfile as '/tmp/stbycontrol01.ctl';
alter database open;
Replace standby control files with copies (renamed) of '/tmp/stbycontrol01.ctl'
On new standby:
startup nomount
alter database mount standby database;
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;
alter database clear logfile group 5;
alter database clear logfile group 6;
To confirm accuracy of transferred datafiles:
alter database open read only;
alter database recover managed standby database disconnect from session;
Back on primary:
alter system set log_archive_dest_state_2='DEFER';
alter system archive log current;
alter system set log_archive_dest_state_2='ENABLE';

[KapilRaj]

..