开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4075-12c管理类OCP认证班第三期 › 课程第32次（2017-09-14星期四）
返回列表 发新帖
查看: 1007|回复: 0

课程第32次（2017-09-14星期四）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-9-14 20:01:43 | 显示全部楼层 |阅读模式
上完1Z0-052第15章
1Z0-052共19章（上完11章），1Z0-053共21章（上完5章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的16章
对磁盘备份集再备份（转移）到磁带机上：
  1. RMAN> run {
  2. 2> allocate channel c1 device type disk format '/home/oracle/backup/%U';
  3. 3> backup tablespace example;
  4. 4> }

  6. allocated channel: c1
  7. channel c1: SID=77 device type=DISK

  9. Starting backup at 14-SEP-17
  10. channel c1: starting full datafile backup set
  11. channel c1: specifying datafile(s) in backup set
  12. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  13. channel c1: starting piece 1 at 14-SEP-17
  14. channel c1: finished piece 1 at 14-SEP-17
  15. piece handle=/home/oracle/backup/16sef9h9_1_1 tag=TAG20170914T195729 comment=NONE
  16. channel c1: backup set complete, elapsed time: 00:00:01
  17. Finished backup at 14-SEP-17

  19. Starting Control File and SPFILE Autobackup at 14-SEP-17
  20. piece handle=+FRA/orcl/autobackup/2017_09_14/s_954705450.275.954705451 comment=NONE
  21. Finished Control File and SPFILE Autobackup at 14-SEP-17
  22. released channel: c1

  24. RMAN> list backup;


  27. List of Backup Sets
  28. ===================


  31. BS Key  Size       Device Type Elapsed Time Completion Time
  32. ------- ---------- ----------- ------------ ---------------
  33. 33      10.25M     SBT_TAPE    00:00:15     18-MAY-17      
  34.         BP Key: 33   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  35.         Handle: 11s4ih3q_1_1   Media: station90-000001

  37.   List of Archived Logs in backup set 33
  38.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  39.   ---- ------- ---------- --------- ---------- ---------
  40.   1    18      1053749    18-MAY-17 1057190    18-MAY-17

  42. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  43. ------- ---- -- ---------- ----------- ------------ ---------------
  44. 34      Incr 0  502.25M    SBT_TAPE    00:00:20     18-MAY-17      
  45.         BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  46.         Handle: 13s4ih4j_1_1   Media: station90-000002
  47.   List of Datafiles in backup set 34
  48.   File LV Type Ckp SCN    Ckp Time  Name
  49.   ---- -- ---- ---------- --------- ----
  50.   2    0  Incr 1057424    18-MAY-17 +DATA/orcl/datafile/sysaux.257.816169553
  51.   3    0  Incr 1057424    18-MAY-17 +DATA/orcl/datafile/undotbs1.258.816169553
  52.   4    0  Incr 1057424    18-MAY-17 +DATA/orcl/datafile/users.259.816169553

  54. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  55. ------- ---- -- ---------- ----------- ------------ ---------------
  56. 35      Incr 0  657.75M    SBT_TAPE    00:00:27     18-MAY-17      
  57.         BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  58.         Handle: 12s4ih4j_1_1   Media: station90-000001
  59.   List of Datafiles in backup set 35
  60.   File LV Type Ckp SCN    Ckp Time  Name
  61.   ---- -- ---- ---------- --------- ----
  62.   1    0  Incr 1057421    18-MAY-17 +DATA/orcl/datafile/system.256.816169553
  63.   5    0  Incr 1057421    18-MAY-17 +DATA/orcl/datafile/example.265.816169651

  65. BS Key  Size       Device Type Elapsed Time Completion Time
  66. ------- ---------- ----------- ------------ ---------------
  67. 36      2.00M      SBT_TAPE    00:00:15     18-MAY-17      
  68.         BP Key: 36   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  69.         Handle: 14s4ih5n_1_1   Media: station90-000001

  71.   List of Archived Logs in backup set 36
  72.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  73.   ---- ------- ---------- --------- ---------- ---------
  74.   1    19      1057190    18-MAY-17 1057470    18-MAY-17

  76. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  77. ------- ---- -- ---------- ----------- ------------ ---------------
  78. 37      Full    9.50M      SBT_TAPE    00:00:16     18-MAY-17      
  79.         BP Key: 37   Status: AVAILABLE  Compressed: NO  Tag: TAG20170518T164400
  80.         Handle: c-1343950367-20170518-00   Media: station90-000001
  81.   SPFILE Included: Modification time: 18-MAY-17
  82.   SPFILE db_unique_name: ORCL
  83.   Control File Included: Ckp SCN: 1057507      Ckp time: 18-MAY-17

  85. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  86. ------- ---- -- ---------- ----------- ------------ ---------------
  87. 38      Full    69.58M     DISK        00:00:00     14-SEP-17      
  88.         BP Key: 38   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T195729
  89.         Piece Name: /home/oracle/backup/16sef9h9_1_1
  90.   List of Datafiles in backup set 38
  91.   File LV Type Ckp SCN    Ckp Time  Name
  92.   ---- -- ---- ---------- --------- ----
  93.   5       Full 1149089    14-SEP-17 +DATA/orcl/datafile/example.265.816169651

  95. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  96. ------- ---- -- ---------- ----------- ------------ ---------------
  97. 39      Full    9.36M      DISK        00:00:01     14-SEP-17      
  98.         BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T195730
  99.         Piece Name: +FRA/orcl/autobackup/2017_09_14/s_954705450.275.954705451
  100.   SPFILE Included: Modification time: 13-SEP-17
  101.   SPFILE db_unique_name: ORCL
  102.   Control File Included: Ckp SCN: 1149108      Ckp time: 14-SEP-17

  104. RMAN> backup backupset 38  ;

  106. Starting backup at 14-SEP-17
  107. allocated channel: ORA_SBT_TAPE_1
  108. channel ORA_SBT_TAPE_1: SID=77 device type=SBT_TAPE
  109. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  110. allocated channel: ORA_SBT_TAPE_2
  111. channel ORA_SBT_TAPE_2: SID=79 device type=SBT_TAPE
  112. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  113. skipping backup set key 38; already backed up 1 time(s)
  114. Finished backup at 14-SEP-17

  116. RMAN> backup backupset 38  force delete input;

  118. Starting backup at 14-SEP-17
  119. using channel ORA_SBT_TAPE_1
  120. using channel ORA_SBT_TAPE_2
  121. channel ORA_SBT_TAPE_1: input backup set: count=38, stamp=954705449, piece=1
  122. channel ORA_SBT_TAPE_1: starting piece 1 at 14-SEP-17
  123. channel ORA_SBT_TAPE_1: backup piece /home/oracle/backup/16sef9h9_1_1
  124. piece handle=16sef9h9_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
  125. channel ORA_SBT_TAPE_1: finished piece 1 at 14-SEP-17
  126. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:25
  127. deleted backup piece
  128. backup piece handle=/home/oracle/backup/16sef9h9_1_1 RECID=38 STAMP=954705449
  129. Finished backup at 14-SEP-17

  131. Starting Control File and SPFILE Autobackup at 14-SEP-17
  132. piece handle=c-1343950367-20170914-01 comment=API Version 2.0,MMS Version 10.4.0.4
  133. Finished Control File and SPFILE Autobackup at 14-SEP-17

  135. RMAN> list backup;


  138. List of Backup Sets
  139. ===================


  142. BS Key  Size       Device Type Elapsed Time Completion Time
  143. ------- ---------- ----------- ------------ ---------------
  144. 33      10.25M     SBT_TAPE    00:00:15     18-MAY-17      
  145.         BP Key: 33   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  146.         Handle: 11s4ih3q_1_1   Media: station90-000001

  148.   List of Archived Logs in backup set 33
  149.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  150.   ---- ------- ---------- --------- ---------- ---------
  151.   1    18      1053749    18-MAY-17 1057190    18-MAY-17

  153. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  154. ------- ---- -- ---------- ----------- ------------ ---------------
  155. 34      Incr 0  502.25M    SBT_TAPE    00:00:20     18-MAY-17      
  156.         BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  157.         Handle: 13s4ih4j_1_1   Media: station90-000002
  158.   List of Datafiles in backup set 34
  159.   File LV Type Ckp SCN    Ckp Time  Name
  160.   ---- -- ---- ---------- --------- ----
  161.   2    0  Incr 1057424    18-MAY-17 +DATA/orcl/datafile/sysaux.257.816169553
  162.   3    0  Incr 1057424    18-MAY-17 +DATA/orcl/datafile/undotbs1.258.816169553
  163.   4    0  Incr 1057424    18-MAY-17 +DATA/orcl/datafile/users.259.816169553

  165. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  166. ------- ---- -- ---------- ----------- ------------ ---------------
  167. 35      Incr 0  657.75M    SBT_TAPE    00:00:27     18-MAY-17      
  168.         BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  169.         Handle: 12s4ih4j_1_1   Media: station90-000001
  170.   List of Datafiles in backup set 35
  171.   File LV Type Ckp SCN    Ckp Time  Name
  172.   ---- -- ---- ---------- --------- ----
  173.   1    0  Incr 1057421    18-MAY-17 +DATA/orcl/datafile/system.256.816169553
  174.   5    0  Incr 1057421    18-MAY-17 +DATA/orcl/datafile/example.265.816169651

  176. BS Key  Size       Device Type Elapsed Time Completion Time
  177. ------- ---------- ----------- ------------ ---------------
  178. 36      2.00M      SBT_TAPE    00:00:15     18-MAY-17      
  179.         BP Key: 36   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  180.         Handle: 14s4ih5n_1_1   Media: station90-000001

  182.   List of Archived Logs in backup set 36
  183.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  184.   ---- ------- ---------- --------- ---------- ---------
  185.   1    19      1057190    18-MAY-17 1057470    18-MAY-17

  187. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  188. ------- ---- -- ---------- ----------- ------------ ---------------
  189. 37      Full    9.50M      SBT_TAPE    00:00:16     18-MAY-17      
  190.         BP Key: 37   Status: AVAILABLE  Compressed: NO  Tag: TAG20170518T164400
  191.         Handle: c-1343950367-20170518-00   Media: station90-000001
  192.   SPFILE Included: Modification time: 18-MAY-17
  193.   SPFILE db_unique_name: ORCL
  194.   Control File Included: Ckp SCN: 1057507      Ckp time: 18-MAY-17

  196. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  197. ------- ---- -- ---------- ----------- ------------ ---------------
  198. 38      Full    69.58M     SBT_TAPE    00:00:00     14-SEP-17      
  199.         BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T195729
  200.         Handle: 16sef9h9_1_2   Media: station90-000001
  201.   List of Datafiles in backup set 38
  202.   File LV Type Ckp SCN    Ckp Time  Name
  203.   ---- -- ---- ---------- --------- ----
  204.   5       Full 1149089    14-SEP-17 +DATA/orcl/datafile/example.265.816169651

  206. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  207. ------- ---- -- ---------- ----------- ------------ ---------------
  208. 39      Full    9.36M      DISK        00:00:01     14-SEP-17      
  209.         BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T195730
  210.         Piece Name: +FRA/orcl/autobackup/2017_09_14/s_954705450.275.954705451
  211.   SPFILE Included: Modification time: 13-SEP-17
  212.   SPFILE db_unique_name: ORCL
  213.   Control File Included: Ckp SCN: 1149108      Ckp time: 14-SEP-17

  215. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  216. ------- ---- -- ---------- ----------- ------------ ---------------
  217. 40      Full    9.50M      SBT_TAPE    00:00:15     14-SEP-17      
  218.         BP Key: 41   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T195920
  219.         Handle: c-1343950367-20170914-01   Media: station90-000001
  220.   SPFILE Included: Modification time: 13-SEP-17
  221.   SPFILE db_unique_name: ORCL
  222.   Control File Included: Ckp SCN: 1149272      Ckp time: 14-SEP-17

  224. RMAN>
