开启辅助访问

Bo's Oracle Station

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

课程第26次（2017-05-09星期二）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-5-10 09:39:33 | 显示全部楼层 |阅读模式
上完1Z0-053第2章
1Z0-052共19章（上完12章），1Z0-053共21章（上完6章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的18章


  3. Report of files that must be backed up to satisfy 1 days recovery window
  4. File Days  Name
  5. ---- ----- -----------------------------------------------------

  7. RMAN> report need backup;

  9. RMAN retention policy will be applied to the command
  10. RMAN retention policy is set to recovery window of 1 days
  11. Report of files that must be backed up to satisfy 1 days recovery window
  12. File Days  Name
  13. ---- ----- -----------------------------------------------------
  14. 1    2     +DATA/orcl/datafile/system.256.832197063
  15. 2    2     +DATA/orcl/datafile/sysaux.257.832197065
  16. 3    2     +DATA/orcl/datafile/undotbs1.258.832197065
  17. 4    2     +DATA/orcl/datafile/users.259.832197065
  18. 5    2     +DATA/orcl/datafile/example.265.832197353
  19. 6    2     +DATA/orcl/datafile/undotbs2.267.939552631

  21. RMAN> report need backup;

  23. RMAN retention policy will be applied to the command
  24. RMAN retention policy is set to recovery window of 1 days
  25. Report of files that must be backed up to satisfy 1 days recovery window
  26. File Days  Name
  27. ---- ----- -----------------------------------------------------
  28. 1    2     +DATA/orcl/datafile/system.256.832197063
  29. 2    2     +DATA/orcl/datafile/sysaux.257.832197065
  30. 3    2     +DATA/orcl/datafile/undotbs1.258.832197065
  31. 4    2     +DATA/orcl/datafile/users.259.832197065
  32. 5    2     +DATA/orcl/datafile/example.265.832197353
  33. 6    2     +DATA/orcl/datafile/undotbs2.267.939552631

  35. RMAN> backup '3rd DAY' database ;

  37. RMAN-00571: ===========================================================
  38. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  39. RMAN-00571: ===========================================================
  40. RMAN-00558: error encountered while parsing input commands
  41. RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "archivelog, as, auxiliary, backupset, backup, channel, check, controlfilecopy, copies, copy, cumulative, current, database, datafilecopy, datafile, db_file_name_convert, db_recovery_file_dest, device, diskratio, duration, filesperset, force, format, for, from, full, incremental, keep, maxsetsize, nochecksum, noexclude, nokeep, not, pool, proxy, recovery, reuse, section, skip readonly, skip, spfile, tablespace, tag, to, validate, ("
  42. RMAN-01007: at line 1 column 8 file: standard input

  44. RMAN> backup tag '3rd DAY' database ;

  46. Starting backup at 2017-05-12:00:02:38
  47. allocated channel: ORA_SBT_TAPE_1
  48. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
  49. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  50. allocated channel: ORA_SBT_TAPE_2
  51. channel ORA_SBT_TAPE_2: SID=139 device type=SBT_TAPE
  52. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  53. channel ORA_SBT_TAPE_1: starting full datafile backup set
  54. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  55. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  56. input datafile file number=00006 name=+DATA/orcl/datafile/undotbs2.267.939552631
  57. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065
  58. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-05-12:00:02:53
  59. channel ORA_SBT_TAPE_2: starting full datafile backup set
  60. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  61. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  62. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  63. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.832197065
  64. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-05-12:00:02:58
  65. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-05-12:00:04:45
  66. piece handle=22s40s9d_1_1 tag=3RD DAY comment=API Version 2.0,MMS Version 10.3.0.2
  67. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:52
  68. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-05-12:00:04:55
  69. piece handle=23s40s9d_1_1 tag=3RD DAY comment=API Version 2.0,MMS Version 10.3.0.2
  70. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:57
  71. Finished backup at 2017-05-12:00:04:55

  73. Starting Control File and SPFILE Autobackup at 2017-05-12:00:04:55
  74. piece handle=c-1359978017-20170512-00 comment=API Version 2.0,MMS Version 10.3.0.2
  75. Finished Control File and SPFILE Autobackup at 2017-05-12:00:05:50

  77. RMAN> backup tag '4th' database ;

  79. Starting backup at 2017-05-12:00:06:05
  80. using channel ORA_SBT_TAPE_1
  81. using channel ORA_SBT_TAPE_2
  82. skipping datafile 4; already backed up 1 time(s)
  83. channel ORA_SBT_TAPE_1: starting full datafile backup set
  84. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  85. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  86. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065
  87. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-05-12:00:06:06
  88. channel ORA_SBT_TAPE_2: starting full datafile backup set
  89. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  90. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  91. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  92. input datafile file number=00006 name=+DATA/orcl/datafile/undotbs2.267.939552631
  93. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-05-12:00:06:06
  94. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-05-12:00:07:51
  95. piece handle=25s40sfd_1_1 tag=4TH comment=API Version 2.0,MMS Version 10.3.0.2
  96. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:45
  97. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-05-12:00:07:51
  98. piece handle=26s40sfe_1_1 tag=4TH comment=API Version 2.0,MMS Version 10.3.0.2
  99. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:45
  100. Finished backup at 2017-05-12:00:07:51

  102. Starting Control File and SPFILE Autobackup at 2017-05-12:00:07:51
  103. piece handle=c-1359978017-20170512-01 comment=API Version 2.0,MMS Version 10.3.0.2
  104. Finished Control File and SPFILE Autobackup at 2017-05-12:00:08:56

  106. RMAN> report obsolete;

  108. RMAN retention policy will be applied to the command
  109. RMAN retention policy is set to recovery window of 1 days
  110. Report of obsolete backups and copies
  111. Type                 Key    Completion Time    Filename/Handle
  112. -------------------- ------ ------------------ --------------------
  113. Backup Set           48     2017-05-09:21:04:38
  114.   Backup Piece       68     2017-05-09:21:04:38 1ss3r8vt_1_1
  115. Backup Set           49     2017-05-09:21:04:50
  116.   Backup Piece       69     2017-05-09:21:04:50 1ts3r8vt_1_1
  117. Backup Set           50     2017-05-09:21:05:45
  118.   Backup Piece       70     2017-05-09:21:05:45 c-1359978017-20170509-02

  120. RMAN> report obsolete recvoery window of 2 days   ;

  122. RMAN-00571: ===========================================================
  123. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  124. RMAN-00571: ===========================================================
  125. RMAN-00558: error encountered while parsing input commands
  126. RMAN-01009: syntax error: found "identifier": expecting one of: "device, high, recovery, redundancy, to restore point, until restore point, until, ;"
  127. RMAN-01008: the bad identifier was: recvoery
  128. RMAN-01007: at line 1 column 17 file: standard input

  130. RMAN> report obsolete recovery window of 2 days   ;

  132. no obsolete backups found

  134. RMAN> report obsolete redundancy 1   ;

  136. Report of obsolete backups and copies
  137. Type                 Key    Completion Time    Filename/Handle
  138. -------------------- ------ ------------------ --------------------
  139. Backup Set           48     2017-05-09:21:04:38
  140.   Backup Piece       68     2017-05-09:21:04:38 1ss3r8vt_1_1
  141. Backup Set           49     2017-05-09:21:04:50
  142.   Backup Piece       69     2017-05-09:21:04:50 1ts3r8vt_1_1
  143. Backup Set           50     2017-05-09:21:05:45
  144.   Backup Piece       70     2017-05-09:21:05:45 c-1359978017-20170509-02
  145. Backup Set           51     2017-05-10:21:09:57
  146.   Backup Piece       71     2017-05-10:21:09:57 1vs3ttlq_1_1
  147. Backup Set           52     2017-05-10:21:10:00
  148.   Backup Piece       72     2017-05-10:21:10:00 20s3ttlq_1_1
  149. Archive Log          35     2017-05-11:21:03:02 +FRA/orcl/archivelog/2017_05_11/thread_1_seq_40.293.943736581
  150. Backup Set           53     2017-05-10:21:10:54
  151.   Backup Piece       73     2017-05-10:21:10:54 c-1359978017-20170510-00
  152. Backup Set           54     2017-05-12:00:04:44
  153.   Backup Piece       74     2017-05-12:00:04:44 22s40s9d_1_1
  154. Backup Set           56     2017-05-12:00:05:43
  155.   Backup Piece       76     2017-05-12:00:05:43 c-1359978017-20170512-00

  157. RMAN> report obsolete redundancy 2  ;

  159. Report of obsolete backups and copies
  160. Type                 Key    Completion Time    Filename/Handle
  161. -------------------- ------ ------------------ --------------------
  162. Backup Set           48     2017-05-09:21:04:38
  163.   Backup Piece       68     2017-05-09:21:04:38 1ss3r8vt_1_1
  164. Backup Set           49     2017-05-09:21:04:50
  165.   Backup Piece       69     2017-05-09:21:04:50 1ts3r8vt_1_1
  166. Backup Set           50     2017-05-09:21:05:45
  167.   Backup Piece       70     2017-05-09:21:05:45 c-1359978017-20170509-02
  168. Backup Set           51     2017-05-10:21:09:57
  169.   Backup Piece       71     2017-05-10:21:09:57 1vs3ttlq_1_1
  170. Backup Set           53     2017-05-10:21:10:54
  171.   Backup Piece       73     2017-05-10:21:10:54 c-1359978017-20170510-00

  173. RMAN> report obsolete redundancy 3  ;

  175. Report of obsolete backups and copies
  176. Type                 Key    Completion Time    Filename/Handle
  177. -------------------- ------ ------------------ --------------------
  178. Backup Set           48     2017-05-09:21:04:38
  179.   Backup Piece       68     2017-05-09:21:04:38 1ss3r8vt_1_1
  180. Backup Set           50     2017-05-09:21:05:45
  181.   Backup Piece       70     2017-05-09:21:05:45 c-1359978017-20170509-02

  183. RMAN> report obsolete   ;

  185. RMAN retention policy will be applied to the command
  186. RMAN retention policy is set to recovery window of 1 days
  187. Report of obsolete backups and copies
  188. Type                 Key    Completion Time    Filename/Handle
  189. -------------------- ------ ------------------ --------------------
  190. Backup Set           48     2017-05-09:21:04:38
  191.   Backup Piece       68     2017-05-09:21:04:38 1ss3r8vt_1_1
  192. Backup Set           49     2017-05-09:21:04:50
  193.   Backup Piece       69     2017-05-09:21:04:50 1ts3r8vt_1_1
  194. Backup Set           50     2017-05-09:21:05:45
  195.   Backup Piece       70     2017-05-09:21:05:45 c-1359978017-20170509-02

  197. RMAN> delete noprompt obsolete;

  199. RMAN retention policy will be applied to the command
  200. RMAN retention policy is set to recovery window of 1 days
  201. allocated channel: ORA_DISK_1
  202. channel ORA_DISK_1: SID=16 device type=DISK
  203. allocated channel: ORA_DISK_2
  204. channel ORA_DISK_2: SID=70 device type=DISK
  205. allocated channel: ORA_DISK_3
  206. channel ORA_DISK_3: SID=137 device type=DISK
  207. allocated channel: ORA_DISK_4
  208. channel ORA_DISK_4: SID=11 device type=DISK
  209. allocated channel: ORA_DISK_5
  210. channel ORA_DISK_5: SID=68 device type=DISK
  211. allocated channel: ORA_DISK_6
  212. channel ORA_DISK_6: SID=138 device type=DISK
  213. allocated channel: ORA_DISK_7
  214. channel ORA_DISK_7: SID=192 device type=DISK
  215. allocated channel: ORA_DISK_8
  216. channel ORA_DISK_8: SID=12 device type=DISK
  217. using channel ORA_SBT_TAPE_1
  218. using channel ORA_SBT_TAPE_2
  219. Deleting the following obsolete backups and copies:
  220. Type                 Key    Completion Time    Filename/Handle
  221. -------------------- ------ ------------------ --------------------
  222. Backup Set           48     2017-05-09:21:04:38
  223.   Backup Piece       68     2017-05-09:21:04:38 1ss3r8vt_1_1
  224. Backup Set           49     2017-05-09:21:04:50
  225.   Backup Piece       69     2017-05-09:21:04:50 1ts3r8vt_1_1
  226. Backup Set           50     2017-05-09:21:05:45
  227.   Backup Piece       70     2017-05-09:21:05:45 c-1359978017-20170509-02
  228. deleted backup piece
  229. backup piece handle=1ss3r8vt_1_1 RECID=68 STAMP=943563773
  230. deleted backup piece
  231. backup piece handle=1ts3r8vt_1_1 RECID=69 STAMP=943563778
  232. deleted backup piece
  233. backup piece handle=c-1359978017-20170509-02 RECID=70 STAMP=943563898
  234. Deleted 3 objects


  237. RMAN> exit


  240. Recovery Manager complete.
  241. [oracle@station2 ~]$ rman target /      

  243. Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 12 00:12:00 2017

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

  247. connected to target database: ORCL (DBID=1359978017)

  249. RMAN> exit


  252. Recovery Manager complete.
  253. [oracle@station2 ~]$ rman target /

  255. Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 12 23:50:05 2017

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

  259. connected to target database: ORCL (DBID=1359978017)

  261. RMAN> backup tag '5th' database ;

  263. Starting backup at 2017-05-12:23:50:16
  264. using target database control file instead of recovery catalog
  265. allocated channel: ORA_SBT_TAPE_1
  266. channel ORA_SBT_TAPE_1: SID=139 device type=SBT_TAPE
  267. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  268. allocated channel: ORA_SBT_TAPE_2
  269. channel ORA_SBT_TAPE_2: SID=138 device type=SBT_TAPE
  270. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  271. skipping datafile 4; already backed up 1 time(s)
  272. channel ORA_SBT_TAPE_1: starting full datafile backup set
  273. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  274. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  275. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065
  276. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-05-12:23:50:33
  277. channel ORA_SBT_TAPE_2: starting full datafile backup set
  278. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  279. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  280. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  281. input datafile file number=00006 name=+DATA/orcl/datafile/undotbs2.267.939552631
  282. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-05-12:23:50:33
  283. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-05-12:23:51:59
  284. piece handle=29s43fu9_1_1 tag=5TH comment=API Version 2.0,MMS Version 10.3.0.2
  285. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:26
  286. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-05-12:23:52:59
  287. piece handle=28s43fu9_1_1 tag=5TH comment=API Version 2.0,MMS Version 10.3.0.2
  288. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:26
  289. Finished backup at 2017-05-12:23:52:59

  291. Starting Control File and SPFILE Autobackup at 2017-05-12:23:52:59
  292. piece handle=c-1359978017-20170512-02 comment=API Version 2.0,MMS Version 10.3.0.2
  293. Finished Control File and SPFILE Autobackup at 2017-05-12:23:53:54

  295. RMAN> run {
  296. 2> allocate channel c1 device type disk format '/home/oracle/backup/%U';
  297. 3> backup tablespace example;
  298. 4> }

  300. released channel: ORA_SBT_TAPE_1
  301. released channel: ORA_SBT_TAPE_2
  302. allocated channel: c1
  303. channel c1: SID=139 device type=DISK

  305. Starting backup at 2017-05-12:23:57:08
  306. channel c1: starting full datafile backup set
  307. channel c1: specifying datafile(s) in backup set
  308. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  309. channel c1: starting piece 1 at 2017-05-12:23:57:08
  310. channel c1: finished piece 1 at 2017-05-12:23:57:15
  311. piece handle=/home/oracle/backup/2bs43gak_1_1 tag=TAG20170512T235708 comment=NONE
  312. channel c1: backup set complete, elapsed time: 00:00:07
  313. Finished backup at 2017-05-12:23:57:15

  315. Starting Control File and SPFILE Autobackup at 2017-05-12:23:57:15
  316. piece handle=+FRA/orcl/autobackup/2017_05_12/s_943833435.287.943833437 comment=NONE
  317. Finished Control File and SPFILE Autobackup at 2017-05-12:23:57:18
  318. released channel: c1

  320. RMAN> list backup of tablespace example;


  323. List of Backup Sets
  324. ===================


  327. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  328. ------- ---- -- ---------- ----------- ------------ -------------------
  329. 52      Full    496.25M    SBT_TAPE    00:01:50     2017-05-10:21:10:00
  330.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: 2ND DAY
  331.         Handle: 20s3ttlq_1_1   Media: station2-000006
  332.   List of Datafiles in backup set 52
  333.   File LV Type Ckp SCN    Ckp Time            Name
  334.   ---- -- ---- ---------- ------------------- ----
  335.   5       Full 1325932    2017-05-10:21:08:10 +DATA/orcl/datafile/example.265.832197353

  337. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  338. ------- ---- -- ---------- ----------- ------------ -------------------
  339. 55      Full    499.00M    SBT_TAPE    00:01:58     2017-05-12:00:04:51
  340.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: 3RD DAY
  341.         Handle: 23s40s9d_1_1   Media: station2-000006
  342.   List of Datafiles in backup set 55
  343.   File LV Type Ckp SCN    Ckp Time            Name
  344.   ---- -- ---- ---------- ------------------- ----
  345.   5       Full 1339326    2017-05-12:00:02:59 +DATA/orcl/datafile/example.265.832197353

  347. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  348. ------- ---- -- ---------- ----------- ------------ -------------------
  349. 58      Full    495.75M    SBT_TAPE    00:01:39     2017-05-12:00:07:45
  350.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: 4TH
  351.         Handle: 26s40sfe_1_1   Media: station2-000005
  352.   List of Datafiles in backup set 58
  353.   File LV Type Ckp SCN    Ckp Time            Name
  354.   ---- -- ---- ---------- ------------------- ----
  355.   5       Full 1339447    2017-05-12:00:06:06 +DATA/orcl/datafile/example.265.832197353

  357. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  358. ------- ---- -- ---------- ----------- ------------ -------------------
  359. 60      Full    495.75M    SBT_TAPE    00:01:24     2017-05-12:23:51:57
  360.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 5TH
  361.         Handle: 29s43fu9_1_1   Media: station2-000006
  362.   List of Datafiles in backup set 60
  363.   File LV Type Ckp SCN    Ckp Time            Name
  364.   ---- -- ---- ---------- ------------------- ----
  365.   5       Full 1340293    2017-05-12:23:50:33 +DATA/orcl/datafile/example.265.832197353

  367. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  368. ------- ---- -- ---------- ----------- ------------ -------------------
  369. 63      Full    69.57M     DISK        00:00:04     2017-05-12:23:57:12
  370.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20170512T235708
  371.         Piece Name: /home/oracle/backup/2bs43gak_1_1
  372.   List of Datafiles in backup set 63
  373.   File LV Type Ckp SCN    Ckp Time            Name
  374.   ---- -- ---- ---------- ------------------- ----
  375.   5       Full 1340640    2017-05-12:23:57:08 +DATA/orcl/datafile/example.265.832197353

  377. RMAN> backup backupset 63;

  379. Starting backup at 2017-05-12:23:58:20
  380. allocated channel: ORA_SBT_TAPE_1
  381. channel ORA_SBT_TAPE_1: SID=139 device type=SBT_TAPE
  382. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  383. allocated channel: ORA_SBT_TAPE_2
  384. channel ORA_SBT_TAPE_2: SID=138 device type=SBT_TAPE
  385. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  386. skipping backup set key 63; already backed up 1 time(s)
  387. Finished backup at 2017-05-12:23:58:37

  389. RMAN> backup backupset 63 force ;

  391. Starting backup at 2017-05-12:23:59:01
  392. using channel ORA_SBT_TAPE_1
  393. using channel ORA_SBT_TAPE_2
  394. channel ORA_SBT_TAPE_1: input backup set: count=75, stamp=943833428, piece=1
  395. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-05-12:23:59:03
  396. channel ORA_SBT_TAPE_1: backup piece /home/oracle/backup/2bs43gak_1_1
  397. piece handle=2bs43gak_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  398. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-05-13:00:00:18
  399. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:01:16
  400. Finished backup at 2017-05-13:00:00:18

  402. Starting Control File and SPFILE Autobackup at 2017-05-13:00:00:18
  403. piece handle=c-1359978017-20170513-00 comment=API Version 2.0,MMS Version 10.3.0.2
  404. Finished Control File and SPFILE Autobackup at 2017-05-13:00:01:13

  406. RMAN> list backup of tablespace example;


  409. List of Backup Sets
  410. ===================


  413. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  414. ------- ---- -- ---------- ----------- ------------ -------------------
  415. 52      Full    496.25M    SBT_TAPE    00:01:50     2017-05-10:21:10:00
  416.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: 2ND DAY
  417.         Handle: 20s3ttlq_1_1   Media: station2-000006
  418.   List of Datafiles in backup set 52
  419.   File LV Type Ckp SCN    Ckp Time            Name
  420.   ---- -- ---- ---------- ------------------- ----
  421.   5       Full 1325932    2017-05-10:21:08:10 +DATA/orcl/datafile/example.265.832197353

  423. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  424. ------- ---- -- ---------- ----------- ------------ -------------------
  425. 55      Full    499.00M    SBT_TAPE    00:01:58     2017-05-12:00:04:51
  426.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: 3RD DAY
  427.         Handle: 23s40s9d_1_1   Media: station2-000006
  428.   List of Datafiles in backup set 55
  429.   File LV Type Ckp SCN    Ckp Time            Name
  430.   ---- -- ---- ---------- ------------------- ----
  431.   5       Full 1339326    2017-05-12:00:02:59 +DATA/orcl/datafile/example.265.832197353

  433. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  434. ------- ---- -- ---------- ----------- ------------ -------------------
  435. 58      Full    495.75M    SBT_TAPE    00:01:39     2017-05-12:00:07:45
  436.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: 4TH
  437.         Handle: 26s40sfe_1_1   Media: station2-000005
  438.   List of Datafiles in backup set 58
  439.   File LV Type Ckp SCN    Ckp Time            Name
  440.   ---- -- ---- ---------- ------------------- ----
  441.   5       Full 1339447    2017-05-12:00:06:06 +DATA/orcl/datafile/example.265.832197353

  443. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  444. ------- ---- -- ---------- ----------- ------------ -------------------
  445. 60      Full    495.75M    SBT_TAPE    00:01:24     2017-05-12:23:51:57
  446.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 5TH
  447.         Handle: 29s43fu9_1_1   Media: station2-000006
  448.   List of Datafiles in backup set 60
  449.   File LV Type Ckp SCN    Ckp Time            Name
  450.   ---- -- ---- ---------- ------------------- ----
  451.   5       Full 1340293    2017-05-12:23:50:33 +DATA/orcl/datafile/example.265.832197353

  453. BS Key  Type LV Size
  454. ------- ---- -- ----------
  455. 63      Full    69.57M
  456.   List of Datafiles in backup set 63
  457.   File LV Type Ckp SCN    Ckp Time            Name
  458.   ---- -- ---- ---------- ------------------- ----
  459.   5       Full 1340640    2017-05-12:23:57:08 +DATA/orcl/datafile/example.265.832197353

  461.   Backup Set Copy #1 of backup set 63
  462.   Device Type Elapsed Time Completion Time     Compressed Tag
  463.   ----------- ------------ ------------------- ---------- ---
  464.   DISK        00:00:04     2017-05-12:23:57:11 NO         TAG20170512T235708

  466.     List of Backup Pieces for backup set 63 Copy #1
  467.     BP Key  Pc# Status      Piece Name
  468.     ------- --- ----------- ----------
  469.     83      1   AVAILABLE   /home/oracle/backup/2bs43gak_1_1

  471.   Backup Set Copy #2 of backup set 63
  472.   Device Type Elapsed Time Completion Time     Compressed Tag
  473.   ----------- ------------ ------------------- ---------- ---
  474.   SBT_TAPE    00:00:04     2017-05-13:00:00:08 NO         TAG20170512T235708

  476.     List of Backup Pieces for backup set 63 Copy #2
  477.     BP Key  Pc# Status      Media                   Piece Name
  478.     ------- --- ----------- ----------------------- ----------
  479.     85      1   AVAILABLE   station2-000005         2bs43gak_1_2

  481. RMAN> backup tag '6th' database ;      

  483. Starting backup at 2017-05-13:00:02:17
  484. using channel ORA_SBT_TAPE_1
  485. using channel ORA_SBT_TAPE_2
  486. channel ORA_SBT_TAPE_1: starting full datafile backup set
  487. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  488. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063
  489. input datafile file number=00006 name=+DATA/orcl/datafile/undotbs2.267.939552631
  490. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065
  491. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-05-13:00:02:18
  492. channel ORA_SBT_TAPE_2: starting full datafile backup set
  493. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  494. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
  495. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353
  496. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.832197065
  497. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-05-13:00:02:23
  498. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-05-13:00:04:13
  499. piece handle=2es43gka_1_1 tag=6TH comment=API Version 2.0,MMS Version 10.3.0.2
  500. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:55
  501. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-05-13:00:04:13
  502. piece handle=2fs43gka_1_1 tag=6TH comment=API Version 2.0,MMS Version 10.3.0.2
  503. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:50
  504. Finished backup at 2017-05-13:00:04:13

  506. Starting Control File and SPFILE Autobackup at 2017-05-13:00:04:13











复制代码




回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-25 06:27 , Processed in 0.047504 second(s), 24 queries .

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