OraFAQ Forum: Data Guard » ORA-01665: control file is not a standby control file

Home » Server Options » Data Guard » ORA-01665: control file is not a standby control file (Oracle DB 10.2.0.2 RHEL4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01665: control file is not a standby control file [message #317165]

Tue, 29 April 2008 14:54

TLegend33
Messages: 203
Registered: March 2005

Senior Member

Unfortunately, I did not set up our standby database and the Sr. DBA who did is no longer with the company.
Also, unfortunately this morning our standby database experienced a power failure. We finally brought the server up and I'd like to get the standby database running. I read some documentation that indicated I need to mount the database, so I issued:

SQL> startup mount

and the database mounted. However, I read later that I needed to issue:

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 3305111552 bytes
Fixed Size                  2074760 bytes
Variable Size             704644984 bytes
Database Buffers         2583691264 bytes
Redo Buffers               14700544 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01665: control file is not a standby control file

Do I need to recreate the control file on the standby system as a standby control file? Should I back up my current control files in the even creating the standby control files does not resolve the issue?
One of my primary concerns is that I will corrupt the existing control files, thus rendering the standby database unusable.
Thanks.

[Updated on: Tue, 29 April 2008 14:57]

Report message to a moderator

Re: ORA-01665: control file is not a standby control file [message #317166 is a reply to message #317165]

Tue, 29 April 2008 15:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>One of my primary concerns is that I will corrupt the existing control files
This is why you should take a cold backup of all Oracle realted files BEFORE doing anything else.

If you have a cold backup, at least you should be able to get back to where you are right NOW to try something different.

Just follow the documented & tested Recovery Procedures.

Report message to a moderator

Re: ORA-01665: control file is not a standby control file [message #317171 is a reply to message #317166]

Tue, 29 April 2008 15:43

TLegend33
Messages: 203
Registered: March 2005

Senior Member

The procedures indicate that I need to create a standby control file by issuing

ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oracle/dbs/stbycf.ctl';

while the primary database is mounted but not open.
We cannot take our primary database down. Is there any way to create the standby control file while the primary database is still up?
Thanks.

Report message to a moderator

Re: ORA-01665: control file is not a standby control file [message #317178 is a reply to message #317171]

Tue, 29 April 2008 17:55

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Yes.

Report message to a moderator

Previous Topic:	Scripts for Monitoring Data Guard using Broker - Oracle9i
Next Topic:	Query regarding upgrading protection mode in a data guard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 14:43:34 CST 2025