开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 其他 › 数据库所有实验共同问题 › TSPIR的实验
返回列表 发新帖
查看: 1214|回复: 0

TSPIR的实验

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2020-11-24 20:21:27 | 显示全部楼层 |阅读模式
1.进行自包含集检查：
  1. begin
  2.   dbms_tts.transport_set_check('USERS');
  3. end;
  4. /

  6. select  * from transport_set_violations;

  8. alter table aud$ move tablespace system;
复制代码
2. 确定一下有没有0级的全库备份：
  1. [oracle@classroom ~]$ rman target /

  3. Recovery Manager: Release 12.1.0.2.0 - Production on 星期二 11月 24 20:17:19 2020

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

  7. connected to target database: ORCL (DBID=1574592120)

  9. RMAN> list copy;

  11. using target database control file instead of recovery catalog
  12. specification does not match any control file copy in the repository
  13. List of Datafile Copies
  14. =======================

  16. Key     File S Completion Time     Ckp SCN    Ckp Time           
  17. ------- ---- - ------------------- ---------- -------------------
  18. 55      1    A 2020-11-15:16:42:38 11939954   2020-11-15:16:42:14
  19.         Name: +FRA/ORCL/DATAFILE/system.422.1056559341
  20.         Tag: ORAOEM_LEVEL_0

  22. 53      2    A 2020-11-15:16:42:35 11939949   2020-11-15:16:42:14
  23.         Name: +FRA/ORCL/DATAFILE/sysaux.394.1056559335
  24.         Tag: ORAOEM_LEVEL_0

  26. 54      3    A 2020-11-15:16:42:35 11939952   2020-11-15:16:42:14
  27.         Name: +FRA/ORCL/DATAFILE/undotbs1.393.1056559337
  28.         Tag: ORAOEM_LEVEL_0

  30. 51      4    A 2020-11-15:16:42:24 11939956   2020-11-15:16:42:14
  31.         Name: +FRA/ORCL/DATAFILE/users.426.1056559339
  32.         Tag: ORAOEM_LEVEL_0

  34. 56      5    A 2020-11-15:16:42:39 11939946   2020-11-15:16:42:13
  35.         Name: +FRA/ORCL/DATAFILE/example.403.1056559335
  36.         Tag: ORAOEM_LEVEL_0

  38. 50      6    A 2020-11-15:16:42:21 11939959   2020-11-15:16:42:14
  39.         Name: +FRA/ORCL/DATAFILE/tbs1.387.1056559339
  40.         Tag: ORAOEM_LEVEL_0

  42. 58      7    A 2020-11-15:16:42:39 11939970   2020-11-15:16:42:25
  43.         Name: +FRA/ORCL/DATAFILE/tbs2.425.1056559359
  44.         Tag: ORAOEM_LEVEL_0

  46. 52      8    A 2020-11-15:16:42:26 11939962   2020-11-15:16:42:15
  47.         Name: +FRA/ORCL/DATAFILE/tbs3.423.1056559345
  48.         Tag: ORAOEM_LEVEL_0

  50. 63      9    A 2020-11-15:16:42:46 11939994   2020-11-15:16:42:44
  51.         Name: +FRA/ORCL/DATAFILE/tbsocp05_test.415.1056559367
  52.         Tag: ORAOEM_LEVEL_0

  54. 49      10   A 2020-11-15:16:42:17 11939958   2020-11-15:16:42:14
  55.         Name: +FRA/ORCL/DATAFILE/tbsuniform.421.1056559337
  56.         Tag: ORAOEM_LEVEL_0

  58. 57      11   A 2020-11-15:16:42:39 11939973   2020-11-15:16:42:26
  59.         Name: +FRA/ORCL/DATAFILE/tbsbig.424.1056559359
  60.         Tag: ORAOEM_LEVEL_0

  62. 59      12   A 2020-11-15:16:42:40 11939977   2020-11-15:16:42:28
  63.         Name: +FRA/ORCL/DATAFILE/tbsuniform.427.1056559361
  64.         Tag: ORAOEM_LEVEL_0

  66. 64      13   A 2020-11-15:16:42:46 11939997   2020-11-15:16:42:45
  67.         Name: +FRA/ORCL/DATAFILE/tbs32k.396.1056559367
  68.         Tag: ORAOEM_LEVEL_0

  70. 60      14   A 2020-11-15:16:42:40 11939980   2020-11-15:16:42:29
  71.         Name: +FRA/ORCL/DATAFILE/tbs_nocompression.408.1056559361
  72.         Tag: ORAOEM_LEVEL_0

  74. 61      15   A 2020-11-15:16:42:45 11939988   2020-11-15:16:42:43
  75.         Name: +FRA/ORCL/DATAFILE/tbs_basic.413.1056559365
  76.         Tag: ORAOEM_LEVEL_0

  78. 62      16   A 2020-11-15:16:42:46 11939991   2020-11-15:16:42:44
  79.         Name: +FRA/ORCL/DATAFILE/tbs_oltp.416.1056559367
  80.         Tag: ORAOEM_LEVEL_0

  82. List of Archived Log Copies for database with db_unique_name ORCL
  83. =====================================================================

  85. Key     Thrd Seq     S Low Time           
  86. ------- ---- ------- - -------------------
  87. 22      1    1       A 2020-11-15:16:29:01
  88.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_15/thread_1_seq_1.412.1056559383

  90. 23      1    2       A 2020-11-15:16:43:03
  91.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_15/thread_1_seq_2.401.1056559807

  93. 24      1    3       A 2020-11-15:16:50:07
  94.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_17/thread_1_seq_3.402.1056743447

  96. 25      1    4       A 2020-11-17:19:50:46
  97.         Name: +FRA/ORCL/ARCHIVELOG/2018_06_22/thread_1_seq_4.397.1056551755

  99. 26      1    5       A 2018-06-22:20:25:39
  100.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_5.428.1057347933

复制代码

  1. run {
  2. allocate channel oem_disk_backup1 type disk ;
  3. allocate channel oem_disk_backup2 type disk ;
  4. allocate channel oem_disk_backup3 type disk ;
  5. allocate channel oem_disk_backup4 type disk ;
  6. allocate channel oem_disk_backup5 type disk ;
  7. allocate channel oem_disk_backup6 type disk ;
  8. allocate channel oem_disk_backup7 type disk ;
  9. allocate channel oem_disk_backup8 type disk ;
  10. recover copy of database with tag 'ORAOEM_LEVEL_0';
  11. backup incremental level 1 copies=1 for recover of copy with tag 'ORAOEM_LEVEL_0' database;
  12. release channel oem_disk_backup1;
  13. release channel oem_disk_backup2;
  14. release channel oem_disk_backup3;
  15. release channel oem_disk_backup4;
  16. release channel oem_disk_backup5;
  17. release channel oem_disk_backup6;
  18. release channel oem_disk_backup7;
  19. release channel oem_disk_backup8;
  20. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%d_%U' parms "ENV=(OB_MEDIA_FAMILY=classroom)";
  21. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%d_%U' parms "ENV=(OB_MEDIA_FAMILY=classroom)";
  22. backup archivelog all not backed up;
  23. }
  24. allocate channel for maintenance device type 'SBT_TAPE' parms "ENV=(OB_MEDIA_FAMILY=classroom)";
  25. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';

