Re: RMAN error code

Mercadante, Thomas F wrote:
> Drake,
>
> Just for grins, try deleting the backup sets one at a time.
>
> RMAN> change backupset 698 delete;

Thomas,

Thanks for your reply. I have tried deleting the backup sets one at a time, unfortunately with the same result.

 > Sorry - I don't have any information about "additional information 2".

A few other helpful people have emailed me with information about "Additional information: 2" - thanks! Here is what they've told me:

John Clarke:
My guess is that "2" is an O/S return code, and in /usr/sys/include/errno.h, you'll see that error# 2 is "no such file or directory. Accompanied with ORA-27191, I'd guess that your problem is that your tape library doesn't currently have the tape(s) loaded and/or can't find them.

Mladen Gogala:
Additional information 2 means that OS returned status 2. That is a "file not found" error. In plain Spanglish, you cannot delete files from tape, only from the disk drives.

Niall Litchfield:
The source error is the ora-27191 error
(http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10744/e24280.htm#ORA-27191) which suggests a tape library issue to me. You can search for RMAN errors using the error search page as well http://otn.oracle.com/pls/db10g/db10g.error_search?search=rman-03009 for example

Thanks again everyone for your help! I now have much more to go on than before.

-Drake

--
http://www.freelists.org/webpage/oracle-l