Chinaunix首页 | 论坛 | 博客
  • 博客访问: 10170876
  • 博文数量: 1669
  • 博客积分: 16831
  • 博客等级: 上将
  • 技术积分: 12594
  • 用 户 组: 普通用户
  • 注册时间: 2011-02-25 07:23
个人简介

柔中带刚,刚中带柔,淫荡中富含柔和,刚猛中荡漾风骚,无坚不摧,无孔不入!

文章分类

全部博文(1669)

文章存档

2023年(4)

2022年(1)

2021年(10)

2020年(24)

2019年(4)

2018年(19)

2017年(66)

2016年(60)

2015年(49)

2014年(201)

2013年(221)

2012年(638)

2011年(372)

分类: Oracle

2012-01-10 10:35:36

RMAN duplicate 错误越来越离奇!
分类: 数据库 268人阅读 评论(0) 举报

主库上加了一个数据文件后再进行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怎么也不行,只能通过修改内部脚本了。

奇怪了???

 

阅读(717) | 评论(0) | 转发(1) |
给主人留下些什么吧!~~