oracle中rman坏块,使用rman进行坏块修复（ORA-01578、ORA-01110）

Dump file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j002_1872.trc部分内容如下：Mon Jul 02 22:17:29 2012

ORACLE V10.2.0.3.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options

Windows Server 2003 Version V5.2 Service Pack 2

CPU                 : 8 - type 586, 2 Physical Cores

Process Affinity    : 0x00000000

Memory (Avail/Total): Ph:14514M/16382M, Ph+PgF:16031M/17822M, VA:2626M/4095M

Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 28

Windows thread id: 1872, image: ORACLE.EXE (J002)

*** 2012-07-02 22:17:29.718

*** ACTION NAME:(GATHER_STATS_JOB) 2012-07-02 22:17:29.703

*** MODULE NAME:(DBMS_SCHEDULER) 2012-07-02 22:17:29.703

*** SERVICE NAME:(SYS$USERS) 2012-07-02 22:17:29.703

*** SESSION ID:(147.1) 2012-07-02 22:17:29.703

ORA-00604: error occurred at recursive SQL level 2

ORA-01578: ORACLE data block corrupted (file # 1, block # 71013)

ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'

*** 2012-07-02 22:17:29.734

GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYSMAN"','"MGMT_SEVERITY"','""', ...)

ORA-00604: error occurred at recursive SQL level 2

ORA-01578: ORACLE data block corrupted (file # 1, block # 71013)

ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'

*** 2012-07-02 22:17:52.515

GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"HISTGRM$"','""', ...)

ORA-01578: ORACLE data block corrupted (file # 1, block # 71013)

ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'

*** 2012-07-02 22:20:55.312

GATHER_STATS_JOB: GATHER_TABLE_STATS('"ZLHIS"','"病人医嘱记录"','""', ...)

ORA-00604: error occurred at recursive SQL level 2

ORA-01578: ORACLE data block corrupted (file # 3, block # 56437)

ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'……