Month: October 2021

How to Configure Multiple Standby Databases in Data Guard

This post demonstrates how to configure multiple standby databases. The following environment and namings are involved in this post:

Primary Database :
db_name : PRIMDB
db_unique_name : PRIMDB
Standby Database 1 :
db_name : PRIMDB
db_unique_name : STDBY1DB
Standby Database 2:
db_name : PRIMDB
db_unique_name : STDBY2DB
Standby Database 3 :
db_name : PRIMDB
db_unique_name : STDBY3DB

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

ORA-01033 When Adding Standby Database into Data Guard Configuration

The following errors occur when adding a standby database to DG: 

DGMGRL> add database 'stdby_db'  as connect identifier is 'stdby_db'  maintained as physical;
Error: ORA-01033: ORACLE initialization or shutdown in progress

Failed.

SOLUTION

Make sure the password file is copied from primary database, and configured properly in RAC:

On standby database server:

$ srvctl config database -d stdby_db
...
..
Password file:             <======= password file is not on ASM and will be read from $ORACLE_HOME/dbs instead

Copy the correct password file from Primary’s ASM to the Standby’s ASM and modify the password file path in OCR:


$ srvctl modify database -d stdby_db -pwfile <ASM path for the password file>