RMAN ORA-19693 error resolution

10.2.0.5 on windows 64 bit
 
Phenomenon: Copy backupset from server A to server B. Recover from server B. First, use 'catalog start with' to catalog backupset.
 
When restoring the database, the following error occurs:
 
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_000011 already supported DED

Find the following article on mos: ID 288129.1 indicates that the backupset can only have one copy during restoration.

Use list backup summary:
 
RMAN> list backup summary;

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

Use RMAN> list backup of database tag = TAG20140530T170010; To list copies greater than 1.

Rename the disk's backupset, delete the redundant backup, and re-catalog.
 
Two cases:
 
1. The actual backupset has only one copy. due to multiple catalog S, entries is duplicated.
 
You can rename the backupset, re-catalog, and then crosscheck.
 
Note: You can use other methods to delete the entry ??
 
2. The actual backupset has multiple points, and the excessive backupset is deleted before crosscheck.

OERR: ORA-19693 backup piece % s already included (Document ID 288129.1)

Applies:
Oracle Server-Enterprise Edition-Version 10.1.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 12 Jul 2012
PURPOSE
 
Provide OERR information for ORA-19693
 
DETAILS
 
{This note contains error information about an "Oracle Server" error number. It may contain in additional support notes as described in Note: 22080.1}
 
Error: ORA-19693
Text: backup piece % s already included
---------------------------------------------------------------------------
Cause: This backup piece was already specified for future sion 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.

-------------------------------------- Recommended reading --------------------------------------

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------