Tuesday, February 23, 2016

ORA-19622: archived log thread 1 sequence 0001 not restored due to missing data while restore

Very recently I got stuck with my db restore. The error which occurred and failed my restore with ORA-19622. 

Things to observe:

1.) We had a valid backup to restore
2.) The archive log sequence which gave error while restore was physically available on the backup server.


I tried multiple restore but no success.

If you guys stuck in such situation. Please dont waste your time.



This is an oracle bug. 


Bug 18674170 : RMAN RESTORE FOR AN ARCHIVED LOG FAILS WITH ORA-19622 MISSING DATA

Unable to restore Archive logs size > 32 GB and fails with ORA-19622: archived log thread 1 sequence 0001 not restored due to missing data.

This is confirmed bug for versions 11.2.02, 11.2.0.3 and 11.2.04

 There is a one off patch available for this bug.

I would recommend contact Oracle support for this issue.