一次控制文件损坏后的恢复经历

一次在没有备份的情况下成功恢复控制文件的经历： 由于开发服务器的安装完成后并没有作任何备份。 当oracle连接出现ora-00205:的错误。查看alert_orcl.log 中提示：找到相应的trc文件。 ORA-00600: internal error code, arguments: [999], [], [], [], [], [], [], [] 一些相关的资料并不是很能够解决问题。于是尝试重新创建新的控制文件 来恢复oracle . oracle的当前状态 noarchivelog. root@mylocalhost$du -h redo01.log 101 M 1.重新生成控制文件： create controlfile reuse database "orcl" noresetlogs noarchivelog maxlogfiles 16 maxlogmembers 3 maxdatafiles 100 maxinstances 8 maxloghistory 454 logfile group 1('/opt/oracle/oradata/orcl/redo01.log') size 100m, group 1('/opt/oracle/oradata/orcl/redo02.log') size 100m, group 1('/opt/oracle/oradata/orcl/redo03.log') size 100m datafile '/opt/oracle/oradata/ORCL/cwmlite01.dbf', '/opt/oracle/oradata/ORCL/indx01.dbf', '/opt/oracle/oradata/ORCL/users01.dbf', '/opt/oracle/oradata/ORCL/drsys01.dbf', '/opt/oracle/oradata/ORCL/odm01.dbf', '/opt/oracle/oradata/ORCL/tools01.dbf', '/opt/oracle/oradata/ORCL/xdb01.dbf', '/opt/oracle/oradata/ORCL/example01.dbf', '/opt/oracle/oradata/ORCL/system01.dbf', '/opt/oracle/oradata/ORCL/undotbs01.dbf' CHARACTER SET ZHS16GBK; 2.shutdown immediate 3.startup mount. ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.0.0.0 SQL>show parameter compatible 8.1.0 由于oracle9i启动是从initorcl.ora文件中读取参数,修改 compatible=9.2.0.0.0 4.startup SQL> startup; ORACLE instance started. Total System Global Area 1125193868 bytes Fixed Size 452748 bytes Variable Size 486539264 bytes Database Buffers 637534208 bytes Redo Buffers 667648 bytes Database mounted. ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/opt/oracle/oradata/ORCL/system01.dbf' 5.恢复工作 SQL>recover database 或者 SQL>recover database using backup controlfile until cancel 6.打开数据库 SQL>alter databae open;
如果在创建控制文件的时候size 101M 则会出现错误。后来修改为100m则问题解决 。 错误提示如下： ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01163: SIZE clause indicates 20480 (blocks), but should match header 204800 ORA-01517: log member: '/opt/oracle/oradata/ORCL/redo01.log'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/90618/viewspace-520948/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/90618/viewspace-520948/