使用dg broker管理的dataguard环境,启动时还是先启动备库、再启动主库。详细操作如下:
GMGRL> connect sys/oracle@orcl
Connected as SYSDBA.
DGMGRL> startup
ORACLE instance started.
Database mounted.
Database opened.
DGMGRL> connect sys/oraclepppp
Connected as SYSDG.
DGMGRL> show configuration verbose
Configuration - dg
Protection Mode: MaxPerformance
Members:
orcls - Primary database
Error: ORA-16778: redo transport error for one or more databases
orcl2 - Physical standby database
Error: ORA-01034: ORACLE not available
orcl - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
DGMGRL> connect sys/oralce#;
Connected as SYSDG.
DGMGRL> connect sys/oracle@orcl2
Connected as SYSDBA.
DGMGRL> startup
ORACLE instance started.
Database mounted.
Database opened.
DGMGRL> show configuration verbose
Configuration - dg
Protection Mode: MaxPerformance
Members:
orcls - Primary database
orcl2 - Physical standby database
orcl - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
----------------------关闭顺序正好相反
DGMGRL> connect sys/oracle@orcl
DGMGRL> shutdown immediate
DGMGRL> connect sys/oracle@orcl2
DGMGRL> shutdown immediate