Tuesday, October 28, 2008

ORA-01666: controlfile is for a standby database

# PROBLEM :-
# unable to mount an Oracle 9i standby database

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

# SOLUTION :-

SQL> alter database mount standby database;

Database altered.