我的服务器是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