当前位置:Oracle研究中心 > 故障案例 >
时间:2016-09-09 20:34 来源:Oracle研究中心 作者:惜分飞 点击: 次
ERROR: Format: ORA-600 [3020] [a] [b] {c} [d] [e] VERSIONS: version 6.0 and above DESCRIPTION: This is called a 'STUCK RECOVERY'. There is an inconsistency between the information stored in the redo and the information stored in a database block being recovered. ARGUMENTS: For Oracle 9.2 and earlier: Arg [a] Block DBA Arg [b] Redo Thread Arg 1 Redo RBA Seq Arg [d] Redo RBA Block No Arg [e] Redo RBA Offset. For Oracle 10.1 Arg [a] Absolute file number of the datafile. Arg [b] Block number Arg 1 Block DBA FUNCTIONALITY: kernel cache recovery parallel IMPACT: INSTANCE FAILURE during recovery. SUGGESTIONS: There have been cases of receiving this error when RECOVER has been issued, but either some datafiles were not restored to disk, or the restoration has not finished. Therefore, ensure that the entire backup has been restored and that the restore has finished PRIOR to issuing a RECOVER database command. If problems continue, consider restoring from a backup and doing a point-in-time recovery to a time PRIOR to the one implied by the ORA-600[3020] error. Example: SQL> recover database until time 'YYYY-MON-DD:HH:MI:SS'; This error can also be caused by a lost update. During normal operations, block updates/writes are being performed to a number of files including database datafiles, redo log files, archived redo log files etc. This error can be reported if any of these updates are lost for some reason. Therefore, thoroughly check your operating system and disk hardware. In the case of a lost update, restore an old copy of the datafile and attempt to recover and roll forward again.
--------------------------------------ORACLE-DBA----------------------------------------
最权威、专业的Oracle案例资源汇总之【案例】Oracle报错ORA-00600 3020 产生的原因和MOS解决办法
本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/959.html
Powered by Oracle研究中心 OraclePlus Inc.
BY DedeCMS 京ICP备14022373号-5
声明:Oracle研究中心部分文章源自互联网,转载均按原文作者要求转载,如有疑问联系QQ:1026002015,协商未果24小时删除。