RMAN ORA-19504、ORA-27038錯(cuò)誤解決方法

jesonc-wei

RMAN ORA-19504、ORA-27038錯(cuò)誤解決方法
系統(tǒng);redhat 5.4
數(shù)據(jù)庫:10.2.0.1
[oracle@oracle oracle]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jan 22 18:57:57 2010

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

connected to target database: MYDB (DBID=2623955059)
RMAN> backup database format '/opt/oracle/test.dbf';

Starting backup at 22-JAN-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/oracle/oradata/mydb/system01.dbf
input datafile fno=00003 name=/opt/oracle/oradata/mydb/sysaux01.dbf
input datafile fno=00006 name=/opt/oracle/oradata/mydb/catalog_tbs.dbf
input datafile fno=00005 name=/opt/oracle/oradata/mydb/jiajia.dbf
input datafile fno=00002 name=/opt/oracle/oradata/mydb/undotbs01.dbf
input datafile fno=00004 name=/opt/oracle/oradata/mydb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 22-JAN-10
channel ORA_DISK_1: finished piece 1 at 22-JAN-10
piece handle=/opt/oracle/test.dbf tag=TAG20100122T190025 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 22-JAN-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/22/2010 19:02:04
ORA-19504: failed to create file "/opt/oracle/test.dbf"
ORA-27038: created file already exists
Additional information: 1
通過網(wǎng)上找資料，發(fā)現(xiàn)需要在備份文件中加個(gè)%U參數(shù)，如下為測試結(jié)果，成功
RMAN> backup database format '/home/oracle/test_%U.dbf';

Starting backup at 22-JAN-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/oracle/oradata/mydb/system01.dbf
input datafile fno=00003 name=/opt/oracle/oradata/mydb/sysaux01.dbf
input datafile fno=00006 name=/opt/oracle/oradata/mydb/catalog_tbs.dbf
input datafile fno=00005 name=/opt/oracle/oradata/mydb/jiajia.dbf
input datafile fno=00002 name=/opt/oracle/oradata/mydb/undotbs01.dbf
input datafile fno=00004 name=/opt/oracle/oradata/mydb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 22-JAN-10
channel ORA_DISK_1: finished piece 1 at 22-JAN-10
piece handle=/home/oracle/test_0hl44car_1_1.dbf tag=TAG20100122T191122 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 22-JAN-10
channel ORA_DISK_1: finished piece 1 at 22-JAN-10
piece handle=/home/oracle/test_0il44ccs_1_1.dbf tag=TAG20100122T191122 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-JAN-10
說明：對于上面的報(bào)錯(cuò)，以前在9204版本用的時(shí)候都很正常，并未出現(xiàn)過

本文來自ChinaUnix博客，如果查看原文請點(diǎn)：http://blog.chinaunix.net/u3/93765/showart_2180548.html