Clear the Oracle flashback Zone

The following error occurs when importing impdp data:

1. ErrorsInFile/Oracle/app/diag/rdbms/gavin/Gavin/trace/Gavin_arc0_5889.trc:
2. ORA-19809: exceeds the limit on the number of recovery files
3. ORA-19804: unable to reclaim 49837568 bytes of disk space (from 5218762752 limit)
4. ARC0: Error 19809 Creating archive log fileTo '/Oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_180 _ % u _. arc' 

It should be because the arc log is not specified and is stored in the flash back area by default. After you manually delete the archived log in the flash back area, the above error still occurs. query the flash back area usage.

1. Sys @ GAVIN>SELECTSubstr (Name, 1, 30)Name, Space_limitASQuota,
2. 2 space_usedASUsed,
3. 3 space_reclaimableASReclaimable,
4. 4 number_of_filesASFiles
5. 5FROMV $ recovery_file_dest;
6.  
7. NAMEQUOTA USED
8. Certificate -------------------------------------------------------------------------------------------------------------------------------------------- 
9. RECLAIMABLE FILES
10. --------------------- 
11. /Oracle/app/flash_recovery_are 5218762752 5174088704
12. 0 110

110 files are still recorded and not released.

Use rman to wake up with cross check

1. [Oracle @ virtuabox ~] $ Rman target/
2.  
3. Recovery MANAGER: Release 11.2.0.1.0-ProductionOnThursday July 19 14:00:00 2012
4.  
5. Copyright (c) 1982,200 9, OracleAnd/OrIts affiliates.AllRights reserved.
6.  
7. Connect to the target database: GAVIN (DBID = 2942876758)
8.  
9. RMAN> crosscheck archivelogAll;
10.  
11. Use the target database control file to replace the recovery directory
12. Allocated channel: ORA_DISK_1
13. Channel ORA_DISK_1: SID = 16 device type = DISK
14. An error occurred while verifying the archived logs.
15. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_70_80h2qxpn _. arc RECID = 1 STAMP = 789049214
16. An error occurred while verifying the archived logs.
17. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_000071_80h6z3hl _. arc RECID = 2 STAMP = 789053542
18. An error occurred while verifying the archived logs.
19. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_72_80h6z8o7 _. arc RECID = 3 STAMP = 789053549
20. An error occurred while verifying the archived logs.
21. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_000073_80h6zlgv _. arc RECID = 4 STAMP = 789053557
22. An error occurred while verifying the archived logs.
23. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_74_80h6zrds _. arc RECID = 5 STAMP = 789053566
24. An error occurred while verifying the archived logs.
25. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_000075_80h70264 _. arc RECID = 6 STAMP = 789053571
26. An error occurred while verifying the archived logs.
27. Archived log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_10976_80h707kp _. arc RECID = 7 STAMP = 789053577
28. An error occurred while verifying the archived logs.
29. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_77_80h70fg1 _. arc RECID = 8 STAMP = 789053583
30. An error occurred while verifying the archived logs.
31. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_78_80h70mhx _. arc RECID = 9 STAMP = 789053589
32. An error occurred while verifying the archived logs.
33. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_10979_80h70sgg _. arc RECID = 10 STAMP = 789053594
34. An error occurred while verifying the archived logs.
35. Archive log file name =/oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_000080_80h70zgp _. arc RECID = 11 STAMP = 789053601
36. An error occurred while verifying the archived logs.
37. ...
38. ...
39. ...
40. ...
41. ...
42. =/Oracle/app/flash_recovery_area/GAVIN/archivelog/2012_07_19/o1_mf_1_179_801_k015 _. arc RECID = 110 STAMP = 789054113
43. 110 objects that have been cross-checked

1 2 3 Next Page