Home » RDBMS Server » Backup & Recovery » rman error ORA-19504 (11g R2, HP-UX 64 bit)
rman error ORA-19504 [message #530327] Mon, 07 November 2011 11:41 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi Expert,

When executing full DB backup, i'm getting ORA-19504. Please suggest. /PDF/AMDD_BACKUP is new folder with 777 permission.


RMAN> connect target

connected to target database: AMDD (DBID=493031056)

RMAN> run {
2> allocate channel ch1 type disk;
3> allocate channel ch2 type disk;
4> backup database include current controlfile format '/PDF/AMDD_BACKUP/%d_Lvl0_Hot_Back';
5> backup archivelog all format '/PDF/AMDD_BACKUP/%d_Arc_Logs_%u_%t';
6> release channel t1;
7> release channel t2;
8> }

using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: sid=1747 devtype=DISK

allocated channel: ch2
channel ch2: sid=597 devtype=DISK

Starting backup at 07-NOV-11
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00060 name=/AMDD/oracle/oravl01/dbf/pool_data_AMDD_39.dbf
input datafile fno=00026 name=/AMDD/oracle/oravl05/dbf/pool_data_AMDD_14.dbf
input datafile fno=00028 name=/AMDD/oracle/oravl05/dbf/pool_data_AMDD_15.dbf
input datafile fno=00006 name=/AMDD/oracle/oravl02/dbf/pool_ix_AMDD_01.dbf
input datafile fno=00016 name=/AMDD/oracle/oravl02/dbf/pool_data_AMDD_06.dbf
input datafile fno=00018 name=/AMDD/oracle/oravl04/dbf/pool_data_AMDD_08.dbf
input datafile fno=00029 name=/AMDD/oracle/oravl05/dbf/pool_data_AMDD_16.dbf
channel ch1: starting piece 1 at 07-NOV-11
channel ch2: starting full datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00061 name=/AMDD/oracle/oravl01/dbf/pool_data_AMDD_40.dbf
input datafile fno=00032 name=/AMDD/oracle/oravl05/dbf/pool_data_AMDD_18.dbf
input datafile fno=00033 name=/AMDD/oracle/oravl05/dbf/pool_data_AMDD_19.dbf
input datafile fno=00019 name=/AMDD/oracle/oravl02/dbf/pool_data_AMDD_09.dbf
input datafile fno=00024 name=/AMDD/oracle/oravl02/dbf/pool_ix_AMDD_07.dbf
input datafile fno=00007 name=/AMDD/oracle/oravl03/dbf/pool_data_AMDD_03.dbf
input datafile fno=00034 name=/AMDD/oracle/oravl05/dbf/pool_data_AMDD_20.dbf
channel ch2: starting piece 1 at 07-NOV-11
RMAN-03009: failure of backup command on ch2 channel at 11/07/2011 17:37:00
ORA-19504: failed to create file "/PDF/AMDD_BACKUP/AMDD_Lvl0_Hot_Back"
ORA-27038: created file already exists
Re: rman error ORA-19504 [message #530328 is a reply to message #530327] Mon, 07 November 2011 11:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-19504: failed to create file "/PDF/AMDD_BACKUP/AMDD_Lvl0_Hot_Back"
>ORA-27038: created file already exists

so how can we assist?
Re: rman error ORA-19504 [message #530329 is a reply to message #530327] Mon, 07 November 2011 11:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need to create unique backupsets.
Use appropriate format options.
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmbckba.htm#CEGBCICH
And I would rather use control file autobackup.

[Updated on: Mon, 07 November 2011 11:50]

Report message to a moderator

Re: rman error ORA-19504 [message #530330 is a reply to message #530329] Mon, 07 November 2011 11:52 Go to previous message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks Mahesh,

i have missed %U into the format portion of the backup script in order to ensure a unique backup file name.

Anyhow, i was taking it as issue of NFS.

Thanks.
Previous Topic: 11g Active Database Duplication
Next Topic: Oracle Database Backup Question
Goto Forum:
  


Current Time: Fri Mar 29 09:39:29 CDT 2024