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

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 03 Aug 2005 19:05:48 +0200
Message-ID: <dcqthc$rm9$2@news.BelWue.DE>

Vince Laurent wrote:
> 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

I can't tell, but why didn't you just pull the plug at primary?

Holger Received on Wed Aug 03 2005 - 12:05:48 CDT