Cause :-
This error can occur for lost/corrupted any
control file.
In my situation I have unfortunately lost one of control file from two files.
In my situation I have unfortunately lost one of control file from two files.
Solution :-
Create pfile from
spfile > Edit pfile Change "*.control_files=" parameter. Open database using pfile.
SQL> select status from v$instance;
STATUS
------------
STARTED
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> select status from v$instance;
STATUS
------------
STARTED
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> create
pfile='D:\pfile.ora' from spfile;
File created.
Now edit pfile
File created.
Now edit pfile
Remove missing
control file
SQL> ALTER
DATABASE MOUNT;
ALTER DATABASE MOUNT
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
ALTER DATABASE MOUNT
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> SHUTDOWN IMMEDIATE;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>
STARTUP PFILE=D:\pfile.ora;
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 310378960 bytes
Database Buffers 218103808 bytes
Redo Buffers 5804032 bytes
Database mounted.
Database opened.
SQL>
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 310378960 bytes
Database Buffers 218103808 bytes
Redo Buffers 5804032 bytes
Database mounted.
Database opened.
SQL>
SQL> create spfile
from pfile;
File created.
No comments:
Post a Comment