You can backup not necessarily mean you can do recovery

Recently I have encountered difficult time to recover a test database. After several failure till 2:00 AM probably, finally I caught the meaning of the following error after speedy reading the document


RMAN-03023: executing command: recover(4)

RMAN-08060: unable to find archivelog

RMAN-08510: archivelog thread=1 sequence=8

RMAN-03026: error recovery releasing channel resources

RMAN-08031: released channel: d1

RMAN-08031: released channel: d2



For some reason, RMAN doesn't know there exits the archived log on the disk, by manually catalog several logs, problem solved:



catalog archivelog '/ora01/orabkup/GEN3Q/arch/GENQA/arch0000000008.arc';

catalog archivelog '/ora01/orabkup/GEN3Q/arch/GENQA/arch0000000009.arc';