主库上加了一个数据文件后再进行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怎么也不行,只能通过修改内部脚本了。
奇怪了???
分享到:
相关推荐
Oracle RMAN DUPLICATE教程
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库
使用RMAN DUPLICATE...FROM ACTIVE DATABASE 创建物理备库 简化standby创建过程,提高效率
rman duplicate 搭建dg 一步步向你展示如何不停机搭建dg
Oracle Rman Active Database Duplicate 迁移方案V1.1.pdf
Rman通过duplicate创建standby
Oracle Rman增量备份Level012脚本,公司用的oracle rac,asm的备份恢复都是通过RMAN,已实践!!
RMAN高级应用之Duplicate复制数据库
RMAN高级应用之Duplicate复制数据库 1.基本概述 2.创建辅助实例 3.不同环境下的复制流程 4.实战 5.附录
Oracle数据库RMAN备份与恢复技术!
oracle rman的学习笔记,!!!
RMAN全备脚本,我们公司搭用的oracle rac,所以ASM备份恢复通过rman实现,已实践!
第一篇 进入RMAN 第二篇 RMAN命令知多少 第三篇 RMAN备份演练初级篇 第四篇 RMAN备份演练进阶篇 第五篇 RMAN基础知识补充 一 第六篇 实战RMAN备份 第七篇 RMAN基础知识补充 二 第八篇 演练RMAN恢复 第九篇 实战rman...
自己用过的备份策略,简单实用,包含了rman0级备份,1级和2级备份的脚本。rman0级备份 #!/bin/bash #chkinst.sh export EDITOR=vi export ORACLE_BASE=/u01/app/oracle ...
RMAN高级应用之Duplicate复制数据库
跟三思一步步学习Rman,很不错的!希望对大学学习有帮助
oracle rman备份 恢复!!
搭建单实例文件系统ORACLE DG,分为2种情况: 1. 利用rman duplicate 在线搭建备库 2. 利用主库备份,离线方式搭建备库
[三思笔记]一步一步学rman 一、进入rman 二、rman命令知多少 三、rman备份演练初级篇 四、rman备份演练进阶篇 五、rman外传-基础资料篇1 六、实战rman备份 七、rman外传-基础资料篇2 八、演练rman恢复 九、实战rman...