Physical Standby: GENSAN
Oracle Database Version: 11.2.0.1.0
Dataguard Broker Configuration: DGCONF
Issue:
When doing switchover to standby database via Dataguard Broker, an error below has been encountered:
DGMGRL for Linux: Version 11.2.0.1.0 - Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected.
DGMGRL> show configuration verbose;
Configuration - DGCONF
Protection Mode: MaxPerformance
Databases:
MANILA - Primary database
GENSAN - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to 'GENSAN';
Performing switchover NOW, please wait...
New primary database "GENSAN" is opening...
Operation requires shutdown of instance "MANILA" on database "MANILA"
Shutting down instance "MANILA"...
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover:
shut down instance "MANILA" of database "MANILA"
start up instance "MANILA" of database "MANILA"
DGMGRL> exit
Resolution:
Do NOT use OS Authentication to connect to DGMGRL (connect /). You should use database authentication, sys/<pwd>[@<connect string>].
E.g.
Connect to Primary Database.
DGMGRL> connect sys/password@MANILA
DGMGRL> connect sys/password@MANILA
Connected.
Code: Select all
DGMGRL> show configuration verbose;
Configuration - DGCONF
Protection Mode: MaxPerformance
Databases:
MANILA - Primary database
GENSAN - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
Code: Select all
switchover to 'GENSAN';
Switchover is now successful.DGMGRL> switchover to 'GENSAN';
Performing switchover NOW, please wait...
New primary database "GENSAN" is opening...
Operation requires shutdown of instance "MANILA" on database "MANILA"
Shutting down instance "MANILA"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "MANILA" on database "MANILA"
Starting instance "MANILA"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "GENSAN"
DGMGRL> exit
Connect to the new Primary, GENSAN and verify that switchover works fine.
DGMGRL> connect sys/password@GENSAN;
DGMGRL> show configuration verbose;DGMGRL> connect sys/password@GENSAN;
Connected.
Verify the Primary Database Status:DGMGRL> show configuration verbose;
Configuration - DGCONF
Protection Mode: MaxPerformance
Databases:
GENSAN - Primary database
MANILA - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
DGMGRL> show database verbose 'GENSAN';
DGMGRL> show database verbose 'GENSAN';
Database - GENSAN
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
GENSAN
Properties:
DGConnectIdentifier = 'GENSAN'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u02/oradata/MANILA/datafile/, /u02/oradata/GENSAN/datafile/'
LogFileNameConvert = '/u02/oradata/MANILA/onlinelog/, /u02/oradata/GENSAN/onlinelog/, /u02/flash_recovery_area/MANILA/onlinelog/, /u02/flash_recovery_area/GENSAN/onlinelog/'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'dgstan.localdomain'
SidName = 'GENSAN'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dgstan.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=GENSAN_DGMGRL)(INSTANCE_NAME=GENSAN)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL>
Verify the Standby Database Status:
DGMGRL> show database verbose 'MANILA';
DGMGRL> show database verbose 'MANILA';
Database - MANILA
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
MANILA
Properties:
DGConnectIdentifier = 'manila'
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 = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u02/oradata/GENSAN/datafile/, /u02/oradata/AUX11G/datafile/'
LogFileNameConvert = '/u02/oradata/GENSAN/onlinelog/, /u02/oradata/AUX11G/onlinelog/, /u02/flash_recovery_area/GENSAN/onlinelog/, /u02/flash_recovery_area/AUX11G/onlinelog/'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'dgprim.localdomain'
SidName = 'MANILA'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dgprim.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MANILA_DGMGRL)(INSTANCE_NAME=MANILA)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL>