Rman re-registering backup sets simple experiment

First, the experimental environment

1 View Existing backup sets

rman> list backup summary;  List of Backups =============== Key TY LV S Device Type completion time #Pieces #Copies compressed Tag------------          -----------------------------------------------------411 B 0 A DISK 09-mar-16 1 1 NO        Neal_lv0 412 B 0 A disk 09-mar-16 1 1 NO neal_lv0 413 b 0 A Disk         09-mar-16 1 1 No neal_lv0 414 B 0 A DISK 09-mar-16 1 1 No Neal_lv0 416 B A A disk 09-mar-16 1 1 NO arc_bak 417 b A a disk 0 9-mar-16 1 1 No Arc_bak 418 B a A DISK 09-mar-16 1 1 No A Rc_bak 419 B F A disk 09-mar-16 1 1 NO Ctlfile_bak 420 b f a disk 09-m AR-16 1 1 NO spfile_bak 

2) The original backup path for/home/oracle/backup modified into/home/oracle/bak/

3 crosscheck backup set, found all marked as expired

Rman> crosscheck Backup; Using channel Ora_disk_1 crosschecked backup Piece:found to IS ' expired ' backup piece Handle=/home/oracle/backup/neal_lv0 _e6r02vfk_1_1_20160309 recid=411 stamp=906067446 crosschecked backup piece:found to be ' expired ' backup piece Handle=/hom e/oracle/backup/neal_lv0_e3r02vfk_1_1_20160309 recid=412 stamp=906067444 crosschecked backup piece:found to be '
Expired ' backup piece handle=/home/oracle/backup/neal_lv0_e4r02vfk_1_1_20160309 recid=413 stamp=906067446 crosschecked backup Piece:found to be ' expired ' backup piece handle=/home/oracle/backup/neal_lv0_e5r02vfk_1_1_20160309 recid=414 stamp=906067446 crosschecked backup piece:found to be ' expired ' backup piece handle=/home/oracle/backup/neal_a rch_e8r02vi2_1_1_20160309 recid=416 stamp=906067522 crosschecked backup piece:found to be ' expired ' backup piece handle=/ home/oracle/backup/neal_arch_e9r02vi2_1_1_20160309 recid=417 stamp=906067522 crosschecked backup piece:found to be ' Expired ' backup piece handle=/home/oracle/backup/neal_arch_ear02vi2_1_1_20160309 recid=418 stamp=906067522 crosschecked backup piece:found to be '
Expired ' backup piece handle=/home/oracle/backup/neal_ctlfile_ebr02vi3_1_1_20160309 recid=419 STAMP=906067524 crosschecked backup Piece:found to be ' expired '

4 The backup set STATUS=X indicates that the backup sets have expired

Rman> list backup summary;
List of Backups
===============
Key     TY LV S Device Type completion time #Pieces #Copies compressed Tag
--- --------------------------------------------------------------
411     B  0  X DISK        09-MAR-16
  1       1       no         neal_lv0
412     B  0  X DISK        09-mar-16       1       1       no         Neal_lv0
413     b  0  X DISK        09-mar-16       1       1       NO         neal_lv0
414     b  0  X Disk        09-mar-16       1       1       NO         neal_lv0
416     B  A  X disk        09-mar-16       1       1       no         arc_bak
417     B  A  X DISK        09-mar-16       1       1       No         arc_bak
418     B  A  X DISK        09-mar-16       1       1       NO         arc_bak
419     B  F  x Disk        09-mar-16       1       1       NO         ctlfile_bak
420     B  f  x disk        09- MAR-16       1       1       NO         Spfile_bak

5 Delete Expired backup set information

rman> Delete noprompt expired backup;  Using channel Ora_disk_1 List of Backup Pieces BP Key BS key pc# cp# Status Device Type Piece Name-------------- --------------------------------------411 411 1 1 Expired Disk/home/oracle/backup/neal_lv0_e 6r02vfk_1_1_20160309 412 412 1 1 expired disk/home/oracle/backup/neal_lv0_e3r02vfk_1_1_20160309 41 3 413 1 1 expired disk/home/oracle/backup/neal_lv0_e4r02vfk_1_1_20160309 414 414 1 1 E        xpired disk/home/oracle/backup/neal_lv0_e5r02vfk_1_1_20160309 416 416 1 1 expired DISK /home/oracle/backup/neal_arch_e8r02vi2_1_1_20160309 417 417 1 1 expired Disk/home/oracle/backup/ne al_arch_e9r02vi2_1_1_20160309 418 418 1 1 expired Disk/home/oracle/backup/neal_arch_ear02vi2_1_1_2 0160309 419 419 1 1 Expired disk/home/oracle/backup/neal_ctlfile_ebr02vi3_1_1_20160309 420 420 1 1 Expired disk/home/oracle/backup/neal_spfile_ecr02vi5_1_1_20160309 deleted backup Piece backup piece handle=/home/oracle/backup/neal_lv0_e6r02vfk_1_1_20160309 recid=411 stamp=906067446 deleted backup Piece backup piece handle=/home/oracle/backup/neal_lv0_e3r02vfk_1_1_20160309 recid=412 stamp=906067444 deleted backup Piece backup piece handle=/home/oracle/backup/neal_lv0_e4r02vfk_1_1_20160309 recid=413 stamp=906067446 deleted backup Piece backup piece handle=/home/oracle/backup/neal_lv0_e5r02vfk_1_1_20160309 recid=414 stamp=906067446 deleted backup Piece backup piece handle=/home/oracle/backup/neal_arch_e8r02vi2_1_1_20160309 recid=416 stamp=906067522 deleted
Backup piece backup piece handle=/home/oracle/backup/neal_arch_e9r02vi2_1_1_20160309 recid=417 stamp=906067522 Deleted backup piece backup piece handle=/home/oracle/backup/neal_arch_ear02vi2_1_1_20160309 recid=418 stamp= 906067522 deleted backup piece backup piece Handle=/home/oracle/backup/neal_ctlfile_ebr02vi3_1_1_20160309 recid=419 stamp=906067524 deleted backup piece backup piece handle=/home/oracle/ backup/neal_spfile_ecr02vi5_1_1_20160309 recid=420 stamp=906067525 deleted backup piece

