备份集迁移到其他目录后加入到catalog的过程

http://blog.chinaunix.net/uid-77311-id-3035955.html
下面演示将备份集mv到其他目录后加入catalog的过程.

1.列出当前的备份集信息(当前的备份集位于目录/u01/rman_backup/2011/201111/)

1. RMAN> list backup;
   
2. 
   
3. using target database control file instead of recovery catalog
   
4. 
   
5. List of Backup Sets
   
6. ===================
   
7. 
   
8. BS Key Type LV Size Device Type Elapsed Time Completion Time
   
9. ------- ---- -- ---------- ----------- ------------ ---------------
   
10. 
    
11. 4 Full 351.26M DISK 00:00:51 30-NOV-11
    
12.         BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
    
13.         Piece Name: /u01/rman_backup/2011/201111/df_768589674_5_1.bak
    
14.   List of Datafiles in backup set 4
    
15.   File LV Type Ckp SCN Ckp Time Name
    
16.   ---- -- ---- ---------- --------- ----
    
17. 
    
18.   1 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/system01.dbf
    
19.   4 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/users01.dbf
    
20. 
    
21. BS Key Type LV Size Device Type Elapsed Time Completion Time
    
22. ------- ---- -- ---------- ----------- ------------ ---------------
    
23. 
    
24. 5 Full 173.91M DISK 00:00:55 30-NOV-11
    
25.         BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
    
26.         Piece Name: /u01/rman_backup/2011/201111/df_768589674_6_1.bak
    
27.   List of Datafiles in backup set 5
    
28.   File LV Type Ckp SCN Ckp Time Name
    
29.   ---- -- ---- ---------- --------- ----
    
30. 
    
31.   2 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/undotbs01.dbf
    
32.   3 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/sysaux01.dbf
    
33.   5 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/hxl01.dbf
    
34. 
    
35. BS Key Type LV Size Device Type Elapsed Time Completion Time
    
36. ------- ---- -- ---------- ----------- ------------ ---------------
    
37. 
    
38. 6 Full 6.77M DISK 00:00:03 30-NOV-11
    
39.         BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
    
40.         Piece Name: /u01/rman_backup/2011/201111/df_768589733_7_1.bak
    
41.   Control File Included: Ckp SCN: 530571 Ckp time: 30-NOV-11
    
42. 
    
43. BS Key Type LV Size Device Type Elapsed Time Completion Time
    
44. ------- ---- -- ---------- ----------- ------------ ---------------
    
45. 
    
46. 7 Full 80.00K DISK 00:00:02 30-NOV-11
    
47.         BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
    
48.         Piece Name: /u01/rman_backup/2011/201111/df_768589735_8_1.bak
    
49.   SPFILE Included: Modification time: 30-NOV-11

2.将备份集mv到目录/u01/rman_backup/2011/201111/mybak

1. [oracle@hxl 201111]$ ls -1
   
2. 20111130
   
3. df_768589674_5_1.bak
   
4. df_768589674_6_1.bak
   
5. df_768589733_7_1.bak
   
6. df_768589735_8_1.bak
   
7. mybak
   
8. 
   
9. [oracle@hxl 201111]$mv *.bak ./mybak

3.校验当前的备份集,因为备份集迁移到了其他目录,所以crosscheck后标记为EXPIRED.

1. RMAN> crosscheck backup;
   
2. 
   
3. allocated channel: ORA_DISK_1
   
4. channel ORA_DISK_1: sid=147 devtype=DISK
   
5. crosschecked backup piece: found to be 'EXPIRED'
   
6. backup piece handle=/u01/rman_backup/2011/201111/df_768589674_5_1.bak recid=4 stamp=768589674
   
7. crosschecked backup piece: found to be 'EXPIRED'
   
8. backup piece handle=/u01/rman_backup/2011/201111/df_768589674_6_1.bak recid=5 stamp=768589674
   
9. crosschecked backup piece: found to be 'EXPIRED'
   
10. backup piece handle=/u01/rman_backup/2011/201111/df_768589733_7_1.bak recid=6 stamp=768589735
    
11. crosschecked backup piece: found to be 'EXPIRED'
    
12. backup piece handle=/u01/rman_backup/2011/201111/df_768589735_8_1.bak recid=7 stamp=768589737
    
13. Crosschecked 4 objects

4.删除过期的备份集

1. RMAN> delete expired backup;
   
2. 
   
3. using channel ORA_DISK_1
   
4. 
   
5. List of Backup Pieces
   
6. BP Key BS Key Pc# Cp# Status Device Type Piece Name
   