复制代码
用磁带机执行backup recovery files：
  1. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  3. old RMAN configuration parameters:
  4. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  5. new RMAN configuration parameters:
  6. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  7. new RMAN configuration parameters are successfully stored
  8. released channel: ORA_SBT_TAPE_1
  9. released channel: ORA_SBT_TAPE_2

  11. RMAN> backup recovery  files;

  13. Starting backup at 14-SEP-17
  14. allocated channel: ORA_DISK_1
  15. channel ORA_DISK_1: SID=77 device type=DISK
  16. allocated channel: ORA_DISK_2
  17. channel ORA_DISK_2: SID=79 device type=DISK
  18. allocated channel: ORA_DISK_3
  19. channel ORA_DISK_3: SID=139 device type=DISK
  20. allocated channel: ORA_DISK_4
  21. channel ORA_DISK_4: SID=198 device type=DISK
  22. allocated channel: ORA_DISK_5
  23. channel ORA_DISK_5: SID=11 device type=DISK
  24. allocated channel: ORA_DISK_6
  25. channel ORA_DISK_6: SID=78 device type=DISK
  26. allocated channel: ORA_DISK_7
  27. channel ORA_DISK_7: SID=135 device type=DISK
  28. allocated channel: ORA_DISK_8
  29. channel ORA_DISK_8: SID=203 device type=DISK
  30. specification does not match any datafile copy in the repository
  31. RMAN-00571: ===========================================================
  32. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  33. RMAN-00571: ===========================================================
  34. RMAN-03002: failure of backup command at 09/14/2017 20:07:32
  35. RMAN-06603: TO DESTINATION option must be specified with RECOVERY AREA, RECOVERY FILES or DB_RECOVERY_FILE_DEST on disk device

  37. RMAN>  CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  39. old RMAN configuration parameters:
  40. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  41. new RMAN configuration parameters:
  42. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  43. new RMAN configuration parameters are successfully stored
  44. released channel: ORA_DISK_1
  45. released channel: ORA_DISK_2
  46. released channel: ORA_DISK_3
  47. released channel: ORA_DISK_4
  48. released channel: ORA_DISK_5
  49. released channel: ORA_DISK_6
  50. released channel: ORA_DISK_7
  51. released channel: ORA_DISK_8

  53. RMAN> backup recovery  files;

  55. Starting backup at 14-SEP-17
  56. allocated channel: ORA_SBT_TAPE_1
  57. channel ORA_SBT_TAPE_1: SID=77 device type=SBT_TAPE
  58. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  59. allocated channel: ORA_SBT_TAPE_2
  60. channel ORA_SBT_TAPE_2: SID=79 device type=SBT_TAPE
  61. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  62. specification does not match any datafile copy in the repository
  63. channel ORA_SBT_TAPE_1: starting archived log backup set
  64. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  65. input archived log thread=1 sequence=20 RECID=12 STAMP=954585053
  66. input archived log thread=1 sequence=21 RECID=13 STAMP=954586600
  67. input archived log thread=1 sequence=22 RECID=14 STAMP=954593821
  68. input archived log thread=1 sequence=23 RECID=15 STAMP=954601529
  69. input archived log thread=1 sequence=24 RECID=16 STAMP=954608466
  70. input archived log thread=1 sequence=25 RECID=17 STAMP=954618389
  71. input archived log thread=1 sequence=26 RECID=18 STAMP=954625206
  72. input archived log thread=1 sequence=27 RECID=19 STAMP=954626436
  73. channel ORA_SBT_TAPE_1: starting piece 1 at 14-SEP-17
  74. channel ORA_SBT_TAPE_2: starting archived log backup set
  75. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  76. input archived log thread=1 sequence=28 RECID=20 STAMP=954626466
  77. input archived log thread=1 sequence=29 RECID=21 STAMP=954665031
  78. input archived log thread=1 sequence=30 RECID=22 STAMP=954670878
  79. input archived log thread=1 sequence=31 RECID=23 STAMP=954688375
  80. input archived log thread=1 sequence=32 RECID=24 STAMP=954691244
  81. input archived log thread=1 sequence=33 RECID=25 STAMP=954702452
  82. input archived log thread=1 sequence=34 RECID=26 STAMP=954705658
  83. channel ORA_SBT_TAPE_2: starting piece 1 at 14-SEP-17
  84. channel ORA_SBT_TAPE_1: finished piece 1 at 14-SEP-17
  85. piece handle=19sefa58_1_1 tag=TAG20170914T200808 comment=API Version 2.0,MMS Version 10.4.0.4
  86. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  87. channel ORA_SBT_TAPE_2: finished piece 1 at 14-SEP-17
  88. piece handle=1asefa58_1_1 tag=TAG20170914T200808 comment=API Version 2.0,MMS Version 10.4.0.4
  89. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  90. channel ORA_SBT_TAPE_1: input backup set: count=39, stamp=954705450, piece=1
  91. channel ORA_SBT_TAPE_1: starting piece 1 at 14-SEP-17
  92. channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/autobackup/2017_09_14/s_954705450.275.954705451
  93. piece handle=c-1343950367-20170914-00 comment=API Version 2.0,MMS Version 10.4.0.4
  94. channel ORA_SBT_TAPE_1: finished piece 1 at 14-SEP-17
  95. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:25
  96. Finished backup at 14-SEP-17

  98. Starting Control File and SPFILE Autobackup at 14-SEP-17
  99. piece handle=c-1343950367-20170914-02 comment=API Version 2.0,MMS Version 10.4.0.4
  100. Finished Control File and SPFILE Autobackup at 14-SEP-17

  102. RMAN>
复制代码
【可选】清理磁带：
  1. [root@station90 10]# du -sh *
  2. 8.0K        CLN101L4
  3. 8.0K        CLN102L5
  4. 934M        E01001L4
  5. 622M        E01002L4
  6. 8.0K        E01003L4
  7. 8.0K        E01004L4
  8. 8.0K        E01005L4
  9. 8.0K        E01006L4
  10. 8.0K        E01007L4
  11. 8.0K        E01008L4
  12. 8.0K        E01009L4
  13. 8.0K        E01010L4
  14. 8.0K        E01011L4
  15. 8.0K        E01012L4
  16. 8.0K        E01013L4
  17. 8.0K        E01014L4
  18. 8.0K        E01015L4
  19. 8.0K        E01016L4
  20. 8.0K        E01017L4
  21. 8.0K        E01018L4
  22. 8.0K        E01019L4
  23. 8.0K        E01020L4
  24. 8.0K        F01030L5
  25. 8.0K        F01031L5
  26. 8.0K        F01032L5
  27. 8.0K        F01033L5
  28. 8.0K        F01034L5
  29. 8.0K        F01035L5
  30. 8.0K        F01036L5
  31. 8.0K        F01037L5
  32. 8.0K        F01038L5
  33. 8.0K        F01039L5
  34. [root@station90 10]# obtool
  35. ob> loadvol -D tape04 -m write 1
  36. ob> unlabelvol -D tape04
  37. ob> reusevol -D tape04
  38. ob> unloadvol -D tape04
  39. ob> loadvol -D tape04 -m write 2
  40. ob> unloadvol -D tape04
  41. ob> reusevol -D tape04
  42. Error: the device is offline.
  43. ob> loadvol -D tape04 -m write 2
  44. ob> unlabelvol -D tape04
  45. ob> reusevol -D tape04
  46. ob> unloadvol -D tape04
  47. ob> lsvol -L lib01 -l
  48. Inventory of library lib01:
  49.     in    1:             barcode E01001L4, oid 137, 8190976 kb remaining
  50.     in    2:             barcode E01002L4, oid 139, 8190976 kb remaining
  51.     in    3:             barcode E01003L4, oid 102
  52.     in    4:             barcode E01004L4, oid 103
  53.     in    5:             barcode E01005L4, oid 104
  54.     in    6:             barcode E01006L4, oid 105
  55.     in    7:             barcode E01007L4, oid 106
  56.     in    8:             barcode E01008L4, oid 107
  57.     in    9:             barcode E01009L4, oid 108
  58.     in    10:            barcode E01010L4, oid 109
  59.     in    11:            barcode E01011L4, oid 110
  60.     in    12:            barcode E01012L4, oid 111
  61.     in    13:            barcode E01013L4, oid 112
  62.     in    14:            barcode E01014L4, oid 113
  63.     in    15:            barcode E01015L4, oid 114
  64.     in    16:            barcode E01016L4, oid 115
  65.     in    17:            barcode E01017L4, oid 116
  66.     in    18:            barcode E01018L4, oid 117
  67.     in    19:            barcode E01019L4, oid 118
  68.     in    20:            barcode E01020L4, oid 119
  69.     in    21:            vacant
  70.     in    22:            barcode CLN101L4, oid 120
  71.     in    23:            barcode CLN102L5, oid 121
  72.     in    24:            vacant
  73.     in    25:            vacant
  74.     in    26:            vacant
  75.     in    27:            vacant
  76.     in    28:            vacant
  77.     in    29:            vacant
  78.     in    30:            barcode F01030L5, oid 122
  79.     in    31:            barcode F01031L5, oid 123
  80.     in    32:            barcode F01032L5, oid 124
  81.     in    33:            barcode F01033L5, oid 125
  82.     in    34:            barcode F01034L5, oid 126
  83.     in    35:            barcode F01035L5, oid 127
  84.     in    36:            barcode F01036L5, oid 128
  85.     in    37:            barcode F01037L5, oid 129
  86.     in    38:            barcode F01038L5, oid 130
  87.     in    39:            barcode F01039L5, oid 131
  88.     in    iee1:          vacant
  89.     in    iee2:          vacant
  90.     in    iee3:          vacant
  91.     in    iee4:          vacant
  92.     in    dte1:          vacant
  93.     in    dte2:          vacant
  94.     in    dte3:          vacant
  95.     in    dte4:          vacant
  96. ob> exit
  97. [root@station90 10]# du -sh *
  98. 8.0K        CLN101L4
  99. 8.0K        CLN102L5
  100. 140K        E01001L4
  101. 140K        E01002L4
  102. 8.0K        E01003L4
  103. 8.0K        E01004L4
  104. 8.0K        E01005L4
  105. 8.0K        E01006L4
  106. 8.0K        E01007L4
  107. 8.0K        E01008L4
  108. 8.0K        E01009L4
  109. 8.0K        E01010L4
  110. 8.0K        E01011L4
  111. 8.0K        E01012L4
  112. 8.0K        E01013L4
  113. 8.0K        E01014L4
  114. 8.0K        E01015L4
  115. 8.0K        E01016L4
  116. 8.0K        E01017L4
  117. 8.0K        E01018L4
  118. 8.0K        E01019L4
  119. 8.0K        E01020L4
  120. 8.0K        F01030L5
  121. 8.0K        F01031L5
  122. 8.0K        F01032L5
  123. 8.0K        F01033L5
  124. 8.0K        F01034L5
  125. 8.0K        F01035L5
  126. 8.0K        F01036L5
  127. 8.0K        F01037L5
  128. 8.0K        F01038L5
  129. 8.0K        F01039L5
  130. [root@station90 10]#
