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.
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
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.