unused block corruption 处理一例

今天在导入一份数据遇到 磁盘空间满，导致impdp 导入进程挂起，提示如下错误：

 

Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39171: Job is experiencing a resumable wait.
ORA-01659: unable to allocate MINEXTENTS beyond 2 in tablespace WEBDATA
ORA-39171: Job is experiencing a resumable wait.
ORA-01659: unable to allocate MINEXTENTS beyond 2 in tablespace WEBDATA
^C
Import> 

Import> stop_job
Are you sure you wish to stop this job ([yes]/no): yes

尝试扩展数据文件 提示 i/o 错误，用dbv 查看了一下有大量的坏块

 

扩展了 /data 分区后，再重新使用impdp 导入数据 

dbv file=webdata.dbf blocksize=8192

 

dbv file=/data/WEBDATA.dbf  blocksize=8192|more

DBVERIFY: Release 11.2.0.1.0 - Production on Fri Jul 14 23:03:09 2017

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

DBVERIFY - Verification starting : FILE = /data/WEBDATA.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 774144
Total Pages Processed (Data) : 60684
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 2
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 40319
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 673139
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 1165168 (0.1165168)