1、报错详情:
[oracle@oraclecent7402 admin]$ sqlplus / as sysdba
SQL> shutdown abort
SQL> startup nomount;
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '/u01/app/oracle/oradata/ywsrmtest/control01.ctl'
version 18992 inconsistent with file
'/u01/app/oracle/fast_recovery_area/ywsrmtest/control02.ctl' version 18988
2、开始解决:
SQL> create pfile='/u01/app/oracle/oradata/ywsrmtest/init.ora' from spfile;
File created.
前往以上文件路径,编辑ora文件,删除control02.ctl
[oracle@oraclecent7402 ywsrmtest]$ vi init.ora
ywsrmtest.__db_cache_size=9462349824
ywsrmtest.__java_pool_size=134217728
ywsrmtest.__large_pool_size=167772160
ywsrmtest.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
ywsrmtest.__pga_aggregate_target=3791650816
ywsrmtest.__sga_target=11374952448
ywsrmtest.__shared_io_pool_size=0
ywsrmtest.__shared_pool_size=1543503872
ywsrmtest.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/ywsrmtest/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u01/app/oracle/oradata/ywsrmtest/control01.ctl'---删除掉02.ctl
……
SQL> shutdow abort
ORACLE instance shut down.
SQL> create spfile from pfile='/u01/app/oracle/oradata/ywsrmtest/init.ora';
File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1.1324E+10 bytes
Fixed Size 2263416 bytes
Variable Size 2113930888 bytes
Database Buffers 9193914368 bytes
Redo Buffers 14053376 bytes
SQL>
SQL> alter database mount;
Database altered.----这一次数据库挂载成功咯~
SQL> exit