10.2.0.5 on windows 64 bit
现象:从一个 server A拷贝backupset 至另一个server B。在server B上恢复。首先使用‘catalog start with ’编录backupset .
在恢复数据库的时候出现:
RMAN> restore database force;
Starting restore at 31-MAY-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\ORADATA\TESTDGP\SYSTEM01.DBF
restoring datafile 00002 to E:\ORADATA\TESTDGP\UNDOTBS01.DBF
restoring datafile 00003 to E:\ORADATA\TESTDGP\SYSAUX01.DBF
restoring datafile 00004 to E:\ORADATA\TESTDGP\USERS01.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/31/2014 10:12:51
ORA-19693: backup piece E:\BAK_04P9JK4Q_1_11 already included
在mos上找到如下文章:ID 288129.1提到恢复的时候backupset只能有一个copy
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
4 B F A DISK 30-MAY-14 1 3 NO TAG201405
30T170010
5 B F A DISK 30-MAY-14 1 3 NO TAG201405
30T170010