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

Advertisements

8 responses to “RMAN fails with kgefec: fatal error 0 kgepop: no error frame to pop to for error 603”

  1. Franck Avatar
    Franck

    Thanks a lot, it’s working for me also !!

    1. Adityanath Dewoolkar Avatar

      Hey Frank,

      Thanks for visiting and appreciate your feedback.:-)

      Regards,
      Adi

  2. jasonbrown264 Avatar

    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!

    1. Adityanath Dewoolkar Avatar

      Hey Jason,

      Thanks for visiting and appreciate your feedback.:-)

      Regards,
      Adi

  3. jasonbrown264 Avatar

    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!

  4. Juan Jonak Avatar
    Juan Jonak

    Thankyou for this post, I am a big big fan of this internet site would like to keep updated.

  5. Veda Chuang Avatar
    Veda Chuang

    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.

  6.  Avatar
    Anonymous

    I really liked your blog post.Thanks Again. Really Great.

Leave a reply to jasonbrown264 Cancel reply

Advertisements
Blog Stats

560,801 hits

Advertisements
Advertisements