RE: Rman - created file already exists

From: Pal, Raj <Raj.Pal_at_echostar.com>
Date: Tue, 8 May 2007 10:01:26 -0600
Message-ID: <9B03F5DB6F5FAB42B13504933E0070AC08CE0366@MER2-EXCHB3.echostar.com>

Try using %t in your format to get a unique identifier (eg. "/ora10/oradata/orabkup/peregrine/hot_copies/peregrine_%t.rbk").

%p only gives you the piece number. %t is an RMAN time stamp.

---

Raj Pal

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Tuesday, May 08, 2007 9:45 AM
To: oracle-l_at_freelists.org
Subject: Rman - created file already exists

I have an rman script which have been using on 8.1.7.4 for several years, but when I run it on 10.2.0.2.0 I get the following error message for each channel:

RMAN-03009: failure of backup command on ch1 channel at 05/08/2007 09:32:03
ORA-19504: failed to create file
"/ora10/oradata/orabkup/peregrine/hot_copies/peregrine_070508093147_1.rb k"
ORA-27038: created file already exists

My script is shown below. I have played around with the format such as adding a %p after the channel number in the file name, but I still get the same error. Any suggestions?

Thanks,
Peter Schauss

---

---

#!/bin/ksh
#
#  rman_bkup.ksh
#
#  Backup a database using rman
#

echo " "
echo " * set Oracle environment variables " export PATH=${PATH}:/usr/local/bin

export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
export BACKUP_DIR=/ora10/oradata/orabkup/$1/hot_copies
export BACKUP_DIR2=/ora10/oradata/orabkup/$1/hot_copies

export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=$1

echo " "

signon=`cat $ORACLE_BASE/maint/dba.ctl/dba.$1` #
BASE_NAME=`date +$1_%y%m%d%H%M%S`
#
rman target $signon nocatalog <<EOF
run {

allocate channel ch1 type disk format '$BACKUP_DIR/${BASE_NAME}_1.rbk';
allocate channel ch2 type disk format '$BACKUP_DIR/${BASE_NAME}_2.rbk';
allocate channel ch3 type disk format '$BACKUP_DIR/${BASE_NAME}_3.rbk';
allocate channel ch4 type disk format '$BACKUP_DIR/${BASE_NAME}_4.rbk';
allocate channel ch5 type disk format '$BACKUP_DIR/${BASE_NAME}_5.rbk';
allocate channel ch6 type disk format '$BACKUP_DIR/${BASE_NAME}_6.rbk';

backup database;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
exit
EOF

#
#  Backup the control file which now contains a record
#  of this backup.
#

sqlplus $signon <<EOF
alter database backup controlfile to
'$BACKUP_DIR/${BASE_NAME}_control.bak';
exit
EOF
#

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 08 2007 - 11:01:26 CDT