RMAN重新注册备份集

一、实验环境
1）查看已有备份集

1. RMAN> list backup summary;
   
2. List of Backups
   
3. ===============
   
4. Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
   
5. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
   
6. 411 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
   
7. 412 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
   
8. 413 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
   
9. 414 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
   
10. 416 B A A DISK 09-MAR-16 1 1 NO ARC_BAK
    
11. 417 B A A DISK 09-MAR-16 1 1 NO ARC_BAK
    
12. 418 B A A DISK 09-MAR-16 1 1 NO ARC_BAK
    
13. 419 B F A DISK 09-MAR-16 1 1 NO CTLFILE_BAK
    
14. 420 B F A DISK 09-MAR-16 1 1 NO SPFILE_BAK

2）原备份路径为/home/oracle/backup修改成/home/oracle/bak/
3）crosscheck备份集，发现已全部标记为EXPIRED

1. RMAN> crosscheck backup;
   
2. 
   
3. using channel ORA_DISK_1
   
4. crosschecked backup piece: found to be 'EXPIRED'
   
5. backup piece handle=/home/oracle/backup/neal_lv0_e6r02vfk_1_1_20160309 RECID=411 STAMP=906067446
   
6. crosschecked backup piece: found to be 'EXPIRED'
   
7. backup piece handle=/home/oracle/backup/neal_lv0_e3r02vfk_1_1_20160309 RECID=412 STAMP=906067444
   
8. crosschecked backup piece: found to be 'EXPIRED'
   
9. backup piece handle=/home/oracle/backup/neal_lv0_e4r02vfk_1_1_20160309 RECID=413 STAMP=906067446
   
10. crosschecked backup piece: found to be 'EXPIRED'
    
11. backup piece handle=/home/oracle/backup/neal_lv0_e5r02vfk_1_1_20160309 RECID=414 STAMP=906067446
    
12. crosschecked backup piece: found to be 'EXPIRED'
    
13. backup piece handle=/home/oracle/backup/neal_arch_e8r02vi2_1_1_20160309 RECID=416 STAMP=906067522
    
14. crosschecked backup piece: found to be 'EXPIRED'
    
15. backup piece handle=/home/oracle/backup/neal_arch_e9r02vi2_1_1_20160309 RECID=417 STAMP=906067522
    
16. crosschecked backup piece: found to be 'EXPIRED'
    
17. backup piece handle=/home/oracle/backup/neal_arch_ear02vi2_1_1_20160309 RECID=418 STAMP=906067522
    
18. crosschecked backup piece: found to be 'EXPIRED'
    
19. backup piece handle=/home/oracle/backup/neal_ctlfile_ebr02vi3_1_1_20160309 RECID=419 STAMP=906067524
    
20. crosschecked backup piece: found to be 'EXPIRED'

4）备份集中Status=X表示备份集已失效

1. RMAN> list backup summary;
   
2. List of Backups
   
3. ===============
   
4. Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
   
5. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
   
6. 411 B 0 X DISK 09-MAR-16 1 1 NO NEAL_LV0
   
7. 412 B 0 X DISK 09-MAR-16 1 1 NO NEAL_LV0
   
8. 413 B 0 X DISK 09-MAR-16 1 1 NO NEAL_LV0
   
9. 414 B 0 X DISK 09-MAR-16 1 1 NO NEAL_LV0
   
10. 416 B A X DISK 09-MAR-16 1 1 NO ARC_BAK
    
11. 417 B A X DISK 09-MAR-16 1 1 NO ARC_BAK
    
12. 418 B A X DISK 09-MAR-16 1 1 NO ARC_BAK
    
13. 419 B F X DISK 09-MAR-16 1 1 NO CTLFILE_BAK
    
14. 420 B F X DISK 09-MAR-16 1 1 NO SPFILE_BAK

5）删除expired的备份集信息

1. RMAN> delete noprompt expired backup;
   
2. using channel ORA_DISK_1
   
3. 
   
4. List of Backup Pieces
   
5. BP Key BS Key Pc# Cp# Status Device Type Piece Name
   
6. ------- ------- --- --- ----------- ----------- ----------
   
7. 411 411 1 1 EXPIRED DISK /home/oracle/backup/neal_lv0_e6r02vfk_1_1_20160309
   
8. 412 412 1 1 EXPIRED DISK /home/oracle/backup/neal_lv0_e3r02vfk_1_1_20160309
   
9. 413 413 1 1 EXPIRED DISK /home/oracle/backup/neal_lv0_e4r02vfk_1_1_20160309
   
10. 414 414 1 1 EXPIRED DISK /home/oracle/backup/neal_lv0_e5r02vfk_1_1_20160309
    
11. 416 416 1 1 EXPIRED DISK /home/oracle/backup/neal_arch_e8r02vi2_1_1_20160309
    
12. 417 417 1 1 EXPIRED DISK /home/oracle/backup/neal_arch_e9r02vi2_1_1_20160309
    
13. 418 418 1 1 EXPIRED DISK /home/oracle/backup/neal_arch_ear02vi2_1_1_20160309
    
14. 419 419 1 1 EXPIRED DISK /home/oracle/backup/neal_ctlfile_ebr02vi3_1_1_20160309
    
15. 420 420 1 1 EXPIRED DISK /home/oracle/backup/neal_spfile_ecr02vi5_1_1_20160309
    
16. deleted backup piece
    
17. backup piece handle=/home/oracle/backup/neal_lv0_e6r02vfk_1_1_20160309 RECID=411 STAMP=906067446
    
18. deleted backup piece
    
19. backup piece handle=/home/oracle/backup/neal_lv0_e3r02vfk_1_1_20160309 RECID=412 STAMP=906067444
    
