Re: Create controlfile for standby database

Hi Sami,

I can't reproduce your example here. Maybe because I do not see the full sequence of events, i.e. from instantiation up to the moment you got this ora 344.

Can you reproduce the error?

Best regards, Carel-Jan

On Mon, 2005-08-29 at 21:48 -0400, Sami Seerangan wrote:

> Carel & Ric,
>
> Thanks for your reply.
>
> Yes. I am doing this on test environment as a POC - how to setup
> Physical standby database using 2 node RAC Primary and Standby.
>
> Now I completely understood we don't need to worry about the
> consistency between datafile backup and control file backup while
> setting up standby DB.
>
> Now I have another question....
>
> When I was playing with switchover process I got into an issue as
> below... May be I have to double check whether I am missing anything.
>
> Not sure why it is complaining about the existing Standby Logfiles and
> Redo Logfiles while switch Standby Into Primary.
>
> SQL> select switchover_status from v$database;
>
> SWITCHOVER_STATUS
> ------------------
> TO PRIMARY
>
>
> SQL> alter database commit to switchover to primary;
> alter database commit to switchover to primary
> *
> ERROR at line 1:
> ORA-00344: unable to re-create online log '/u01/oradata/primary/sredo11.log'
> ORA-17502: ksfdcre:4 Failed to create file /u01/oradata/primary/sredo11.log
> ORA-17500: ODM err:ODM ERROR V-41-4-17 File exists
>
>
> *******REMOVED ALL STANDBY LOGFILES MANUALLY**********
>
>
> SQL> l
> 1* alter database commit to switchover to primary
> SQL> /
> alter database commit to switchover to primary
> *
> ERROR at line 1:
> ORA-00344: unable to re-create online log '/u01/oradata/primary/redo11.log'
> ORA-17502: ksfdcre:4 Failed to create file /u01/oradata/primary/redo11.log
> ORA-17500: ODM err:ODM ERROR V-41-4-17 File exists
>
> *******REMOVED ALL REDO LOGFILES MANUALLY**********
>
> SQL> l
> 1* alter database commit to switchover to primary
> SQL> /
>
> Database altered.
>
>
>
> Thanks again.
> Sami
>
>
> On 8/29/05, Ric Van Dyke <Ric.Van.Dyke_at_hotsos.com> wrote:
> >
> > The start up will indeed increment the SCN, but this isn't a problem with the backup made for the standby. Since the standby will be in a state of recovery you will have no problems with the SCN number. The whole idea of the standby database is to be in sync with the primary and that will happen once you start the apply service. I have created many standbys and following the documentation works very well.
>
>

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

DBA!ert, Independent Oracle consultancy Kastanjelaan 61C
2743 BX Waddinxveen
The Netherlands
tel. +31 (0) 182 64 04 28
fax +31 (0) 182 64 04 29
e-mail info.dbalert_at_xs4all.nl

--
http://www.freelists.org/webpage/oracle-l