Cause
The Data Guard broker could not execute a health check at the moment, so the configuration status could not be determined.
MYCASE: My Port was mismatch with DGMRL defined port. My DB captured the port 1567 But my TNS entry was port 1569. So I came to straight to enable this through DGMGRL. Please Follow
Action
export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ . ./.profile_db
bash-3.2$ export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ export ORACLE_SID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: 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 sys
Password:
Connected.
DGMGRL> show database verbose stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: (unknown)
Apply Lag: (unknown)
Instance(s):
stdy_1
Properties:
DGConnectIdentifier = 'stdy'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '8'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'stdy_1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.222.333.444)(PORT=1567))(CONNECT_DATA=(SERVICE_NAME=stdy_DGMGRL)(INSTANCE_NAME=stdy_1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
bash-3.2$ . ./.profile_asm
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 19:45:41
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 26-JUL-2016 19:19:41
Uptime 0 days 0 hr. 25 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Listener Log File /oracle/app/grid/11.2.0.3/log/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.444)(PORT=1569)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.445)(PORT=1569)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "ibank" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "ibcore" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibcoreXDB" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibcoretest" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibdb" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "ibdbXDB" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "stdy" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_DGB" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_dgmgrl" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "testcbs" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdb" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
bash-3.2$ lsnrctl status op
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 19:46:03
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
The command completed successfully
bash-3.2$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 19:49:49
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /oracle/app/grid/11.2.0.3/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
System parameter file is /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Log messages written to /oracle/oracle_base/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1569)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.445)(PORT=1569)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00303: syntax error in NV string
Listener failed to start. See the error message(s) above...
bash-3.2$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 19:52:47
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /oracle/app/grid/11.2.0.3/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
System parameter file is /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Log messages written to /oracle/oracle_base/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1569)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.445)(PORT=1569)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1569)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 26-JUL-2016 19:52:47
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Listener Log File /oracle/oracle_base/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1569)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.445)(PORT=1569)))
Services Summary...
Service "stdy" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_DGB" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_dgmgrl" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
bash-3.2$ lsnrctl start tatus
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 19:53:07
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1569)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 26-JUL-2016 19:52:47
Uptime 0 days 0 hr. 0 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Listener Log File /oracle/oracle_base/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1569)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.445)(PORT=1569)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.444)(PORT=1569)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "ibank" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "ibcore" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibcoreXDB" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibcoretest" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibdb" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "ibdbXDB" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "stdy" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_DGB" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_dgmgrl" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "testcbs" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdb" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
bash-3.2$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 19:53:15
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1569)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 26-JUL-2016 19:52:47
Uptime 0 days 0 hr. 0 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Listener Log File /oracle/oracle_base/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1569)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.445)(PORT=1569)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.444)(PORT=1569)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "ibank" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "ibcore" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibcoreXDB" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibcoretest" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibdb" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "ibdbXDB" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "stdy" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_DGB" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_dgmgrl" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "testcbs" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdb" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
bash-3.2$ lsnrctl status
bash-3.2$ . ./.profile_asm
bash-3.2$ export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ . ./.profile_db
bash-3.2$ lsnrctl status
bash-3.2$ . ./.profile_asm
bash-3.2$ export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ export ORACLE_SID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ lsnrctl status
bash-3.2$ . ./.profile_asm
bash-3.2$ export ORACLE_BASE=/oracle/oracle_base
bash-3.2$ export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ lsnrctl status
bash-3.2$ . ./.profile_asm
bash-3.2$ export ORACLE_BASE=/oracle/oracle_base
bash-3.2$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: 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 sys
Password:
Connected.
DGMGRL> show database verbose stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: (unknown)
Apply Lag: (unknown)
Instance(s):
stdy_1
Properties:
DGConnectIdentifier = 'stdy'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '8'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'stdy_1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.222.333.444)(PORT=1567))(CONNECT_DATA=(SERVICE_NAME=stdy_DGMGRL)(INSTANCE_NAME=stdy_1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: (unknown)
Apply Lag: (unknown)
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-16665: timeout waiting for the result from a database
DGM-17017: unable to determine configuration status
DGMGRL> exit
bash-3.2$ export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ lsnrctl status
bash-3.2$ . ./.profile_asm
bash-3.2$ . ./.profile_asm
bash-3.2$ export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 20:00:33
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1569)))
The command completed successfully
bash-3.2$ lsnrctl stop art tus
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 20:01:27
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 2: No such file or directory
bash-3.2$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 20:01:37
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 2: No such file or directory
bash-3.2$ lsnrctl stop
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 20:01:41
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /oracle/app/grid/11.2.0.3/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
System parameter file is /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Log messages written to /oracle/oracle_base/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 26-JUL-2016 20:01:41
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Listener Log File /oracle/oracle_base/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
Services Summary...
Service "stdy" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_DGB" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_dgmgrl" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
bash-3.2$ lsnrctl startopatus
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-JUL-2016 20:03:09
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 26-JUL-2016 20:01:41
Uptime 0 days 0 hr. 1 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/grid/11.2.0.3/network/admin/listener.ora
Listener Log File /oracle/oracle_base/diag/tnslsnr/testracdb2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.444)(PORT=1569)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=111.222.333.445)(PORT=1569)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "ibank" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "ibcore" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibcoreXDB" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibcoretest" has 1 instance(s).
Instance "ibcore1", status READY, has 1 handler(s) for this service...
Service "ibdb" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "ibdbXDB" has 1 instance(s).
Instance "ibdb_1", status READY, has 1 handler(s) for this service...
Service "stdy" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_DGB" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "stdy_dgmgrl" has 1 instance(s).
Instance "stdy_1", status UNKNOWN, has 1 handler(s) for this service...
Service "testcbs" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdb" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
bash-3.2$ clear
export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ export ORACLE_SID=stdy_1
bash-3.2$ . ./.profile_asm
bash-3.2$ dgmgrl
export ORACLE_BASE=/oracle/oracle_base
bash-3.2$ export ORACLE_BASE=/oracle/oracle_baseSID=stdy_1
bash-3.2$ . ./.profile_db
bash-3.2$ . ./.profile_asm
bash-3.2$ dgmgrl
export ORACLE_BASE=/oracle/oracle_base
bash-3.2$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: 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 sys
Password:
Connected.
DGMGRL> edit instance 'stdy_1' set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.222.333.444)(PORT=1569))(CONNECT_DATA=(SERVICE_NAME=stdy_DGMGRL)(INSTANCE_NAME=stdy_1)(SERVER=DEDICATED)))';
Property "staticconnectidentifier" updated
DGMGRL> show database stverbose stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: (unknown)
Apply Lag: (unknown)
Instance(s):
stdy_1
Properties:
DGConnectIdentifier = 'stdy'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '8'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'stdy_1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.222.333.444)(PORT=1567))(CONNECT_DATA=(SERVICE_NAME=stdy_DGMGRL)(INSTANCE_NAME=stdy_1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
bash-3.2$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: 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 sys
Password:
Connected.
DGMGRL> enable database 'stdy';
Enabled.
DGMGRL> show database verbose stdy;
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 2 hours 57 minutes 25 seconds
Instance(s):
stdy_1
Warning: ORA-16782: instance not open for read and write access
Properties:
DGConnectIdentifier = 'stdy'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '8'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'stdy_1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.222.333.444)(PORT=1569))(CONNECT_DATA=(SERVICE_NAME=stdy_DGMGRL)(INSTANCE_NAME=stdy_1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
WARNING
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Snapshot standby database
Warning: ORA-16782: instance not open for read and write access
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 2 hours 59 minutes 24 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
bash-3.2$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: 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 sys
Password:
Connected.
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 3 hours 1 minute 56 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database verbose stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 3 hours 2 minutes 4 seconds
Instance(s):
stdy_1
Properties:
DGConnectIdentifier = 'stdy'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '8'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'stdy_1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.222.333.444)(PORT=1569))(CONNECT_DATA=(SERVICE_NAME=stdy_DGMGRL)(INSTANCE_NAME=stdy_1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> convert database stdy to physical standby;
Converting database "stdy" to a Physical Standby database, please wait...
Operation requires shutdown of instance "stdy_1" on database "stdy"
Shutting down instance "stdy_1"...
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "stdy_1" on database "stdy"
Starting instance "stdy_1"...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Database mounted.
Continuing to convert database "stdy" ...
Operation requires shutdown of instance "stdy_1" on database "stdy"
Shutting down instance "stdy_1"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "stdy_1" on database "stdy"
Starting instance "stdy_1"...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Database mounted.
Database "stdy" converted successfully
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show
DGMGRL>
DGMGRL>
DGMGRL> show database drababil;
Database - drababil
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Real Time Query: OFF
Instance(s):
DRABABIL
Database Status:
DGM-17016: failed to retrieve status for database "drababil"
ORA-16664: unable to receive the result from a database
DGMGRL> show database stdy
Database - stdy
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL for IBM/AIX RISC System/6000: 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 sys
Password:
Connected.
DGMGRL> convert database stdy to snapshot standby;
Converting database "stdy" to a Snapshot Standby database, please wait...
Database "stdy" converted successfully
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 10 minutes 54 seconds
Apply Lag: 1 minute 1 second
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 11 minutes
Apply Lag: 1 minute 7 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 11 minutes 5 seconds
Apply Lag: 1 minute 12 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 11 minutes 7 seconds
Apply Lag: 1 minute 14 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 11 minutes 10 seconds
Apply Lag: 1 minute 17 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 12 minutes 36 seconds
Apply Lag: 2 minutes 43 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 12 minutes 38 seconds
Apply Lag: 2 minutes 45 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 12 minutes 40 seconds
Apply Lag: 2 minutes 47 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 12 minutes 45 seconds
Apply Lag: 2 minutes 52 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 13 minutes 14 seconds
Apply Lag: 3 minutes 22 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 6 minutes 12 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 6 minutes 25 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 6 minutes 29 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 6 minutes 37 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 6 minutes 40 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: SNAPSHOT STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 7 minutes 7 seconds
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> convert database stdy to physical standby;
Converting database "stdy" to a Physical Standby database, please wait...
Operation requires shutdown of instance "stdy_1" on database "stdy"
Shutting down instance "stdy_1"...
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "stdy_1" on database "stdy"
Starting instance "stdy_1"...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Database mounted.
Continuing to convert database "stdy" ...
Operation requires shutdown of instance "stdy_1" on database "stdy"
Shutting down instance "stdy_1"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "stdy_1" on database "stdy"
Starting instance "stdy_1"...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Database mounted.
Database "stdy" converted successfully
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show configuration
Configuration - sibladg
Protection Mode: MaxPerformance
Databases:
ababil - Primary database
drababil - Physical standby database
stdy - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show database stdy
Database - stdy
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
stdy_1
Database Status:
SUCCESS
DGMGRL> exit
bash-3.2$ exit
exit
$ exit
Comments
Post a Comment