Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Create controlfile for standby database
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
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 29 2005 - 20:50:36 CDT
![]() |
![]() |