Home » RDBMS Server » Backup & Recovery » ORA-19504: failed to create file "+MY_DG2" (Release 10.2.0.1.0)
ORA-19504: failed to create file "+MY_DG2" [message #325291] Thu, 05 June 2008 10:02 Go to next message
bpeasey
Messages: 46
Registered: March 2005
Member
Hi,

I'm following an Oracle by Example (OBE) on Backup and Recovery

Where I've create a job to backup the archive log files as per:

Quote:
For the job name, enter DAILY_ARCH_BACKUP. Enter a description for this job, such as 'Backup archived log files in the flash recovery area'. For the RMAN script, you can either choose to have a saved script executed by typing in @c:\wkdir\backup_arch.rman or you can type in the RMAN script to run, such as the one listed here:

run {
backup archivelog all delete input format 'c:\wkdir';
}



But when the job runs I get the following error:

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jun 5 09:39:40 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> 

connected to target database: FPPS (DBID=2628313990)

using target database control file instead of recovery catalog

RMAN> 

echo set on

RMAN> @c:\wkdir\backup_arch.rman

RMAN> run {

2>   backup archivelog all delete input format '+MY_DG2';

3> }

Starting backup at 05-JUN-08

current log archived

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=140 devtype=DISK

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=118 recid=1 stamp=656533880

input archive log thread=1 sequence=119 recid=2 stamp=656534722

input archive log thread=1 sequence=120 recid=3 stamp=656557238

input archive log thread=1 sequence=121 recid=4 stamp=656588207

input archive log thread=1 sequence=122 recid=5 stamp=656588382

channel ORA_DISK_1: starting piece 1 at 05-JUN-08

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/05/2008 09:39:51

ORA-19504: failed to create file "+MY_DG2"

RMAN> **end-of-file**

RMAN> exit;

Recovery Manager complete.



I have the file c:\wkdir\backup_arch.rman which I downloaded from the OBE page. Any suggestions are greatly appreciated. Thx.

Brian

Re: ORA-19504: failed to create file "+MY_DG2" [message #325293 is a reply to message #325291] Thu, 05 June 2008 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
First, that is one nicely formatted post!

I suspect that you are not running ASM & possibly do not have any FRA defined.

You can find the RMAN manual at http://tahiti.oracle.com which enumerates the requirements for RMAN
Re: ORA-19504: failed to create file "+MY_DG2" [message #325297 is a reply to message #325291] Thu, 05 June 2008 10:23 Go to previous messageGo to next message
bpeasey
Messages: 46
Registered: March 2005
Member
Hi,

I see now that 'MY_DG2' is ASM related. Which I don't have configured. FRA is there and filling up nicely. Will check out the rman syntax for the correct format.

Thx.
Brian
Re: ORA-19504: failed to create file "+MY_DG2" [message #325314 is a reply to message #325297] Thu, 05 June 2008 12:44 Go to previous message
JackyShu
Messages: 25
Registered: May 2008
Junior Member
just remove "+" from "+MY_DG2"
Previous Topic: open problem after recover
Next Topic: Backup strategy
Goto Forum:
  


Current Time: Sun Dec 04 18:38:44 CST 2016

Total time taken to generate the page: 0.13192 seconds