Re: After Dataguard failover not able to make switchover back

Thanks for the info

I found out what is was when we did the failover the 1_0.dbf file was created as a standby redo log. There is nothing documented that they are needed that I have found. So after working this out and assessing the situation I dropped this from the primary and recreated it in a better location along with the other 3 in accordance with the doc's and then did the same to the standby and once it was done it was working.

Physical standby with maximum performance is the best solution for this customer. You don't want to know why.

Cheers

Peter

Carel-Jan Engel wrote:
> 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 9.2.0.5
>>AIX 5.2
>>
>>
>>Cheers
>>
>>Peter
>>--/
>>/_http://www.freelists.org/webpage/oracle-l_/
>>

-- 
--

Peter McLarty
Technical Consultant
+61402094238
--
http://www.freelists.org/webpage/oracle-l