oracle 控制文件启动不了,Oracle控制文件出错致使启动不到mount状态

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  217157632 bytes

Fixed Size

2251816 bytes

Variable Size

159384536 bytes

Database Buffers

50331648 bytes

Redo Buffers

5189632 bytes

SQL> start

SP2-1506: START, @ or @@ command has no arguments

SQL>

SQL> alter database mount;

alter database mount

*

ERROR at line 1:

ORA-00205: error in identifying control file, check alert log for more infooracle

Oracle能够启动到nomount状态，可是启动不到mount状态，经过上面提示能够肯定在启动到mount状态的时候，控制文件出错了。这样多是参数文件里面控制文件的路径出现了错误。app

db_name=ordb

control_files='/u01/app/oracle/oradata/oradb/control01.ctl','/u01/app/oracle/oradata/oradb/control02.ctl' 参数文件里的内容。

实际控制文件所在路径ide

[oracle@oracle11g oradata]$ cd oradb/

[oracle@oracle11g oradb]$ ls

ctl01.ctl  ctl02.ctl  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf 能够看到参数文件里面控制的路径和实际控制文件路不同。经过修改参数文件以后。

SQL> create spfile from pfile='/home/oracle/initoradb.txt';

create spfile from pfile='/home/oracle/initoradb.txt'

*

ERROR at line 1:

ORA-32002: cannot create SPFILE already being used by the instance

spa

能够看到当前实例正在使用以前错误的参数文件，先将实例关闭了。it

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> create spfile from pfile='/home/oracle/initoradb.txt';

File created.sed

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  217157632 bytes

Fixed Size   2251816 bytes

Variable Size 159384536 bytes

Database Buffers  50331648 bytes

Redo Buffers   5189632 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.file

上面错误中能够看到实例启动的过程中是先去读取参数文件，若是参数文件中控制文件的路径出现问题会致使没法启动到mount状态。command