Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 9i RMAN question

9i RMAN question

From: <epipko_at_gmail.com>
Date: 7 Dec 2005 10:04:15 -0800
Message-ID: <1133978654.933811.198480@g47g2000cwa.googlegroups.com>


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 Received on Wed Dec 07 2005 - 12:04:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US