Dec 19, 2017
ORA-16057: server not in Data Guard configuration
1.8K

ORA-16057: server not in Data Guard configuration

Error:  ORA-16057: server not in Data Guard configuration Solution:  Make sure your log_archive_config and log_archive_dest_2 parameters are set on both Primary and Standby Databases. In my case: alter system set log_archive_config=’dg_config=(PROD,PROD_stby)’; alter system set log_archive_dest_2=’service=PROD_stby lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=PROD_stby’;
Dec 13, 2017
ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
1.5K

ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

Issue:  Unable to change DB_UNIQUE_NAME after failover from PRIMARY TO STANDBY SQL> alter system set db_unique_name=MWMPPROD scope=spfile; alter system set db_unique_name=MWMPPROD scope=spfile * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-65500: could not modify DB_UNIQUE_NAME, resource exists Solution: We need to switch back to PRIMARY instead of making a...
Dec 13, 2017
OPW-00019: Failed to update the CRS resource with DB password file location
1.8K

OPW-00019: Failed to update the CRS resource with DB password file location

Error:  I was facing below error while creating password file on standby side as part of Oracle Data Guard (standby) Configuration [oracle@app admin]$ orapwd file=’+DATA1/orapwdb/orapwPROD’ password=PwdFile force=y dbuniquename=PROD_stby OPW-00019: Failed to update the CRS resource with DB password file location Solution: There seems to be a bug in 12.1.0.2.  As...
Dec 13, 2017
ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
1.6K

ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

Error:   While registering Primary and Standby with Data Guard Broker: DGMGRL> CREATE CONFIGURATION ‘my_dg_conf’ AS PRIMARY DATABASE IS ‘SOAPROD’ CONNECT IDENTIFIER IS ‘SOAPROD’; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added Failed. Solution:  Update LOG_ARCHIVE_DEST_2 with no value and try creating data guard configuration. SQL> show parameter LOG_ARCHIVE_DEST_2 NAME                                 TYPE       ...
Apr 11, 2013
Data guard Interview Question and Answers
3.8K

Data guard Interview Question and Answers

Data guard Interview Question and Answers: Data guard Interview Question and Answers 1. Can Oracle’s Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync? In Oracle Standard Edition, it is possible to be a standby database, and...
Feb 25, 2012
Difference between Physical Standby and Logical Standby
6.7K

Difference between Physical Standby and Logical Standby

Physical standby: ============ 1. Physical standby schema matches exactly the source database. 2. Archived redo logs and FTP’ed directly to the standby database which is always running in “recover” mode. Upon arrival, the archived redo logs are applied directly to the standby database. Logical standby: =========== 1. Logical standby database...