复制代码
Oracle Suggested Backup策略：
  1. Daily Script:
  2. run {
  3. allocate channel oem_disk_backup device type disk;
  4. recover copy of database with tag 'ORA_OEM_LEVEL_0';
  5. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  6. release channel oem_disk_backup;
  7. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  8. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  9. backup archivelog all not backed up;
  10. }
  11. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  12. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  13. Weekly Script:
  14. run {
  15. allocate channel oem_disk_backup device type disk;
  16. recover copy of database with tag 'ORA_OEM_LEVEL_0';
  17. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  18. release channel oem_disk_backup;
  19. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  20. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  21. backup recovery area;
  22. }
  23. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  24. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
复制代码
第一天的EM输出：
  1. Step: Backup
  2.         
  3. Page Refreshed Sep 14, 2017 8:44:22 PM CST
  4. View Data               
  5.         
  6.         Status                Succeeded
  7.         Exit Code                0
  8.         Step ID                215
  9.         Targets                orcl.example.com
  10.         
  11.         Started                Sep 14, 2017 8:35:22 PM CST
  12.         Ended                Sep 14, 2017 8:36:55 PM CST
  13.         Step Elapsed Time                1 minutes, 33 seconds
  14.         Management Service                station90.example.com:1158_Management_Service
  15.         TIP         Management Service from which the job step was dispatched.
  16.                
  17.         
  18. Output Log

  20. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 14 20:35:22 2017

  22. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  24. RMAN>
  25. connected to target database: ORCL (DBID=1343950367)
  26. using target database control file instead of recovery catalog

  28. RMAN>
  29. echo set on


  32. RMAN> run {
  33. 2> allocate channel oem_disk_backup device type disk;
  34. 3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
  35. 4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  36. 5> release channel oem_disk_backup;
  37. 6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  38. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  39. 8> backup archivelog all not backed up;
  40. 9> }
  41. allocated channel: oem_disk_backup
  42. channel oem_disk_backup: SID=204 device type=DISK

  44. Starting recover at 14-SEP-17
  45. no copy of datafile 1 found to recover
  46. no copy of datafile 2 found to recover
  47. no copy of datafile 3 found to recover
  48. no copy of datafile 4 found to recover
  49. no copy of datafile 5 found to recover
  50. Finished recover at 14-SEP-17

  52. Starting backup at 14-SEP-17
  53. no parent backup or copy of datafile 1 found
  54. no parent backup or copy of datafile 2 found
  55. no parent backup or copy of datafile 3 found
  56. no parent backup or copy of datafile 5 found
  57. no parent backup or copy of datafile 4 found
  58. channel oem_disk_backup: starting datafile copy
  59. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  60. output file name=+FRA/orcl/datafile/system.276.954707725 tag=ORA_OEM_LEVEL_0 RECID=4 STAMP=954707728
  61. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:08
  62. channel oem_disk_backup: starting datafile copy
  63. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  64. output file name=+FRA/orcl/datafile/sysaux.274.954707731 tag=ORA_OEM_LEVEL_0 RECID=5 STAMP=954707734
  65. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:07
  66. channel oem_disk_backup: starting datafile copy
  67. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  68. output file name=+FRA/orcl/datafile/undotbs1.273.954707739 tag=ORA_OEM_LEVEL_0 RECID=6 STAMP=954707739
  69. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  70. channel oem_disk_backup: starting datafile copy
  71. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  72. output file name=+FRA/orcl/datafile/example.272.954707739 tag=ORA_OEM_LEVEL_0 RECID=7 STAMP=954707740
  73. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  74. channel oem_disk_backup: starting datafile copy
  75. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  76. output file name=+FRA/orcl/datafile/users.271.954707741 tag=ORA_OEM_LEVEL_0 RECID=8 STAMP=954707741
  77. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  78. Finished backup at 14-SEP-17

  80. Starting Control File and SPFILE Autobackup at 14-SEP-17
  81. piece handle=+FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743 comment=NONE
  82. Finished Control File and SPFILE Autobackup at 14-SEP-17

  84. released channel: oem_disk_backup

  86. allocated channel: oem_sbt_backup1
  87. channel oem_sbt_backup1: SID=204 device type=SBT_TAPE
  88. channel oem_sbt_backup1: Oracle Secure Backup

  90. allocated channel: oem_sbt_backup2
  91. channel oem_sbt_backup2: SID=82 device type=SBT_TAPE
  92. channel oem_sbt_backup2: Oracle Secure Backup

  94. Starting backup at 14-SEP-17
  95. current log archived
  96. channel oem_sbt_backup1: starting archived log backup set
  97. channel oem_sbt_backup1: specifying archived log(s) in backup set
  98. input archived log thread=1 sequence=35 RECID=27 STAMP=954707754
  99. channel oem_sbt_backup1: starting piece 1 at 14-SEP-17
  100. channel oem_sbt_backup1: finished piece 1 at 14-SEP-17
  101. piece handle=1isefbpb_1_1 tag=TAG20170914T203555 comment=API Version 2.0,MMS Version 10.4.0.4
  102. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
  103. Finished backup at 14-SEP-17

  105. Starting Control File and SPFILE Autobackup at 14-SEP-17
  106. piece handle=c-1343950367-20170914-04 comment=API Version 2.0,MMS Version 10.4.0.4
  107. Finished Control File and SPFILE Autobackup at 14-SEP-17
  108. released channel: oem_sbt_backup1
  109. released channel: oem_sbt_backup2


  112. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  113. allocated channel: ORA_MAINT_SBT_TAPE_1
  114. channel ORA_MAINT_SBT_TAPE_1: SID=204 device type=SBT_TAPE
  115. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


  118. RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  119. no obsolete backups found


  122. RMAN> exit;

  124. Recovery Manager complete.
复制代码
第一天的产出物：
  1. RMAN> list backup;


  4. List of Backup Sets
  5. ===================


  8. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  9. ------- ---- -- ---------- ----------- ------------ ---------------
  10. 44      Full    9.36M      DISK        00:00:01     14-SEP-17      
  11.         BP Key: 46   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203541
  12.         Piece Name: +FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743
  13.   SPFILE Included: Modification time: 13-SEP-17
  14.   SPFILE db_unique_name: ORCL
  15.   Control File Included: Ckp SCN: 1152721      Ckp time: 14-SEP-17

  17. BS Key  Size       Device Type Elapsed Time Completion Time
  18. ------- ---------- ----------- ------------ ---------------
  19. 45      4.00M      SBT_TAPE    00:00:24     14-SEP-17      
  20.         BP Key: 47   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203555
  21.         Handle: 1isefbpb_1_1   Media: station90-000003

  23.   List of Archived Logs in backup set 45
  24.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  25.   ---- ------- ---------- --------- ---------- ---------
  26.   1    35      1150069    14-SEP-17 1152813    14-SEP-17

  28. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  29. ------- ---- -- ---------- ----------- ------------ ---------------
  30. 46      Full    9.50M      SBT_TAPE    00:00:15     14-SEP-17      
  31.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203620
  32.         Handle: c-1343950367-20170914-04   Media: station90-000003
  33.   SPFILE Included: Modification time: 13-SEP-17
  34.   SPFILE db_unique_name: ORCL
  35.   Control File Included: Ckp SCN: 1152852      Ckp time: 14-SEP-17

  37. RMAN>
复制代码
  1. RMAN> list copy ;

  3. specification does not match any control file copy in the repository
  4. List of Datafile Copies
  5. =======================

  7. Key     File S Completion Time Ckp SCN    Ckp Time      
  8. ------- ---- - --------------- ---------- ---------------
  9. 4       1    A 14-SEP-17       1152634    14-SEP-17      
  10.         Name: +FRA/orcl/datafile/system.276.954707725
  11.         Tag: ORA_OEM_LEVEL_0

  13. 5       2    A 14-SEP-17       1152644    14-SEP-17      
  14.         Name: +FRA/orcl/datafile/sysaux.274.954707731
  15.         Tag: ORA_OEM_LEVEL_0

  17. 6       3    A 14-SEP-17       1152685    14-SEP-17      
  18.         Name: +FRA/orcl/datafile/undotbs1.273.954707739
  19.         Tag: ORA_OEM_LEVEL_0

  21. 8       4    A 14-SEP-17       1152711    14-SEP-17      
  22.         Name: +FRA/orcl/datafile/users.271.954707741
  23.         Tag: ORA_OEM_LEVEL_0

  25. 7       5    A 14-SEP-17       1152698    14-SEP-17      
  26.         Name: +FRA/orcl/datafile/example.272.954707739
  27.         Tag: ORA_OEM_LEVEL_0

  29. List of Archived Log Copies for database with db_unique_name ORCL
  30. =====================================================================

  32. Key     Thrd Seq     S Low Time
  33. ------- ---- ------- - ---------
  34. 27      1    35      A 14-SEP-17
  35.         Name: +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755


  38. RMAN>
