 | | | Create controlfile for standby database | Create controlfile for standby database 2005-08-29 - By Sami Seerangan
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 (See ORA-00344.ora-code.com): unable to re-create online log '/u01/oradata/primary/sredo11.log'
ORA-17502 (See ORA-17502.ora-code.com): ksfdcre:4 Failed to create file /u01/oradata/primary/sredo11.log
ORA-17500 (See ORA-17500.ora-code.com): 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 (See ORA-00344.ora-code.com): unable to re-create online log '/u01/oradata/primary/redo11.log'
ORA-17502 (See ORA-17502.ora-code.com): ksfdcre:4 Failed to create file /u01/oradata/primary/redo11.log
ORA-17500 (See ORA-17500.ora-code.com): 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@(protected)> 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-l
|
|
|