By on ( 32 Comments )

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

Categories: backup & recovery, ORA errors

Tagged as: , , ,

32 replies ›

  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.
    . . . . .

    Reply

  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.

    Reply

  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!

    Reply

  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.

    Reply

  5. Hi to all, it’s genuinely a fastidious for me to visit this web
    site, it contains useful Information.

    Reply

  6. 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.

    Reply

  7. 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!!!!!

    Reply

  14. It’s really a cool and useful piece of info.

    I am satisfied that you shared this useful information with us.
    Please keep us informed like this. Thank you for sharing.

    Reply

  16. Hello everyone, it’s my first pay a quick visit at
    this web page, and article is in fact fruitful in support of me, keep up posting these types of articles or
    reviews.

    Reply

  17. These are actually fantastic ideas in on the topic
    of blogging. You have touched some pleasant points
    here. Any way keep up wrinting.

    Reply

  18. Remarkable! Its really remarkable piece of
    writing, I have got much clear idea regarding from this paragraph.

    Reply

  20. Like!! I blog frequently and I really thank you for your content. The article has truly peaked my interest.

    Reply

Leave a comment