复制代码
第二天EM的输出：
  1. Step: Backup
  2.         
  3. Page Refreshed Sep 15, 2017 8:37:18 PM CST
  4. View Data               
  5.         
  6.         Status                Succeeded
  7.         Exit Code                0
  8.         Step ID                241
  9.         Targets                orcl.example.com
  10.         
  11.         Started                Sep 15, 2017 8:35:26 PM CST
  12.         Ended                Sep 15, 2017 8:36:45 PM CST
  13.         Step Elapsed Time                1 minutes, 19 seconds
  14.         Management Service                station90.example.com:1158_Management_Service
  15.         TIP         Management Service from which the job step was dispatched.
  16.                
  17.         
  18. Output Log

  20. Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 15 20:35:26 2017

  22. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  24. RMAN>
  25. connected to target database: ORCL (DBID=1343950367)
  26. using target database control file instead of recovery catalog

  28. RMAN>
  29. echo set on


  32. RMAN> run {
  33. 2> allocate channel oem_disk_backup device type disk;
  34. 3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
  35. 4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  36. 5> release channel oem_disk_backup;
  37. 6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  38. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  39. 8> backup archivelog all not backed up;
  40. 9> }
  41. allocated channel: oem_disk_backup
  42. channel oem_disk_backup: SID=13 device type=DISK

  44. Starting recover at 15-SEP-17
  45. no copy of datafile 1 found to recover
  46. no copy of datafile 2 found to recover
  47. no copy of datafile 3 found to recover
  48. no copy of datafile 4 found to recover
  49. no copy of datafile 5 found to recover
  50. Finished recover at 15-SEP-17

  52. Starting backup at 15-SEP-17
  53. channel oem_disk_backup: starting incremental level 1 datafile backup set
  54. channel oem_disk_backup: specifying datafile(s) in backup set
  55. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  56. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  57. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  58. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  59. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  60. channel oem_disk_backup: starting piece 1 at 15-SEP-17
  61. channel oem_disk_backup: finished piece 1 at 15-SEP-17
  62. piece handle=+FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129 tag=ORA_OEM_LEVEL_0 comment=NONE
  63. channel oem_disk_backup: backup set complete, elapsed time: 00:00:03
  64. Finished backup at 15-SEP-17

  66. Starting Control File and SPFILE Autobackup at 15-SEP-17
  67. piece handle=+FRA/orcl/autobackup/2017_09_15/s_954794131.267.954794133 comment=NONE
  68. Finished Control File and SPFILE Autobackup at 15-SEP-17

  70. released channel: oem_disk_backup

  72. allocated channel: oem_sbt_backup1
  73. channel oem_sbt_backup1: SID=13 device type=SBT_TAPE
  74. channel oem_sbt_backup1: Oracle Secure Backup

  76. allocated channel: oem_sbt_backup2
  77. channel oem_sbt_backup2: SID=130 device type=SBT_TAPE
  78. channel oem_sbt_backup2: Oracle Secure Backup

  80. Starting backup at 15-SEP-17
  81. current log archived
  82. skipping archived log file +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755; already backed on 14-SEP-17
  83. channel oem_sbt_backup1: starting archived log backup set
  84. channel oem_sbt_backup1: specifying archived log(s) in backup set
  85. input archived log thread=1 sequence=36 RECID=28 STAMP=954794144
  86. channel oem_sbt_backup1: starting piece 1 at 15-SEP-17
  87. channel oem_sbt_backup1: finished piece 1 at 15-SEP-17
  88. piece handle=1msei051_1_1 tag=TAG20170915T203545 comment=API Version 2.0,MMS Version 10.4.0.4
  89. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
  90. Finished backup at 15-SEP-17

  92. Starting Control File and SPFILE Autobackup at 15-SEP-17
  93. piece handle=c-1343950367-20170915-01 comment=API Version 2.0,MMS Version 10.4.0.4
  94. Finished Control File and SPFILE Autobackup at 15-SEP-17
  95. released channel: oem_sbt_backup1
  96. released channel: oem_sbt_backup2


  99. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  100. allocated channel: ORA_MAINT_SBT_TAPE_1
  101. channel ORA_MAINT_SBT_TAPE_1: SID=13 device type=SBT_TAPE
  102. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


  105. RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  106. no obsolete backups found


  109. RMAN> exit;

  111. Recovery Manager complete.
复制代码
第二天的产出物：

  1. RMAN> list backup;


  4. List of Backup Sets
  5. ===================


  8. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  9. ------- ---- -- ---------- ----------- ------------ ---------------
  10. 44      Full    9.36M      DISK        00:00:01     14-SEP-17      
  11.         BP Key: 46   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203541
  12.         Piece Name: +FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743
  13.   SPFILE Included: Modification time: 13-SEP-17
  14.   SPFILE db_unique_name: ORCL
  15.   Control File Included: Ckp SCN: 1152721      Ckp time: 14-SEP-17

  17. BS Key  Size       Device Type Elapsed Time Completion Time
  18. ------- ---------- ----------- ------------ ---------------
  19. 45      4.00M      SBT_TAPE    00:00:24     14-SEP-17      
  20.         BP Key: 47   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203555
  21.         Handle: 1isefbpb_1_1   Media: station90-000003

  23.   List of Archived Logs in backup set 45
  24.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  25.   ---- ------- ---------- --------- ---------- ---------
  26.   1    35      1150069    14-SEP-17 1152813    14-SEP-17

  28. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  29. ------- ---- -- ---------- ----------- ------------ ---------------
  30. 46      Full    9.50M      SBT_TAPE    00:00:15     14-SEP-17      
  31.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203620
  32.         Handle: c-1343950367-20170914-04   Media: station90-000003
  33.   SPFILE Included: Modification time: 13-SEP-17
  34.   SPFILE db_unique_name: ORCL
  35.   Control File Included: Ckp SCN: 1152852      Ckp time: 14-SEP-17

  37. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  38. ------- ---- -- ---------- ----------- ------------ ---------------
  39. 47      Incr 1  17.88M     DISK        00:00:02     15-SEP-17      
  40.         BP Key: 49   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  41.         Piece Name: +FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129
  42.   List of Datafiles in backup set 47
  43.   File LV Type Ckp SCN    Ckp Time  Name
  44.   ---- -- ---- ---------- --------- ----
  45.   1    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/system.256.816169553
  46.   2    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
  47.   3    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
  48.   4    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/users.259.816169553
  49.   5    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/example.265.816169651

  51. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  52. ------- ---- -- ---------- ----------- ------------ ---------------
  53. 48      Full    9.36M      DISK        00:00:01     15-SEP-17      
  54.         BP Key: 50   Status: AVAILABLE  Compressed: NO  Tag: TAG20170915T203531
  55.         Piece Name: +FRA/orcl/autobackup/2017_09_15/s_954794131.267.954794133
  56.   SPFILE Included: Modification time: 13-SEP-17
  57.   SPFILE db_unique_name: ORCL
  58.   Control File Included: Ckp SCN: 1155522      Ckp time: 15-SEP-17

  60. BS Key  Size       Device Type Elapsed Time Completion Time
  61. ------- ---------- ----------- ------------ ---------------
  62. 49      11.50M     SBT_TAPE    00:00:25     15-SEP-17      
  63.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170915T203545
  64.         Handle: 1msei051_1_1   Media: station90-000003

  66.   List of Archived Logs in backup set 49
  67.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  68.   ---- ------- ---------- --------- ---------- ---------
  69.   1    36      1152813    14-SEP-17 1155635    15-SEP-17

  71. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  72. ------- ---- -- ---------- ----------- ------------ ---------------
  73. 50      Full    9.50M      SBT_TAPE    00:00:15     15-SEP-17      
  74.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20170915T203610
  75.         Handle: c-1343950367-20170915-01   Media: station90-000003
  76.   SPFILE Included: Modification time: 13-SEP-17
  77.   SPFILE db_unique_name: ORCL
  78.   Control File Included: Ckp SCN: 1155702      Ckp time: 15-SEP-17

  80. RMAN>
复制代码
  1. RMAN> list copy;

  3. specification does not match any control file copy in the repository
  4. List of Datafile Copies
  5. =======================

  7. Key     File S Completion Time Ckp SCN    Ckp Time      
  8. ------- ---- - --------------- ---------- ---------------
  9. 4       1    A 14-SEP-17       1152634    14-SEP-17      
  10.         Name: +FRA/orcl/datafile/system.276.954707725
  11.         Tag: ORA_OEM_LEVEL_0

  13. 5       2    A 14-SEP-17       1152644    14-SEP-17      
  14.         Name: +FRA/orcl/datafile/sysaux.274.954707731
  15.         Tag: ORA_OEM_LEVEL_0

  17. 6       3    A 14-SEP-17       1152685    14-SEP-17      
  18.         Name: +FRA/orcl/datafile/undotbs1.273.954707739
  19.         Tag: ORA_OEM_LEVEL_0

  21. 8       4    A 14-SEP-17       1152711    14-SEP-17      
  22.         Name: +FRA/orcl/datafile/users.271.954707741
  23.         Tag: ORA_OEM_LEVEL_0

  25. 7       5    A 14-SEP-17       1152698    14-SEP-17      
  26.         Name: +FRA/orcl/datafile/example.272.954707739
  27.         Tag: ORA_OEM_LEVEL_0

  29. List of Archived Log Copies for database with db_unique_name ORCL
  30. =====================================================================

  32. Key     Thrd Seq     S Low Time
  33. ------- ---- ------- - ---------
  34. 27      1    35      A 14-SEP-17
  35.         Name: +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755

  37. 28      1    36      A 14-SEP-17
  38.         Name: +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145


  41. RMAN>
