Enable FSFO and starting the Observer
An Observer can be any system
with access to the databases in DG configuration and at least Oracle Client
installed.
1. Ensure that SRL's are configured on both
the PRIMARY DB and
the STANDBY DB's
2. Ensure that the LogXptMode is set to SYNC
3. Set the FastStartFailoverTarget
property of PRIMARY to desired
STANDBY DB.
edit
database orcl1 set property
'FastStartFailoverTarget'='orcl2';
4. Upgrade protection Mode to MaxAvailability
if necessary.
edit configuration set
protection mode as MAxAvailability;
5. Enable Flashback on Primary and Standby
DB's
Also
set DB_FLASHBACK_RETENTION_TARGET
to appropriate value.
This
parameter retains the flashback logs such that the database can be
flashed back
to the specified interval of time.
6. Start Observer
Connect
to standby DB using DGMGRL and issue:
start
observer;
7. Enable Fast start Failover
enable
FAST_START failover;
This
statement creates FSFP process
2014-03-12
02:51:34.451 DMON: Creating process FSFP
2014-03-12
02:51:37.549 FSFP: Process
started
2014-03-12
02:51:38.550 DMON: FSFP
successfully started
DGMGRL> show
configuration
Configuration - dg_config
Protection Mode: MaxAvailability
Databases:
orcl1
- Primary database
orcl2
- (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
No comments:
Post a Comment