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

Leave a reply to Anonymous Cancel reply