ORA-19693: 已包括备份片段 /opt/prodb/racpdb/2bufts5f_1_1

问题描述

RMAN> recover database;

Starting recover at 04-11月-2019 15:53:09
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=23501
channel ORA_DISK_1: reading from backup piece /opt/prodb/racpdb/28uftl4h_1_1
channel ORA_DISK_2: starting archived log restore to default destination
channel ORA_DISK_2: restoring archived log
archived log thread=1 sequence=29446
channel ORA_DISK_2: reading from backup piece /opt/prodb/racpdb/29uftl4h_1_1
channel ORA_DISK_3: starting archived log restore to default destination
channel ORA_DISK_3: restoring archived log
archived log thread=1 sequence=29447
Oracle Error:
ORA-01547: 警告: RECOVER 成功但 OPEN RESETLOGS 将出现如下错误
ORA-01152: 文件 1 没有从过旧的备份中还原
ORA-01110: 数据文件 1: '+DATA/racpdb/datafile/system.285.1023458409'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/04/2019 15:53:14
ORA-19693: 已包括备份片段 /opt/prodb/racpdb/2bufts5f_1_1

问题描述：

[oracle@testpdb1 ~]$ oerr ora 19693
19693, 00000, "backup piece %s already included"
// *Cause:  This backup piece was already specified for inclusion in the
//          restore conversation. A restore conversation may process only
//          a single instance of a backup piece.
// *Action: Remove the specified duplicate backup piece in restore steps
//          and restart the conversation.

此备份片已用于RESTORE中。

问题解决

1.crosscheck backup;
2.delete expired backup;
3.recover database;
如果还报错：
4.使用CATALOG START WITH重新添加备份集
5.recover database;

channel default: deleting archived log(s)
archived log file name=+FRA/racpdb/archivelog/2019_11_04/thread_1_seq_29462.272.1023465953 RECID=51430 STAMP=1023465954
unable to find archived log
archived log thread=1 sequence=29463
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/04/2019 16:06:00
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 29463 and starting SCN of 2787125039

RMAN> recover database until sequence 29463;

Starting recover at 04-11月-2019 16:06:43
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 04-11月-2019 16:06:47