ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > 【RMAN】RMAN增量备份那点事

【RMAN】RMAN增量备份那点事

原创 Oracle 作者：xysoul_云龙 时间：2017-06-08 14:26:47 0 删除 编辑
下面的语句是在没有全备（也就是增量备份的0级备份）的情况下执行，考虑下，会出现什么结果


点击(此处)折叠或打开

  1. run {
  2.             allocate channel t1 type disk;
  3.             allocate channel t2 type disk;
  4.             sql 'alter system archive log current';
  5.             sql 'alter system archive log current';
  6.             backup incremental level 1 cumulative filesperset 10 format '/backup/rman/test_incr_%T_%s_%p' database
  7.             include current controlfile spfile plus archivelog delete all input;
  8.          release channel t1;
  9.             release channel t2;
  10.         }

先简单说下增量备份，增量备份是根据块变化来的（如果启用块跟踪的话：v$block_change_tracking）分为两种，一种是差异增量备份，每次增量备份是根据上一次增量备份的基础上进行备份，另一种是累计增量备份，是在全备的基础上进行增量备份。  附：启用块跟踪：alter database enable block change tracking;

下面贴出没有增量备份0级备份的情况进行1级增量备份输出情况

点击(此处)折叠或打开

  1. ……………………

  3. allocated channel: t2
  4. channel t2: SID=22 device type=DISK

  6. sql statement: alter system archive log current

  8. sql statement: alter system archive log current


  11. Starting backup at 08-JUN-17
  12. current log archived
  13. channel t1: starting archived log backup set
  14. channel t1: specifying archived log(s) in backup set
  15. input archived log thread=1 sequence=1 RECID=1 STAMP=946129604
  16. channel t1: starting piece 1 at 08-JUN-17
  17. channel t2: starting archived log backup set
  18. channel t2: specifying archived log(s) in backup set
  19. input archived log thread=1 sequence=2 RECID=2 STAMP=946129614
  20. input archived log thread=1 sequence=3 RECID=3 STAMP=946130655
  21. input archived log thread=1 sequence=4 RECID=4 STAMP=946130703
  22. input archived log thread=1 sequence=5 RECID=5 STAMP=946130801
  23. channel t2: starting piece 1 at 08-JUN-17
  24. channel t2: finished piece 1 at 08-JUN-17
  25. piece handle=/backup/rman/test_incr_20170608_2_1 tag=TAG20170608T140646 comment=NONE
  26. channel t2: backup set complete, elapsed time: 00:00:01
  27. channel t2: deleting archived log(s)
  28. archived log file name=/backup/archivelog/1_2_946047723.dbf RECID=2 STAMP=946129614
  29. archived log file name=/backup/archivelog/1_3_946047723.dbf RECID=3 STAMP=946130655
  30. archived log file name=/backup/archivelog/1_4_946047723.dbf RECID=4 STAMP=946130703
  31. archived log file name=/backup/archivelog/1_5_946047723.dbf RECID=5 STAMP=946130801
  32. channel t2: starting archived log backup set
  33. channel t2: specifying archived log(s) in backup set
  34. input archived log thread=1 sequence=6 RECID=6 STAMP

  36. ………………………………
  37. channel t1: finished piece 1 at 08-JUN-17
  38. piece handle=/backup/rman/test_incr_20170608_1_1 tag=TAG20170608T140646 comment=NONE
  39. channel t1: backup set complete, elapsed time: 00:00:05
  40. channel t1: deleting archived log(s)
  41. archived log file name=/backup/archivelog/1_1_946047723.dbf RECID=1 STAMP=946129604
  42. Finished backup at 08-JUN-17

  44. Starting backup at 08-JUN-17
  45. no parent backup or copy of datafile 5 found  ---没有0级备份，下面开始0级备份
  46. no parent backup or copy of datafile 4 found
  47. no parent backup or copy of datafile 2 found
  48. no parent backup or copy of datafile 1 found
  49. no parent backup or copy of datafile 3 found
  50. channel t1: starting incremental level 0 datafile backup set
  51. channel t1: specifying datafile(s) in backup set
  52. input datafile file number=00005 name=/oracle/app/oracle/oradata/mytestdb/example01.dbf
  53. input datafile file number=00004 name=/oracle/app/oracle/oradata/mytestdb/users01.dbf
  54. input datafile file number=00002 name=/oracle/app/oracle/oradata/mytestdb/sysaux01.dbf
  55. channel t1: starting piece 1 at 08-JUN-17
  56. channel t2: starting incremental level 0 datafile backup set
  57. channel t2: specifying datafile(s) in backup set
  58. input datafile file number=00001 name=/oracle/app/oracle/oradata/mytestdb/system01.dbf
  59. input datafile file number=00003 name=/oracle/app/oracle/oradata/mytestdb/undotbs01.dbf
  60. channel t2: starting piece 1 at 08-JUN-17
  61. channel t1: finished piece 1 at 08-JUN-17
  62. piece handle=/backup/rman/test_incr_20170608_4_1 tag=TAG20170608T140651 comment=NONE
  63. channel t1: backup set complete, elapsed time: 00:00:15
  64. channel t1: starting incremental level 1 datafile backup set
  65. channel t1: specifying datafile(s) in backup set
  66. channel t2: finished piece 1 at 08-JUN-17
  67. piece handle=/backup/rman/test_incr_20170608_5_1 tag=TAG20170608T140651 comment=NONE
  68. channel t2: backup set complete, elapsed time: 00:00:15
  69. channel t2: starting incremental level 1 datafile backup set
  70. channel t2: specifying datafile(s) in backup set
  71. including current SPFILE in backup set
  72. channel t2: starting piece 1 at 08-JUN-17
  73. including current control file in backup set
  74. channel t1: starting piece 1 at 08-JUN-17
  75. channel t2: finished piece 1 at 08-JUN-17
  76. piece handle=/backup/rman/test_incr_20170608_7_1 tag=TAG20170608T140651 comment=NONE
  77. channel t2: backup set complete, elapsed time: 00:00:01
  78. channel t2: starting incremental level 1 datafile backup set
  79. channel t2: specifying datafile(s) in backup set
  80. including current SPFILE in backup set
  81. channel t2: starting piece 1 at 08-JUN-17
  82. channel t1: finished piece 1 at 08-JUN-17
  83. piece handle=/backup/rman/test_incr_20170608_6_1 tag=TAG20170608T140651 comment=NONE
  84. channel t1: backup set complete, elapsed time: 00:00:00
  85. channel t2: finished piece 1 at 08-JUN-17
  86. piece handle=/backup/rman/test_incr_20170608_8_1 tag=TAG20170608T140651 comment=NONE
  87. channel t2: backup set complete, elapsed time: 00:00:01
  88. Finished backup at 08-JUN-17

  90. Starting backup at 08-JUN-17
  91. current log archived
  92. channel t1: starting archived log backup set
  93. channel t1: specifying archived log(s) in backup set
  94. input archived log thread=1 sequence=8 RECID=8 STAMP=946130829
  95. channel t1: starting piece 1 at 08-JUN-17
  96. channel t1: finished piece 1 at 08-JUN-17
  97. piece handle=/backup/rman/test_incr_20170608_9_1 tag=TAG20170608T140709 comment=NONE
  98. channel t1: backup set complete, elapsed time: 00:00:01
  99. channel t1: deleting archived log(s)
  100. archived log file name=/backup/archivelog/1_8_946047723.dbf RECID=8 STAMP=946130829
  101. Finished backup at 08-JUN-17

  103. released channel: t1

  105. released channel: t2


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

0
0
上一篇： 【EXDATA】关于cellcli 小记
下一篇： 【TABLE】oracle表在线重定义注意事项
请登录后发表评论 登录
全部评论
xysoul_云龙
专家姓名：杨云龙
主要从事Oracle数据库 DBA相关工作，其他操作系统、中间件等也有涉及，热衷分享。岁月老将至，如有幸在江湖中留点踪迹，也是欣慰。 【文盲筱烨】好读书爱运动的IT技术爱好者 微博：文盲筱烨 微信公众号：筱烨视点

注册时间：2014-02-15

  • 博文量
    412
  • 访问量
    1104599

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593