切换到窄版

运维联盟俱乐部

 找回密码
 立即注册
运维联盟俱乐部»论坛 › 数据库 › oracle › rman-06023
返回列表 发新帖
查看: 2225|回复: 0

[备份恢复] rman-06023

[复制链接]
admin
  • TA的每日心情
    开心
    2023-8-9 11:05
    		•
    发表于 2020-7-13 12:50:34 | 显示全部楼层 |阅读模式
    1.restore database报错
    1. RMAN-00571: ===========================================================
    2. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    3. RMAN-00571: ===========================================================
    4. RMAN-03002: failure of restore command at 07/13/2020 12:43:10
    5. RMAN-06026: some targets not found - aborting restore
    6. RMAN-06023: no backup or copy of datafile 21 found to restore
    7. RMAN-06023: no backup or copy of datafile 20 found to restore
    8. RMAN-06023: no backup or copy of datafile 19 found to restore
    9. RMAN-06023: no backup or copy of datafile 18 found to restore
    10. RMAN-06023: no backup or copy of datafile 17 found to restore
    11. RMAN-06023: no backup or copy of datafile 16 found to restore
    12. RMAN-06023: no backup or copy of datafile 15 found to restore
    13. RMAN-06023: no backup or copy of datafile 14 found to restore
    14. RMAN-06023: no backup or copy of datafile 13 found to restore
    15. RMAN-06023: no backup or copy of datafile 12 found to restore
    16. RMAN-06023: no backup or copy of datafile 11 found to restore
    17. RMAN-06023: no backup or copy of datafile 10 found to restore
    18. RMAN-06023: no backup or copy of datafile 9 found to restore
    19. RMAN-06023: no backup or copy of datafile 8 found to restore
    20. RMAN-06023: no backup or copy of datafile 7 found to restore
    21. RMAN-06023: no backup or copy of datafile 6 found to restore
    22. RMAN-06023: no backup or copy of datafile 5 found to restore
    23. RMAN-06023: no backup or copy of datafile 4 found to restore
    24. RMAN-06023: no backup or copy of datafile 3 found to restore
    25. RMAN-06023: no backup or copy of datafile 2 found to restore
    26. RMAN-06023: no backup or copy of datafile 1 found to restore
    复制代码
    2.list incarnation
    1. RMAN> list incarnation;


    4. List of Database Incarnations
    5. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
    6. ------- ------- -------- ---------------- --- ---------- ----------
    7. 1       1       ORCL     1511731934       PARENT  1594143    12-AUG-18
    8. 2       2       ORCL     1511731934       PARENT  21718965952 19-JAN-20
    9. 3       3       ORCL     1511731934       CURRENT 24753244621 13-JUL-20

    11. RMAN> reset database to incarnation 2;

    13. database reset to incarnation 2
    复制代码
    3.reset incarnation
    1. RMAN> reset database to incarnation 2;

    3. database reset to incarnation 2
    复制代码
    4.retry
    1. RMAN> run{
    2. 2> allocate channel 'd1' type disk;
    3. 3> allocate channel 'd2' type disk;
    4. 4> allocate channel 'd3' type disk;
    5. 5> allocate channel 'd4' type disk;
    6. 6> allocate channel 'd5' type disk;
    7. 7> allocate channel 'd6' type disk;
    8. 8> set newname for datafile '+DBFILE/ORCL/DATAFILE/system01.dbf'               to '+data/orcl/datafile/system01.dbf';
    9. 9> set newname for datafile '+DBFILE/ORCL/DATAFILE/sysaux.264.1030061393'      to '+data/orcl/datafile/sysaux01.dbf';
    10. 10> set newname for datafile '+DBFILE/ORCL/DATAFILE/sysaux02.dbf'               to '+data/orcl/datafile/sysaux02.dbf';
    11. 11> set newname for datafile '+DBFILE/ORCL/DATAFILE/undotbs1.266.1030061687'    to '+data/orcl/datafile/undotbs1_01.dbf';
    12. 12> set newname for datafile '+DBFILE/ORCL/DATAFILE/undotbs2.259.1030061067'    to '+data/orcl/datafile/undotbs2_01.dbf';
    13. 13> set newname for datafile '+DBFILE/ORCL/DATAFILE/users.262.1030061689'       to '+data/orcl/datafile/users.dbf';
    14. 14> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx01.dbf'              to '+data/orcl/datafile/erpindx01.dbf';
    15. 15> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx02.dbf'              to '+data/orcl/datafile/erpindx02.dbf';
    16. 16> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx03.dbf'              to '+data/orcl/datafile/erpindx03.dbf';
    17. 17> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx04.dbf'              to '+data/orcl/datafile/erpindx04.dbf';
    18. 18> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx05.dbf'              to '+data/orcl/datafile/erpindx05.dbf';
    19. 19> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx06.dbf'              to '+data/orcl/datafile/erpindx06.dbf';
    20. 20> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx07.dbf'              to '+data/orcl/datafile/erpindx07.dbf';
    21. 21> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx08.dbf'              to '+data/orcl/datafile/erpindx08.dbf';
    22. 22> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx.278.1030075145'     to '+data/orcl/datafile/erpindx09.dbf';
    23. 23> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx.261.1030055513'     to '+data/orcl/datafile/erpindx10.dbf';
    24. 24> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx.276.1030068023'     to '+data/orcl/datafile/erpindx11.dbf';
    25. 25> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx.267.1030055511'     to '+data/orcl/datafile/erpindx12.dbf';
    26. 26> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx3.dbf'               to '+data/orcl/datafile/erpindx13.dbf';
    27. 27> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpindx4.dbf'               to '+data/orcl/datafile/erpindx14.dbf';
    28. 28> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpdata01.dbf'              to '+data/orcl/datafile/erpdata01.dbf';
    29. 29> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpdata02.dbf'              to '+data/orcl/datafile/erpdata02.dbf';
    30. 30> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpdata03.dbf'              to '+data/orcl/datafile/erpdata03.dbf';
    31. 31> set newname for datafile '+DBFILE/ORCL/DATAFILE/erpdata.263.1030055517'     to '+data/orcl/datafile/erpdata04.dbf';
    32. 32> restore database;
    33. 33> switch datafile all;
    34. 34> release channel d1;
    35. 35> release channel d2;
    36. 36> release channel d3;
    37. 37> release channel d4;
    38. 38> release channel d5;
    39. 39> release channel d6;
    40. 40> }
    41. 41>
    42. using target database control file instead of recovery catalog
    43. allocated channel: d1
    44. channel d1: SID=2849 device type=DISK

    46. allocated channel: d2
    47. channel d2: SID=2881 device type=DISK

    49. allocated channel: d3
    50. channel d3: SID=2913 device type=DISK

    52. allocated channel: d4
    53. channel d4: SID=2945 device type=DISK

    55. allocated channel: d5
    56. channel d5: SID=2977 device type=DISK

    58. allocated channel: d6
    59. channel d6: SID=2561 device type=DISK

    61. executing command: SET NEWNAME

    63. executing command: SET NEWNAME

    65. executing command: SET NEWNAME

    67. executing command: SET NEWNAME

    69. executing command: SET NEWNAME

    71. executing command: SET NEWNAME

    73. executing command: SET NEWNAME

    75. executing command: SET NEWNAME

    77. executing command: SET NEWNAME

    79. executing command: SET NEWNAME

    81. executing command: SET NEWNAME

    83. executing command: SET NEWNAME

    85. executing command: SET NEWNAME

    87. executing command: SET NEWNAME

    89. executing command: SET NEWNAME

    91. executing command: SET NEWNAME

    93. executing command: SET NEWNAME

    95. executing command: SET NEWNAME

    97. executing command: SET NEWNAME

    99. executing command: SET NEWNAME

    101. executing command: SET NEWNAME

    103. executing command: SET NEWNAME

    105. executing command: SET NEWNAME

    107. executing command: SET NEWNAME

    109. Starting restore at 13-JUL-20

    111. channel d1: starting datafile backup set restore
    112. channel d1: specifying datafile(s) to restore from backup set
    113. channel d1: restoring datafile 00007 to +data/orcl/datafile/erpindx01.dbf
    114. channel d1: restoring datafile 00021 to +data/orcl/datafile/erpindx05.dbf
    115. channel d1: restoring datafile 00024 to +data/orcl/datafile/erpindx08.dbf
    116. channel d1: reading from backup piece /rman_backup/data/9kv56581_1_1.bak
    117. channel d2: starting datafile backup set restore
    118. channel d2: specifying datafile(s) to restore from backup set
    119. channel d2: restoring datafile 00004 to +data/orcl/datafile/undotbs1_01.dbf
    120. channel d2: reading from backup piece /rman_backup/data/9ov568a0_1_1.bak
    121. channel d3: starting datafile backup set restore
    122. channel d3: specifying datafile(s) to restore from backup set
    123. channel d3: restoring datafile 00005 to +data/orcl/datafile/undotbs2_01.dbf
    124. channel d3: reading from backup piece /rman_backup/data/9pv568a7_1_1.bak
    125. channel d4: starting datafile backup set restore
    126. channel d4: specifying datafile(s) to restore from backup set
    127. channel d4: restoring datafile 00019 to +data/orcl/datafile/sysaux02.dbf
    128. channel d4: reading from backup piece /rman_backup/data/9qv568b1_1_1.bak
    129. channel d5: starting datafile backup set restore
    130. channel d5: specifying datafile(s) to restore from backup set
    131. channel d5: restoring datafile 00001 to +data/orcl/datafile/system01.dbf
    132. channel d5: reading from backup piece /rman_backup/data/9rv568bq_1_1.bak
    133. channel d6: starting datafile backup set restore
    134. channel d6: specifying datafile(s) to restore from backup set
    135. channel d6: restoring datafile 00003 to +data/orcl/datafile/sysaux01.dbf
    136. channel d6: reading from backup piece /rman_backup/data/9sv568gb_1_1.bak
    137. channel d2: piece handle=/rman_backup/data/9ov568a0_1_1.bak tag=TAG20200713T052416
    138. channel d2: restored backup piece 1
    139. channel d2: restore complete, elapsed time: 00:00:35
    140. channel d2: starting datafile backup set restore
    141. channel d2: specifying datafile(s) to restore from backup set
    142. channel d2: restoring datafile 00002 to +data/orcl/datafile/erpdata01.dbf
    143. channel d2: restoring datafile 00012 to +data/orcl/datafile/erpindx04.dbf
    144. channel d2: restoring datafile 00013 to +data/orcl/datafile/erpindx09.dbf
    145. channel d2: reading from backup piece /rman_backup/data/9iv56581_1_1.bak
    146. channel d3: piece handle=/rman_backup/data/9pv568a7_1_1.bak tag=TAG20200713T052416
    147. channel d3: restored backup piece 1
    148. channel d3: restore complete, elapsed time: 00:00:35
    149. channel d3: starting datafile backup set restore
    150. channel d3: specifying datafile(s) to restore from backup set
    151. channel d3: restoring datafile 00006 to +data/orcl/datafile/users.dbf
    152. channel d3: reading from backup piece /rman_backup/data/9uv568kk_1_1.bak
    153. channel d3: piece handle=/rman_backup/data/9uv568kk_1_1.bak tag=TAG20200713T052416
    154. channel d3: restored backup piece 1
    155. channel d3: restore complete, elapsed time: 00:00:01
    156. channel d3: starting datafile backup set restore
    157. channel d3: specifying datafile(s) to restore from backup set
    158. channel d3: restoring datafile 00008 to +data/orcl/datafile/erpindx12.dbf
    159. channel d3: restoring datafile 00011 to +data/orcl/datafile/erpdata02.dbf
    160. channel d3: restoring datafile 00015 to +data/orcl/datafile/erpindx10.dbf
    161. channel d3: reading from backup piece /rman_backup/data/9lv56581_1_1.bak
    162. channel d4: piece handle=/rman_backup/data/9qv568b1_1_1.bak tag=TAG20200713T052416
    163. channel d4: restored backup piece 1
    164. channel d4: restore complete, elapsed time: 00:00:43
    165. channel d4: starting datafile backup set restore
    166. channel d4: specifying datafile(s) to restore from backup set
    167. channel d4: restoring datafile 00009 to +data/orcl/datafile/erpindx02.dbf
    168. channel d4: restoring datafile 00010 to +data/orcl/datafile/erpindx03.dbf
    169. channel d4: restoring datafile 00023 to +data/orcl/datafile/erpindx07.dbf
    170. channel d4: reading from backup piece /rman_backup/data/9jv56581_1_1.bak
    171. channel d5: piece handle=/rman_backup/data/9rv568bq_1_1.bak tag=TAG20200713T052416
    172. channel d5: restored backup piece 1
    173. channel d5: restore complete, elapsed time: 00:02:48
    174. channel d5: starting datafile backup set restore
    175. channel d5: specifying datafile(s) to restore from backup set
    176. channel d5: restoring datafile 00014 to +data/orcl/datafile/erpdata04.dbf
    177. channel d5: restoring datafile 00017 to +data/orcl/datafile/erpindx13.dbf
    178. channel d5: restoring datafile 00020 to +data/orcl/datafile/erpdata03.dbf
    179. channel d5: reading from backup piece /rman_backup/data/9mv56581_1_1.bak
    180. channel d6: piece handle=/rman_backup/data/9sv568gb_1_1.bak tag=TAG20200713T052416
    181. channel d6: restored backup piece 1
    182. channel d6: restore complete, elapsed time: 00:02:49
    183. channel d6: starting datafile backup set restore
    184. channel d6: specifying datafile(s) to restore from backup set
    185. channel d6: restoring datafile 00016 to +data/orcl/datafile/erpindx11.dbf
    186. channel d6: restoring datafile 00018 to +data/orcl/datafile/erpindx14.dbf
    187. channel d6: restoring datafile 00022 to +data/orcl/datafile/erpindx06.dbf
    复制代码






    回复

    使用道具 举报

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

    本版积分规则

    运维联盟俱乐部 ( 冀ICP备19036648号 )

    GMT+8, 2024-5-17 10:14 , Processed in 0.046444 second(s), 21 queries , Gzip On.

    Powered by Discuz! X3.4

    © 2001-2023 Discuz! Team.

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