ITPub博客

首页 > Linux操作系统 > Linux操作系统 > recovery允许出现坏块

recovery允许出现坏块

原创 Linux操作系统 作者:myownstars 时间:2011-03-29 17:35:48 0 删除 编辑

在进行recover的时候,如果出现坏块,可以通过添加allow n corruption 来暂时跳过这个错误继续进行恢复。

周一的时候就遇到了这个情况,当时是恢复物理备库的时候遇到错误

Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 16 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /data/oracle/oradata/justin/arch/1_3697_722804382.dbf
Completed: ALTER DATABASE RECOVER  managed standby database disconnect from session
Mon Mar 28 11:24:03 2011
Errors in file /data/oracle/diag/rdbms/justin/justin/trace/justin_pr04_1824.trc  (incident=252244):
ORA-00600: internal error code, arguments: [3020], [7], [113548], [29473676], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 7, block# 113548, file offset is 930185216 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 7: '/data/oracle/oradata/justin/undotbs02.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /data/oracle/diag/rdbms/justin/justin/incident/incdir_252244/justin_pr04_1824_i252244.trc
Slave exiting with ORA-600 exception
Errors in file /data/oracle/diag/rdbms/justin/justin/trace/justin_pr04_1824.trc:
ORA-00600: internal error code, arguments: [3020], [7], [113548], [29473676], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 7, block# 113548, file offset is 930185216 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 7: '/data/oracle/oradata/justin/undotbs02.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Mon Mar 28 11:24:04 2011

通过执行Recover standby database allow 1 corruption 顺利恢复;这个命令可能会造成部分数据不一致,建议慎重使用。

以下是oracle的官方解释

If you decide to allow recovery to proceed in spite of block corruptions, then run the RECOVER command with the ALLOW n CORRUPTION clause, where n is the number of allowable corrupt blocks.

To allow recovery to corrupt blocks:

Ensure that all normal recovery preconditions are met. For example, if the database is open, then take tablespaces offline before attempting recovery.

Run the RECOVER command, allowing a single corruption, repeating as necessary for each corruption to be made. The following statements shows a valid example:

RECOVER DATABASE ALLOW 1 CORRUPTION

 

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

上一篇: find 命令
请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3159856