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!

ORA-27038: created file already exists

SHANOJJan 6 2013 — edited Jan 6 2013
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


RMAN-03009: failure of backup command on t1 channel at 01/06/2013 21:24:49
ORA-19504: failed to create file "/oradbs/disk_bakup/amx53s/amx53s_arch_060113_1747"
ORA-27038: created file already exists

MY RMAN SCRIPT:
-------------------------
export ORACLE_HOME
ORACLE_SID=amx53s
export ORACLE_SID

date=`date '+%d%m%y_%H%M`

JOBLOG=/oradbs/disk_bakup/amx53s/amx53s.rman_$date.log


$ORACLE_HOME/bin/rman target / NOCATALOG log "$JOBLOG" <<EOF

run {
allocate channel t1 type disk;
backup
format '/oradbs/disk_bakup/amx53s/amx53s_offline_$date'
tag='amx53s_offline'
database;

backup
format '/oradbs/disk_bakup/amx53s/amx53s_arch_$date'
tag='amx53s_ARC_Tape_backup'
archivelog all delete input ;

backup current controlfile format '/oradbs/disk_bakup/amx53s/amx53s_Ctl_$date';

crosscheck backup;
release channel t1;
}
This post has been answered by Salman Qureshi on Jan 6 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2013
Added on Jan 6 2013
5 comments
6,708 views