| ORA-01665: control file is not a standby control file [message #317165] |
Tue, 29 April 2008 14:54  |
TLegend33
Messages: 160
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:
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]
|
|
|
| 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  |
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in 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 |
TLegend33
Messages: 160
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 |
 |
ebrian
Messages: 1883
Registered: April 2006 |
Senior Member |
|
|
|
Yes.
|
|
|
]
Members
Search
Help
Register
Login
Home