复制代码
第三天EM的输出：
  1. Step: Backup
  2.         
  3. Page Refreshed Sep 16, 2017 8:37:32 PM CST
  4. View Data               
  5.         
  6.         Status                Succeeded
  7.         Exit Code                0
  8.         Step ID                267
  9.         Targets                orcl.example.com
  10.         
  11.         Started                Sep 16, 2017 8:35:28 PM CST
  12.         Ended                Sep 16, 2017 8:37:06 PM CST
  13.         Step Elapsed Time                1 minutes, 38 seconds
  14.         Management Service                station90.example.com:1158_Management_Service
  15.         TIP         Management Service from which the job step was dispatched.
  16.                
  17.         
  18. Output Log

  20. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 16 20:35:29 2017

  22. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  24. RMAN>
  25. connected to target database: ORCL (DBID=1343950367)
  26. using target database control file instead of recovery catalog

  28. RMAN>
  29. echo set on


  32. RMAN> run {
  33. 2> allocate channel oem_disk_backup device type disk;
  34. 3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
  35. 4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  36. 5> release channel oem_disk_backup;
  37. 6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  38. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  39. 8> backup archivelog all not backed up;
  40. 9> }
  41. allocated channel: oem_disk_backup
  42. channel oem_disk_backup: SID=135 device type=DISK

  44. Starting recover at 16-SEP-17
  45. channel oem_disk_backup: starting incremental datafile backup set restore
  46. channel oem_disk_backup: specifying datafile copies to recover
  47. recovering datafile copy file number=00001 name=+FRA/orcl/datafile/system.276.954707725
  48. recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.274.954707731
  49. recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.273.954707739
  50. recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.271.954707741
  51. recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.272.954707739
  52. channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129
  53. channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129 tag=ORA_OEM_LEVEL_0
  54. channel oem_disk_backup: restored backup piece 1
  55. channel oem_disk_backup: restore complete, elapsed time: 00:00:03
  56. Finished recover at 16-SEP-17

  58. Starting backup at 16-SEP-17
  59. channel oem_disk_backup: starting incremental level 1 datafile backup set
  60. channel oem_disk_backup: specifying datafile(s) in backup set
  61. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  62. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  63. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  64. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  65. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  66. channel oem_disk_backup: starting piece 1 at 16-SEP-17
  67. channel oem_disk_backup: finished piece 1 at 16-SEP-17
  68. piece handle=+FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539 tag=ORA_OEM_LEVEL_0 comment=NONE
  69. channel oem_disk_backup: backup set complete, elapsed time: 00:00:07
  70. Finished backup at 16-SEP-17

  72. Starting Control File and SPFILE Autobackup at 16-SEP-17
  73. piece handle=+FRA/orcl/autobackup/2017_09_16/s_954880542.261.954880543 comment=NONE
  74. Finished Control File and SPFILE Autobackup at 16-SEP-17

  76. released channel: oem_disk_backup

  78. allocated channel: oem_sbt_backup1
  79. channel oem_sbt_backup1: SID=135 device type=SBT_TAPE
  80. channel oem_sbt_backup1: Oracle Secure Backup

  82. allocated channel: oem_sbt_backup2
  83. channel oem_sbt_backup2: SID=197 device type=SBT_TAPE
  84. channel oem_sbt_backup2: Oracle Secure Backup

  86. Starting backup at 16-SEP-17
  87. current log archived
  88. skipping archived log file +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755; already backed on 14-SEP-17
  89. skipping archived log file +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145; already backed on 15-SEP-17
  90. channel oem_sbt_backup1: starting archived log backup set
  91. channel oem_sbt_backup1: specifying archived log(s) in backup set
  92. input archived log thread=1 sequence=37 RECID=29 STAMP=954880359
  93. input archived log thread=1 sequence=38 RECID=30 STAMP=954880389
  94. channel oem_sbt_backup1: starting piece 1 at 16-SEP-17
  95. channel oem_sbt_backup2: starting archived log backup set
  96. channel oem_sbt_backup2: specifying archived log(s) in backup set
  97. input archived log thread=1 sequence=39 RECID=31 STAMP=954880555
  98. channel oem_sbt_backup2: starting piece 1 at 16-SEP-17
  99. channel oem_sbt_backup1: finished piece 1 at 16-SEP-17
  100. piece handle=1qsekkhc_1_1 tag=TAG20170916T203555 comment=API Version 2.0,MMS Version 10.4.0.4
  101. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
  102. channel oem_sbt_backup2: finished piece 1 at 16-SEP-17
  103. piece handle=1rsekkhc_1_1 tag=TAG20170916T203555 comment=API Version 2.0,MMS Version 10.4.0.4
  104. channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:35
  105. Finished backup at 16-SEP-17

  107. Starting Control File and SPFILE Autobackup at 16-SEP-17
  108. piece handle=c-1343950367-20170916-01 comment=API Version 2.0,MMS Version 10.4.0.4
  109. Finished Control File and SPFILE Autobackup at 16-SEP-17
  110. released channel: oem_sbt_backup1
  111. released channel: oem_sbt_backup2

  113. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  114. allocated channel: ORA_MAINT_SBT_TAPE_1
  115. channel ORA_MAINT_SBT_TAPE_1: SID=135 device type=SBT_TAPE
  116. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


  119. RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  120. no obsolete backups found

  122. RMAN> exit;

  124. Recovery Manager complete.
复制代码
第三天产出物：
  1. RMAN> list backup;

  3. using target database control file instead of recovery catalog

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


  9. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  10. ------- ---- -- ---------- ----------- ------------ ---------------
  11. 44      Full    9.36M      DISK        00:00:01     14-SEP-17      
  12.         BP Key: 46   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203541
  13.         Piece Name: +FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743
  14.   SPFILE Included: Modification time: 13-SEP-17
  15.   SPFILE db_unique_name: ORCL
  16.   Control File Included: Ckp SCN: 1152721      Ckp time: 14-SEP-17

  18. BS Key  Size       Device Type Elapsed Time Completion Time
  19. ------- ---------- ----------- ------------ ---------------
  20. 45      4.00M      SBT_TAPE    00:00:24     14-SEP-17      
  21.         BP Key: 47   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203555
  22.         Handle: 1isefbpb_1_1   Media: station90-000003

  24.   List of Archived Logs in backup set 45
  25.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  26.   ---- ------- ---------- --------- ---------- ---------
  27.   1    35      1150069    14-SEP-17 1152813    14-SEP-17

  29. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  30. ------- ---- -- ---------- ----------- ------------ ---------------
  31. 46      Full    9.50M      SBT_TAPE    00:00:15     14-SEP-17      
  32.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203620
  33.         Handle: c-1343950367-20170914-04   Media: station90-000003
  34.   SPFILE Included: Modification time: 13-SEP-17
  35.   SPFILE db_unique_name: ORCL
  36.   Control File Included: Ckp SCN: 1152852      Ckp time: 14-SEP-17

  38. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  39. ------- ---- -- ---------- ----------- ------------ ---------------
  40. 47      Incr 1  17.88M     DISK        00:00:02     15-SEP-17      
  41.         BP Key: 49   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  42.         Piece Name: +FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129
  43.   List of Datafiles in backup set 47
  44.   File LV Type Ckp SCN    Ckp Time  Name
  45.   ---- -- ---- ---------- --------- ----
  46.   1    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/system.256.816169553
  47.   2    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
  48.   3    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
  49.   4    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/users.259.816169553
  50.   5    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/example.265.816169651

  52. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  53. ------- ---- -- ---------- ----------- ------------ ---------------
  54. 48      Full    9.36M      DISK        00:00:01     15-SEP-17      
  55.         BP Key: 50   Status: AVAILABLE  Compressed: NO  Tag: TAG20170915T203531
  56.         Piece Name: +FRA/orcl/autobackup/2017_09_15/s_954794131.267.954794133
  57.   SPFILE Included: Modification time: 13-SEP-17
  58.   SPFILE db_unique_name: ORCL
  59.   Control File Included: Ckp SCN: 1155522      Ckp time: 15-SEP-17

  61. BS Key  Size       Device Type Elapsed Time Completion Time
  62. ------- ---------- ----------- ------------ ---------------
  63. 49      11.50M     SBT_TAPE    00:00:25     15-SEP-17      
  64.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170915T203545
  65.         Handle: 1msei051_1_1   Media: station90-000003

  67.   List of Archived Logs in backup set 49
  68.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  69.   ---- ------- ---------- --------- ---------- ---------
  70.   1    36      1152813    14-SEP-17 1155635    15-SEP-17

  72. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  73. ------- ---- -- ---------- ----------- ------------ ---------------
  74. 50      Full    9.50M      SBT_TAPE    00:00:15     15-SEP-17      
  75.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20170915T203610
  76.         Handle: c-1343950367-20170915-01   Media: station90-000003
  77.   SPFILE Included: Modification time: 13-SEP-17
  78.   SPFILE db_unique_name: ORCL
  79.   Control File Included: Ckp SCN: 1155702      Ckp time: 15-SEP-17

  81. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  82. ------- ---- -- ---------- ----------- ------------ ---------------
  83. 51      Incr 1  45.66M     DISK        00:00:04     16-SEP-17      
  84.         BP Key: 53   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  85.         Piece Name: +FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539
  86.   List of Datafiles in backup set 51
  87.   File LV Type Ckp SCN    Ckp Time  Name
  88.   ---- -- ---- ---------- --------- ----
  89.   1    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/system.256.816169553
  90.   2    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
  91.   3    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
  92.   4    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/users.259.816169553
  93.   5    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/example.265.816169651

  95. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  96. ------- ---- -- ---------- ----------- ------------ ---------------
  97. 52      Full    9.36M      DISK        00:00:00     16-SEP-17      
  98.         BP Key: 54   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T203542
  99.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954880542.261.954880543
  100.   SPFILE Included: Modification time: 13-SEP-17
  101.   SPFILE db_unique_name: ORCL
  102.   Control File Included: Ckp SCN: 1165783      Ckp time: 16-SEP-17

  104. BS Key  Size       Device Type Elapsed Time Completion Time
  105. ------- ---------- ----------- ------------ ---------------
  106. 53      33.75M     SBT_TAPE    00:00:24     16-SEP-17      
  107.         BP Key: 55   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T203555
  108.         Handle: 1qsekkhc_1_1   Media: station90-000003

  110.   List of Archived Logs in backup set 53
  111.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  112.   ---- ------- ---------- --------- ---------- ---------
  113.   1    37      1155635    15-SEP-17 1161457    16-SEP-17
  114.   1    38      1161457    16-SEP-17 1164170    16-SEP-17

  116. BS Key  Size       Device Type Elapsed Time Completion Time
  117. ------- ---------- ----------- ------------ ---------------
  118. 54      11.00M     SBT_TAPE    00:00:26     16-SEP-17      
  119.         BP Key: 56   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T203555
  120.         Handle: 1rsekkhc_1_1   Media: station90-000004

  122.   List of Archived Logs in backup set 54
  123.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  124.   ---- ------- ---------- --------- ---------- ---------
  125.   1    39      1164170    16-SEP-17 1165906    16-SEP-17

  127. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  128. ------- ---- -- ---------- ----------- ------------ ---------------
  129. 55      Full    9.50M      SBT_TAPE    00:00:16     16-SEP-17      
  130.         BP Key: 57   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T203631
  131.         Handle: c-1343950367-20170916-01   Media: station90-000003
  132.   SPFILE Included: Modification time: 13-SEP-17
  133.   SPFILE db_unique_name: ORCL
  134.   Control File Included: Ckp SCN: 1165981      Ckp time: 16-SEP-17

  136. RMAN>
