11.2.0.4 : Creating a 2nd standby instance
Hello,
We have a 11.2.0.4 database running EBS R12.2 . This database has a primary and standby database. We have a requirement to create another standby database . We are planning to do the following
1) backup standby database.
2) use the backup to create 2nd standby database and enable log sync
alter database recover managed standby database cancel;
Database altered.
SQL> alter database convert to snapshot standby;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter system switch logfile;
System altered.
RMAN
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/FINPRDSDB/%F';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/FINPRDSDB/%d_S_%s_P_%p_T_%t';