We got issue in one of the production environment, RMAN archivelog backup was failing with following errors:
kgefec: fatal error 0 kgepop: no error frame to pop to for error 603
We were using following command in rcv file to backup archivelogs:
BACKUP archivelog all delete input;
After searching on metalink, I found one note with same scenario : RMAN Archivelog backup with DELETE INPUT fails kgepop: no error frame to pop to for error 603 (Doc ID 1921228.1)
According to this note, RMAN errors out when over 5000 archivelogs were being backed up resulting in an excessively large pl/sql to be executed.
Yes in my case, RMAN was processing more than 2TB archives in one go.
SELECT NAME,ROUND(SPACE_LIMIT / 1048576) SPACE_LIMIT_MB,ROUND(SPACE_USED / 1048576) SPACE_USED_MB,ROUND(((SPACE_USED / 1048576) * 100) / (SPACE_LIMIT / 1048576), 2) PRC_USED FROM V$RECOVERY_FILE_DEST; NAME SPACE_LIMIT_MB SPACE_USED_MB PRC_USED ------------------------------ -------------- ------------- ---------- +RECO_FIN 3145728 2085370 66.29
As a solution I tried reducing archive logs volume that being backed using following command :
DELETE force noprompt archivelog until time '(sysdate - 2)' backed up 1 times to device type disk;
DONE!!!! This resolved my issue 🙂
Hope so u will find this post very useful 🙂
Cheers
Regards,
Adityanath
Categories: backup & recovery, ORA errors
Adityanath's Oracle Blog 
Thanks a lot, it’s working for me also !!
Hey Frank,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
Great post, sir! This helped me tremendously as well! I was getting Archiver Hung Error because my archivelog backups had been failing to delete archivelogs for over 60 days. Thanks!
Hey Jason,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
Reblogged this on @dba_jay and commented:
Great post by Adityanath’s Oracle Blog! This helped me tremendously as well! I was getting Archiver Hung Error because my archivelog backups had been failing to delete archivelogs for over 60 days. Thanks!
Thankyou for this post, I am a big big fan of this internet site would like to keep updated.
Thanks for every other informative site. Where else may just I am getting that type of information written in such a perfect approach? I have a undertaking that I am simply now operating on, and I have been at the glance out for such info.