首页 > Linux操作系统 > Linux操作系统 > recovery允许出现坏块
在进行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博客 ” ,链接:https://blog.itpub.net/15480802/viewspace-691242/ ,如需转载,请注明出处,否则将追究法律责任。