今天打开数据库的时候出现如下报错信息:
SYS@orcl 05-SEP-14>startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 587206224 bytes
Database Buffers 255852544 bytes
Redo Buffers 5132288 bytes
ORA-00214: control file '/u01/app/controlfile/control01.ctl' version 2713
inconsistent with file '/u01/app/oracle/flash_recovery_area/orcl/control03.ctl'
version 2700
*.control_files='/u01/app/controlfile/control01.ctl','/u01/app/oracle/flash_recovery_area/orcl/control02.ctl'
修改之后存盘退出,回到sqlplus。
再由pfile创建spfile,成功打开数据库,查看参数control_files:
SYS@orcl 05-SEP-14>create spfile from pfile
2 ;
File created.
SYS@orcl 05-SEP-14>startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 587206224 bytes
Database Buffers 255852544 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
SYS@orcl 05-SEP-14>show parameter cont
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /u01/app/controlfile/control01
.ctl, /u01/app/oracle/flash_re
covery_area/orcl/control02.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
global_context_pool_size string
SYS@orcl 05-SEP-14>startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 587206224 bytes
Database Buffers 255852544 bytes
Redo Buffers 5132288 bytes
ORA-00214: control file '/u01/app/controlfile/control01.ctl' version 2713
inconsistent with file '/u01/app/oracle/flash_recovery_area/orcl/control03.ctl'
version 2700
下面记录下解决过程:
这个是由于oracle中的控制文件状态不一致引起的。我的control02.ctl和control03.ctl状态不一致,于是
关闭数据库,由spfile创建pfile:
SYS@orcl 05-SEP-14>shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@orcl 05-SEP-14>create pfile from spfile;
File created.
接着找到pfile---initorcl.ora并修改其中的control_files参数。
这个是由于oracle中的控制文件状态不一致引起的。我的control02.ctl和control03.ctl状态不一致,于是
关闭数据库,由spfile创建pfile:
SYS@orcl 05-SEP-14>shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@orcl 05-SEP-14>create pfile from spfile;
File created.
*.control_files='/u01/app/controlfile/control01.ctl','/u01/app/oracle/flash_recovery_area/orcl/control02.ctl'
再由pfile创建spfile,成功打开数据库,查看参数control_files:
SYS@orcl 05-SEP-14>create spfile from pfile
2 ;
File created.
SYS@orcl 05-SEP-14>startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 587206224 bytes
Database Buffers 255852544 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
SYS@orcl 05-SEP-14>show parameter cont
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /u01/app/controlfile/control01
.ctl, /u01/app/oracle/flash_re
covery_area/orcl/control02.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
global_context_pool_size string
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29800581/viewspace-1265083/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29800581/viewspace-1265083/