Chinaunix首页 | 论坛 | 博客

the rock

首页　| 　博文目录　| 　关于我

guopy007

  • 博客访问： 1013325
  • 博文数量： 584
  • 博客积分： 2293
  • 博客等级： 大尉
  • 技术积分： 3045
  • 用 户 组： 普通用户
  • 注册时间： 2006-03-28 11:15
文章分类

全部博文（584）

文章存档

2012年（532）

2011年（47）

2009年（5）

我的朋友
最近访客
推荐博文
备份集迁移到其他目录后加入到catalog的过程

分类：

2012-03-08 20:09:55

原文地址：备份集迁移到其他目录后加入到catalog的过程 作者：hxl

下面演示将备份集mv到其他目录后加入catalog的过程.
1.列出当前的备份集信息(当前的备份集位于目录/u01/rman_backup/2011/201111/)
  1. RMAN> list backup;

  3. using target database control file instead of recovery catalog

  5. List of Backup Sets
  6. ===================

  8. BS Key Type LV Size Device Type Elapsed Time Completion Time
  9. ------- ---- -- ---------- ----------- ------------ ---------------

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

  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

  21. BS Key Type LV Size Device Type Elapsed Time Completion Time
  22. ------- ---- -- ---------- ----------- ------------ ---------------

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

  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

  35. BS Key Type LV Size Device Type Elapsed Time Completion Time
  36. ------- ---- -- ---------- ----------- ------------ ---------------

  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

  43. BS Key Type LV Size Device Type Elapsed Time Completion Time
  44. ------- ---- -- ---------- ----------- ------------ ---------------

  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

  9. [oracle@hxl 201111]$mv *.bak ./mybak

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

  1. RMAN> crosscheck backup;

  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;

  3. using channel ORA_DISK_1

  5. List of Backup Pieces
  6. BP Key BS Key Pc# Cp# Status Device Type Piece Name
  7. ------- ------- --- --- ----------- ----------- ----------

  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

  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';

  3. cataloged backuppiece
  4. backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak recid=12 stamp=769250367

  6. RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak';

  8. cataloged backuppiece
  9. backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak recid=13 stamp=769250424

  11. RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak';

  13. cataloged backuppiece
  14. backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak recid=14 stamp=769250451

  16. RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak';

  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;

  3. List of Backup Sets
  4. ===================

  6. BS Key Type LV Size Device Type Elapsed Time Completion Time
  7. ------- ---- -- ---------- ----------- ------------ ---------------

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

  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

  19. BS Key Type LV Size Device Type Elapsed Time Completion Time
  20. ------- ---- -- ---------- ----------- ------------ ---------------

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

  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

  33. BS Key Type LV Size Device Type Elapsed Time Completion Time
  34. ------- ---- -- ---------- ----------- ------------ ---------------

  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

  41. BS Key Type LV Size Device Type Elapsed Time Completion Time
  42. ------- ---- -- ---------- ----------- ------------ ---------------

  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;

阅读(257) | 评论(0) | 转发(0) |
0

上一篇：非归档模式下丢失数据文件的恢复01

下一篇：日常维护脚本

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6