RMAN RESTORE ORA-19693-优快云博客

本文链接：https://blog.youkuaiyun.com/chenglinli0902/article/details/97815689

在跨平台异库恢复RMAN备份时遇到ORA-19693错误，该错误源于多次执行catalog命令导致备份片重复。解决方法包括检查RMAN备份摘要，确认并删除多余的备份副本，使用uncatalog命令移除不再需要的备份片。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

RMAN RESTORE ORA-19693

错误代码：
错误原因：
解决方法：

错误代码：

RMAN> run{
2> set newname for datafile 1 to ‘D:\oracle\product\10.2.0\oradata\orcl\system01.dbf’;
…
29> set newname for datafile 28 to ‘D:\oracle\product\10.2.0\oradata\orcl\users05.dbf’;
30> restore database;
31> switch datafile all;
32> recover database;
33> }
executing command: SET NEWNAME
…
executing command: SET NEWNAME

Starting restore at 30-JUL-19
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 00002 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
…
restoring datafile 00028 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS05.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/30/2019 19:25:04
ORA-19693: backup piece E:\RMAN\FULL_ORCL_6592_1_E0U5E52U.BAK already included

错误原因：

跨平台异库恢复RMAN备份集时，由于多次执行catalog start with ‘从源库拷贝到本地的备份集路径’ 命令而导致的restore错误。

解决方法：

用以下命令确认当前catalog的备份片的副本数量及“BP Key”。
RMAN> list backup summary;
RMAN> list backup of database;
…
Backup Set Copy #1 of backup set 6596
Device Type Elapsed Time Completion Time Compressed Tag

DISK 00:00:00 29-JUL-19 YES TAG20190701T213007

List of Backup Pieces for backup set 6596 Copy #1
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
6598    1   AVAILABLE   E:\RMAN\FULL_ORCL_6598_1_E6U5JDR0.BAK

Backup Set Copy #2 of backup set 6596
Device Type Elapsed Time Completion Time Compressed Tag

DISK 00:00:00 30-JUL-19 YES TAG20190701T213007

List of Backup Pieces for backup set 6596 Copy #2
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
6618    1   AVAILABLE   E:\RMAN\FULL_ORCL_6598_1_E6U5JDR0.BAK

Backup Set Copy #3 of backup set 6596
Device Type Elapsed Time Completion Time Compressed Tag

DISK 00:00:00 30-JUL-19 YES TAG20190701T213007

List of Backup Pieces for backup set 6596 Copy #3
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
6638    1   AVAILABLE   E:\RMAN\FULL_ORCL_6598_1_E6U5JDR0.BAK

Backup Set Copy #4 of backup set 6596
Device Type Elapsed Time Completion Time Compressed Tag

DISK 00:00:00 30-JUL-19 YES TAG20190701T213007

List of Backup Pieces for backup set 6596 Copy #4
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
6658    1   AVAILABLE   E:\RMAN\FULL_ORCL_6598_1_E6U5JDR0.BAK
...

找出多余的COPY #，并将多余的backup peice 副本 uncatalog掉。

使用命令：
RMAN> change backuppiece 6658 uncatalog;
RMAN> change backuppiece 6638 uncatalog;
RMAN> change backuppiece 6618 uncatalog;