| ORA-19504: failed to create file "+MY_DG2" [message #325291] |
Thu, 05 June 2008 10:02  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
