unused block corruption 处理一例

来源:互联网 发布:苏联海军 知乎 编辑:程序博客网 时间:2024/06/09 15:11

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

Processing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/TABLESPACE_QUOTAProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/SYNONYM/SYNONYMProcessing object type SCHEMA_EXPORT/TYPE/TYPE_SPECProcessing object type SCHEMA_EXPORT/DB_LINKProcessing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANTProcessing object type SCHEMA_EXPORT/TABLE/TABLEORA-39171: Job is experiencing a resumable wait.ORA-01659: unable to allocate MINEXTENTS beyond 2 in tablespace WEBDATAORA-39171: Job is experiencing a resumable wait.ORA-01659: unable to allocate MINEXTENTS beyond 2 in tablespace WEBDATA^CImport> Import> stop_jobAre 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|moreDBVERIFY: Release 11.2.0.1.0 - Production on Fri Jul 14 23:03:09 2017Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.DBVERIFY - Verification starting : FILE = /data/WEBDATA.dbfDBVERIFY - Verification completeTotal Pages Examined         : 774144Total Pages Processed (Data) : 60684Total Pages Failing   (Data) : 0Total Pages Processed (Index): 2Total Pages Failing   (Index): 0Total Pages Processed (Other): 40319Total Pages Processed (Seg)  : 0Total Pages Failing   (Seg)  : 0Total Pages Empty            : 673139Total Pages Marked Corrupt   : 0Total Pages Influx           : 0Total Pages Encrypted        : 0Highest block SCN            : 1165168 (0.1165168)



阅读全文
0 0
原创粉丝点击