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: 12 Dec 2005 08:32:52 -0800
Message-ID: <1134405172.648690.77900@z14g2000cwz.googlegroups.com>


Hi all,
I am running Oracle 9i on Win2003 Server. I am running:
RUN
 {
ALLOCATE CHANNEL ch0 DEVICE TYPE DISK;
CROSSCHECK ARCHIVELOG ALL;
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT 'r:\rman_RET2\%d_%p.bk'; ALLOCATE CHANNEL ch2 DEVICE TYPE DISK FORMAT 'r:\rman_RET2\%d_%p.bk'; BACKUP DATABASE PLUS ARCHIVELOG;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK; DELETE OBSOLETE DEVICE TYPE DISK;
SQL "alter database backup controlfile to trace"; exit;

and getting:

RMAN-00571: ========================================================
RMAN-00569: =========== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ========================================================
RMAN-03002: failure of backup command at 12/12/2005 08:26:35
ORA-19504: failed to create file "r:\rman_RET2\TITAN_1.bk"
ORA-27038: skgfrcre: file exists
OSD-04010: <create> option specified, file already exists

We have an OS command that delets old arch logs, so I need to make sure that RMAN checks for valid arch logs first. Then I am trying to backup d/base and logs and thn delete backed up logs.

Why is it failing? Message saying that the file already exists, however, I see no files in "r:\rman_RET2"

Thanks,
Eugene Received on Mon Dec 12 2005 - 10:32:52 CST

Original text of this message

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