复制代码
  1. [oracle@classroom ~]$ rman target  / cmdfile=/home/oracle/day1.rcv

  3. Recovery Manager: Release 12.1.0.2.0 - Production on 星期二 11月 24 20:18:43 2020

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

  7. connected to target database: ORCL (DBID=1574592120)

  9. RMAN> run {
  10. 2> allocate channel oem_disk_backup1 type disk ;
  11. 3> allocate channel oem_disk_backup2 type disk ;
  12. 4> allocate channel oem_disk_backup3 type disk ;
  13. 5> allocate channel oem_disk_backup4 type disk ;
  14. 6> allocate channel oem_disk_backup5 type disk ;
  15. 7> allocate channel oem_disk_backup6 type disk ;
  16. 8> allocate channel oem_disk_backup7 type disk ;
  17. 9> allocate channel oem_disk_backup8 type disk ;
  18. 10> recover copy of database with tag 'ORAOEM_LEVEL_0';
  19. 11> backup incremental level 1 copies=1 for recover of copy with tag 'ORAOEM_LEVEL_0' database;
  20. 12> release channel oem_disk_backup1;
  21. 13> release channel oem_disk_backup2;
  22. 14> release channel oem_disk_backup3;
  23. 15> release channel oem_disk_backup4;
  24. 16> release channel oem_disk_backup5;
  25. 17> release channel oem_disk_backup6;
  26. 18> release channel oem_disk_backup7;
  27. 19> release channel oem_disk_backup8;
  28. 20> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%d_%U' parms "ENV=(OB_MEDIA_FAMILY=classroom)";
  29. 21> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%d_%U' parms "ENV=(OB_MEDIA_FAMILY=classroom)";
  30. 22> backup archivelog all not backed up;
  31. 23> }
  32. 24> allocate channel for maintenance device type 'SBT_TAPE' parms "ENV=(OB_MEDIA_FAMILY=classroom)";
  33. 25> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  34. 26>
  35. 27>
  36. 28>
  37. using target database control file instead of recovery catalog
  38. allocated channel: oem_disk_backup1
  39. channel oem_disk_backup1: SID=372 device type=DISK

  41. allocated channel: oem_disk_backup2
  42. channel oem_disk_backup2: SID=20 device type=DISK

  44. allocated channel: oem_disk_backup3
  45. channel oem_disk_backup3: SID=138 device type=DISK

  47. allocated channel: oem_disk_backup4
  48. channel oem_disk_backup4: SID=255 device type=DISK

  50. allocated channel: oem_disk_backup5
  51. channel oem_disk_backup5: SID=373 device type=DISK

  53. allocated channel: oem_disk_backup6
  54. channel oem_disk_backup6: SID=21 device type=DISK

  56. allocated channel: oem_disk_backup7
  57. channel oem_disk_backup7: SID=139 device type=DISK

  59. allocated channel: oem_disk_backup8
  60. channel oem_disk_backup8: SID=258 device type=DISK

  62. Starting recover at 2020-11-24:20:18:50
  63. channel oem_disk_backup1: starting incremental datafile backup set restore
  64. channel oem_disk_backup1: specifying datafile copies to recover
  65. recovering datafile copy file number=00002 name=+FRA/ORCL/DATAFILE/sysaux.394.1056559335
  66. recovering datafile copy file number=00009 name=+FRA/ORCL/DATAFILE/tbsocp05_test.415.1056559367
  67. channel oem_disk_backup1: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.398.1056559787
  68. channel oem_disk_backup2: starting incremental datafile backup set restore
  69. channel oem_disk_backup2: specifying datafile copies to recover
  70. recovering datafile copy file number=00003 name=+FRA/ORCL/DATAFILE/undotbs1.393.1056559337
  71. recovering datafile copy file number=00016 name=+FRA/ORCL/DATAFILE/tbs_oltp.416.1056559367
  72. channel oem_disk_backup2: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.400.1056559787
  73. channel oem_disk_backup3: starting incremental datafile backup set restore
  74. channel oem_disk_backup3: specifying datafile copies to recover
  75. recovering datafile copy file number=00005 name=+FRA/ORCL/DATAFILE/example.403.1056559335
  76. channel oem_disk_backup3: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.399.1056559787
  77. channel oem_disk_backup4: starting incremental datafile backup set restore
  78. channel oem_disk_backup4: specifying datafile copies to recover
  79. recovering datafile copy file number=00001 name=+FRA/ORCL/DATAFILE/system.422.1056559341
  80. recovering datafile copy file number=00015 name=+FRA/ORCL/DATAFILE/tbs_basic.413.1056559365
  81. channel oem_disk_backup4: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.418.1056559787
  82. channel oem_disk_backup5: starting incremental datafile backup set restore
  83. channel oem_disk_backup5: specifying datafile copies to recover
  84. recovering datafile copy file number=00004 name=+FRA/ORCL/DATAFILE/users.426.1056559339
  85. recovering datafile copy file number=00014 name=+FRA/ORCL/DATAFILE/tbs_nocompression.408.1056559361
  86. channel oem_disk_backup5: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.373.1056559787
  87. channel oem_disk_backup6: starting incremental datafile backup set restore
  88. channel oem_disk_backup6: specifying datafile copies to recover
  89. recovering datafile copy file number=00006 name=+FRA/ORCL/DATAFILE/tbs1.387.1056559339
  90. recovering datafile copy file number=00011 name=+FRA/ORCL/DATAFILE/tbsbig.424.1056559359
  91. channel oem_disk_backup6: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.410.1056559787
  92. channel oem_disk_backup7: starting incremental datafile backup set restore
  93. channel oem_disk_backup7: specifying datafile copies to recover
  94. recovering datafile copy file number=00007 name=+FRA/ORCL/DATAFILE/tbs2.425.1056559359
  95. recovering datafile copy file number=00008 name=+FRA/ORCL/DATAFILE/tbs3.423.1056559345
  96. channel oem_disk_backup7: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.258.1056559787
  97. channel oem_disk_backup8: starting incremental datafile backup set restore
  98. channel oem_disk_backup8: specifying datafile copies to recover
  99. recovering datafile copy file number=00010 name=+FRA/ORCL/DATAFILE/tbsuniform.421.1056559337
  100. recovering datafile copy file number=00012 name=+FRA/ORCL/DATAFILE/tbsuniform.427.1056559361
  101. channel oem_disk_backup8: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.409.1056559787
  102. channel oem_disk_backup1: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.398.1056559787 tag=ORAOEM_LEVEL_0
  103. channel oem_disk_backup1: restored backup piece 1
  104. channel oem_disk_backup1: restore complete, elapsed time: 00:00:01
  105. channel oem_disk_backup1: starting incremental datafile backup set restore
  106. channel oem_disk_backup1: specifying datafile copies to recover
  107. recovering datafile copy file number=00013 name=+FRA/ORCL/DATAFILE/tbs32k.396.1056559367
  108. channel oem_disk_backup1: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.392.1056559791
  109. channel oem_disk_backup2: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.400.1056559787 tag=ORAOEM_LEVEL_0
  110. channel oem_disk_backup2: restored backup piece 1
  111. channel oem_disk_backup2: restore complete, elapsed time: 00:00:02
  112. channel oem_disk_backup3: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.399.1056559787 tag=ORAOEM_LEVEL_0
  113. channel oem_disk_backup3: restored backup piece 1
  114. channel oem_disk_backup3: restore complete, elapsed time: 00:00:02
  115. channel oem_disk_backup4: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.418.1056559787 tag=ORAOEM_LEVEL_0
  116. channel oem_disk_backup4: restored backup piece 1
  117. channel oem_disk_backup4: restore complete, elapsed time: 00:00:02
  118. channel oem_disk_backup5: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.373.1056559787 tag=ORAOEM_LEVEL_0
  119. channel oem_disk_backup5: restored backup piece 1
  120. channel oem_disk_backup5: restore complete, elapsed time: 00:00:02
  121. channel oem_disk_backup1: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.392.1056559791 tag=ORAOEM_LEVEL_0
  122. channel oem_disk_backup1: restored backup piece 1
  123. channel oem_disk_backup1: restore complete, elapsed time: 00:00:01
  124. channel oem_disk_backup6: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.410.1056559787 tag=ORAOEM_LEVEL_0
  125. channel oem_disk_backup6: restored backup piece 1
  126. channel oem_disk_backup6: restore complete, elapsed time: 00:00:03
  127. channel oem_disk_backup7: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.258.1056559787 tag=ORAOEM_LEVEL_0
  128. channel oem_disk_backup7: restored backup piece 1
  129. channel oem_disk_backup7: restore complete, elapsed time: 00:00:02
  130. channel oem_disk_backup8: piece handle=+FRA/ORCL/BACKUPSET/2020_11_15/nnndn1_oraoem_level_0_0.409.1056559787 tag=ORAOEM_LEVEL_0
  131. channel oem_disk_backup8: restored backup piece 1
  132. channel oem_disk_backup8: restore complete, elapsed time: 00:00:02
  133. Finished recover at 2020-11-24:20:18:55

  135. Starting backup at 2020-11-24:20:18:56
  136. channel oem_disk_backup1: starting incremental level 1 datafile backup set
  137. channel oem_disk_backup1: specifying datafile(s) in backup set
  138. input datafile file number=00005 name=+DATA/ORCL/DATAFILE/example.279.1054329825
  139. channel oem_disk_backup1: starting piece 1 at 2020-11-24:20:18:58
  140. channel oem_disk_backup2: starting incremental level 1 datafile backup set
  141. channel oem_disk_backup2: specifying datafile(s) in backup set
  142. input datafile file number=00002 name=+DATA/ORCL/DATAFILE/sysaux.282.1054329823
  143. input datafile file number=00009 name=+DATA/ORCL/DATAFILE/tbsocp05_test.284.1054152837
  144. channel oem_disk_backup2: starting piece 1 at 2020-11-24:20:18:58
  145. channel oem_disk_backup3: starting incremental level 1 datafile backup set
  146. channel oem_disk_backup3: specifying datafile(s) in backup set
  147. input datafile file number=00003 name=+DATA/ORCL/DATAFILE/undotbs1.286.1054329823
  148. input datafile file number=00016 name=+DATA/ORCL/DATAFILE/tbs_oltp.293.1054936567
  149. channel oem_disk_backup3: starting piece 1 at 2020-11-24:20:18:58
  150. channel oem_disk_backup4: starting incremental level 1 datafile backup set
  151. channel oem_disk_backup4: specifying datafile(s) in backup set
  152. input datafile file number=00001 name=+DATA/ORCL/DATAFILE/system.263.1054329825
  153. input datafile file number=00015 name=+DATA/ORCL/DATAFILE/tbs_basic.292.1054936269
  154. channel oem_disk_backup4: starting piece 1 at 2020-11-24:20:18:58
  155. channel oem_disk_backup5: starting incremental level 1 datafile backup set
  156. channel oem_disk_backup5: specifying datafile(s) in backup set
  157. input datafile file number=00004 name=+DATA/orcl/DATAFILE/users.262.1054329889
  158. input datafile file number=00014 name=+DATA/ORCL/DATAFILE/tbs_nocompression.291.1054936255
  159. channel oem_disk_backup5: starting piece 1 at 2020-11-24:20:18:59
  160. channel oem_disk_backup6: starting incremental level 1 datafile backup set
  161. channel oem_disk_backup6: specifying datafile(s) in backup set
  162. input datafile file number=00006 name=+DATA/ORCL/DATAFILE/tbs1.287.1050417229
  163. input datafile file number=00011 name=+DATA/ORCL/DATAFILE/tbsbig.280.1054764585
  164. channel oem_disk_backup6: starting piece 1 at 2020-11-24:20:18:59
  165. channel oem_disk_backup7: starting incremental level 1 datafile backup set
  166. channel oem_disk_backup7: specifying datafile(s) in backup set
  167. input datafile file number=00010 name=+DATA/ORCL/DATAFILE/tbsuniform.278.1054763341
  168. input datafile file number=00012 name=+DATA/ORCL/DATAFILE/tbsuniform.277.1054764627
  169. channel oem_disk_backup7: starting piece 1 at 2020-11-24:20:18:59
  170. channel oem_disk_backup8: starting incremental level 1 datafile backup set
  171. channel oem_disk_backup8: specifying datafile(s) in backup set
  172. input datafile file number=00008 name=+DATA/ORCL/DATAFILE/tbs3.289.1050418001
  173. input datafile file number=00007 name=+DATA/ORCL/DATAFILE/tbs2.288.1050417617
  174. channel oem_disk_backup8: starting piece 1 at 2020-11-24:20:18:59
  175. channel oem_disk_backup1: finished piece 1 at 2020-11-24:20:19:03
  176. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.411.1057349941 tag=ORAOEM_LEVEL_0 comment=NONE
  177. channel oem_disk_backup1: backup set complete, elapsed time: 00:00:05
  178. channel oem_disk_backup1: starting incremental level 1 datafile backup set
  179. channel oem_disk_backup1: specifying datafile(s) in backup set
  180. channel oem_disk_backup2: finished piece 1 at 2020-11-24:20:19:03
  181. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.376.1057349941 tag=ORAOEM_LEVEL_0 comment=NONE
  182. channel oem_disk_backup2: backup set complete, elapsed time: 00:00:05
  183. channel oem_disk_backup2: starting incremental level 1 datafile backup set
  184. channel oem_disk_backup2: specifying datafile(s) in backup set
  185. input datafile file number=00013 name=+DATA/ORCL/DATAFILE/tbs32k.259.1054931811
  186. channel oem_disk_backup2: starting piece 1 at 2020-11-24:20:19:03
  187. channel oem_disk_backup3: finished piece 1 at 2020-11-24:20:19:03
  188. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.407.1057349941 tag=ORAOEM_LEVEL_0 comment=NONE
  189. channel oem_disk_backup3: backup set complete, elapsed time: 00:00:05
  190. channel oem_disk_backup3: starting incremental level 1 datafile backup set
  191. channel oem_disk_backup3: specifying datafile(s) in backup set
  192. including current SPFILE in backup set
  193. channel oem_disk_backup3: starting piece 1 at 2020-11-24:20:19:03
  194. channel oem_disk_backup4: finished piece 1 at 2020-11-24:20:19:03
  195. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.346.1057349941 tag=ORAOEM_LEVEL_0 comment=NONE
  196. channel oem_disk_backup4: backup set complete, elapsed time: 00:00:05
  197. channel oem_disk_backup5: finished piece 1 at 2020-11-24:20:19:04
  198. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.405.1057349943 tag=ORAOEM_LEVEL_0 comment=NONE
  199. channel oem_disk_backup5: backup set complete, elapsed time: 00:00:05
  200. channel oem_disk_backup6: finished piece 1 at 2020-11-24:20:19:04
  201. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.406.1057349941 tag=ORAOEM_LEVEL_0 comment=NONE
  202. channel oem_disk_backup6: backup set complete, elapsed time: 00:00:05
  203. including current control file in backup set
  204. channel oem_disk_backup1: starting piece 1 at 2020-11-24:20:19:04
  205. channel oem_disk_backup7: finished piece 1 at 2020-11-24:20:19:04
  206. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.404.1057349943 tag=ORAOEM_LEVEL_0 comment=NONE
  207. channel oem_disk_backup7: backup set complete, elapsed time: 00:00:05
  208. channel oem_disk_backup8: finished piece 1 at 2020-11-24:20:19:04
  209. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.414.1057349943 tag=ORAOEM_LEVEL_0 comment=NONE
  210. channel oem_disk_backup8: backup set complete, elapsed time: 00:00:05
  211. channel oem_disk_backup3: finished piece 1 at 2020-11-24:20:19:04
  212. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnsnn1_oraoem_level_0_0.419.1057349943 tag=ORAOEM_LEVEL_0 comment=NONE
  213. channel oem_disk_backup3: backup set complete, elapsed time: 00:00:01
  214. channel oem_disk_backup1: finished piece 1 at 2020-11-24:20:19:05
  215. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/ncnnn1_oraoem_level_0_0.437.1057349945 tag=ORAOEM_LEVEL_0 comment=NONE
  216. channel oem_disk_backup1: backup set complete, elapsed time: 00:00:01
  217. channel oem_disk_backup2: finished piece 1 at 2020-11-24:20:19:05
  218. piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.371.1057349945 tag=ORAOEM_LEVEL_0 comment=NONE
  219. channel oem_disk_backup2: backup set complete, elapsed time: 00:00:02
  220. Finished backup at 2020-11-24:20:19:05

  222. released channel: oem_disk_backup1

  224. released channel: oem_disk_backup2

  226. released channel: oem_disk_backup3

  228. released channel: oem_disk_backup4

  230. released channel: oem_disk_backup5

  232. released channel: oem_disk_backup6

  234. released channel: oem_disk_backup7

  236. released channel: oem_disk_backup8

  238. allocated channel: oem_sbt_backup1
  239. channel oem_sbt_backup1: SID=372 device type=SBT_TAPE
  240. channel oem_sbt_backup1: Oracle Secure Backup

  242. allocated channel: oem_sbt_backup2
  243. channel oem_sbt_backup2: SID=20 device type=SBT_TAPE
  244. channel oem_sbt_backup2: Oracle Secure Backup

  246. Starting backup at 2020-11-24:20:19:19
  247. current log archived
  248. skipping archived logs of thread 1 from sequence 1 to 2; already backed up
  249. channel oem_sbt_backup1: starting archived log backup set
  250. channel oem_sbt_backup1: specifying archived log(s) in backup set
  251. input archived log thread=1 sequence=3 RECID=24 STAMP=1056743446
  252. input archived log thread=1 sequence=4 RECID=25 STAMP=979503940
  253. channel oem_sbt_backup1: starting piece 1 at 2020-11-24:20:19:20
  254. channel oem_sbt_backup2: starting archived log backup set
  255. channel oem_sbt_backup2: specifying archived log(s) in backup set
  256. input archived log thread=1 sequence=5 RECID=26 STAMP=1057347934
  257. input archived log thread=1 sequence=6 RECID=27 STAMP=1057349960
  258. channel oem_sbt_backup2: starting piece 1 at 2020-11-24:20:19:20
  259. channel oem_sbt_backup1: finished piece 1 at 2020-11-24:20:19:45
  260. piece handle=ORCL_2pvgboa8_1_1 tag=TAG20201124T201920 comment=API Version 2.0,MMS Version 12.1.0.2
  261. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
  262. channel oem_sbt_backup2: finished piece 1 at 2020-11-24:20:19:45
  263. piece handle=ORCL_2qvgboa8_1_1 tag=TAG20201124T201920 comment=API Version 2.0,MMS Version 12.1.0.2
  264. channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:25
  265. Finished backup at 2020-11-24:20:19:45
  266. released channel: oem_sbt_backup1
  267. released channel: oem_sbt_backup2

  269. allocated channel: ORA_MAINT_SBT_TAPE_1
  270. channel ORA_MAINT_SBT_TAPE_1: SID=372 device type=SBT_TAPE
  271. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup

  273. no obsolete backups found

  275. Recovery Manager complete.
  276. [oracle@classroom ~]$
