epipko_at_gmail.com wrote:
> HI all,
> We are running Oracle 9i on Win 2003 Server.
> I am trying to do my first backup using RMAN using the following:
> RUN
> {
> ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'r:\rman_back\%u';
> BACKUP DATABASE include current controlfile;
> backup archivelog all delete input;
> }
> allocate channel for maintenance device type disk;
> delete obsolete device type disk;
> SQL "alter database backup controlfile to trace ";
> exit;
>
> Looks like backup of files goes fine, but at the end I get the
> following error:
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of backup command at 12/06/2005 14:22:59
> RMAN-06059: expected archived log not found, lost of archived log
> compromises recoverability
> ORA-19625: error identifying file
> L:\ORACLE\ESST\ARCH\ESST_ARCHIVE_12690.ARC
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> Since we have to watch for free space, we have an internal routine that
> deletes archive logs older than 3 days. If I query v$archived_log, then
> I cannot see: ESST_ARCHIVE_12690.ARC in there. Is this why I am getting
> an error?
> What do I need to do for RMAN to backup correct archived logs and, not
> just delete all of them, but leave 3 days of them on disk and delete
> any others???
>
> Thanks,
> Eugene
>
Yes. Perform a crosscheck, and let RMAN delete the files:
backup archivelog all delete input; should do that.
Schedule a crosscheck every once in a while (e.g. weekly)
in order to prevent this.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Dec 07 2005 - 12:26:53 CST