复制代码
看滚雪球：
  1. RMAN> list copy;

  3. specification does not match any control file copy in the repository
  4. List of Datafile Copies
  5. =======================

  7. Key     File S Completion Time Ckp SCN    Ckp Time      
  8. ------- ---- - --------------- ---------- ---------------
  9. 11      1    A 16-SEP-17       1155512    15-SEP-17      
  10.         Name: +FRA/orcl/datafile/system.276.954707725
  11.         Tag: ORA_OEM_LEVEL_0

  13. 13      2    A 16-SEP-17       1155512    15-SEP-17      
  14.         Name: +FRA/orcl/datafile/sysaux.274.954707731
  15.         Tag: ORA_OEM_LEVEL_0

  17. 12      3    A 16-SEP-17       1155512    15-SEP-17      
  18.         Name: +FRA/orcl/datafile/undotbs1.273.954707739
  19.         Tag: ORA_OEM_LEVEL_0

  21. 10      4    A 16-SEP-17       1155512    15-SEP-17      
  22.         Name: +FRA/orcl/datafile/users.271.954707741
  23.         Tag: ORA_OEM_LEVEL_0

  25. 9       5    A 16-SEP-17       1155512    15-SEP-17      
  26.         Name: +FRA/orcl/datafile/example.272.954707739
  27.         Tag: ORA_OEM_LEVEL_0

  29. List of Archived Log Copies for database with db_unique_name ORCL
  30. =====================================================================

  32. Key     Thrd Seq     S Low Time
  33. ------- ---- ------- - ---------
  34. 27      1    35      A 14-SEP-17
  35.         Name: +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755

  37. 28      1    36      A 14-SEP-17
  38.         Name: +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145

  40. 29      1    37      A 15-SEP-17
  41.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_37.265.954880359

  43. 30      1    38      A 16-SEP-17
  44.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_38.264.954880389

  46. 31      1    39      A 16-SEP-17
  47.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_39.262.954880555


  50. RMAN>
复制代码
周备份EM输出：
  1. Step: Backup
  2.         
  3. Page Refreshed Sep 17, 2017 8:39:54 PM CST
  4. View Data               
  5.         
  6.         Status                Succeeded
  7.         Exit Code                0
  8.         Step ID                293
  9.         Targets                orcl.example.com
  10.         
  11.         Started                Sep 17, 2017 8:35:21 PM CST
  12.         Ended                Sep 17, 2017 8:39:06 PM CST
  13.         Step Elapsed Time                3 minutes, 45 seconds
  14.         Management Service                station90.example.com:1158_Management_Service
  15.         TIP         Management Service from which the job step was dispatched.
  16.                
  17.         
  18. Output Log

  20. Recovery Manager: Release 11.2.0.1.0 - Production on Sun Sep 17 20:35:22 2017

  22. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  24. RMAN>
  25. connected to target database: ORCL (DBID=1343950367)
  26. using target database control file instead of recovery catalog

  28. RMAN>
  29. echo set on


  32. RMAN> run {
  33. 2> allocate channel oem_disk_backup device type disk;
  34. 3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
  35. 4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  36. 5> release channel oem_disk_backup;
  37. 6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  38. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  39. 8> backup recovery area;
  40. 9> }
  41. allocated channel: oem_disk_backup
  42. channel oem_disk_backup: SID=79 device type=DISK

  44. Starting recover at 17-SEP-17
  45. channel oem_disk_backup: starting incremental datafile backup set restore
  46. channel oem_disk_backup: specifying datafile copies to recover
  47. recovering datafile copy file number=00001 name=+FRA/orcl/datafile/system.276.954707725
  48. recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.274.954707731
  49. recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.273.954707739
  50. recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.271.954707741
  51. recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.272.954707739
  52. channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539
  53. channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539 tag=ORA_OEM_LEVEL_0
  54. channel oem_disk_backup: restored backup piece 1
  55. channel oem_disk_backup: restore complete, elapsed time: 00:00:03
  56. Finished recover at 17-SEP-17

  58. Starting backup at 17-SEP-17
  59. channel oem_disk_backup: starting incremental level 1 datafile backup set
  60. channel oem_disk_backup: specifying datafile(s) in backup set
  61. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  62. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  63. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  64. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  65. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  66. channel oem_disk_backup: starting piece 1 at 17-SEP-17
  67. channel oem_disk_backup: finished piece 1 at 17-SEP-17
  68. piece handle=+FRA/orcl/backupset/2017_09_17/nnndn1_ora_oem_level_0_0.278.954966931 tag=ORA_OEM_LEVEL_0 comment=NONE
  69. channel oem_disk_backup: backup set complete, elapsed time: 00:00:07
  70. Finished backup at 17-SEP-17

  72. Starting Control File and SPFILE Autobackup at 17-SEP-17
  73. piece handle=+FRA/orcl/autobackup/2017_09_17/s_954966934.279.954966935 comment=NONE
  74. Finished Control File and SPFILE Autobackup at 17-SEP-17

  76. released channel: oem_disk_backup

  78. allocated channel: oem_sbt_backup1
  79. channel oem_sbt_backup1: SID=79 device type=SBT_TAPE
  80. channel oem_sbt_backup1: Oracle Secure Backup

  82. allocated channel: oem_sbt_backup2
  83. channel oem_sbt_backup2: SID=142 device type=SBT_TAPE
  84. channel oem_sbt_backup2: Oracle Secure Backup

  86. Starting backup at 17-SEP-17
  87. skipping archived log file +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755; already backed up 1 time(s)
  88. skipping archived log file +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145; already backed up 1 time(s)
  89. skipping archived log file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_37.265.954880359; already backed up 1 time(s)
  90. skipping archived log file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_38.264.954880389; already backed up 1 time(s)
  91. skipping archived log file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_39.262.954880555; already backed up 1 time(s)
  92. channel oem_sbt_backup1: starting full datafile backup set
  93. channel oem_sbt_backup1: including datafile copy of datafile 00002 in backup set
  94. input file name=+FRA/orcl/datafile/sysaux.274.954707731
  95. channel oem_sbt_backup1: including datafile copy of datafile 00003 in backup set
  96. input file name=+FRA/orcl/datafile/undotbs1.273.954707739
  97. channel oem_sbt_backup1: including datafile copy of datafile 00005 in backup set
  98. input file name=+FRA/orcl/datafile/example.272.954707739
  99. channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
  100. channel oem_sbt_backup2: starting full datafile backup set
  101. channel oem_sbt_backup2: including datafile copy of datafile 00001 in backup set
  102. input file name=+FRA/orcl/datafile/system.276.954707725
  103. channel oem_sbt_backup2: including datafile copy of datafile 00004 in backup set
  104. input file name=+FRA/orcl/datafile/users.271.954707741
  105. channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
  106. channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
  107. piece handle=1vsen8t4_1_1 tag=TAG20170917T203547 comment=API Version 2.0,MMS Version 10.4.0.4
  108. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:35
  109. channel oem_sbt_backup1: starting archived log backup set
  110. channel oem_sbt_backup1: specifying archived log(s) in backup set
  111. input archived log thread=1 sequence=40 RECID=32 STAMP=954966748
  112. channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
  113. channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
  114. piece handle=20sen8t4_1_1 tag=TAG20170917T203547 comment=API Version 2.0,MMS Version 10.4.0.4
  115. channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:35
  116. channel oem_sbt_backup2: starting archived log backup set
  117. channel oem_sbt_backup2: specifying archived log(s) in backup set
  118. input archived log thread=1 sequence=41 RECID=33 STAMP=954966917
  119. channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
  120. channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
  121. piece handle=21sen8u7_1_1 tag=TAG20170917T203547 comment=API Version 2.0,MMS Version 10.4.0.4
  122. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
  123. channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
  124. piece handle=22sen8u7_1_1 tag=TAG20170917T203547 comment=API Version 2.0,MMS Version 10.4.0.4
  125. channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:25
  126. channel oem_sbt_backup1: input backup set: count=49, stamp=954707741, piece=1
  127. channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
  128. channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743
  129. channel oem_sbt_backup2: input backup set: count=52, stamp=954794128, piece=1
  130. channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
  131. channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129
  132. piece handle=c-1343950367-20170914-03 comment=API Version 2.0,MMS Version 10.4.0.4
  133. channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
  134. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:25
  135. channel oem_sbt_backup1: input backup set: count=53, stamp=954794131, piece=1
  136. channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
  137. channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_09_15/s_954794131.267.954794133
  138. piece handle=1ksei04g_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
  139. channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
  140. channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:26
  141. channel oem_sbt_backup2: input backup set: count=56, stamp=954880535, piece=1
  142. channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
  143. channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539
  144. piece handle=c-1343950367-20170915-00 comment=API Version 2.0,MMS Version 10.4.0.4
  145. channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
  146. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:26
  147. channel oem_sbt_backup1: input backup set: count=57, stamp=954880542, piece=1
  148. channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
  149. channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_09_16/s_954880542.261.954880543
  150. piece handle=1osekkgn_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
  151. channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
  152. channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:25
  153. channel oem_sbt_backup2: input backup set: count=61, stamp=954966927, piece=1
  154. channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
  155. channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2017_09_17/nnndn1_ora_oem_level_0_0.278.954966931
  156. piece handle=c-1343950367-20170916-00 comment=API Version 2.0,MMS Version 10.4.0.4
  157. channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
  158. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:25
  159. channel oem_sbt_backup1: input backup set: count=62, stamp=954966934, piece=1
  160. channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
  161. channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_09_17/s_954966934.279.954966935
  162. piece handle=1tsen8sf_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
  163. channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
  164. channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:26
  165. piece handle=c-1343950367-20170917-00 comment=API Version 2.0,MMS Version 10.4.0.4
  166. channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
  167. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:26
  168. Finished backup at 17-SEP-17

  170. Starting Control File and SPFILE Autobackup at 17-SEP-17
  171. piece handle=c-1343950367-20170917-01 comment=API Version 2.0,MMS Version 10.4.0.4
  172. Finished Control File and SPFILE Autobackup at 17-SEP-17
  173. released channel: oem_sbt_backup1
  174. released channel: oem_sbt_backup2


  177. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  178. allocated channel: ORA_MAINT_SBT_TAPE_1
  179. channel ORA_MAINT_SBT_TAPE_1: SID=79 device type=SBT_TAPE
  180. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


  183. RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  184. no obsolete backups found


  187. RMAN> exit;

  189. Recovery Manager complete.
