cle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.
DGMGRL> ENABLE FAST_START FAILOVER;
Enabled.
DGMGRL> SHOW FAST_START FAILOVER;
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: JAKKI
Observer: cube
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver NO
Datafile Offline YES
Oracle Error Conditions:
(none)
switch over 演示:
DGMGRL> switchover to 'JAKKI';
Performing switchover NOW, please wait...
Operation requires a connection to instance "JAKKI" on database "JAKKI"
Connecting to instance "JAKKI"...
Connected.
New primary database "JAKKI" is opening...
Operation requires startup of instance "CUBE" on database "CUBE"
Starting instance "CUBE"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "JAKKI"
DGMGRL> show configuration;
Configuration - DRSolution
Protection Mode: MaxAvailability
Databases:
JAKKI - Primary database
CUBE - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
failover 测试:
DGMGRL> connect sys/password@jakki;
Connected.
DGMGRL> failover to 'JAKKI';
Performing failover NOW, please wait...
Failover succeeded, new primary is "JAKKI"
DGMGRL> show configuration;
Configuration - DRSolution
Protection Mode: MaxAvailability
Databases:
JAKKI - Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration
CUBE - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
原主库重新启动至mount状态:
[oracle@cube ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 4 15:56:39 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 839282688 bytes
Fixed Size 2257880 bytes
Variable Size 545262632 bytes
Database Buffers 289406976 bytes
Redo Buffers 2355200 bytes
Database mounted.
重新将