问题描述
故障现状:
1、前期nfs搭建备库时数据错误,导致备库这个文件损坏,建议备份主库文件后切换回来,然后重搭备库!
2、客户决定采用usb硬盘对主库文件全备:
USB挂载的时候参数:barrier=0,data=writeback,commit=60
测试最大的并发可能,这些可以加速ext4的效率,但是务必unmount
搭好备库做recover时候报错:
archived log file name=/backup1/orcl/archivelog/1_12635_860525963.dbf thread=1 sequence=12635
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/23/2019 22:21:25
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile ‘/backup1/orcl/archivelog/1_12635_860525963.dbf’
ORA-00600: internal error code, arguments: [3020], [10], [1322389505], [1322389505], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 10, block# 1322389505, file offset is 1107304448 bytes)
ORA-10564: tablespace DT_IMG_DAT
ORA-01110: data file 10: ‘/backup1/orcl/oradata/data_D-ORCL_TS-DT_IMG_DAT_FNO-10’
ORA-10560: block type ‘0’
dbv file=/backup1/orcl/oradata/data_D-ORCL_TS-DT_IMG_DAT_FNO-10 start=1322389505 end=1322389505