复制代码
  1. [oracle@classroom ~]$ rman target  /

  3. Recovery Manager: Release 12.1.0.2.0 - Production on 星期二 11月 24 20:21:00 2020

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

  7. connected to target database: ORCL (DBID=1574592120)

  9. RMAN> list copy;

  11. using target database control file instead of recovery catalog
  12. specification does not match any control file copy in the repository
  13. List of Datafile Copies
  14. =======================

  16. Key     File S Completion Time     Ckp SCN    Ckp Time           
  17. ------- ---- - ------------------- ---------- -------------------
  18. 73      1    A 2020-11-24:20:18:54 11940839   2020-11-15:16:49:44
  19.         Name: +FRA/ORCL/DATAFILE/system.422.1056559341
  20.         Tag: ORAOEM_LEVEL_0

  22. 69      2    A 2020-11-24:20:18:53 11940832   2020-11-15:16:49:43
  23.         Name: +FRA/ORCL/DATAFILE/sysaux.394.1056559335
  24.         Tag: ORAOEM_LEVEL_0

  26. 68      3    A 2020-11-24:20:18:53 11940835   2020-11-15:16:49:43
  27.         Name: +FRA/ORCL/DATAFILE/undotbs1.393.1056559337
  28.         Tag: ORAOEM_LEVEL_0

  30. 75      4    A 2020-11-24:20:18:54 11940842   2020-11-15:16:49:44
  31.         Name: +FRA/ORCL/DATAFILE/users.426.1056559339
  32.         Tag: ORAOEM_LEVEL_0

  34. 67      5    A 2020-11-24:20:18:53 11940829   2020-11-15:16:49:43
  35.         Name: +FRA/ORCL/DATAFILE/example.403.1056559335
  36.         Tag: ORAOEM_LEVEL_0

  38. 77      6    A 2020-11-24:20:18:54 11940845   2020-11-15:16:49:45
  39.         Name: +FRA/ORCL/DATAFILE/tbs1.387.1056559339
  40.         Tag: ORAOEM_LEVEL_0

  42. 78      7    A 2020-11-24:20:18:55 11940851   2020-11-15:16:49:45
  43.         Name: +FRA/ORCL/DATAFILE/tbs2.425.1056559359
  44.         Tag: ORAOEM_LEVEL_0

  46. 74      8    A 2020-11-24:20:18:54 11940851   2020-11-15:16:49:45
  47.         Name: +FRA/ORCL/DATAFILE/tbs3.423.1056559345
  48.         Tag: ORAOEM_LEVEL_0

  50. 66      9    A 2020-11-24:20:18:53 11940832   2020-11-15:16:49:43
  51.         Name: +FRA/ORCL/DATAFILE/tbsocp05_test.415.1056559367
  52.         Tag: ORAOEM_LEVEL_0

  54. 80      10   A 2020-11-24:20:18:55 11940848   2020-11-15:16:49:45
  55.         Name: +FRA/ORCL/DATAFILE/tbsuniform.421.1056559337
  56.         Tag: ORAOEM_LEVEL_0

  58. 72      11   A 2020-11-24:20:18:54 11940845   2020-11-15:16:49:45
  59.         Name: +FRA/ORCL/DATAFILE/tbsbig.424.1056559359
  60.         Tag: ORAOEM_LEVEL_0

  62. 76      12   A 2020-11-24:20:18:54 11940848   2020-11-15:16:49:45
  63.         Name: +FRA/ORCL/DATAFILE/tbsuniform.427.1056559361
  64.         Tag: ORAOEM_LEVEL_0

  66. 79      13   A 2020-11-24:20:18:55 11940855   2020-11-15:16:49:49
  67.         Name: +FRA/ORCL/DATAFILE/tbs32k.396.1056559367
  68.         Tag: ORAOEM_LEVEL_0

  70. 70      14   A 2020-11-24:20:18:53 11940842   2020-11-15:16:49:44
  71.         Name: +FRA/ORCL/DATAFILE/tbs_nocompression.408.1056559361
  72.         Tag: ORAOEM_LEVEL_0

  74. 71      15   A 2020-11-24:20:18:53 11940839   2020-11-15:16:49:44
  75.         Name: +FRA/ORCL/DATAFILE/tbs_basic.413.1056559365
  76.         Tag: ORAOEM_LEVEL_0

  78. 65      16   A 2020-11-24:20:18:53 11940835   2020-11-15:16:49:43
  79.         Name: +FRA/ORCL/DATAFILE/tbs_oltp.416.1056559367
  80.         Tag: ORAOEM_LEVEL_0

  82. List of Archived Log Copies for database with db_unique_name ORCL
  83. =====================================================================

  85. Key     Thrd Seq     S Low Time           
  86. ------- ---- ------- - -------------------
  87. 22      1    1       A 2020-11-15:16:29:01
  88.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_15/thread_1_seq_1.412.1056559383

  90. 23      1    2       A 2020-11-15:16:43:03
  91.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_15/thread_1_seq_2.401.1056559807

  93. 24      1    3       A 2020-11-15:16:50:07
  94.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_17/thread_1_seq_3.402.1056743447

  96. 25      1    4       A 2020-11-17:19:50:46
  97.         Name: +FRA/ORCL/ARCHIVELOG/2018_06_22/thread_1_seq_4.397.1056551755

  99. 26      1    5       A 2018-06-22:20:25:39
  100.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_5.428.1057347933

  102. 27      1    6       A 2020-11-24:19:45:33
  103.         Name: +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_6.420.1057349959


  106. RMAN>
