Oracle DataGuard备库数据文件坏块处理

alert 日志报错信息：

Fri Mar 10 13:25:58 2017
Errors in file /oracle/diag/rdbms/orcl/orcl/trace/orcl_pr0i_174837.trc  (incident=45270):
ORA-00600: internal error code, arguments: [3020], [51], [1349380], [215258884], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 51, block# 1349380, file offset is 2464186368 bytes)
ORA-10564: tablespace T74_TABLE
ORA-01110: data file 51: '/oradata/orcl/t74tab_08_20G.dbf'
ORA-10560: block type '0'
Incident details in: /oracle/diag/rdbms/orcl/orcl/incident/incdir_45270/orcl_pr0i_174837_i45270.trc
Use ADRCI or Support Workbench to package the incident.

出现原因：

该数据文件存在损坏，导致redo 信息与主库不一致。

处理：

1）坏块检查：
[oracle@rorcls admin]$ dbv file=/oradata/orcl/t74tab_08_20G.dbf

DBVERIFY - Verification complete

Total Pages Examined         : 2621440
Total Pages Processed (Data) : 2523271
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 67127
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 13071
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 17971
Total Pages Marked Corrupt   : 127
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 1976922457 (3.1976922457)



2）主库备份文件到备库恢复
RMAN> backup datafile 51 format '/orabak/backup/t74tab_08_20G.dbf';

Starting backup at 10-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=136 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00051 name=/oradata/orcl/t74tab_08_20G.dbf
channel ORA_DISK_1: starting piece 1 at 10-MAR-17

channel ORA_DISK_1: finished piece 1 at 10-MAR-17
piece handle=/orabak/backup/t74tab_08_20G.dbf tag=TAG20170310T152545 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:45
Finished backup at 10-MAR-17

Starting Control File and SPFILE Autobackup at 10-MAR-17
piece handle=/oracle/fast_recovery_area/orcl/autobackup/2017_03_10/o1_mf_s_938273370_dd4ogvc1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 10-MAR-17


3）传输到备库：
RMAN> sql 'alter database datafile 51 offline drop';

RMAN> restore datafile 51;

Starting restore at 10-MAR-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=581 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00051 to /oradata/orcl/t74tab_08_20G.dbf
channel ORA_DISK_1: reading from backup piece /oradata/dgrestore/t74tab_08_20G.dbf
channel ORA_DISK_1: piece handle=/oradata/dgrestore/t74tab_08_20G.dbf tag=TAG20170310T152545
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:35
Finished restore at 10-MAR-17

5）重启日志应用
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;