dataguard fail over test... what did I miss?

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Wed, 03 Aug 2005 16:57:08 GMT
Message-ID: <upt1f19i419vk52andgbh4akapobn8mdbo@4ax.com>

I wanted to test the standby as a primary so I did the following. This is a TEST environment so I had to kludge a few things.

1. On the PRIMARY alter system set log_archive_dest_state_2='defer';
2. On the STANDBY Modified the /etc/hosts to invalidate the primary address to simulate a fail of the primary
3. On the STANDBY alter database set standby database to maximize performance; alter database recover managed standby database finish skip standby logfile; alter database commit to switchover to primary;

Now on my NEW PRIMARY I get:
SQL> select switchover_status
  2 from v$database;

SWITCHOVER_STATUS

---

SESSIONS ACTIVE And in the alert log:
Wed Aug 3 11:55:23 2005

RFS: Possible network disconnect with primary database
RFS: Destination database mount ID mismatch [0x528f2395:0x5290b4a8]
RFS: Not using real application clusters

What did I miss? Thanks!
Vince

---

Come race with us!
http://www.mgpmrc.org Received on Wed Aug 03 2005 - 11:57:08 CDT