Database Backup and Recovery (MOSC)

MOSC Banner

11.2.0.4 : Creating a 2nd standby instance

edited Aug 21, 2019 8:11PM in Database Backup and Recovery (MOSC) 3 commentsAnswered

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center