RMAN restore database fails with ORA-19693: backup piece XXX already included.

Yesterday I was recreating DR database with production database backup, when restore database command failed with error: ORA-19693


RMAN> restore database;
Starting restore at 05-AUG-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to G:\OPDB\REPOSITORY\DATABASE112_SE_X64\ORADATA\OPDB\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00015 to G:\OPDB\REPOSITORY\DATABASE112_SE_X64\ORADATA\OPDB\IFLOWDB_3.ORA
channel ORA_DISK_1: restoring datafile 00017 to G:\OPDB\REPOSITORY\DATABASE112_SE_X64\ORADATA\OPDB\IFLOWDB_2.ORA
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/05/2015 17:19:34
ORA-19693: backup piece G:\BACKUP\RMAN\OPDB_DBF_7829_1_886892410 already included

Before proceeding with restore, I had cataloged all backuppieces that have been copied using command : catalog start with ‘G:\BACKUP\RMAN\’;

After searching on metalink and google I got different solutions, none of which worked for me.

Some suggested to catalog backuppieces using “catalog start with” (which I had already done), while other suggested to uncatalog backuppiece.

So I tried following command to uncatlog one of the backuppiece:


RMAN> change backuppiece 'G:\BACKUP\RMAN\OPDB_DBF_7829_1_886892410' uncatalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of uncatalog command at 08/05/2015 17:19:52
RMAN-20261: ambiguous backup piece handle
RMAN-06092: error while looking up backup piece

After concentrating on error “RMAN-06092: error while looking up backup piece”, as per my understanding though “catalog start with” command was successful haven’t cataloged any of the backuppieces.

So instead of command “catalog start with”, I preferred cataloging individual backuppieces using following command:


RMAN> catalog backuppiece 'G:\BACKUP\RMAN\OPDB_DBF_7829_1_886892410';
cataloged backup piece
backup piece handle=G:\BACKUP\RMAN\OPDB_DBF_7829_1_886892410 RECID=7851 STAMP=88
6958466
And so on.....

After cataloging all backuppieces individually, I was able to restore database without any issues.

Hope so u will find this post very useful 🙂

Cheers

Regards,

Adityanath

Advertisements

18 thoughts on “RMAN restore database fails with ORA-19693: backup piece XXX already included.

  1. Hi there very coօl Ьlog!! Man .. Excellent ..
    Amazing .. I will bookmark yoսr sіte and take the feeds also?

    I am happy to find so many useful information here in the post, we’d likе
    work out more techniԛues in this regard, thank you for sharіng.
    . . . . .

  2. If some ߋne desires expеrt view on the topic of blogging afterward i
    rеcommend him/her to visit this web site, Keep up the pleаsant work.

  3. Spot on with tɦis write-uρ, I honestly think this website needs fɑr more attentіon. I’ll probably be returning to read more, thanks for the info!

  4. Hello there, You’ve done an excellent job. I’ll definitely digg it and personally recommend to my friends.
    I’m sure they will be benefited from this web site.

  5. I’m amazed, I have to admit. Rarely do I encounter a blog that’s both equally educative and
    engaging, and without a doubt, you’ve hit the nail on the head.
    The problem is an issue that too few people are
    speaking intelligently about. Now i’m very happy I
    found this during my search for something relating to this.

  6. Man, thanks a lot you just saved my life!!!!!! I was running round and round with the same issue and your way out worked just fine for me! THanks a lot!!!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s