Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01665 : control file is not a standby control file

662800Feb 19 2009 — edited Feb 19 2009
I've already tested Dataguard configuration on Oracle 10g Enterprise edition for Windows.
While configuring the same in Sun Solaris, I'm receiving this error:

ORA-01665: control file is not a standby control file

Steps I follow are as below:

1) Creating a password file on both databases (primary and standby)
2) Force logging primary db and shut it down. Take a cold backup of redo log files and datafiles.
3) Transferring them to Standby db.
4) Starting primary db in mount mode and creating a standby controlfile. Transferring standby controlfile to proper location defined in standby init file.
5) Start primary db in read-write mode and secondary db in mount mode using:

alter database mount standby database;

I receive this error while firing this SQL.

Can anyone please help me out solving the same.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2009
Added on Feb 19 2009
20 comments
4,916 views