Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 9i RMAN question
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-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
Received on Wed Dec 07 2005 - 12:04:15 CST
![]() |
![]() |