Home » Server Options » Data Guard » ORA-01665: control file is not a standby control file (Oracle DB 10.2.0.2 RHEL4)
ORA-01665: control file is not a standby control file [message #317165] Tue, 29 April 2008 14:54 Go to next message
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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.
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 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes.
Previous Topic: Scripts for Monitoring Data Guard using Broker - Oracle9i
Next Topic: Query regarding upgrading protection mode in a data guard
Goto Forum:
  


Current Time: Thu Mar 28 14:03:54 CDT 2024