6 See again that there is no backup set that can be used to recover

Rman> list backup summary;
Specification does not match no backup in the repository

re-registering backup sets

1. Register a single backup slice

1 Use the Catalog backuppiece command to specify the required registered backup slices

rman> Catalog backuppiece '/home/oracle/bak/neal_lv0_e6r02vfk_1_1_20160309 ', '/home/oracle/bak/neal_lv0_ e3r02vfk_1_1_20160309 ';

Cataloged backup piece
backup piece handle=/home/oracle/bak/neal_lv0_e6r02vfk_1_1_20160309 recid=438 stamp= 906127338
cataloged backup piece
backup piece handle=/home/oracle/bak/neal_lv0_e3r02vfk_1_1_20160309 recid= 439 stamp=906127338

2 List command found already registered in Rman

Rman> list backup summary;
List of Backups
===============
Key     TY LV S Device Type completion time #Pieces #Copies compressed Tag
--- --------------------------------------------------------------
438     B  0  A DISK        09-MAR-16
  1       1       no         neal_lv0
439     B  0  A DISK        09-mar-16       1       1       no         Neal_lv0

2. Register the whole catalogue

1 Use catalog start with to specify the file directory where the backup set resides, preferably Plus/

rman> catalog start with '/home/oracle/bak/';

-If the ASM is used in the following way catalog start with ' +disk '; Searching for all files, match the pattern/home/oracle/bak/list of files Unknown to the Database ================== =================== file name:/home/oracle/bak/neal_spfile_eur04m79_1_1_20160310 file name:/home/oracle/bak/neal_ arch_err04m73_1_1_20160310 file name:/home/oracle/bak/neal_arch_eqr04m73_1_1_20160310 file name:/home/oracle/bak/ neal_arch_e9r02vi2_1_1_20160309 file name:/home/oracle/bak/neal_lv0_e4r02vfk_1_1_20160309 file name:/home/oracle/ bak/neal_lv0_e5r02vfk_1_1_20160309 file name:/home/oracle/bak/neal_lv0_enr04m4j_1_1_20160310 file name:/home/ oracle/bak/neal_arch_epr04m73_1_1_20160310 File Name:/home/oracle/bak/neal_ctlfile_etr04m77_1_1_20160310 do Really want to catalog the above files (enter YES or NO)? Yes cataloging files ... cataloging done List of cataloged files ======================= File Name:/home/oracle/bak/neal_ spfile_eur04m79_1_1_20160310 FileName:/home/oracle/bak/neal_arch_err04m73_1_1_20160310 File Name:/home/oracle/bak/neal_arch_eqr04m73_1_1_20160310 File name:/home/oracle/bak/neal_arch_e9r02vi2_1_1_20160309 file name:/home/oracle/bak/neal_lv0_e4r02vfk_1_1_ 20160309 file name:/home/oracle/bak/neal_lv0_e5r02vfk_1_1_20160309 file name:/home/oracle/bak/neal_lv0_enr04m4j_1_ 1_20160310 file name:/home/oracle/bak/neal_arch_epr04m73_1_1_20160310 file name:/home/oracle/bak/neal_ctlfile_ etr04m77_1_1_20160310

2 View Backup Set Registration

rman> list backup summary;  List of Backups =============== Key TY LV S Device Type completion time #Pieces #Copies compressed Tag------------          -----------------------------------------------------438 B 0 A DISK 09-mar-16 1 1 NO        Neal_lv0 439 b 0 A disk 09-mar-16 1 1 NO neal_lv0 440 b F A disk         10-mar-16 1 1 No Spfile_bak 441 B A A DISK 10-mar-16 1 1 No        Arc_bak 442 b A A disk 10-mar-16 1 1 NO arc_bak 443 b A A disk         09-mar-16 1 1 No Arc_bak 444 B 0 A DISK 09-mar-16 1 1 No Neal_lv0 445 b 0 A disk 09-mar-16 1 1 NO neal_lv0 448 b F A disk 10-ma R-16 1 1 NO ctlfile_bak