Archive

Posts Tagged ‘testing dg broker’

Testing DG Broker/fast_start failover configuration

March 24, 2013 Leave a comment

1. To enable DG broker with fast_start failover configuration check the below link

https://startupforce.wordpress.com/2013/03/24/dg-broker-configuration-with-fast_start-failover-observer/

2. Now check whether both the primary and standby are in sync

SQL> select FS_FAILOVER_STATUS,FS_FAILOVER_CURRENT_TARGET,FS_FAILOVER_THRESHOLD,
FS_FAILOVER_OBSERVER_PRESENT,FS_FAILOVER_OBSERVER_HOST from v$database;

On Primary:

FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET FS_FAILOVER_THRESHOLD
FS_FAIL FS_FAILOVER_OBSERVER
---------------------- ------------------------------ --------------------- 
SYNCHRONIZED                      bharat_stby             30 
YES rac2.localdomain

On Standby

FS_FAILOVER_STATUS  FS_FAILOVER_CURRENT_TARGET FS_FAILOVER_THRESHOLD 
FS_FAIL FS_FAILOVER_OBSERVER
---------------------- ------------------------------ ---------------------
SYNCHRONIZED                             bharat_pri            30 
YES               rac1.localdomain

Failover testing:

1. Check that there is enough flashback data available in the primary database, atleast 30-40 mins.

 SQL> select (sysdate - oldest_flashback_time)*24*60 as history 
                                       from v$flashback_database_log;
   HISTORY
   ----------
   2898.61667

2. Create a sample table on the primary

 SQL> create table x as select * from all_objects;
 Table created.
 SQL> select count(*) from x;
    COUNT(*)
     ----------
     12615

3. Kill the instance:

[oracle@rac1 ~]$ ps -ef | grep pmon
oracle 4571 1 0 09:18 ? 00:00:00 ora_pmon_bharat
oracle 5311 4526 0 09:46 pts/1 00:00:00 grep pmon
[oracle@rac1 ~]$ kill -9 4571

4. Check the status in the DG Broker configuration

DGMGRL> show site verbose bharat_pri

5. Also check the observer log

[oracle@rac2 ~]$ cat observer.log

[W000 03/07 09:38:41.76] Observer started.
09:47:24.66  Thursday, March 07, 2013
Initiating Fast-Start Failover to database "bharat_stby"...
Performing failover NOW, please wait...
Failover succeeded, new primary is "bharat_stby"
09:47:42.01  Thursday, March 07, 2013

6. Check the DG Broker configuration

DGMGRL> show configuration
 Configuration - bharatDR
   Protection Mode: MaxAvailability
  Databases:
    bharat_stby - Primary database
    Warning: ORA-16817: unsynchronized fast-start failover configuration 
    (Above warning is because of max availability configuration)
     bharat_pri  - (*) Physical standby database (disabled)
     ORA-16661: the standby database needs to be reinstated
 Fast-Start Failover: ENABLED
 Configuration Status:
WARNING

7. Check the table count on new primary(bharat_stby):

 SQL> select database_role,switchover_status from v$database;
 DATABASE_ROLE SWITCHOVER_STATUS
---------------- --------------------
PRIMARY NOT ALLOWED
 SQL> select count(*) from x;
 COUNT(*)
----------
12615

8. Now Re-instate the old primary as standby

Mount the database and observer will take care of re-instation. Check the observer log below

 SQL> alter database mount
[oracle@rac2 ~]$ tail -f observer.log
[W000 03/07 09:38:41.76] Observer started.
 09:47:24.66 Thursday, March 07, 2013
Initiating Fast-Start Failover to database "bharat_stby"...
Performing failover NOW, please wait...
Failover succeeded, new primary is "bharat_stby"
09:47:42.01 Thursday, March 07, 2013
 09:52:20.86 Thursday, March 07, 2013
Initiating reinstatement for database "bharat_pri"...
Reinstating database "bharat_pri", please wait...
Operation requires shutdown of instance "bharat" on database "bharat_pri"
Shutting down instance "bharat"...
ORA-01109: database not open
 Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "bharat" on database "bharat_pri"
Starting instance "bharat"...
ORACLE instance started.
Database mounted.
Continuing to reinstate database "bharat_pri" ...
Reinstatement of database "bharat_pri" succeeded
09:53:44.70 Thursday, March 07, 2013

 

This completes testing 🙂


Advertisements
Oracle database internals by Riyaj

Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite.

StartupForce

Where all the Action Is !!!!

Pavan DBA's Blog

The DBA Knowledge Store

ORACLE-BASE - Latest Articles

Where all the Action Is !!!!