7. ------- ------- --- --- ----------- ----------- ----------
   
8. 
   
9. 4 4 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589674_5_1.bak
   
10. 5 5 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589674_6_1.bak
    
11. 6 6 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589733_7_1.bak
    
12. 7 7 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589735_8_1.bak
    
13. 
    
14. Do you really want to delete the above objects (enter YES or NO)? YES
    
15. deleted backup piece
    
16. backup piece handle=/u01/rman_backup/2011/201111/df_768589674_5_1.bak recid=4 stamp=768589674
    
17. deleted backup piece
    
18. backup piece handle=/u01/rman_backup/2011/201111/df_768589674_6_1.bak recid=5 stamp=768589674
    
19. deleted backup piece
    
20. backup piece handle=/u01/rman_backup/2011/201111/df_768589733_7_1.bak recid=6 stamp=768589735
    
21. deleted backup piece
    
22. backup piece handle=/u01/rman_backup/2011/201111/df_768589735_8_1.bak recid=7 stamp=768589737
    
23. Deleted 4 EXPIRED objects

5.查看当前的备份集,因为标记为过期的备份集已经删除,所以当前catalog里没有备份集的记录.

1. RMAN> list backup;

6.逐个将备份集加入到catalog里

1. RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak';
   
2. 
   
3. cataloged backuppiece
   
4. backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak recid=12 stamp=769250367
   
5. 
   
6. RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak';
   
7. 
   
8. cataloged backuppiece
   
9. backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak recid=13 stamp=769250424
   
10. 
    
11. RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak';
    
12. 
    
13. cataloged backuppiece
    
14. backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak recid=14 stamp=769250451
    
15. 
    
16. RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak';
    
17. 
    
18. cataloged backuppiece
    
19. backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak recid=15 stamp=769250478

7.列出迁移到mybak目录后的备份集

1. RMAN> list backup;
   
2. 
   
3. List of Backup Sets
   
4. ===================
   
5. 
   
6. BS Key Type LV Size Device Type Elapsed Time Completion Time
   
7. ------- ---- -- ---------- ----------- ------------ ---------------
   
8. 
   
9. 4 Full 351.26M DISK 00:00:51 30-NOV-11
   
10.         BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
    
11.         Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
    
12.   List of Datafiles in backup set 4
    
13.   File LV Type Ckp SCN Ckp Time Name
    
14.   ---- -- ---- ---------- --------- ----
    
15. 
    
16.   1 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/system01.dbf
    
17.   4 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/users01.dbf
    
18. 
    
19. BS Key Type LV Size Device Type Elapsed Time Completion Time
    
20. ------- ---- -- ---------- ----------- ------------ ---------------
    
21. 
    
22. 5 Full 173.91M DISK 00:00:55 30-NOV-11
    
23.         BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
    
24.         Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak
    
25.   List of Datafiles in backup set 5
    
26.   File LV Type Ckp SCN Ckp Time Name
    
27.   ---- -- ---- ---------- --------- ----
    
28. 
    
29.   2 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/undotbs01.dbf
    
30.   3 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/sysaux01.dbf
    
31.   5 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/hxl01.dbf
    
32. 
    
33. BS Key Type LV Size Device Type Elapsed Time Completion Time
    
34. ------- ---- -- ---------- ----------- ------------ ---------------
    
35. 
    
36. 6 Full 6.77M DISK 00:00:03 30-NOV-11
    
37.         BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
    
38.         Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak
    
39.   Control File Included: Ckp SCN: 530571 Ckp time: 30-NOV-11
    
40. 
    
41. BS Key Type LV Size Device Type Elapsed Time Completion Time
    
42. ------- ---- -- ---------- ----------- ------------ ---------------
    
43. 
    
44. 7 Full 80.00K DISK 00:00:02 30-NOV-11
    
45.         BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
    
46.         Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak
    
47.   SPFILE Included: Modification time: 30-NOV-11

CATALOG常用方法:

1.扫描备份片
CATALOG BACKUPPIECE '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak';

2.扫描归档日志
CATALOG ARCHIVELOG '/u01/rman_backup/archive_bak/archlog_78922.bak';

3.扫描数据文件拷贝,并且将其做为增量备份的level 0
CATALOG DATAFILECOPY '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak' LEVEL 0;

4.扫描控制文件拷贝
CATALOG CONTROLFILECOPY '/u01/app/oracle/oradata/oracl/control01.ctl'

5.扫描整个目录
CATALOG START WITH '/u01/rman_backup/2011/201111/mybak';

6.扫描闪回恢复区
CATALOG RECOVERY AREA NOPROMPT;