Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: After Dataguard failover not able to make switchover back

Re: After Dataguard failover not able to make switchover back

From: Carel-Jan Engel <>
Date: Thu, 19 May 2005 21:16:29 +0200
Message-Id: <>

Hi Peter,
Sorry for not getting back on this earlier. I had to assist a customer yesterday evening.

When a standby will not switchover to primary, several reasons can lead to this.

First: did you create the standby controlfile from the primary _after_ you made the backup of the database? Otherwise it might not become a proper standby.

Second: Did you verify that the standby catched up with the primary? E.g. did you check that the logfiles were applied? (check the applied column in v$archived_log)

Third: Did you commit to switchover to standby the primary first? The primary needs to be switched first, before the standby can switchover. Otherwise it is a failover again.

You are using the ..file_name_convert parameters. Why is that? Are both databases on the same server? That is not much High Availability. And, if not, I recommend to keep your systems as symmetric as possible, for robustness. Otherwise the server you have to deal with all of a sudden is a differente environment after a failover. That makes the situation even more error-prone, when the system is more vulnerable. After the failover you don't have your standby to protect you, unless you had two of them.

Best regards,

Carel-Jan Engel

If you think education is expensive, try ignorance. (Derek Bok) ===

On Wed, 2005-05-18 at 12:32, Peter McLarty wrote:

> Hi all DG gurus
> I have run some tests of dataguard and in the it all something has
> happened of which I am a little lost.
> After a number of configuration errors in the two databases I had the
> system making switchovers successfully. Then the client insisted that we
> do a fail over test. the failover went smoothly and all appeared well.
> No for the fun part I rebuilt the old primary as a standby to the new
> primary and have now had 4 attempts to successfully switchover none of
> which have worked.
> I have a problem that the switchover fails because the standby says
> there is incomplete recovery and as such cannot continue.
> I think i may have stuffed this one and may have to export the data and
> rebuild a new clean primary but if anyone has any ideas as to how to
> recover I would appreciate it

> Oracle
> AIX 5.2
> Cheers
> Peter
> --

Received on Thu May 19 2005 - 15:21:49 CDT

Original text of this message