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
- unused block corruption 处理一例
- 系统运维之--处理block corruption
- 修复 block corruption
- VS2010下Heap corruption排查一例
- 数据库修复【block corruption recovery】
- all about oracle block corruption
- 遇到C++ error: heap corruption detected:after normal block(#xxx) at 0x xxxxxxxx怎么处理
- HEAP CORRUPTION DETECTED :after Normal block 错误
- 检查数据块损坏(Block Corruption)
- heap corruption detected: after normal block
- [每日一题] OCP1z0-047 :2013-07-26 alter table set unused之后各种情况处理..................15
- 11g Active Standby Database Automatic Block Corruption Repair
- heap corruption detected: after normal block 可能的原因
- heap corruption detected: after normal block 可能的原因
- (转)heap corruption detected: after normal block(#xxx) 。。
- bug笔记: heap corruption detected: after normal block
- 关于oracle block corruption (mos (文档 ID 840978.1))
- HEAP CORRUPTION DETECTED:after Normal block错误方法解决
- 如何在Linux 4.12内核添加系统调用
- java Web Lesson 1-4(笔记)
- 杀时间的人最终都被时间杀掉了
- 暑期项目开发实训 Day18
- List<Map<String,Object>>按某个字段排序
- unused block corruption 处理一例
- MSSQL联表查询优化
- 为什么df和lsblk显示的内存不一样大
- socket与http的区别
- FFMPEG(二)关键数据结构
- 关于在页面哪部分引入JS的讨论
- ORA-00257:程序归档错误,在释放之前仅限于内部连接
- 香港服务器的核心特点是什么
- Eclipse+Maven创建webapp项目