[oracle@subhen_PRODdb04 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected.
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxPerformance
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with database setting
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL> show instance verbose 'ORCLB2'
Instance 'ORCLB2' of database 'ORCLB'
Host Name: orempr2db08.esp.aur.national.com.au
PFILE:
Properties:
SidName = 'ORCLB2'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.47)(PORT=1621))(CONNECT_DATA=(SERVICE_NAME=ORCLB_DGMGRL)(INSTANCE_NAME=ORCLB2)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '+FRA'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Instance Warning(s):
ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting
ORA-16714: the value of property AlternateLocation is inconsistent with the database setting
Instance Status:
WARNING
DGMGRL> edit instance 'ORCLB2' set property StandbyArchiveLocation='+BACKUP';
Error: ORA-16664: unable to receive the result from a database
Failed.
DGMGRL> disable configuration
Disabled.
DGMGRL> remove configuration
Removed configuration
DGMGRL> show configuration
ORA-16532: Data Guard broker configuration does not exist
Configuration details cannot be determined by DGMGRL
-- set dg_broker_start=FALSE in both database(primary and standby) and also remove the broker files from ASM location
SQL> alter system set dg_broker_start=FALSE scope=both sid='*';
-- set dg_broker_start=TRUE and proceed for reconfiguring dgmgrl again
alter system set dg_broker_start=TRUE scope=both sid='*';
DGMGRL> create configuration ORCLDG as primary database is 'ORCL' connect identifier is 'ORCL';
Configuration "ORCLdg" created with primary database "ORCL"
DGMGRL> add database 'ORCLB' as connect identifier is 'ORCLB' maintained as physical;
Database "ORCLB" added
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxPerformance
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxPerformance
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
--- but i had a little proble from 2nd host of standby site
DGMGRL> connect /
Connected.
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxPerformance
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01017: invalid username/password; logon denied
ORA-16625: cannot reach database "ORCL"
DGM-17017: unable to determine configuration status
-- so i had copied the password file from other standby host and replaced(renamed) it and it works fine
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected.
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxPerformance
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with database setting
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL> show instance verbose 'ORCLB2'
Instance 'ORCLB2' of database 'ORCLB'
Host Name: orempr2db08.esp.aur.national.com.au
PFILE:
Properties:
SidName = 'ORCLB2'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.47)(PORT=1621))(CONNECT_DATA=(SERVICE_NAME=ORCLB_DGMGRL)(INSTANCE_NAME=ORCLB2)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '+FRA'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Instance Warning(s):
ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting
ORA-16714: the value of property AlternateLocation is inconsistent with the database setting
Instance Status:
WARNING
DGMGRL> edit instance 'ORCLB2' set property StandbyArchiveLocation='+BACKUP';
Error: ORA-16664: unable to receive the result from a database
Failed.
DGMGRL> disable configuration
Disabled.
DGMGRL> remove configuration
Removed configuration
DGMGRL> show configuration
ORA-16532: Data Guard broker configuration does not exist
Configuration details cannot be determined by DGMGRL
-- set dg_broker_start=FALSE in both database(primary and standby) and also remove the broker files from ASM location
SQL> alter system set dg_broker_start=FALSE scope=both sid='*';
-- set dg_broker_start=TRUE and proceed for reconfiguring dgmgrl again
alter system set dg_broker_start=TRUE scope=both sid='*';
DGMGRL> create configuration ORCLDG as primary database is 'ORCL' connect identifier is 'ORCL';
Configuration "ORCLdg" created with primary database "ORCL"
DGMGRL> add database 'ORCLB' as connect identifier is 'ORCLB' maintained as physical;
Database "ORCLB" added
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxPerformance
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxPerformance
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
--- but i had a little proble from 2nd host of standby site
DGMGRL> connect /
Connected.
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxPerformance
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01017: invalid username/password; logon denied
ORA-16625: cannot reach database "ORCL"
DGM-17017: unable to determine configuration status
-- so i had copied the password file from other standby host and replaced(renamed) it and it works fine