impdp 导入数据出现如下错误

最新推荐文章于 2021-04-14 00:06:34 发布

iteye_19543

最新推荐文章于 2021-04-14 00:06:34 发布

阅读量313

点赞数

文章标签： oracle培训 oracle学习 cuug培训 ocp com

本文链接：https://blog.csdn.net/iteye_19543/article/details/82573878

版权

[img]http://dl2.iteye.com/upload/attachment/0095/2960/5b7c8065-293b-392b-bd4e-ac4dc74ed6c4.jpg[/img]
Errors in file /Oracle/app/diag/rdbms/gavin/Gavin/trace/Gavin_arc0_5889.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 49837568 字节磁盘空间 (从 5218762752 限制中)
ARC0: Error 19809 Creating archive log file to '/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_180_%u_.arc'
应为arc log 没有指定默认放在了闪回区,手工删除闪回区归档日志后,仍然出现以上错误,查询闪回区使用情况

sys@GAVIN>SELECT substr(name, 1, 30) name, space_limit AS quota,
2 space_used AS used,
3 space_reclaimable AS reclaimable,
4 number_of_files AS files
5 FROM v$recovery_file_dest ;

NAME QUOTA USED
------------------------------------------------------------------------------------------------------------------------ ---------- ----------
RECLAIMABLE FILES
----------- ----------
/oracle/app/flash_recovery_are 5218762752 5174088704
0 110
发现仍然记录了110个文件,并未释放.

使用rman对归档日志惊醒cross check

[oracle@virtuabox ~]$ rman target /

恢复管理器: Release 11.2.0.1.0 - Production on 星期四 7月 19 14:00:00 2012

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

连接到目标数据库: GAVIN (DBID=2942876758)

RMAN> crosscheck archivelog all;

使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=16 设备类型=DISK
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_70_80h2qxpn_.arc RECID=1 STAMP=789049214
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_71_80h6z3hl_.arc RECID=2 STAMP=789053542
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_72_80h6z8o7_.arc RECID=3 STAMP=789053549
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_73_80h6zlgv_.arc RECID=4 STAMP=789053557
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_74_80h6zrds_.arc RECID=5 STAMP=789053566
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_75_80h70264_.arc RECID=6 STAMP=789053571
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_76_80h707kp_.arc RECID=7 STAMP=789053577
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_77_80h70fg1_.arc RECID=8 STAMP=789053583
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_78_80h70mhx_.arc RECID=9 STAMP=789053589
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_79_80h70sgg_.arc RECID=10 STAMP=789053594
对归档日志的验证失败
归档日志文件名=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_80_80h70zgp_.arc RECID=11 STAMP=789053601
对归档日志的验证失败
...
...
...
...
...
=/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_179_80h7k015_.arc RECID=110 STAMP=789054113
已交叉检验的 110 对象