Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: epipko@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: 9i rman question
Date: 12 Dec 2005 08:32:52 -0800
Organization: http://groups.google.com
Lines: 35
Message-ID: <1134405172.648690.77900@z14g2000cwz.googlegroups.com>
NNTP-Posting-Host: 12.144.240.34
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1134405177 25969 127.0.0.1 (12 Dec 2005 16:32:57 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 12 Dec 2005 16:32:57 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=12.144.240.34;
   posting-account=4M6ulA0AAAB0U-Ai6sdFh_EoFhB5CQGh
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:257558

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