复制代码
周备份的产出物：
  1. RMAN> list backup;

  3. using target database control file instead of recovery catalog

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


  9. BS Key  Type LV Size
  10. ------- ---- -- ----------
  11. 44      Full    9.36M
  12.   SPFILE Included: Modification time: 13-SEP-17
  13.   SPFILE db_unique_name: ORCL
  14.   Control File Included: Ckp SCN: 1152721      Ckp time: 14-SEP-17

  16.   Backup Set Copy #1 of backup set 44
  17.   Device Type Elapsed Time Completion Time Compressed Tag
  18.   ----------- ------------ --------------- ---------- ---
  19.   DISK        00:00:01     14-SEP-17       NO         TAG20170914T203541

  21.     List of Backup Pieces for backup set 44 Copy #1
  22.     BP Key  Pc# Status      Piece Name
  23.     ------- --- ----------- ----------
  24.     46      1   AVAILABLE   +FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743

  26.   Backup Set Copy #2 of backup set 44
  27.   Device Type Elapsed Time Completion Time Compressed Tag
  28.   ----------- ------------ --------------- ---------- ---
  29.   SBT_TAPE    00:00:01     17-SEP-17       NO         TAG20170914T203541

  31.     List of Backup Pieces for backup set 44 Copy #2
  32.     BP Key  Pc# Status      Media                   Piece Name
  33.     ------- --- ----------- ----------------------- ----------
  34.     64      1   AVAILABLE   station90-000003        c-1343950367-20170914-03

  36. BS Key  Size       Device Type Elapsed Time Completion Time
  37. ------- ---------- ----------- ------------ ---------------
  38. 45      4.00M      SBT_TAPE    00:00:24     14-SEP-17      
  39.         BP Key: 47   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203555
  40.         Handle: 1isefbpb_1_1   Media: station90-000003

  42.   List of Archived Logs in backup set 45
  43.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  44.   ---- ------- ---------- --------- ---------- ---------
  45.   1    35      1150069    14-SEP-17 1152813    14-SEP-17

  47. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  48. ------- ---- -- ---------- ----------- ------------ ---------------
  49. 46      Full    9.50M      SBT_TAPE    00:00:15     14-SEP-17      
  50.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20170914T203620
  51.         Handle: c-1343950367-20170914-04   Media: station90-000003
  52.   SPFILE Included: Modification time: 13-SEP-17
  53.   SPFILE db_unique_name: ORCL
  54.   Control File Included: Ckp SCN: 1152852      Ckp time: 14-SEP-17

  56. BS Key  Type LV Size
  57. ------- ---- -- ----------
  58. 47      Incr 1  17.88M
  59.   List of Datafiles in backup set 47
  60.   File LV Type Ckp SCN    Ckp Time  Name
  61.   ---- -- ---- ---------- --------- ----
  62.   1    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/system.256.816169553
  63.   2    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
  64.   3    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
  65.   4    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/users.259.816169553
  66.   5    1  Incr 1155512    15-SEP-17 +DATA/orcl/datafile/example.265.816169651

  68.   Backup Set Copy #1 of backup set 47
  69.   Device Type Elapsed Time Completion Time Compressed Tag
  70.   ----------- ------------ --------------- ---------- ---
  71.   DISK        00:00:02     15-SEP-17       NO         ORA_OEM_LEVEL_0

  73.     List of Backup Pieces for backup set 47 Copy #1
  74.     BP Key  Pc# Status      Piece Name
  75.     ------- --- ----------- ----------
  76.     49      1   AVAILABLE   +FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129

  78.   Backup Set Copy #2 of backup set 47
  79.   Device Type Elapsed Time Completion Time Compressed Tag
  80.   ----------- ------------ --------------- ---------- ---
  81.   SBT_TAPE    00:00:02     17-SEP-17       NO         ORA_OEM_LEVEL_0

  83.     List of Backup Pieces for backup set 47 Copy #2
  84.     BP Key  Pc# Status      Media                   Piece Name
  85.     ------- --- ----------- ----------------------- ----------
  86.     65      1   AVAILABLE   station90-000004        1ksei04g_1_2

  88. BS Key  Type LV Size
  89. ------- ---- -- ----------
  90. 48      Full    9.36M
  91.   SPFILE Included: Modification time: 13-SEP-17
  92.   SPFILE db_unique_name: ORCL
  93.   Control File Included: Ckp SCN: 1155522      Ckp time: 15-SEP-17

  95.   Backup Set Copy #1 of backup set 48
  96.   Device Type Elapsed Time Completion Time Compressed Tag
  97.   ----------- ------------ --------------- ---------- ---
  98.   DISK        00:00:01     15-SEP-17       NO         TAG20170915T203531

  100.     List of Backup Pieces for backup set 48 Copy #1
  101.     BP Key  Pc# Status      Piece Name
  102.     ------- --- ----------- ----------
  103.     50      1   AVAILABLE   +FRA/orcl/autobackup/2017_09_15/s_954794131.267.954794133

  105.   Backup Set Copy #2 of backup set 48
  106.   Device Type Elapsed Time Completion Time Compressed Tag
  107.   ----------- ------------ --------------- ---------- ---
  108.   SBT_TAPE    00:00:01     17-SEP-17       NO         TAG20170915T203531

  110.     List of Backup Pieces for backup set 48 Copy #2
  111.     BP Key  Pc# Status      Media                   Piece Name
  112.     ------- --- ----------- ----------------------- ----------
  113.     67      1   AVAILABLE   station90-000003        c-1343950367-20170915-00

  115. BS Key  Size       Device Type Elapsed Time Completion Time
  116. ------- ---------- ----------- ------------ ---------------
  117. 49      11.50M     SBT_TAPE    00:00:25     15-SEP-17      
  118.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20170915T203545
  119.         Handle: 1msei051_1_1   Media: station90-000003

  121.   List of Archived Logs in backup set 49
  122.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  123.   ---- ------- ---------- --------- ---------- ---------
  124.   1    36      1152813    14-SEP-17 1155635    15-SEP-17

  126. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  127. ------- ---- -- ---------- ----------- ------------ ---------------
  128. 50      Full    9.50M      SBT_TAPE    00:00:15     15-SEP-17      
  129.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20170915T203610
  130.         Handle: c-1343950367-20170915-01   Media: station90-000003
  131.   SPFILE Included: Modification time: 13-SEP-17
  132.   SPFILE db_unique_name: ORCL
  133.   Control File Included: Ckp SCN: 1155702      Ckp time: 15-SEP-17

  135. BS Key  Type LV Size
  136. ------- ---- -- ----------
  137. 51      Incr 1  45.66M
  138.   List of Datafiles in backup set 51
  139.   File LV Type Ckp SCN    Ckp Time  Name
  140.   ---- -- ---- ---------- --------- ----
  141.   1    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/system.256.816169553
  142.   2    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
  143.   3    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
  144.   4    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/users.259.816169553
  145.   5    1  Incr 1165770    16-SEP-17 +DATA/orcl/datafile/example.265.816169651

  147.   Backup Set Copy #1 of backup set 51
  148.   Device Type Elapsed Time Completion Time Compressed Tag
  149.   ----------- ------------ --------------- ---------- ---
  150.   DISK        00:00:04     16-SEP-17       NO         ORA_OEM_LEVEL_0

  152.     List of Backup Pieces for backup set 51 Copy #1
  153.     BP Key  Pc# Status      Piece Name
  154.     ------- --- ----------- ----------
  155.     53      1   AVAILABLE   +FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539

  157.   Backup Set Copy #2 of backup set 51
  158.   Device Type Elapsed Time Completion Time Compressed Tag
  159.   ----------- ------------ --------------- ---------- ---
  160.   SBT_TAPE    00:00:04     17-SEP-17       NO         ORA_OEM_LEVEL_0

  162.     List of Backup Pieces for backup set 51 Copy #2
  163.     BP Key  Pc# Status      Media                   Piece Name
  164.     ------- --- ----------- ----------------------- ----------
  165.     66      1   AVAILABLE   station90-000004        1osekkgn_1_2

  167. BS Key  Type LV Size
  168. ------- ---- -- ----------
  169. 52      Full    9.36M
  170.   SPFILE Included: Modification time: 13-SEP-17
  171.   SPFILE db_unique_name: ORCL
  172.   Control File Included: Ckp SCN: 1165783      Ckp time: 16-SEP-17

  174.   Backup Set Copy #1 of backup set 52
  175.   Device Type Elapsed Time Completion Time Compressed Tag
  176.   ----------- ------------ --------------- ---------- ---
  177.   DISK        00:00:00     16-SEP-17       NO         TAG20170916T203542

  179.     List of Backup Pieces for backup set 52 Copy #1
  180.     BP Key  Pc# Status      Piece Name
  181.     ------- --- ----------- ----------
  182.     54      1   AVAILABLE   +FRA/orcl/autobackup/2017_09_16/s_954880542.261.954880543

  184.   Backup Set Copy #2 of backup set 52
  185.   Device Type Elapsed Time Completion Time Compressed Tag
  186.   ----------- ------------ --------------- ---------- ---
  187.   SBT_TAPE    00:00:00     17-SEP-17       NO         TAG20170916T203542

  189.     List of Backup Pieces for backup set 52 Copy #2
  190.     BP Key  Pc# Status      Media                   Piece Name
  191.     ------- --- ----------- ----------------------- ----------
  192.     69      1   AVAILABLE   station90-000003        c-1343950367-20170916-00

  194. BS Key  Size       Device Type Elapsed Time Completion Time
  195. ------- ---------- ----------- ------------ ---------------
  196. 53      33.75M     SBT_TAPE    00:00:24     16-SEP-17      
  197.         BP Key: 55   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T203555
  198.         Handle: 1qsekkhc_1_1   Media: station90-000003

  200.   List of Archived Logs in backup set 53
  201.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  202.   ---- ------- ---------- --------- ---------- ---------
  203.   1    37      1155635    15-SEP-17 1161457    16-SEP-17
  204.   1    38      1161457    16-SEP-17 1164170    16-SEP-17

  206. BS Key  Size       Device Type Elapsed Time Completion Time
  207. ------- ---------- ----------- ------------ ---------------
  208. 54      11.00M     SBT_TAPE    00:00:26     16-SEP-17      
  209.         BP Key: 56   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T203555
  210.         Handle: 1rsekkhc_1_1   Media: station90-000004

  212.   List of Archived Logs in backup set 54
  213.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  214.   ---- ------- ---------- --------- ---------- ---------
  215.   1    39      1164170    16-SEP-17 1165906    16-SEP-17

  217. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  218. ------- ---- -- ---------- ----------- ------------ ---------------
  219. 55      Full    9.50M      SBT_TAPE    00:00:16     16-SEP-17      
  220.         BP Key: 57   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T203631
  221.         Handle: c-1343950367-20170916-01   Media: station90-000003
  222.   SPFILE Included: Modification time: 13-SEP-17
  223.   SPFILE db_unique_name: ORCL
  224.   Control File Included: Ckp SCN: 1165981      Ckp time: 16-SEP-17

  226. BS Key  Type LV Size
  227. ------- ---- -- ----------
  228. 56      Incr 1  36.98M
  229.   List of Datafiles in backup set 56
  230.   File LV Type Ckp SCN    Ckp Time  Name
  231.   ---- -- ---- ---------- --------- ----
  232.   1    1  Incr 1173934    17-SEP-17 +DATA/orcl/datafile/system.256.816169553
  233.   2    1  Incr 1173934    17-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
  234.   3    1  Incr 1173934    17-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
  235.   4    1  Incr 1173934    17-SEP-17 +DATA/orcl/datafile/users.259.816169553
  236.   5    1  Incr 1173934    17-SEP-17 +DATA/orcl/datafile/example.265.816169651

  238.   Backup Set Copy #1 of backup set 56
  239.   Device Type Elapsed Time Completion Time Compressed Tag
  240.   ----------- ------------ --------------- ---------- ---
  241.   DISK        00:00:04     17-SEP-17       NO         ORA_OEM_LEVEL_0

  243.     List of Backup Pieces for backup set 56 Copy #1
  244.     BP Key  Pc# Status      Piece Name
  245.     ------- --- ----------- ----------
  246.     58      1   AVAILABLE   +FRA/orcl/backupset/2017_09_17/nnndn1_ora_oem_level_0_0.278.954966931

  248.   Backup Set Copy #2 of backup set 56
  249.   Device Type Elapsed Time Completion Time Compressed Tag
  250.   ----------- ------------ --------------- ---------- ---
  251.   SBT_TAPE    00:00:04     17-SEP-17       NO         ORA_OEM_LEVEL_0

  253.     List of Backup Pieces for backup set 56 Copy #2
  254.     BP Key  Pc# Status      Media                   Piece Name
  255.     ------- --- ----------- ----------------------- ----------
  256.     68      1   AVAILABLE   station90-000004        1tsen8sf_1_2

  258. BS Key  Type LV Size
  259. ------- ---- -- ----------
  260. 57      Full    9.36M
  261.   SPFILE Included: Modification time: 13-SEP-17
  262.   SPFILE db_unique_name: ORCL
  263.   Control File Included: Ckp SCN: 1173943      Ckp time: 17-SEP-17

  265.   Backup Set Copy #1 of backup set 57
  266.   Device Type Elapsed Time Completion Time Compressed Tag
  267.   ----------- ------------ --------------- ---------- ---
  268.   DISK        00:00:01     17-SEP-17       NO         TAG20170917T203534

  270.     List of Backup Pieces for backup set 57 Copy #1
  271.     BP Key  Pc# Status      Piece Name
  272.     ------- --- ----------- ----------
  273.     59      1   AVAILABLE   +FRA/orcl/autobackup/2017_09_17/s_954966934.279.954966935

  275.   Backup Set Copy #2 of backup set 57
  276.   Device Type Elapsed Time Completion Time Compressed Tag
  277.   ----------- ------------ --------------- ---------- ---
  278.   SBT_TAPE    00:00:01     17-SEP-17       NO         TAG20170917T203534

  280.     List of Backup Pieces for backup set 57 Copy #2
  281.     BP Key  Pc# Status      Media                   Piece Name
  282.     ------- --- ----------- ----------------------- ----------
  283.     70      1   AVAILABLE   station90-000004        c-1343950367-20170917-00

  285. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  286. ------- ---- -- ---------- ----------- ------------ ---------------
  287. 58      Full    536.00M    SBT_TAPE    00:00:29     17-SEP-17      
  288.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T203547
  289.         Handle: 1vsen8t4_1_1   Media: station90-000003
  290.   List of Datafiles in backup set 58
  291.   File LV Type Ckp SCN    Ckp Time  Name
  292.   ---- -- ---- ---------- --------- ----
  293.   2       Full 1165770    16-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
  294.   3       Full 1165770    16-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
  295.   5       Full 1165770    16-SEP-17 +DATA/orcl/datafile/example.265.816169651

  297. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  298. ------- ---- -- ---------- ----------- ------------ ---------------
  299. 59      Full    597.00M    SBT_TAPE    00:00:32     17-SEP-17      
  300.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T203547
  301.         Handle: 20sen8t4_1_1   Media: station90-000004
  302.   List of Datafiles in backup set 59
  303.   File LV Type Ckp SCN    Ckp Time  Name
  304.   ---- -- ---- ---------- --------- ----
  305.   1       Full 1165770    16-SEP-17 +DATA/orcl/datafile/system.256.816169553
  306.   4       Full 1165770    16-SEP-17 +DATA/orcl/datafile/users.259.816169553

  308. BS Key  Size       Device Type Elapsed Time Completion Time
  309. ------- ---------- ----------- ------------ ---------------
  310. 60      16.75M     SBT_TAPE    00:00:16     17-SEP-17      
  311.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T203547
  312.         Handle: 21sen8u7_1_1   Media: station90-000003

  314.   List of Archived Logs in backup set 60
  315.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  316.   ---- ------- ---------- --------- ---------- ---------
  317.   1    40      1165906    16-SEP-17 1171926    17-SEP-17

  319. BS Key  Size       Device Type Elapsed Time Completion Time
  320. ------- ---------- ----------- ------------ ---------------
  321. 61      15.50M     SBT_TAPE    00:00:16     17-SEP-17      
  322.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T203547
  323.         Handle: 22sen8u7_1_1   Media: station90-000004

  325.   List of Archived Logs in backup set 61
  326.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  327.   ---- ------- ---------- --------- ---------- ---------
  328.   1    41      1171926    17-SEP-17 1173817    17-SEP-17

  330. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  331. ------- ---- -- ---------- ----------- ------------ ---------------
  332. 62      Full    9.50M      SBT_TAPE    00:00:16     17-SEP-17      
  333.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T203831
  334.         Handle: c-1343950367-20170917-01   Media: station90-000004
  335.   SPFILE Included: Modification time: 13-SEP-17
  336.   SPFILE db_unique_name: ORCL
  337.   Control File Included: Ckp SCN: 1174323      Ckp time: 17-SEP-17

  339. RMAN>