20. deleted backup piece
    
21. backup piece handle=/home/oracle/backup/neal_lv0_e4r02vfk_1_1_20160309 RECID=413 STAMP=906067446
    
22. deleted backup piece
    
23. backup piece handle=/home/oracle/backup/neal_lv0_e5r02vfk_1_1_20160309 RECID=414 STAMP=906067446
    
24. deleted backup piece
    
25. backup piece handle=/home/oracle/backup/neal_arch_e8r02vi2_1_1_20160309 RECID=416 STAMP=906067522
    
26. deleted backup piece
    
27. backup piece handle=/home/oracle/backup/neal_arch_e9r02vi2_1_1_20160309 RECID=417 STAMP=906067522
    
28. deleted backup piece
    
29. backup piece handle=/home/oracle/backup/neal_arch_ear02vi2_1_1_20160309 RECID=418 STAMP=906067522
    
30. deleted backup piece
    
31. backup piece handle=/home/oracle/backup/neal_ctlfile_ebr02vi3_1_1_20160309 RECID=419 STAMP=906067524
    
32. deleted backup piece
    
33. backup piece handle=/home/oracle/backup/neal_spfile_ecr02vi5_1_1_20160309 RECID=420 STAMP=906067525
    
34. deleted backup piece

6）再次查看发现已经没有可以用来恢复的备份集

1. RMAN> list backup summary;
   
2. specification does not match any backup in the repository

二、重新注册备份集
1、注册单个备份片
1）使用catalog backuppiece命令来指定所需注册的备份片

1. RMAN> catalog backuppiece '/home/oracle/bak/neal_lv0_e6r02vfk_1_1_20160309','/home/oracle/bak/neal_lv0_e3r02vfk_1_1_20160309';
   
2. 
   
3. cataloged backup piece
   
4. backup piece handle=/home/oracle/bak/neal_lv0_e6r02vfk_1_1_20160309 RECID=438 STAMP=906127338
   
5. cataloged backup piece
   
6. backup piece handle=/home/oracle/bak/neal_lv0_e3r02vfk_1_1_20160309 RECID=439 STAMP=906127338

2）list命令发现已经注册到rman中

1. RMAN> list backup summary;
   
2. List of Backups
   
3. ===============
   
4. Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
   
5. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
   
6. 438 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
   
7. 439 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0

2、注册整个目录
1）使用catalog start with来指定备份集所在的文件目录，最好加上/

1. RMAN> catalog start with '/home/oracle/bak/';
   
2. 
   
3. --如果是ASM使用方式如下
   
4. catalog start with '+disk';
   
5. 
   
6. searching for all files that match the pattern /home/oracle/bak/
   
7. 
   
8. List of Files Unknown to the Database
   
9. =====================================
   
10. File Name: /home/oracle/bak/neal_spfile_eur04m79_1_1_20160310
    
11. File Name: /home/oracle/bak/neal_arch_err04m73_1_1_20160310
    
12. File Name: /home/oracle/bak/neal_arch_eqr04m73_1_1_20160310
    
13. File Name: /home/oracle/bak/neal_arch_e9r02vi2_1_1_20160309
    
14. File Name: /home/oracle/bak/neal_lv0_e4r02vfk_1_1_20160309
    
15. File Name: /home/oracle/bak/neal_lv0_e5r02vfk_1_1_20160309
    
16. File Name: /home/oracle/bak/neal_lv0_enr04m4j_1_1_20160310
    
17. File Name: /home/oracle/bak/neal_arch_epr04m73_1_1_20160310
    
18. File Name: /home/oracle/bak/neal_ctlfile_etr04m77_1_1_20160310
    
19. 
    
20. Do you really want to catalog the above files (enter YES or NO)? yes
    
21. cataloging files...
    
22. cataloging done
    
23. 
    
24. List of Cataloged Files
    
25. =======================
    
26. File Name: /home/oracle/bak/neal_spfile_eur04m79_1_1_20160310
    
27. File Name: /home/oracle/bak/neal_arch_err04m73_1_1_20160310
    
28. File Name: /home/oracle/bak/neal_arch_eqr04m73_1_1_20160310
    
29. File Name: /home/oracle/bak/neal_arch_e9r02vi2_1_1_20160309
    
30. File Name: /home/oracle/bak/neal_lv0_e4r02vfk_1_1_20160309
    
31. File Name: /home/oracle/bak/neal_lv0_e5r02vfk_1_1_20160309
    
32. File Name: /home/oracle/bak/neal_lv0_enr04m4j_1_1_20160310
    
33. File Name: /home/oracle/bak/neal_arch_epr04m73_1_1_20160310
    
34. File Name: /home/oracle/bak/neal_ctlfile_etr04m77_1_1_20160310

2）查看备份集注册情况

1. RMAN> list backup summary;
   
2. List of Backups
   
3. ===============
   
4. Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
   
5. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
   
6. 438 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
   
7. 439 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
   
8. 440 B F A DISK 10-MAR-16 1 1 NO SPFILE_BAK
   
9. 441 B A A DISK 10-MAR-16 1 1 NO ARC_BAK
   
10. 442 B A A DISK 10-MAR-16 1 1 NO ARC_BAK
    
11. 443 B A A DISK 09-MAR-16 1 1 NO ARC_BAK
    
12. 444 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
    
13. 445 B 0 A DISK 09-MAR-16 1 1 NO NEAL_LV0
    
14. 448 B F A DISK 10-MAR-16 1 1 NO CTLFILE_BAK

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29812844/viewspace-2063681/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29812844/viewspace-2063681/