当前位置:Gxlcms > 数据库问题 > SAP系统拷贝-ORACLE更改SID

SAP系统拷贝-ORACLE更改SID

时间:2021-07-01 10:21:17 帮助过:11人阅读

ECCPRD TO Q05系统拷贝 2018.01.25
第一部分 V7000存储进行存储LUN拷贝
  1. 使用一致性组进行LUN克隆
  2. 将克隆卷映射到新主机
  3. 在新主机上强制导入卷组,因为AIX镜像丢失,无法正常导入卷组,需要加上-f参数
    1. <code># importvg -y q05datavg -f hdisk11
    2. PV Status: hdisk11 00067a4b2d12e06f PVACTIVE
    3. hdisk12 00067a4b7901a384 PVACTIVE
    4. hdisk13 00067a4b7901a3d6 PVACTIVE
    5. hdisk14 00067a4b7901a429 PVACTIVE
    6. hdisk15 0001d23cddef5ee6 PVACTIVE
    7. hdisk16 0001d23cde6afe3a PVACTIVE
    8. 0001d23cde6a7b05 NONAME
    9. 00067a4bf5b39357 NONAME
    10. 00067a4bf5b39312 NONAME
    11. 0001d23cddef5de1 NONAME
    12. 00067a4bf5b39285 NONAME
    13. 00067a4bf5b392cf NONAME
    14. varyonvg: Volume group q05datavg is varied on.
    15. 0516-510 synclvodm: Physical volume not found for physical volume
    16. identifier 00067a4bf5b392850000000000000000.
    17. 0516-510 synclvodm: Physical volume not found for physical volume
    18. identifier 00067a4bf5b392cf0000000000000000.
    19. 0516-510 synclvodm: Physical volume not found for physical volume
    20. identifier 00067a4bf5b393120000000000000000.
    21. 0516-510 synclvodm: Physical volume not found for physical volume
    22. identifier 00067a4bf5b393570000000000000000.
    23. 0516-510 synclvodm: Physical volume not found for physical volume
    24. identifier 0001d23cddef5de10000000000000000.
    25. 0516-510 synclvodm: Physical volume not found for physical volume
    26. identifier 0001d23cde6a7b050000000000000000.
    27. 0516-548 synclvodm: Partially successful with updating volume
    28. group q05datavg.
    29. q05datavg
    30. PV Status: hdisk12 00067a4b7901a384 PVACTIVE
    31. hdisk13 00067a4b7901a3d6 PVACTIVE
    32. hdisk14 00067a4b7901a429 PVACTIVE
    33. hdisk11 00067a4b2d12e06f PVACTIVE
    34. hdisk15 0001d23cddef5ee6 PVACTIVE
    35. hdisk16 0001d23cde6afe3a PVACTIVE
    36. 0001d23cde6a7b05 NONAME
    37. 00067a4bf5b39357 NONAME
    38. 00067a4bf5b39312 NONAME
    39. 0001d23cddef5de1 NONAME
    40. 00067a4bf5b39285 NONAME
    41. 00067a4bf5b392cf NONAME
    42. varyonvg: Volume group q05datavg is varied on.
    43. # lsvg
    44. rootvg
    45. q05datavg
    46. # lsvg -l q05datavg
    47. q05datavg:
    48. LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
    49. loglv00 jfs2log 1 2 2 closed/stale N/A
    50. dvdlv jfs2 200 400 2 closed/syncd /DVD
    51. sapmntlv jfs2 40 80 2 closed/stale /sapmnt
    52. usrsaplv jfs2 200 400 3 closed/syncd /usr/sap
    53. oraclelv jfs2 80 160 2 closed/syncd /oracle
    54. oraPRDlv jfs2 120 240 2 closed/syncd /oracle/PRD
    55. oradate1lv jfs2 6144 12288 8 closed/stale /oracle/PRD/sapdata1
    56. oradate2lv jfs2 6144 12288 10 closed/stale /oracle/PRD/sapdata2
    57. oradate3lv jfs2 1600 3200 2 closed/stale /oracle/PRD/sapdata3
    58. oradate4lv jfs2 1200 2400 2 closed/stale /oracle/PRD/sapdata4
    59. oraarchlv jfs2 800 1600 2 closed/syncd /oracle/PRD/oraarch
    60. origlogAlv jfs2 4 8 2 closed/stale /oracle/PRD/origlogA
    61. origlogBlv jfs2 4 8 2 closed/stale /oracle/PRD/origlogB
    62. mirrlogAlv jfs2 4 8 2 closed/stale /oracle/PRD/mirrlogA
    63. mirrlogBlv jfs2 4 8 2 closed/syncd /oracle/PRD/mirrlogB
    64. paging00 paging 64 128 2 closed/syncd N/A
    65. paging01 paging 80 160 2 closed/syncd N/A</code>
  4. 丢失的卷如下

    0001d23cde6a7b05 NONAME
    00067a4bf5b39357 NONAME
    00067a4bf5b39312 NONAME
    0001d23cddef5de1 NONAME
    00067a4bf5b39285 NONAME
    00067a4bf5b392cf NONAME

  5. 可以手动删除缺失的pv,略

    第二部分 数据库还原/更改SID
  6. 正常启动数据库,进行crash恢复
    1. <code>MMNL started with pid=16, OS id=13238340
    2. ORACLE_BASE from environment = /oracle
    3. Fri Jan 26 09:42:03 2018
    4. alter database mount
    5. Fri Jan 26 09:42:08 2018
    6. Successful mount of redo thread 1, with mount id 2030095339
    7. Database mounted in Exclusive Mode
    8. Lost write protection disabled
    9. Completed: alter database mount
    10. alter database open
    11. Fri Jan 26 09:42:14 2018
    12. Block change tracking file is current.
    13. Beginning crash recovery of 1 threads
    14. parallel recovery started with 7 processes
    15. Started redo scan
    16. Completed redo scan
    17. read 81129 KB redo, 17401 data blocks need recovery
    18. Fri Jan 26 09:42:26 2018
    19. Started redo application at
    20. Thread 1: logseq 452162, block 92297
    21. Recovery of Online Redo Log: Thread 1 Group 4 Seq 452162 Reading mem 0
    22. Mem# 0: /oracle/PRD/origlogB/log_g14m1.dbf
    23. Mem# 1: /oracle/PRD/mirrlogB/log_g14m2.dbf
    24. Recovery of Online Redo Log: Thread 1 Group 5 Seq 452163 Reading mem 0
    25. Mem# 0: /oracle/PRD/origlogA/log_g15m1.dbf
    26. Mem# 1: /oracle/PRD/mirrlogA/log_g15m2.dbf
    27. Completed redo application of 65.45MB
    28. Completed crash recovery at
    29. Thread 1: logseq 452163, block 62783, scn 6133924352
    30. 17401 data blocks read, 17400 data blocks written, 81129 redo k-bytes read
    31. Fri Jan 26 09:42:30 2018
    32. ...
    33. SMON: enabling tx recovery
    34. Database Characterset is UTF8
    35. No Resource Manager plan active
    36. Fri Jan 26 09:42:39 2018
    37. Starting background process QMNC
    38. Fri Jan 26 09:42:39 2018
    39. QMNC started with pid=31, OS id=30015654
    40. Completed: alter database open</code>
  7. 备份spfile并更改参数如下(重启验证再备份为pfile)
    1. <code>create pfile from spfile;
    2. aleter system set memory_max_target=24G scope=spfile;
    3. aleter system set memory_target=10G scope=spfile;
    4. aleter system set sga_max_size=5G scope=spfile;
    5. aleter system set db_cache_size=2G scope=spfile;
    6. aleter system set large_pool_size 1G scope=spfile;
    7. aleter system set shared_pool_size=2G scope=spfile;</code>
  8. 备份控制文件到trace
    1. <code>alter database backup controlfile to trace;</code>
  9. 关闭数据库更改文件系统路径(卸载状态)
    1. <code>chfs -m /oracle/Q05 /oracle/PRD
    2. chfs -m /oracle/Q05/sapdata1 /oracle/PRD/sapdata1
    3. chfs -m /oracle/Q05/sapdata2 /oracle/PRD/sapdata2
    4. chfs -m /oracle/Q05/sapdata3 /oracle/PRD/sapdata3
    5. chfs -m /oracle/Q05/sapdata4 /oracle/PRD/sapdata4
    6. chfs -m /oracle/Q05/oraarch /oracle/PRD/oraarch
    7. chfs -m /oracle/Q05/origlogA /oracle/PRD/origlogA
    8. chfs -m /oracle/Q05/origlogB /oracle/PRD/origlogB
    9. chfs -m /oracle/Q05/mirrlogA /oracle/PRD/mirrlogA
    10. chfs -m /oracle/Q05/mirrlogB /oracle/PRD/mirrlogB</code>
  10. 创建OS用户并更改环境变量,更改下面文件名并替换文件中的旧SID为新SID
    原hostname:SAPPRDA
    新hostname:ECCQASQ05
    原SID:PRD
    新SID:Q05
    1. <code>.dbenv.csh
    2. .dbenv_SAPPRDA.csh
    3. .sapenv_SAPPRDA.csh</code>
  11. 更改listener和tnsname文件中的旧SID为新SID
    目录:/oracle/SID/112_64/network/admin
  12. 更改profile文件名和里面的路径信息
    文件:/oracle/SID/112_64/dbs/initSID.ora
  13. 编辑之前的controlfile备份trace,指定新SID,最终如下:
    1. <code>STARTUP NOMOUNT
    2. CREATE CONTROLFILE set DATABASE "Q05" RESETLOGS ARCHIVELOG
    3. MAXLOGFILES 255
    4. MAXLOGMEMBERS 3
    5. MAXDATAFILES 254
    6. MAXINSTANCES 50
    7. MAXLOGHISTORY 23360
    8. LOGFILE
    9. GROUP 1 (
    10. ‘/oracle/Q05/origlogA/log_g11m1.dbf‘,
    11. ‘/oracle/Q05/mirrlogA/log_g11m2.dbf‘
    12. ) SIZE 200M BLOCKSIZE 512,
    13. GROUP 2 (
    14. ‘/oracle/Q05/origlogB/log_g12m1.dbf‘,
    15. ‘/oracle/Q05/mirrlogB/log_g12m2.dbf‘
    16. ) SIZE 200M BLOCKSIZE 512,
    17. GROUP 3 (
    18. ‘/oracle/Q05/origlogA/log_g13m1.dbf‘,
    19. ‘/oracle/Q05/mirrlogA/log_g13m2.dbf‘
    20. ) SIZE 200M BLOCKSIZE 512,
    21. GROUP 4 (
    22. ‘/oracle/Q05/origlogB/log_g14m1.dbf‘,
    23. ‘/oracle/Q05/mirrlogB/log_g14m2.dbf‘
    24. ) SIZE 200M BLOCKSIZE 512,
    25. GROUP 5 (
    26. ‘/oracle/Q05/origlogA/log_g15m1.dbf‘,
    27. ‘/oracle/Q05/mirrlogA/log_g15m2.dbf‘
    28. ) SIZE 200M BLOCKSIZE 512,
    29. GROUP 6 (
    30. ‘/oracle/Q05/origlogB/log_g16m1.dbf‘,
    31. ‘/oracle/Q05/mirrlogB/log_g16m2.dbf‘
    32. ) SIZE 200M BLOCKSIZE 512
    33. -- STANDBY LOGFILE
    34. DATAFILE
    35. ‘/oracle/Q05/sapdata1/system_1/system.data1‘,
    36. ‘/oracle/Q05/sapdata3/undo_1/undo.data1‘,
    37. ‘/oracle/Q05/sapdata1/sysaux_1/sysaux.data1‘,
    38. ‘/oracle/Q05/sapdata1/sr3_1/sr3.data1‘,
    39. ‘/oracle/Q05/sapdata1/sr3_2/sr3.data2‘,
    40. ‘/oracle/Q05/sapdata1/sr3_3/sr3.data3‘,
    41. ‘/oracle/Q05/sapdata1/sr3_4/sr3.data4‘,
    42. ‘/oracle/Q05/sapdata1/sr3_5/sr3.data5‘,
    43. ‘/oracle/Q05/sapdata2/sr3_6/sr3.data6‘,
    44. ‘/oracle/Q05/sapdata2/sr3_7/sr3.data7‘,
    45. ‘/oracle/Q05/sapdata2/sr3_8/sr3.data8‘,
    46. ‘/oracle/Q05/sapdata2/sr3_9/sr3.data9‘,
    47. ‘/oracle/Q05/sapdata2/sr3_10/sr3.data10‘,
    48. ‘/oracle/Q05/sapdata3/sr3_11/sr3.data11‘,
    49. ‘/oracle/Q05/sapdata3/sr3_12/sr3.data12‘,
    50. ‘/oracle/Q05/sapdata3/sr3_13/sr3.data13‘,
    51. ‘/oracle/Q05/sapdata3/sr3_14/sr3.data14‘,
    52. ‘/oracle/Q05/sapdata3/sr3_15/sr3.data15‘,
    53. ‘/oracle/Q05/sapdata4/sr3_16/sr3.data16‘,
    54. ‘/oracle/Q05/sapdata4/sr3_17/sr3.data17‘,
    55. ‘/oracle/Q05/sapdata4/sr3_18/sr3.data18‘,
    56. ‘/oracle/Q05/sapdata4/sr3_19/sr3.data19‘,
    57. ‘/oracle/Q05/sapdata4/sr3_20/sr3.data20‘,
    58. ‘/oracle/Q05/sapdata1/sr3700_1/sr3700.data1‘,
    59. ‘/oracle/Q05/sapdata1/sr3700_2/sr3700.data2‘,
    60. ‘/oracle/Q05/sapdata1/sr3700_3/sr3700.data3‘,
    61. ‘/oracle/Q05/sapdata1/sr3700_4/sr3700.data4‘,
    62. ‘/oracle/Q05/sapdata2/sr3700_5/sr3700.data5‘,
    63. ‘/oracle/Q05/sapdata2/sr3700_6/sr3700.data6‘,
    64. ‘/oracle/Q05/sapdata2/sr3700_7/sr3700.data7‘,
    65. ‘/oracle/Q05/sapdata2/sr3700_8/sr3700.data8‘,
    66. ‘/oracle/Q05/sapdata3/sr3700_9/sr3700.data9‘,
    67. ‘/oracle/Q05/sapdata3/sr3700_10/sr3700.data10‘,
    68. ‘/oracle/Q05/sapdata3/sr3700_11/sr3700.data11‘,
    69. ‘/oracle/Q05/sapdata3/sr3700_12/sr3700.data12‘,
    70. ‘/oracle/Q05/sapdata4/sr3700_13/sr3700.data13‘,
    71. ‘/oracle/Q05/sapdata4/sr3700_14/sr3700.data14‘,
    72. ‘/oracle/Q05/sapdata4/sr3700_15/sr3700.data15‘,
    73. ‘/oracle/Q05/sapdata4/sr3700_16/sr3700.data16‘,
    74. ‘/oracle/Q05/sapdata1/sr3usr_1/sr3usr.data1‘,
    75. ‘/oracle/Q05/sapdata4/sr3_21/sr3.data21‘,
    76. ‘/oracle/Q05/sapdata4/sr3_22/sr3.data22‘,
    77. ‘/oracle/Q05/sapdata4/sr3_23/sr3.data23‘,
    78. ‘/oracle/Q05/sapdata4/sr3_24/sr3.data24‘,
    79. ‘/oracle/Q05/sapdata1/sr3_25/sr3.data25‘,
    80. ‘/oracle/Q05/sapdata1/sr3_26/sr3.data26‘,
    81. ‘/oracle/Q05/sapdata1/sr3_27/sr3.data27‘,
    82. ‘/oracle/Q05/sapdata1/sr3_28/sr3.data28‘,
    83. ‘/oracle/Q05/sapdata2/sr3_29/sr3.data29‘,
    84. ‘/oracle/Q05/sapdata2/sr3_30/sr3.data30‘,
    85. ‘/oracle/Q05/sapdata2/sr3_31/sr3.data31‘,
    86. ‘/oracle/Q05/sapdata2/sr3_32/sr3.data32‘,
    87. ‘/oracle/Q05/sapdata3/sr3_33/sr3.data33‘,
    88. ‘/oracle/Q05/sapdata3/sr3_34/sr3.data34‘,
    89. ‘/oracle/Q05/sapdata3/sr3_35/sr3.data35‘,
    90. ‘/oracle/Q05/sapdata3/sr3_36/sr3.data36‘,
    91. ‘/oracle/Q05/sapdata3/sr3_37/sr3.data37‘,
    92. ‘/oracle/Q05/sapdata3/sr3_38/sr3.data38‘,
    93. ‘/oracle/Q05/sapdata3/sr3_39/sr3.data39‘,
    94. ‘/oracle/Q05/sapdata3/sr3_40/sr3.data40‘,
    95. ‘/oracle/Q05/sapdata3/sr3_41/sr3.data41‘,
    96. ‘/oracle/Q05/sapdata3/sr3_42/sr3.data42‘,
    97. ‘/oracle/Q05/sapdata3/sr3_43/sr3.data43‘,
    98. ‘/oracle/Q05/sapdata3/sr3_44/sr3.data44‘,
    99. ‘/oracle/Q05/sapdata1/sr3_45/sr3.data45‘,
    100. ‘/oracle/Q05/sapdata1/sr3_46/sr3.data46‘,
    101. ‘/oracle/Q05/sapdata1/sr3_47/sr3.data47‘,
    102. ‘/oracle/Q05/sapdata1/sr3_48/sr3.data48‘,
    103. ‘/oracle/Q05/sapdata1/sr3_49/sr3.data49‘,
    104. ‘/oracle/Q05/sapdata1/sysaux_2/sysaux.data2‘,
    105. ‘/oracle/Q05/sapdata1/sr3_50/sr3.data50‘,
    106. ‘/oracle/Q05/sapdata1/sr3_51/sr3.data51‘,
    107. ‘/oracle/Q05/sapdata1/sr3_52/sr3.data52‘,
    108. ‘/oracle/Q05/sapdata1/sr3_53/sr3.data53‘,
    109. ‘/oracle/Q05/sapdata1/sr3_54/sr3.data54‘,
    110. ‘/oracle/Q05/sapdata1/sr3_55/sr3.data55‘,
    111. ‘/oracle/Q05/sapdata1/sr3_56/sr3.data56‘,
    112. ‘/oracle/Q05/sapdata1/sr3_57/sr3.data57‘,
    113. ‘/oracle/Q05/sapdata1/sr3_58/sr3.data58‘,
    114. ‘/oracle/Q05/sapdata1/sr3_59/sr3.data59‘,
    115. ‘/oracle/Q05/sapdata1/sr3_60/sr3.data60‘,
    116. ‘/oracle/Q05/sapdata1/sr3_61/sr3.data61‘,
    117. ‘/oracle/Q05/sapdata1/sr3_62/sr3.data62‘,
    118. ‘/oracle/Q05/sapdata1/sr3_63/sr3.data63‘,
    119. ‘/oracle/Q05/sapdata1/sr3_64/sr3.data64‘,
    120. ‘/oracle/Q05/sapdata1/sr3_65/sr3.data65‘,
    121. ‘/oracle/Q05/sapdata1/sr3_66/sr3.data66‘,
    122. ‘/oracle/Q05/sapdata1/sr3_67/sr3.data67‘,
    123. ‘/oracle/Q05/sapdata1/sr3_68/sr3.data68‘,
    124. ‘/oracle/Q05/sapdata1/sr3_69/sr3.data69‘,
    125. ‘/oracle/Q05/sapdata1/sr3_70/sr3.data70‘,
    126. ‘/oracle/Q05/sapdata1/sr3_71/sr3.data71‘,
    127. ‘/oracle/Q05/sapdata1/sr3_72/sr3.data72‘,
    128. ‘/oracle/Q05/sapdata1/sr3_73/sr3.data73‘,
    129. ‘/oracle/Q05/sapdata1/sr3_74/sr3.data74‘,
    130. ‘/oracle/Q05/sapdata1/sr3_75/sr3.data75‘,
    131. ‘/oracle/Q05/sapdata1/sr3_76/sr3.data76‘,
    132. ‘/oracle/Q05/sapdata1/sr3_77/sr3.data77‘,
    133. ‘/oracle/Q05/sapdata1/sr3_78/sr3.data78‘,
    134. ‘/oracle/Q05/sapdata1/sr3_79/sr3.data79‘,
    135. ‘/oracle/Q05/sapdata1/sr3usr_2/sr3usr.data2‘,
    136. ‘/oracle/Q05/sapdata1/sr3_80/sr3.data80‘,
    137. ‘/oracle/Q05/sapdata1/sr3_81/sr3.data81‘,
    138. ‘/oracle/Q05/sapdata1/sr3_82/sr3.data82‘,
    139. ‘/oracle/Q05/sapdata1/sr3_83/sr3.data83‘,
    140. ‘/oracle/Q05/sapdata1/sr3_84/sr3.data84‘,
    141. ‘/oracle/Q05/sapdata1/sr3_85/sr3.data85‘,
    142. ‘/oracle/Q05/sapdata1/sr3_86/sr3.data86‘,
    143. ‘/oracle/Q05/sapdata1/sr3_87/sr3.data87‘,
    144. ‘/oracle/Q05/sapdata1/sr3_88/sr3.data88‘,
    145. ‘/oracle/Q05/sapdata1/sr3_89/sr3.data89‘,
    146. ‘/oracle/Q05/sapdata1/sr3_90/sr3.data90‘,
    147. ‘/oracle/Q05/sapdata1/sr3_91/sr3.data91‘,
    148. ‘/oracle/Q05/sapdata1/sr3_92/sr3.data92‘,
    149. ‘/oracle/Q05/sapdata1/sr3_93/sr3.data93‘,
    150. ‘/oracle/Q05/sapdata1/sr3_94/sr3.data94‘,
    151. ‘/oracle/Q05/sapdata1/sr3_95/sr3.data95‘,
    152. ‘/oracle/Q05/sapdata1/sr3_96/sr3.data96‘,
    153. ‘/oracle/Q05/sapdata1/sr3_97/sr3.data97‘,
    154. ‘/oracle/Q05/sapdata1/sr3_98/sr3.data98‘,
    155. ‘/oracle/Q05/sapdata1/sr3_99/sr3.data99‘,
    156. ‘/oracle/Q05/sapdata1/sr3_100/sr3.data100‘,
    157. ‘/oracle/Q05/sapdata1/sr3_101/sr3.data101‘,
    158. ‘/oracle/Q05/sapdata1/sr3_102/sr3.data102‘,
    159. ‘/oracle/Q05/sapdata1/sr3_103/sr3.data103‘,
    160. ‘/oracle/Q05/sapdata1/sr3_104/sr3.data104‘,
    161. ‘/oracle/Q05/sapdata1/sr3_105/sr3.data105‘,
    162. ‘/oracle/Q05/sapdata1/sr3_106/sr3.data106‘,
    163. ‘/oracle/Q05/sapdata1/sr3_107/sr3.data107‘,
    164. ‘/oracle/Q05/sapdata1/sr3_108/sr3.data108‘,
    165. ‘/oracle/Q05/sapdata1/sr3_109/sr3.data109‘,
    166. ‘/oracle/Q05/sapdata1/sr3_110/sr3.data110‘,
    167. ‘/oracle/Q05/sapdata1/sr3_111/sr3.data111‘,
    168. ‘/oracle/Q05/sapdata1/sr3_112/sr3.data112‘,
    169. ‘/oracle/Q05/sapdata1/sr3_113/sr3.data113‘,
    170. ‘/oracle/Q05/sapdata1/sr3_114/sr3.data114‘,
    171. ‘/oracle/Q05/sapdata4/sr3700_17/sr3700.data17‘,
    172. ‘/oracle/Q05/sapdata4/sr3700_18/sr3700.data18‘,
    173. ‘/oracle/Q05/sapdata4/sr3700_19/sr3700.data19‘,
    174. ‘/oracle/Q05/sapdata4/sr3700_20/sr3700.data20‘,
    175. ‘/oracle/Q05/sapdata4/sr3700_21/sr3700.data21‘,
    176. ‘/oracle/Q05/sapdata4/sr3700_22/sr3700.data22‘,
    177. ‘/oracle/Q05/sapdata4/sr3700_23/sr3700.data23‘,
    178. ‘/oracle/Q05/sapdata1/system_2/system.data2‘,
    179. ‘/oracle/Q05/sapdata1/sr3_115/sr3.data115‘,
    180. ‘/oracle/Q05/sapdata1/sr3_116/sr3.data116‘,
    181. ‘/oracle/Q05/sapdata1/sr3_117/sr3.data117‘,
    182. ‘/oracle/Q05/sapdata1/sr3_118/sr3.data118‘,
    183. ‘/oracle/Q05/sapdata1/sr3_119/sr3.data119‘,
    184. ‘/oracle/Q05/sapdata1/sr3_120/sr3.data120‘,
    185. ‘/oracle/Q05/sapdata2/sr3_121/sr3.data121‘,
    186. ‘/oracle/Q05/sapdata2/sr3_122/sr3.data122‘,
    187. ‘/oracle/Q05/sapdata2/sr3_123/sr3.data123‘,
    188. ‘/oracle/Q05/sapdata2/sr3_124/sr3.data124‘,
    189. ‘/oracle/Q05/sapdata2/sr3_125/sr3.data125‘,
    190. ‘/oracle/Q05/sapdata2/sr3_126/sr3.data126‘,
    191. ‘/oracle/Q05/sapdata2/sr3_127/sr3.data127‘,
    192. ‘/oracle/Q05/sapdata2/sr3_128/sr3.data128‘,
    193. ‘/oracle/Q05/sapdata2/sr3_129/sr3.data129‘,
    194. ‘/oracle/Q05/sapdata2/sr3_130/sr3.data130‘,
    195. ‘/oracle/Q05/sapdata2/sr3_131/sr3.data131‘,
    196. ‘/oracle/Q05/sapdata2/sr3_132/sr3.data132‘,
    197. ‘/oracle/Q05/sapdata2/sr3_133/sr3.data133‘,
    198. ‘/oracle/Q05/sapdata2/sr3_134/sr3.data134‘,
    199. ‘/oracle/Q05/sapdata2/sr3_135/sr3.data135‘,
    200. ‘/oracle/Q05/sapdata2/sr3_136/sr3.data136‘,
    201. ‘/oracle/Q05/sapdata2/sr3_137/sr3.data137‘,
    202. ‘/oracle/Q05/sapdata2/sr3_138/sr3.data138‘,
    203. ‘/oracle/Q05/sapdata2/sr3_138/sr3.data139‘,
    204. ‘/oracle/Q05/sapdata2/sr3_140/sr3.data140‘,
    205. ‘/oracle/Q05/sapdata2/sr3_141/sr3.data141‘,
    206. ‘/oracle/Q05/sapdata2/sr3_142/sr3.data142‘,
    207. ‘/oracle/Q05/sapdata2/sr3_142/sr3.data143‘,
    208. ‘/oracle/Q05/sapdata2/sr3_144/sr3.data144‘,
    209. ‘/oracle/Q05/sapdata2/sr3_145/sr3.data145‘,
    210. ‘/oracle/Q05/sapdata2/sr3_146/sr3.data146‘,
    211. ‘/oracle/Q05/sapdata2/sr3_147/sr3.data147‘,
    212. ‘/oracle/Q05/sapdata2/sr3_148/sr3.data148‘,
    213. ‘/oracle/Q05/sapdata2/sr3_149/sr3.data149‘,
    214. ‘/oracle/Q05/sapdata2/sr3_150/sr3.data150‘,
    215. ‘/oracle/Q05/sapdata2/sr3_151/sr3.data151‘,
    216. ‘/oracle/Q05/sapdata2/sr3_152/sr3.data152‘
    217. CHARACTER SET UTF8
    218. ;
    219. ALTER DATABASE OPEN RESETLOGS;
    220. ALTER TABLESPACE PSAPTEMP ADD TEMPFILE ‘/oracle/Q05/sapdata2/temp_1/temp.data1‘ REUSE;</code>
  14. 运行sql
    1. <code>
    2. SQL> @control.sql
    3. ORACLE instance started.</code>

Total System Global Area 5394989056 bytes
Fixed Size 2229080 bytes
Variable Size 3238005928 bytes
Database Buffers 2147483648 bytes
Redo Buffers 7270400 bytes

Control file created.

  1. <code>> 习惯手动运行最后两条命令 </code>

SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE ‘/oracle/Q05/sapdata2/temp_1/temp.data1‘ REUSE;

Tablespace altered.

SQL> show parameter name;

NAME TYPE VALUE


db_file_name_convert string
db_name string Q05
db_unique_name string Q05
global_names boolean FALSE
instance_name string Q05
lock_name_space string
log_file_name_convert string
service_names string Q05

  1. <code>
  2. 10. 恢复并更改SID完毕。
  3. ###### 第三部分 BASIS</code>

SAP系统拷贝-ORACLE更改SID

标签:def   sse   crash   重启   smon   round   --   code   usr   

人气教程排行