expdp 跳过坏块

技术文章 4个月前 完美者
1,503 0

标签:ase   com   dbf   other   lte   via   rod   bsp   warning   

一、坏块验证

[oracle@lucky ~]$ dbv file=‘/u01/eisoo.dbf‘

DBVERIFY: Release 11.2.0.1.0 - Production on Thu Oct 2 16:08:24 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /u01/eisoo.dbf
Page 148 is marked corrupt
Corrupt block relative dba: 0x01800094 (file 6, block 148)
Bad check value found during dbv: 
Data in bad block:
 type: 6 format: 2 rdba: 0x01800094
 last change scn: 0x0000.035f6b23 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x6b230601
 check value in block header: 0x8a1e
 computed block checksum: 0x300

DBVERIFY - Verification complete

Total Pages Examined         : 384
Total Pages Processed (Data) : 109
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 137
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 137
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 56584995 (0.56584995)

二、查看表,expdp报错

SQL> select count(*) from eisoo;
select count(*) from eisoo
                     *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 6, block # 148)
ORA-01110: data file 6: ‘/u01/eisoo.dbf‘

[oracle@lucky ~]$ exp eisoo/eisoo file=eisoo.dmp tables=eisoo

Export: Release 11.2.0.1.0 - Production on Thu Oct 2 16:11:15 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                          EISOO
EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 6, block # 148)
ORA-01110: data file 6: ‘/u01/eisoo.dbf‘
Export terminated successfully with warnings.

 三、启动内部事件

SQL> ALTER SYSTEM SET EVENTS=‘10231 trace name context forever,level 10‘;

System altered.

四、导出表重建

五、查看表、dbv验证

[oracle@lucky ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 2 16:15:18 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn eisoo/eisoo;
Connected.
SQL> select count(*) from eisoo;

  COUNT(*)
----------
      3139
 

 
[oracle@lucky ~]$ dbv file=‘/u01/eisoo.dbf‘

DBVERIFY: Release 11.2.0.1.0 - Production on Thu Oct 2 16:15:11 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /u01/eisoo.dbf
Page 148 is marked corrupt
Corrupt block relative dba: 0x01800094 (file 6, block 148)
Bad check value found during dbv: 
Data in bad block:
 type: 6 format: 2 rdba: 0x01800094
 last change scn: 0x0000.035f6b23 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x6b230601
 check value in block header: 0x8a1e
 computed block checksum: 0x300

DBVERIFY - Verification complete

Total Pages Examined         : 384
Total Pages Processed (Data) : 109
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 137
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 137
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0
Total Pages Encrypted        : 0

Highest block SCN            : 56584995 (0.56584995)

 

六、关闭内部事件

SQL> alter system set events=‘10231 trace name context off‘;

System altered.

 
 

expdp 跳过坏块

标签:ase   com   dbf   other   lte   via   rod   bsp   warning   

原文地址:https://www.cnblogs.com/shujuyr/p/14265289.html

版权声明:完美者 发表于 2021-01-13 11:20:08。
转载请注明:expdp 跳过坏块 | 完美导航

暂无评论

暂无评论...