RMAN backup error
Date: Mon, 18 Aug 2008 19:20:41 -0700 (PDT)
Message-ID: <9343c508-24b0-4c8b-ae08-46e67942ce30@x41g2000hsb.googlegroups.com>
I am runnign my backups and started getting this error and don't know
why. Here is my bakup script. Why is it giving me an error? Thanks
for your help.
backup device type disk format 'F:\oracle\product
\10.2.0\flash_recovery_area\dailyfull_%T_%d.bks' database;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup device type disk format 'F:\oracle\product
\10.2.0\flash_recovery_area\archivelog_%T_%d.bks' archivelog all not
backed up delete all input;
restore database validate;
CROSSCHECK BACKUPSET;
delete noprompt obsolete device type disk;
host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\pwdporky.ora F:
\oracle\product\10.2.0\flash_recovery_area';
host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora F:
\oracle\product\10.2.0\flash_recovery_area';
host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora F:
\oracle\product\10.2.0\flash_recovery_area';
Here is my backup log.
RMAN> backup device type disk format 'F:\oracle\product
\10.2.0\flash_recovery_area\dailyfull_%T_%d.bks' database;
2> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
3> backup device type disk format 'F:\oracle\product
\10.2.0\flash_recovery_area\archivelog_%T_%d.bks' archivelog all not
backed up delete all input;
4> restore database validate; 5> CROSSCHECK BACKUPSET; 6> delete noprompt obsolete device type disk; 7> host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\pwdporky.oraF:\oracle\product\10.2.0\flash_recovery_area'; 8> host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora F:\oracle\product\10.2.0\flash_recovery_area'; 9> host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora F:\oracle\product\10.2.0\flash_recovery_area';
10> 11> sql 'begin cic3.rman_email_message; end;'; 12> exit;
Starting backup at 18-AUG-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=79 devtype=DISK channel ORA_DISK_1: starting compressed full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00004 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
\PORKY\USERS01.DBF
input datafile fno=00005 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
\PORKY\USERS02.DBF
input datafile fno=00002 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
\PORKY\UNDOTBS01.DBF
input datafile fno=00003 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
\PORKY\SYSAUX01.DBF
input datafile fno=00001 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
\PORKY\SYSTEM01.DBF
input datafile fno=00006 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\PERFSTAT.DBF
input datafile fno=00007 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE
\TOOLS.DBF
channel ORA_DISK_1: starting piece 1 at 18-AUG-08 RMAN-00571:
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571:
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/18/2008 20:56:26
ORA-19504: failed to create file "F:\ORACLE\PRODUCT
\10.2.0\FLASH_RECOVERY_AREA\DAILYFULL_20080818_PORKY.BKS"
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists
Recovery Manager complete. Received on Mon Aug 18 2008 - 21:20:41 CDT