Wednesday, 24 September 2014

RMAN 20261 ambiguous backup piece handle ORA - 19693

RMAN> recover database noredo;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/24/2014 00:36:41
ORA-19693: backup piece C:\INCREMENTAL\INC_GCPJ8UC8_1_1.BAK already included


RMAN> change backuppiece 'C:\INCREMENTAL\INC_GCPJ8UC8_1_1.BAK' uncatalog;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of uncatalog command at 09/24/2014 00:35:31
RMAN-20261: ambiguous backup piece handle
RMAN-06092: error while looking up backup piece


 RMAN> list backup;

 List of Backup Pieces for backup set 71 Copy #1
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
71      1   AVAILABLE   C:\INCREMENTAL\INC_GDPJ8UCN_1_1.BAK

List of Backup Pieces for backup set 71 Copy #2
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
77      1   AVAILABLE   C:\INCREMENTAL\INC_GDPJ8UCN_1_1.BAK


RMAN> change backuppiece 71 uncatalog;

uncataloged backup piece
backup piece handle=C:\INCREMENTAL\INC_GDPJ8UCN_1_1.BAK RECID=71 STAMP=859077016
Uncataloged 1 objects



RMAN> change backuppiece 77 uncatalog;

uncataloged backup piece
backup piece handle=C:\INCREMENTAL\INC_GDPJ8UCN_1_1.BAK RECID=77 STAMP=859077286
Uncataloged 1 objects


RMAN> recover database noredo;

Starting recover at 24-SEP-14
using channel ORA_DISK_1

Finished recover at 24-SEP-14



No comments:

Post a Comment