Skip to Main Content

Database Software

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

Karan KukrejaDec 19 2011 — edited Mar 22 2012
Hi All ,

i am on oracle 11.2.0 and Solaris OS.

I had to create a DR database in another server so i followed the following steps :

1.created a tar of oracle home since the DR was on 10 and the source was 11.
2.moved to another location ( Dr Server) and untar it.
3.made the changes in the environment variable and also made the changes in the init.ora file.

4.restored the control file from the RMAN backup priece.

5. mounted the database

6. Set the new file names as per the Dr structure and ran the restoration and recovery by the RMAN backups.

It completed successfully.

The control file that was created was standby control file .

now when I am trying to recover standy database with the available archives I am getting the below error :

SQL> recover standby database
ORA-00283: recovery session canceled due to errors
ORA-01665: control file is not a standby control file
While the standby control already exists.. What can i do in this situation. Please guide ?

Regards
kk
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2012
Added on Dec 19 2011
19 comments
22,612 views