复制代码
3. （待验证）最好把默认通道设为磁盘通道（原因是，待会创建chrone实例的时候，用磁盘通道创建）：
  1. [oracle@classroom ~]$ rman target  /

  3. Recovery Manager: Release 12.1.0.2.0 - Production on 星期二 11月 24 20:25:03 2020

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

  7. connected to target database: ORCL (DBID=1574592120)

  9. RMAN> show all;

  11. using target database control file instead of recovery catalog
  12. RMAN configuration parameters for database with db_unique_name ORCL are:
  13. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
  14. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  15. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  16. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  17. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  18. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  19. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  20. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  21. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  22. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  23. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  24. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  25. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=classroom)';
  26. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=classroom)';
  27. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "ENV=(OB_MEDIA_FAMILY=classroom)";
  28. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  29. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  30. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  31. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  32. CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
  33. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  34. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0/dbhome_2/dbs/snapcf_orcl.f'; # default

  36. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  38. old RMAN configuration parameters:
  39. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  40. new RMAN configuration parameters:
  41. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  42. new RMAN configuration parameters are successfully stored

  44. RMAN> show all;

  46. RMAN configuration parameters for database with db_unique_name ORCL are:
  47. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
  48. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  49. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  50. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  51. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  52. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  53. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  54. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  55. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  56. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  57. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  58. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  59. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=classroom)';
  60. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=classroom)';
  61. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "ENV=(OB_MEDIA_FAMILY=classroom)";
  62. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  63. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  64. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  65. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  66. CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
  67. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  68. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0/dbhome_2/dbs/snapcf_orcl.f'; # default

  70. RMAN>
