channel ORA_DISK_1: starting piece 1 at 15-JUN-16 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/15/2016 11:10:18 ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 117977088 bytes disk space from 75161927680 limit
NAME SIZE_M USED_M PCT_USED -------------------------------- ------------ ------------ -------- F:\oracle\fra 81,920 71,635 88
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------- ------------------ ------------------------- --------------- CONTROL FILE 0 0 0 REDO LOG 0 0 0 ARCHIVED LOG 87.23 .02 521 BACKUP PIECE .22 0 5 IMAGE COPY 0 0 0 FLASHBACK LOG 0 0 0 FOREIGN ARCHIVED LOG 0 0 0
Ale zde žádné soubory nejsou. Správce OS je smazal ručně.
F:\oracle\fra\orcl\ARCHIVELOG\2016_06_15>dir
Volume in drive F is LOGS
Volume Serial Number is D2DD-77F1
Directory of F:\oracle\fra\orcl\ARCHIVELOG\2016_06_15
06/15/2016 11:21 AM <DIR> .
06/15/2016 11:21 AM <DIR> ..
06/15/2016 09:11 AM 493,056 O1_MF_1_21784_CP1ZWPC7_.ARC
06/15/2016 09:11 AM 2,048 O1_MF_1_21785_CP1ZWX1N_.ARC
06/15/2016 09:11 AM 6,656 O1_MF_1_21786_CP1ZX35Q_.ARC
06/15/2016 09:11 AM 4,096 O1_MF_1_21787_CP1ZX5HV_.ARC
06/15/2016 09:11 AM 8,704 O1_MF_1_21788_CP1ZXBNH_.ARC
06/15/2016 09:21 AM 634,880 O1_MF_1_21789_CP20J9RH_.ARC
06/15/2016 09:22 AM 543,744 O1_MF_1_21790_CP20K500_.ARC
06/15/2016 09:22 AM 8,192 O1_MF_1_21791_CP20KFC8_.ARC
06/15/2016 09:22 AM 3,072 O1_MF_1_21792_CP20KMYG_.ARC
06/15/2016 09:22 AM 2,048 O1_MF_1_21793_CP20KSZ2_.ARC
06/15/2016 09:22 AM 1,024 O1_MF_1_21794_CP20KY4H_.ARC
06/15/2016 09:22 AM 1,024 O1_MF_1_21795_CP20L1JZ_.ARC
06/15/2016 10:21 AM 4,446,208 O1_MF_1_21796_CP240CQQ_.ARC
06/15/2016 10:21 AM 1,024 O1_MF_1_21797_CP240K5D_.ARC
06/15/2016 10:21 AM 18,432 O1_MF_1_21798_CP240P9K_.ARC
06/15/2016 10:21 AM 50,176 O1_MF_1_21799_CP240W7R_.ARC
06/15/2016 10:21 AM 1,536 O1_MF_1_21800_CP2412G9_.ARC
06/15/2016 11:10 AM 10,550,272 O1_MF_1_21801_CP26VOYM_.ARC
06/15/2016 11:18 AM 420,352 O1_MF_1_21802_CP27COO0_.ARC
06/15/2016 11:19 AM 143,360 O1_MF_1_21803_CP27DZJY_.ARC
06/15/2016 11:20 AM 154,624 O1_MF_1_21804_CP27HB98_.ARC
06/15/2016 11:21 AM 61,440 O1_MF_1_21805_CP27JTC8_.ARC
06/15/2016 11:21 AM 10,752 O1_MF_1_21806_CP27K0BY_.ARC
06/15/2016 11:21 AM 2,048 O1_MF_1_21807_CP27K6G2_.ARC
06/15/2016 11:21 AM 1,024 O1_MF_1_21808_CP27K9B0_.ARC
06/15/2016 11:21 AM 1,024 O1_MF_1_21809_CP27KGDP_.ARC
26 File(s) 17,570,816 bytes
2 Dir(s) 98,476,253,184 bytes free
Řešení
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
Deleted 495 EXPIRED objects
NAME SIZE_M USED_M PCT_USED -------------------------------- ------------ ------------ -------- F:\oracle\fra 81,920 197 1