RMAN duplicate 错误越来越离奇!

主库上加了一个数据文件后再进行duplicate 时发生如下错误:

RMAN> DUPLICATE TARGET DATABASE TO ARSPRD until time "to_date('04/07/2009 05:13','mm/dd/yyyy hh24:mi')" nofilenamecheck;

Starting Duplicate Db at 08-APR-10
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=14 devtype=DISK

printing stored script: Memory Script
{
set until scn 8366551462153;
set newname for datafile 1 to
"/global/oracle/oradata2/ARSPRD/system01.dbf";
set newname for datafile 2 to
"/global/oracle/oradata3/ARSPRD/undotbs01.dbf";
set newname for datafile 3 to
"/global/oracle/oradump2/ARSPRD/arsystem01.dbf";
set newname for datafile 4 to
"/global/oracle/oradata3/ARSPRD/drsys01.dbf";
set newname for datafile 5 to
"/global/oracle/oradata4/ARSPRD/tools01.dbf";
set newname for datafile 6 to
"/global/oracle/oradata4/ARSPRD/users01.dbf";
set newname for datafile 7 to
"/global/oracle/oradata3/ARSPRD/xdb01.dbf";
set newname for datafile 8 to
"/global/oracle2/oradata1/ARSPRD/arsystem02.dbf";
set newname for datafile 9 to
"/global/oracle/oradata1/ARSPRD/smc_mv_logs01.dbf";
set newname for datafile 10 to
"/global/oracle/oradata1/ARSPRD/arsystem03.dbf";
set newname for datafile 11 to
"/global/oracle/oradump2/ARSPRD/arsystem04.dbf";????奇怪没有12号文件。
restore
check readonly
clone database
;
}
executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 08-APR-10

using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/08/2010 01:56:02
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> exit

修改参数文件后重启数据库:*.DB_FILE_NAME_CONVERT=加上这一行。'/global/oracle/oradata1/ARSPRD/arsystem05','/global/oracle/oradump2/
ARSPRD/arsystem05'

错误依旧:

最后手工编写duplicate 脚本 :

{
set until time "to_date('Apr 06 2010 02:15:00','Mon DD YYYY HH24:MI:SS')";
set newname for datafile 1 to "/global/oracle/oradata2/ARSPRD/system01.dbf";
set newname for datafile 2 to "/global/oracle/oradata3/ARSPRD/undotbs01.dbf";
set newname for datafile 3 to "/global/oracle2/oradata1/ARSPRD/arsystem01.dbf";
set newname for datafile 4 to "/global/oracle/oradata3/ARSPRD/drsys01.dbf";
set newname for datafile 5 to "/global/oracle/oradata4/ARSPRD/tools01.dbf";
set newname for datafile 6 to "/global/oracle/oradata4/ARSPRD/users01.dbf";
set newname for datafile 7 to "/global/oracle/oradata3/ARSPRD/xdb01.dbf";
set newname for datafile 8 to "/global/oracle2/oradata1/ARSPRD/arsystem02.dbf";
set newname for datafile 9 to "/global/oracle/oradata1/ARSPRD/smc_mv_logs01.dbf";
set newname for datafile 10 to "/global/oracle/oradata1/ARSPRD/arsystem03.dbf";
set newname for datafile 11 to "/global/oracle/oradump2/ARSPRD/arsystem04.dbf";
set newname for datafile 12 to "/global/oracle/oradump2/ARSPRD/arsystem05.dbf";-----显示指定12号文件。
restore
check readonly
clone database
;
}

成功复制。

上一次加11号文件的时候的修改::*.DB_FILE_NAME_CONVERT就可以了。

现在试了好几次PFILE和SPFILE怎么也不行,只能通过修改内部脚本了。

奇怪了???

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值