standby controlfile issue

OS Win2000
DB 9i

Hi all,

I have read Oracle docs on standy DB creation and performed all the steps. When I try to mount the standby DB, I get this error:

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup nomount pfile=D:\Oracle\Ora92\database\init.ora
ORACLE instance started.

Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01665: controlfile is not a standby controlfile

This controlfile file was created with the 'alter database create controlfile......' command.

Any input will be highly appreciated.

Process error is my guess. I have used that a zillion times, just last week after rebuilding the primary control file because someone created the db with maxlogfiles=5, made new primary control file then create standby. Then 'copy' standby control file to other host and be sure its being used.

1) use an unusual name when you create it
2) verify it is transferred successfully
3) verify it is going in the right location by examining spfile

Quote:

---

Originally posted by roman33
This controlfile file was created with the 'alter database create controlfile......' command.

---

4. verify that you are using the control file that you think you created in the alter database command. use the TO 'c:\somwhere\stdby.ctl' option of the command.

Quote:

---

SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01665: controlfile is not a standby controlfile

This controlfile file was created with the 'alter database create controlfile......' command.

---

You have to use another command:
CREATE STANDBY CONTROLFILE AS 'filename'

Quote:

---

Originally posted by kgb
You have to use another command:
CREATE STANDBY CONTROLFILE AS 'filename'

---

Good catch Dmitri!!!
That fact obviously slipped past BJE_DBA and myself!!! :D

Thanks gus!!!!!

I mean thanks guys!!!!!

Hello,


I am getting this error: SQL> startup nomount pfile='c:\richard\local\pfile\init.ora'
ORACLE instance started.

Total System Global Area 104114204 bytes
Fixed Size 75804 bytes
Variable Size 57389056 bytes
Database Buffers 46571520 bytes
Redo Buffers 77824 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-00205: error in identifying controlfile, check alert log for more info

the Alert log states:

Wed Mar 24 13:28:37 2004
alter database mount standby database

Wed Mar 24 13:28:38 2004
ORA-00202: controlfile: 'c:\richard\control01.ctl'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Wed Mar 24 13:28:41 2004
ORA-205 signalled during: alter database mount standby database


Does that mean when moving my datafiles, standby control file and my redo log files, I also need to move my control files?