【RMAN】RMAN增量备份那点事

下面的语句是在没有全备(也就是增量备份的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. ……………………

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

  4. sql statement: alter system archive log current

  5. sql statement: alter system archive log current


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

  30. ………………………………
  31. channel t1: finished piece 1 at 08-JUN-17
  32. piece handle=/backup/rman/test_incr_20170608_1_1 tag=TAG20170608T140646 comment=NONE
  33. channel t1: backup set complete, elapsed time: 00:00:05
  34. channel t1: deleting archived log(s)
  35. archived log file name=/backup/archivelog/1_1_946047723.dbf RECID=1 STAMP=946129604
  36. Finished backup at 08-JUN-17

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

  82. Starting backup at 08-JUN-17
  83. current log archived
  84. channel t1: starting archived log backup set
  85. channel t1: specifying archived log(s) in backup set
  86. input archived log thread=1 sequence=8 RECID=8 STAMP=946130829
  87. channel t1: starting piece 1 at 08-JUN-17
  88. channel t1: finished piece 1 at 08-JUN-17
  89. piece handle=/backup/rman/test_incr_20170608_9_1 tag=TAG20170608T140709 comment=NONE
  90. channel t1: backup set complete, elapsed time: 00:00:01
  91. channel t1: deleting archived log(s)
  92. archived log file name=/backup/archivelog/1_8_946047723.dbf RECID=8 STAMP=946130829
  93. Finished backup at 08-JUN-17

  94. released channel: t1

  95. released channel: t2


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

转载于:http://blog.itpub.net/29487349/viewspace-2140442/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值