RMAN ORA-19504、ORA-27038错误解决方法

jesonc-wei

RMAN ORA-19504、ORA-27038错误解决方法
系统;redhat 5.4
数据库: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
通过网上找资料，发现需要在备份文件中加个%U参数，如下为测试结果，成功
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
说明：对于上面的报错，以前在9204版本用的时候都很正常，并未出现过

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u3/93765/showart_2180548.html