OraFAQ Forum: Backup & Recovery » rman error ORA-19504

Home » RDBMS Server » Backup & Recovery » rman error ORA-19504 (11g R2, HP-UX 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rman error ORA-19504 [message #530327]

Mon, 07 November 2011 11:41

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

Report message to a moderator

Re: rman error ORA-19504 [message #530328 is a reply to message #530327]

Mon, 07 November 2011 11:43

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?

Report message to a moderator

Re: rman error ORA-19504 [message #530329 is a reply to message #530327]

Mon, 07 November 2011 11:47

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

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.

Report message to a moderator

Previous Topic:	11g Active Database Duplication
Next Topic:	Oracle Database Backup Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 29 21:34:39 CDT 2023