RMAN 报：ORA-19504 ORA-27038

最新推荐文章于 2021-10-16 12:36:39 发布

Hank丶Yoon

最新推荐文章于 2021-10-16 12:36:39 发布

阅读量372

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/yoon0205/article/details/50605459

版权

Oracle 专栏收录该内容

70 篇文章 0 订阅

订阅专栏

在执行Oracle 10g的RMAN备份时遇到了ORA-19504和ORA-27038错误，问题源于备份脚本中archive log格式设置不包含唯一标识符。解决方案是在格式字符串中添加%U参数，以确保每个备份文件名的独特性，从而避免文件已存在导致的错误。

摘要由CSDN通过智能技术生成

在itpub中看到下面的问题：

oracle 10g
备份脚本如下
run{
allocate channel d1 device type disk MAXPIECESIZE=100M;
crosscheck archivelog all;
delete noprompt expired archivelog all;
backup full tag '3Gfull' database include current controlfile format '/vm_svn/rmanback/fullback_%d_%T_s%s_p%p' plus
archivelog format '/vm_svn/rmanback/arch_%d_%T_%s' delete all input;
delete noprompt obsolete;
}

输出的log
.....
input archive log thread=1 sequence=2174 recid=1631 stamp=734587098
....
input archive log thread=1 sequence=2223 recid=1680 stamp=734671824
channel d1: starting piece 1 at 10-NOV-10
channel d1: finished piece 1 at 10-NOV-10
piece handle=/opt/oracle/rmanback/arch_ORCL_20101110_1544 tag=3GFULL comment=NONE
channel d1: starting piece 2 at 10-NOV-10
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 11/10/2010 03:31:26
ORA-19504: failed to create file "/opt/oracle/rmanback/arch_ORCL_20101110_1544"
ORA-27038: created file already exists
Additional information: 1