复制代码
  1. RMAN> list copy;

  3. using target database control file instead of recovery catalog
  4. specification does not match any control file copy in the repository
  5. List of Datafile Copies
  6. =======================

  8. Key     File S Completion Time Ckp SCN    Ckp Time      
  9. ------- ---- - --------------- ---------- ---------------
  10. 17      1    A 17-SEP-17       1165770    16-SEP-17      
  11.         Name: +FRA/orcl/datafile/system.276.954707725
  12.         Tag: ORA_OEM_LEVEL_0

  14. 18      2    A 17-SEP-17       1165770    16-SEP-17      
  15.         Name: +FRA/orcl/datafile/sysaux.274.954707731
  16.         Tag: ORA_OEM_LEVEL_0

  18. 16      3    A 17-SEP-17       1165770    16-SEP-17      
  19.         Name: +FRA/orcl/datafile/undotbs1.273.954707739
  20.         Tag: ORA_OEM_LEVEL_0

  22. 15      4    A 17-SEP-17       1165770    16-SEP-17      
  23.         Name: +FRA/orcl/datafile/users.271.954707741
  24.         Tag: ORA_OEM_LEVEL_0

  26. 14      5    A 17-SEP-17       1165770    16-SEP-17      
  27.         Name: +FRA/orcl/datafile/example.272.954707739
  28.         Tag: ORA_OEM_LEVEL_0

  30. List of Archived Log Copies for database with db_unique_name ORCL
  31. =====================================================================

  33. Key     Thrd Seq     S Low Time
  34. ------- ---- ------- - ---------
  35. 27      1    35      A 14-SEP-17
  36.         Name: +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755

  38. 28      1    36      A 14-SEP-17
  39.         Name: +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145

  41. 29      1    37      A 15-SEP-17
  42.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_37.265.954880359

  44. 30      1    38      A 16-SEP-17
  45.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_38.264.954880389

  47. 31      1    39      A 16-SEP-17
  48.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_39.262.954880555

  50. 32      1    40      A 16-SEP-17
  51.         Name: +FRA/orcl/archivelog/2017_09_17/thread_1_seq_40.275.954966747

  53. 33      1    41      A 17-SEP-17
  54.         Name: +FRA/orcl/archivelog/2017_09_17/thread_1_seq_41.277.954966917


  57. RMAN>
复制代码






回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-27 06:50 , Processed in 0.037292 second(s), 24 queries .

快速回复 返回顶部 返回列表