oracle 10561,oracle standby ORA-10567:故障

版本 oracle 10g R2 10.2.0.1 x64

平台:redhat as4u6-x64

oracle standby ORA-10567:故障

Errors in file

/opt/oracle10g/admin/ORCL/bdump/orcl_mrp0_30516.trc:

ORA-00600: internal error code, arguments: [3020], [4], [534917],

[1], [16135], [23783], [1

28], []

ORA-10567: Redo is inconsistent with data block (file# 4, block#

534917)

ORA-10564: tablespace USERS

ORA-01110: data file 4: '/data/ORCL/users/users01.dbf'

ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data

object# 123227

Errors with log

/data/ORCL/arch_log/1_16135_635703190_16135arch.dbf

MRP0: Background Media Recovery terminated with error 600

故障排除:

关闭standby,在primary端:

SQL>alter tablespace users begin backup;

SQL>alter tablespace users end

backup;

启动standby到managed recover模式即可