Setup the Data Guardbroker configuration
dgmgrl
DGMGRL> connect sys/oracle
create configuration drs as primary database is rmanp connect identifier is rmanp;
add database rmans as connect identifier is rmans maintained as physical;
enable configuration;
DGMGRL> show configuration;
Configuration - drs
Protection Mode: MaxAvailability
Databases:
rmanp - Primary database
rmans - (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
Setup Fast failover:
Enable flashback on both databases
alter system set db_recovery_file_dest_size=2G;
alter system set db_recovery_file_dest='/u01/app/oracle/oradata';
set fast failover target
DGMGRL> EDIT DATABASE rmanp SET PROPERTY FastStartFailoverTarget = rmans;
DGMGRL> EDIT DATABASE rmans SET PROPERTY FastStartFailoverTarget = rmanp;
set log mode and protection mode
DGMGRL> EDIT DATABASE 'rmans' SET PROPERTY LogXptMode=SYNC;
DGMGRL> EDIT DATABASE 'rmanp' SET PROPERTY LogXptMode=SYNC;
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;
DGMGRL> EDIT CONFIGURATION SET PROPERTY FastStartFailoverThreshold = 10;
FastStartFailoverThreshold Used to specify the number of seconds to delay failover after the detection of a primary database failure. This parameter defaults to 30 seconds.
FastStartFailoverPmyShutdown In its default setting of true, this parameter causes the primary database to shut down when FastStartFailoverThreshold has been reached for a particular database. This parameter setting is ignored in the case of a user-configurable condition failover.
FastStartFailoverLagLimit Allows for definition of the number of seconds the standby database is able to fall behind. When this threshold is exceeded, automatic failover will not be allowed.
FastStartFailoverAutoReinstate When set to its default of true, this parameter enables the automatic reinstatement of a failed primary database as a standby. Automatic reinstatement is not possible for user-configurable failover conditions regardless of this parameter setting.
DGMGRL> edit database 'cosp' set property ' FastStartFailoverLagLimit '='60';
DGMGRL> ENABLE FAST_START FAILOVER CONDITION 'Inaccessible Logfile';
enable fash failover
DGMGRL> enable fast_start failover
DGMGRL> show fast_start failover
Fast-Start Failover: ENABLED
Threshold: 10 seconds
Target: rmans
Observer: Yusuf-PC
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile YES
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
DGMGRL> show configuration;
Configuration - drs
Protection Mode: MaxAvailability
Databases:
rmanp - Primary database
rmans - (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