复制代码
4. 把时间换算成SCN：
  1. select  timestamp_to_scn(to_date('2020-11-24:20:33:39','YYYY-MM-DD:HH24:MI:SS'))  from dual;
复制代码

5. 特点：
  1. [oracle@classroom trace]$ . oraenv
  2. ORACLE_SID = [orcl2] ? orcl
  3. The Oracle base remains unchanged with value /u01/app/oracle
  4. [oracle@classroom trace]$ sqlplus /nolog

  6. SQL*Plus: Release 12.1.0.2.0 Production on 星期二 11月 24 20:45:51 2020

  8. Copyright (c) 1982, 2014, Oracle.  All rights reserved.

  10. SQL> conn / as sysdba
  11. Connected.
  12. SQL> select open_mode from v$database;

  14. OPEN_MODE
  15. --------------------
  16. READ WRITE

  18. SQL>

复制代码
6. 抓取到的内存实例：
  1. [root@classroom ~]# ps aux | grep ymms
  2. oracle   31190  0.0  0.3 2484960 53240 ?       Ss   20:55   0:00 ora_pmon_ymms
  3. oracle   31192  0.1  0.3 2484960 51680 ?       Ss   20:55   0:00 ora_psp0_ymms
  4. oracle   31195  0.6  0.3 2484960 51976 ?       Ss   20:55   0:00 ora_vktm_ymms
  5. oracle   31199  0.0  0.3 2484960 51844 ?       Ss   20:55   0:00 ora_gen0_ymms
  6. oracle   31201  1.1  0.7 2484960 110900 ?      Ss   20:55   0:00 ora_mman_ymms
  7. oracle   31205  0.0  0.3 2484960 49460 ?       Ss   20:55   0:00 ora_diag_ymms
  8. oracle   31207  0.0  0.3 2484960 51844 ?       Ss   20:55   0:00 ora_dbrm_ymms
  9. oracle   31209  0.0  0.3 2484960 49456 ?       Ss   20:55   0:00 ora_vkrm_ymms
  10. oracle   31211  0.0  0.3 2486496 55148 ?       Ss   20:55   0:00 ora_dia0_ymms
  11. oracle   31213  0.0  0.3 2491608 58440 ?       Ss   20:55   0:00 ora_dbw0_ymms
  12. oracle   31215  0.0  0.3 2484960 51268 ?       Ss   20:55   0:00 ora_lgwr_ymms
  13. oracle   31217  0.0  0.3 2484960 54664 ?       Ss   20:55   0:00 ora_ckpt_ymms
  14. oracle   31221  0.0  0.3 2484956 50952 ?       Ss   20:55   0:00 ora_lg00_ymms
  15. oracle   31223  0.0  0.3 2484960 49384 ?       Ss   20:55   0:00 ora_smon_ymms
  16. oracle   31225  0.0  0.3 2484956 50828 ?       Ss   20:55   0:00 ora_lg01_ymms
  17. oracle   31227  0.0  0.3 2484960 49412 ?       Ss   20:55   0:00 ora_reco_ymms
  18. oracle   31229  0.1  0.3 2490740 52564 ?       Ss   20:55   0:00 ora_lreg_ymms
  19. oracle   31233  0.0  0.3 2484960 51592 ?       Ss   20:55   0:00 ora_pxmn_ymms
  20. oracle   31236  0.0  0.3 2484960 53592 ?       Ss   20:55   0:00 ora_mmon_ymms
  21. oracle   31238  0.0  0.3 2484960 53128 ?       Ss   20:55   0:00 ora_mmnl_ymms
  22. oracle   31251  1.8  0.5 2495304 89956 ?       Ss   20:55   0:00 oracleymms (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  23. oracle   31262  0.5  0.4 2495240 71924 ?       Rs   20:55   0:00 oracleymms (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  24. oracle   31303  0.3  0.4 2496788 74972 ?       Ss   20:55   0:00 oracleymms (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  25. oracle   31320  0.2  0.4 2496480 67988 ?       Ss   20:55   0:00 oracleymms (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  26. oracle   31348  0.3  0.4 2493872 66120 ?       Ss   20:55   0:00 oracleymms (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  27. oracle   31354  0.6  0.4 2493868 65952 ?       Ss   20:55   0:00 oracleymms (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  28. oracle   31363  2.0  0.4 2493872 65608 ?       Ss   20:55   0:00 oracleymms (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  29. root     31369  0.0  0.0 224856  1068 pts/4    S+   20:55   0:00 grep --color=auto ymms
  30. [root@classroom ~]#
复制代码

下面是执行过程：

  1. oracle@classroom trace]$ rman target  /

  3. Recovery Manager: Release 12.1.0.2.0 - Production on 星期二 11月 24 20:52:34 2020

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

  7. connected to target database: ORCL (DBID=1574592120)

  9. RMAN> recover tablespace users until scn 12273726
  10. 2> auxiliary destination '/u01/app/oracle/oradata';

  12. Starting recover at 2020-11-24:20:54:36
  13. using target database control file instead of recovery catalog
  14. current log archived
  15. allocated channel: ORA_SBT_TAPE_1
  16. channel ORA_SBT_TAPE_1: SID=141 device type=SBT_TAPE
  17. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  18. allocated channel: ORA_SBT_TAPE_2
  19. channel ORA_SBT_TAPE_2: SID=375 device type=SBT_TAPE
  20. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  21. allocated channel: ORA_DISK_1
  22. channel ORA_DISK_1: SID=139 device type=DISK
  23. allocated channel: ORA_DISK_2
  24. channel ORA_DISK_2: SID=258 device type=DISK
  25. allocated channel: ORA_DISK_3
  26. channel ORA_DISK_3: SID=377 device type=DISK
  27. allocated channel: ORA_DISK_4
  28. channel ORA_DISK_4: SID=22 device type=DISK
  29. allocated channel: ORA_DISK_5
  30. channel ORA_DISK_5: SID=124 device type=DISK
  31. allocated channel: ORA_DISK_6
  32. channel ORA_DISK_6: SID=256 device type=DISK
  33. allocated channel: ORA_DISK_7
  34. channel ORA_DISK_7: SID=357 device type=DISK
  35. allocated channel: ORA_DISK_8
  36. channel ORA_DISK_8: SID=20 device type=DISK
  37. RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time

  39. List of tablespaces expected to have UNDO segments
  40. Tablespace SYSTEM
  41. Tablespace UNDOTBS1

  43. Creating automatic instance, with SID='ymms'

  45. initialization parameters used for automatic instance:
  46. db_name=ORCL
  47. db_unique_name=ymms_pitr_ORCL
  48. compatible=12.1.0.2.0
  49. db_block_size=8192
  50. db_files=200
  51. diagnostic_dest=/u01/app/oracle
  52. _system_trig_enabled=FALSE
  53. sga_target=2048M
  54. processes=200
  55. db_32k_cache_size=16M
  56. db_create_file_dest=/u01/app/oracle/oradata
  57. log_archive_dest_1='location=/u01/app/oracle/oradata'
  58. #No auxiliary parameter file used


  61. starting up automatic instance ORCL

  63. Oracle instance started

  65. Total System Global Area    2147483648 bytes

  67. Fixed Size                     2926472 bytes
  68. Variable Size                503318648 bytes
  69. Database Buffers            1627389952 bytes
  70. Redo Buffers                  13848576 bytes
  71. Automatic instance created


  74. List of tablespaces that have been dropped from the target database:
  75. Tablespace USERS

  77. contents of Memory Script:
  78. {
  79. # set requested point in time
  80. set until  scn 12273726;
  81. # restore the controlfile
  82. restore clone controlfile;

  84. # mount the controlfile
  85. sql clone 'alter database mount clone database';

  87. # archive current online log
  88. sql 'alter system archive log current';
  89. # avoid unnecessary autobackups for structural changes during TSPITR
  90. sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
  91. }
  92. executing Memory Script

  94. executing command: SET until clause

  96. Starting restore at 2020-11-24:20:55:44
  97. allocated channel: ORA_AUX_SBT_TAPE_1
  98. channel ORA_AUX_SBT_TAPE_1: SID=6 device type=SBT_TAPE
  99. channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
  100. allocated channel: ORA_AUX_SBT_TAPE_2
  101. channel ORA_AUX_SBT_TAPE_2: SID=89 device type=SBT_TAPE
  102. channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
  103. allocated channel: ORA_AUX_DISK_1
  104. channel ORA_AUX_DISK_1: SID=169 device type=DISK
  105. allocated channel: ORA_AUX_DISK_2
  106. channel ORA_AUX_DISK_2: SID=246 device type=DISK
  107. allocated channel: ORA_AUX_DISK_3
  108. channel ORA_AUX_DISK_3: SID=7 device type=DISK
  109. allocated channel: ORA_AUX_DISK_4
  110. channel ORA_AUX_DISK_4: SID=90 device type=DISK
  111. allocated channel: ORA_AUX_DISK_5
  112. channel ORA_AUX_DISK_5: SID=170 device type=DISK
  113. allocated channel: ORA_AUX_DISK_6
  114. channel ORA_AUX_DISK_6: SID=251 device type=DISK
  115. allocated channel: ORA_AUX_DISK_7
  116. channel ORA_AUX_DISK_7: SID=8 device type=DISK
  117. allocated channel: ORA_AUX_DISK_8
  118. channel ORA_AUX_DISK_8: SID=91 device type=DISK

  120. channel ORA_AUX_DISK_1: starting datafile backup set restore
  121. channel ORA_AUX_DISK_1: restoring control file
  122. channel ORA_AUX_DISK_1: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_24/ncnnf0_labs-14-contr-before-drop_0.431.1057350805
  123. channel ORA_AUX_DISK_1: piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/ncnnf0_labs-14-contr-before-drop_0.431.1057350805 tag=LABS-14-CONTR-BEFORE-DROP
  124. channel ORA_AUX_DISK_1: restored backup piece 1
  125. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:00
  126. output file name=/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_hvt0qopt_.ctl
  127. Finished restore at 2020-11-24:20:56:22

  129. sql statement: alter database mount clone database

  131. sql statement: alter system archive log current

  133. sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;

  135. contents of Memory Script:
  136. {
  137. # set requested point in time
  138. set until  scn 12273726;
  139. # set destinations for recovery set and auxiliary set datafiles
  140. set newname for clone datafile  1 to new;
  141. set newname for clone datafile  3 to new;
  142. set newname for clone datafile  2 to new;
  143. set newname for clone tempfile  1 to new;
  144. set newname for datafile  4 to new;
  145. # switch all tempfiles
  146. switch clone tempfile all;
  147. # restore the tablespaces in the recovery set and the auxiliary set
  148. restore clone datafile  1, 3, 2, 4;

  150. switch clone datafile all;
  151. }
  152. executing Memory Script

  154. executing command: SET until clause

  156. executing command: SET NEWNAME

  158. executing command: SET NEWNAME

  160. executing command: SET NEWNAME

  162. executing command: SET NEWNAME

  164. executing command: SET NEWNAME

  166. renamed tempfile 1 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_%u_.tmp in control file

  168. Starting restore at 2020-11-24:20:56:30
  169. using channel ORA_AUX_SBT_TAPE_1
  170. using channel ORA_AUX_SBT_TAPE_2
  171. using channel ORA_AUX_DISK_1
  172. using channel ORA_AUX_DISK_2
  173. using channel ORA_AUX_DISK_3
  174. using channel ORA_AUX_DISK_4
  175. using channel ORA_AUX_DISK_5
  176. using channel ORA_AUX_DISK_6
  177. using channel ORA_AUX_DISK_7
  178. using channel ORA_AUX_DISK_8

  180. channel ORA_AUX_DISK_1: restoring datafile 00001
  181. input datafile copy RECID=73 STAMP=1057349934 file name=+FRA/ORCL/DATAFILE/system.422.1056559341
  182. destination for restore of datafile 00001: /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_%u_.dbf
  183. channel ORA_AUX_DISK_2: restoring datafile 00003
  184. input datafile copy RECID=68 STAMP=1057349933 file name=+FRA/ORCL/DATAFILE/undotbs1.393.1056559337
  185. destination for restore of datafile 00003: /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_%u_.dbf
  186. channel ORA_AUX_DISK_3: restoring datafile 00002
  187. input datafile copy RECID=69 STAMP=1057349933 file name=+FRA/ORCL/DATAFILE/sysaux.394.1056559335
  188. destination for restore of datafile 00002: /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_%u_.dbf
  189. channel ORA_AUX_DISK_4: restoring datafile 00004
  190. input datafile copy RECID=75 STAMP=1057349934 file name=+FRA/ORCL/DATAFILE/users.426.1056559339
  191. destination for restore of datafile 00004: +data
  192. channel ORA_AUX_DISK_4: copied datafile copy of datafile 00004
  193. output file name=+DATA/ORCL/DATAFILE/users.262.1057352191 RECID=81 STAMP=1057352194
  194. channel ORA_AUX_DISK_1: copied datafile copy of datafile 00001
  195. output file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hvt0qz17_.dbf RECID=82 STAMP=1057352215
  196. channel ORA_AUX_DISK_2: copied datafile copy of datafile 00003
  197. output file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_hvt0qz19_.dbf RECID=83 STAMP=1057352215
  198. channel ORA_AUX_DISK_3: copied datafile copy of datafile 00002
  199. output file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_hvt0qz19_.dbf RECID=84 STAMP=1057352215
  200. Finished restore at 2020-11-24:20:56:57

  202. datafile 4 switched to datafile copy
  203. input datafile copy RECID=85 STAMP=1057352217 file name=+DATA/ORCL/DATAFILE/users.262.1057352191
  204. datafile 1 switched to datafile copy
  205. input datafile copy RECID=86 STAMP=1057352217 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hvt0qz17_.dbf
  206. datafile 3 switched to datafile copy
  207. input datafile copy RECID=87 STAMP=1057352218 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_hvt0qz19_.dbf
  208. datafile 2 switched to datafile copy
  209. input datafile copy RECID=88 STAMP=1057352218 file name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_hvt0qz19_.dbf

  211. contents of Memory Script:
  212. {
  213. # set requested point in time
  214. set until  scn 12273726;
  215. # online the datafiles restored or switched
  216. sql clone "alter database datafile  1 online";
  217. sql clone "alter database datafile  3 online";
  218. sql clone "alter database datafile  2 online";
  219. sql clone "alter database datafile  4 online";
  220. # recover and open resetlogs
  221. recover clone database tablespace  "USERS", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;
  222. alter clone database open resetlogs;
  223. }
  224. executing Memory Script

  226. executing command: SET until clause

  228. sql statement: alter database datafile  1 online

  230. sql statement: alter database datafile  3 online

  232. sql statement: alter database datafile  2 online

  234. sql statement: alter database datafile  4 online

  236. Starting recover at 2020-11-24:20:56:58
  237. using channel ORA_AUX_SBT_TAPE_1
  238. using channel ORA_AUX_SBT_TAPE_2
  239. using channel ORA_AUX_DISK_1
  240. using channel ORA_AUX_DISK_2
  241. using channel ORA_AUX_DISK_3
  242. using channel ORA_AUX_DISK_4
  243. using channel ORA_AUX_DISK_5
  244. using channel ORA_AUX_DISK_6
  245. using channel ORA_AUX_DISK_7
  246. using channel ORA_AUX_DISK_8
  247. channel ORA_AUX_DISK_1: starting incremental datafile backup set restore
  248. channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
  249. destination for restore of datafile 00001: /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hvt0qz17_.dbf
  250. channel ORA_AUX_DISK_1: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.346.1057349941
  251. channel ORA_AUX_DISK_2: starting incremental datafile backup set restore
  252. channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
  253. destination for restore of datafile 00002: /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_hvt0qz19_.dbf
  254. channel ORA_AUX_DISK_2: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.376.1057349941
  255. channel ORA_AUX_DISK_3: starting incremental datafile backup set restore
  256. channel ORA_AUX_DISK_3: specifying datafile(s) to restore from backup set
  257. destination for restore of datafile 00004: +DATA/ORCL/DATAFILE/users.262.1057352191
  258. channel ORA_AUX_DISK_3: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.405.1057349943
  259. channel ORA_AUX_DISK_4: starting incremental datafile backup set restore
  260. channel ORA_AUX_DISK_4: specifying datafile(s) to restore from backup set
  261. destination for restore of datafile 00003: /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_hvt0qz19_.dbf
  262. channel ORA_AUX_DISK_4: reading from backup piece +FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.407.1057349941
  263. channel ORA_AUX_DISK_3: piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.405.1057349943 tag=ORAOEM_LEVEL_0
  264. channel ORA_AUX_DISK_3: restored backup piece 1
  265. channel ORA_AUX_DISK_3: restore complete, elapsed time: 00:00:01
  266. channel ORA_AUX_DISK_4: piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.407.1057349941 tag=ORAOEM_LEVEL_0
  267. channel ORA_AUX_DISK_4: restored backup piece 1
  268. channel ORA_AUX_DISK_4: restore complete, elapsed time: 00:00:03
  269. channel ORA_AUX_DISK_1: piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.346.1057349941 tag=ORAOEM_LEVEL_0
  270. channel ORA_AUX_DISK_1: restored backup piece 1
  271. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
  272. channel ORA_AUX_DISK_2: piece handle=+FRA/ORCL/BACKUPSET/2020_11_24/nnndn1_oraoem_level_0_0.376.1057349941 tag=ORAOEM_LEVEL_0
  273. channel ORA_AUX_DISK_2: restored backup piece 1
  274. channel ORA_AUX_DISK_2: restore complete, elapsed time: 00:00:25

  276. starting media recovery

  278. archived log for thread 1 with sequence 6 is already on disk as file +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_6.420.1057349959
  279. archived log for thread 1 with sequence 7 is already on disk as file +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_7.390.1057350807
  280. archived log for thread 1 with sequence 8 is already on disk as file +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_8.372.1057350807
  281. archived log for thread 1 with sequence 9 is already on disk as file +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_9.433.1057350809
  282. archived log for thread 1 with sequence 10 is already on disk as file +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_10.432.1057350809
  283. archived log for thread 1 with sequence 11 is already on disk as file +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_11.434.1057350813
  284. archived log for thread 1 with sequence 12 is already on disk as file +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_12.395.1057350813
  285. archived log for thread 1 with sequence 13 is already on disk as file +FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_13.257.1057352077
  286. archived log file name=+FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_6.420.1057349959 thread=1 sequence=6
  287. archived log file name=+FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_7.390.1057350807 thread=1 sequence=7
  288. archived log file name=+FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_8.372.1057350807 thread=1 sequence=8
  289. archived log file name=+FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_9.433.1057350809 thread=1 sequence=9
  290. archived log file name=+FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_10.432.1057350809 thread=1 sequence=10
  291. archived log file name=+FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_11.434.1057350813 thread=1 sequence=11
  292. archived log file name=+FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_12.395.1057350813 thread=1 sequence=12
  293. archived log file name=+FRA/ORCL/ARCHIVELOG/2020_11_24/thread_1_seq_13.257.1057352077 thread=1 sequence=13
  294. media recovery complete, elapsed time: 00:00:13
  295. Finished recover at 2020-11-24:20:57:40

  297. database opened

  299. contents of Memory Script:
  300. {
  301. # make read only the tablespace that will be exported
  302. sql clone 'alter tablespace  USERS read only';
  303. # create directory for datapump import
  304. sql "create or replace directory TSPITR_DIROBJ_DPDIR as ''
  305. /u01/app/oracle/oradata''";
  306. # create directory for datapump export
  307. sql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''
  308. /u01/app/oracle/oradata''";
  309. }
  310. executing Memory Script

  312. sql statement: alter tablespace  USERS read only

  314. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/oradata''

  316. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/oradata''

  318. Performing export of metadata...
  319.    EXPDP> 启动 "SYS"."TSPITR_EXP_ymms_lzec":  
  320.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
  321.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/TABLE
  322.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
  323.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/INDEX/INDEX
  324.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/INDEX_STATISTICS
  325.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/TRIGGER
  326.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/TABLE_STATISTICS
  327.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/STATISTICS/MARKER
  328.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/FGA_POLICY
  329.    EXPDP> 处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
  330.    EXPDP> 已成功加载/卸载了主表 "SYS"."TSPITR_EXP_ymms_lzec"
  331.    EXPDP> ******************************************************************************
  332.    EXPDP> SYS.TSPITR_EXP_ymms_lzec 的转储文件集为:
  333.    EXPDP>   /u01/app/oracle/oradata/tspitr_ymms_69605.dmp
  334.    EXPDP> ******************************************************************************
  335.    EXPDP> 可传输表空间 USERS 所需的数据文件:
  336.    EXPDP>   +DATA/ORCL/DATAFILE/users.262.1057352191
  337.    EXPDP> 作业 "SYS"."TSPITR_EXP_ymms_lzec" 已于 星期二 11月 24 20:59:29 2020 elapsed 0 00:01:26 成功完成
  338. Export completed


  341. contents of Memory Script:
  342. {
  343. # shutdown clone before import
  344. shutdown clone abort
  345. }
  346. executing Memory Script

  348. Oracle instance shut down

  350. Performing import of metadata...
  351.    IMPDP> 已成功加载/卸载了主表 "SYS"."TSPITR_IMP_ymms_hfyz"
  352.    IMPDP> 启动 "SYS"."TSPITR_IMP_ymms_hfyz":  
  353.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
  354.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/TABLE
  355.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
  356.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/INDEX/INDEX
  357.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/INDEX_STATISTICS
  358.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/TRIGGER
  359.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/TABLE_STATISTICS
  360.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/STATISTICS/MARKER
  361.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/FGA_POLICY
  362.    IMPDP> 处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
  363.    IMPDP> 作业 "SYS"."TSPITR_IMP_ymms_hfyz" 已于 星期二 11月 24 21:00:15 2020 elapsed 0 00:00:36 成功完成
  364. Import completed


  367. contents of Memory Script:
  368. {
  369. # make read write and offline the imported tablespaces
  370. sql 'alter tablespace  USERS read write';
  371. sql 'alter tablespace  USERS offline';
  372. # enable autobackups after TSPITR is finished
  373. sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';
  374. }
  375. executing Memory Script

  377. sql statement: alter tablespace  USERS read write

  379. sql statement: alter tablespace  USERS offline

  381. sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;

  383. Removing automatic instance
  384. Automatic instance removed
  385. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_hvt0t9sc_.tmp deleted
  386. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_hvt0t5y2_.log deleted
  387. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_hvt0t592_.log deleted
  388. auxiliary instance file /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_hvt0t4lb_.log deleted
  389. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_hvt0qz19_.dbf deleted
  390. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_hvt0qz19_.dbf deleted
  391. auxiliary instance file /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hvt0qz17_.dbf deleted
  392. auxiliary instance file /u01/app/oracle/oradata/ORCL/controlfile/o1_mf_hvt0qopt_.ctl deleted
  393. auxiliary instance file tspitr_ymms_69605.dmp deleted
  394. Finished recover at 2020-11-24:21:00:18

  396. RMAN>
复制代码






回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-21 19:27 , Processed in 0.036397 second(s), 24 queries .

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