oracle中的duplicate,oracle duplicate 的ORA-19870 问题求解

我的服务器是linux 数据库版本上10.2.0.1.0,两台机器都一样的,

我想从server 1上的database duplicate 到=>server 2 上

先是server 1上用backupset 备份了 控制文件,归档日志,数据文件等

然后,将备份的文件拷到server 2的相同的文件目录下

然后到server 2 上 rman nocatalog target[email=sys/oracle@server1]sys/oracle@server1[/email]auxiliary  /

duplicate target database to LSORA1 NOFILENAMECHECK

发生了一下的错,请各位大侠相助

RMAN> duplicate target database to LSORA1 NOFILENAMECHECK;

Starting Duplicate Db at 24-AUG-08

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: sid=158 devtype=DISK

contents of Memory Script:

{

set until scn  490026;

set newname for datafile  1 to

"/u01/app/oracle/oradata/LSORA/system01.dbf";

set newname for datafile  2 to

"/u01/app/oracle/oradata/LSORA/undotbs01.dbf";

set newname for datafile  3 to

"/u01/app/oracle/oradata/LSORA/sysaux01.dbf";

set newname for datafile  4 to

"/u01/app/oracle/oradata/LSORA/users01.dbf";

set newname for datafile  5 to

"/u01/app/oracle/oradata/LSORA/tbs.dbf";

restore

check readonly

clone database

;

}

executing 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

Starting restore at 24-AUG-08

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /u01/app/oracle/oradata/LSORA/system01.dbf

restoring datafile 00002 to /u01/app/oracle/oradata/LSORA/undotbs01.dbf

restoring datafile 00003 to /u01/app/oracle/oradata/LSORA/sysaux01.dbf

restoring datafile 00004 to /u01/app/oracle/oradata/LSORA/users01.dbf

restoring datafile 00005 to /u01/app/oracle/oradata/LSORA/tbs.dbf

channel ORA_AUX_DISK_1: reading from backup piece /hotbak/LSORA_full_663630510_27_1.bak

ORA-19870: error reading backup piece /hotbak/LSORA_full_663630510_27_1.bak

ORA-19504: failed to create file "/u01/app/oracle/oradata/LSORA/system01.dbf"

ORA-27040: file create error, unable to create file

Linux Error: 2: No such file or directory

failover to previous backup

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 08/24/2008 20:21:59

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 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

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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值