Re: [RMAN] Missing archive

On 2006-10-10, astalavista <nobody_at_nowhere.com> wrote:
>
> Hi,
>
> When backuping the archives, I get, sometimes, the following error:
>
> Starting backup at 2006-10-09-16.31.03
> current log archived
> released channel: ch00
> released channel: ch01
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of backup command at 10/09/2006 16:31:16
> RMAN-06059: expected archived log not found, lost of archived log
> compromises re
> coverability
> ORA-19625: error identifying file
> /base/PROLINK/data/arch/archPROLINK1_26395.dbf
> ORA-27037: unable to obtain file status
> SVR4 Error: 2: No such file or directory
> Additional information: 3
>
>
> The script to backup is the following:
>
> run { archivelog all
> delete input ;
> }
>
> I wondered if I have to do:
> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'
> before taking the backup.

...on the subject of why some DBAs hate RMAN.

        You've got a missing archivelog.

        The result is RMAN going into panic mode.

        Execute the following:

                crosscheck archivelog all

        This will get RMAN past it's panic attack and allow you to backup the archivelogs again. A full backup may be in order at this point or not. RMAN will get like this even if an obsolete archive log is what's missing.

>
> Can you help me ?
>
> TIA
>
>
>
>
>
>
>

-- 

	Truth is irrelevant as long as the predictions are good.      |||
                                                                     / | \