Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman

user13364377Aug 4 2010 — edited Aug 4 2010
I am taking a full backup of the database using rman to a specific location. My control file and spfile autobackup is ON.
I am getting the error message mentioned below ...

RMAN> backup database format '/oracle/rmanbackup/full' tag=fullbackupnormal;

Starting backup at 04-AUG-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/oracle/product/dbn/system01.dbf
input datafile fno=00003 name=/oracle/product/dbn/sysaux01.dbf
input datafile fno=00005 name=/oracle/product/dbn/example01.dbf
input datafile fno=00002 name=/oracle/product/dbn/undotbs01.dbf
input datafile fno=00010 name=/oracle/indxts.dbf
input datafile fno=00012 name=/oracle/secondf.dbf
input datafile fno=00004 name=/oracle/product/dbn/users01.dbf
input datafile fno=00006 name=/oracle/product/newtablespace.dbf
channel ORA_DISK_1: starting piece 1 at 04-AUG-10
channel ORA_DISK_1: finished piece 1 at 04-AUG-10
piece handle=/oracle/rmanbackup/full tag=FULLBACKUPNORMAL comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 04-AUG-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/04/2010 03:55:44
ORA-19504: failed to create file "/oracle/rmanbackup/full"
ORA-27038: created file already exists
Additional information: 1

-----------------

the database full backup is successful as we can notice it from the message
'piece handle=/oracle/rmanbackup/full tag=FULLBACKUPNORMAL comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05'

Since my controlfile and spfile autobackup is ON, database is not able to create the control file and spfile backups with the same name. Please correct if I and wrong and how to resolve this...
This post has been answered by unknown-698157 on Aug 4 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2010
Added on Aug 4 2010
4 comments
718 views