SAP系統拷貝-ORACLE更改SID

標籤：def   sse   crash   重啟   smon   round   --   code   usr   

ECCPRD TO Q05系統拷貝 2018.01.25第一部分 V7000儲存進行儲存LUN拷貝

1. 使用一致性組進行LUN複製
2. 將複製卷映射到新主機
3. 在新主機上強制匯入卷組，因為AIX鏡像丟失，無法正常匯入卷組，需要加上-f參數

   # importvg -y q05datavg -f hdisk11PV Status:      hdisk11 00067a4b2d12e06f        PVACTIVE            hdisk12 00067a4b7901a384        PVACTIVE            hdisk13 00067a4b7901a3d6        PVACTIVE            hdisk14 00067a4b7901a429        PVACTIVE            hdisk15 0001d23cddef5ee6        PVACTIVE            hdisk16 0001d23cde6afe3a        PVACTIVE                    0001d23cde6a7b05        NONAME                    00067a4bf5b39357        NONAME                    00067a4bf5b39312        NONAME                    0001d23cddef5de1        NONAME                    00067a4bf5b39285        NONAME                    00067a4bf5b392cf        NONAMEvaryonvg: Volume group q05datavg is varied on.0516-510 synclvodm: Physical volume not found for physical volume    identifier 00067a4bf5b392850000000000000000.0516-510 synclvodm: Physical volume not found for physical volume    identifier 00067a4bf5b392cf0000000000000000.0516-510 synclvodm: Physical volume not found for physical volume    identifier 00067a4bf5b393120000000000000000.0516-510 synclvodm: Physical volume not found for physical volume    identifier 00067a4bf5b393570000000000000000.0516-510 synclvodm: Physical volume not found for physical volume    identifier 0001d23cddef5de10000000000000000.0516-510 synclvodm: Physical volume not found for physical volume    identifier 0001d23cde6a7b050000000000000000.0516-548 synclvodm: Partially successful with updating volume    group q05datavg.q05datavgPV Status:      hdisk12 00067a4b7901a384        PVACTIVE            hdisk13 00067a4b7901a3d6        PVACTIVE            hdisk14 00067a4b7901a429        PVACTIVE            hdisk11 00067a4b2d12e06f        PVACTIVE            hdisk15 0001d23cddef5ee6        PVACTIVE            hdisk16 0001d23cde6afe3a        PVACTIVE                    0001d23cde6a7b05        NONAME                    00067a4bf5b39357        NONAME                    00067a4bf5b39312        NONAME                    0001d23cddef5de1        NONAME                    00067a4bf5b39285        NONAME                    00067a4bf5b392cf        NONAMEvaryonvg: Volume group q05datavg is varied on.# lsvgrootvgq05datavg# lsvg -l q05datavgq05datavg:LV NAME             TYPE       LPs     PPs     PVs  LV STATE      MOUNT POINTloglv00             jfs2log    1       2       2    closed/stale  N/Advdlv               jfs2       200     400     2    closed/syncd  /DVDsapmntlv            jfs2       40      80      2    closed/stale  /sapmntusrsaplv            jfs2       200     400     3    closed/syncd  /usr/saporaclelv            jfs2       80      160     2    closed/syncd  /oracleoraPRDlv            jfs2       120     240     2    closed/syncd  /oracle/PRDoradate1lv          jfs2       6144    12288   8    closed/stale  /oracle/PRD/sapdata1oradate2lv          jfs2       6144    12288   10   closed/stale  /oracle/PRD/sapdata2oradate3lv          jfs2       1600    3200    2    closed/stale  /oracle/PRD/sapdata3oradate4lv          jfs2       1200    2400    2    closed/stale  /oracle/PRD/sapdata4oraarchlv           jfs2       800     1600    2    closed/syncd  /oracle/PRD/oraarchoriglogAlv          jfs2       4       8       2    closed/stale  /oracle/PRD/origlogAoriglogBlv          jfs2       4       8       2    closed/stale  /oracle/PRD/origlogBmirrlogAlv          jfs2       4       8       2    closed/stale  /oracle/PRD/mirrlogAmirrlogBlv          jfs2       4       8       2    closed/syncd  /oracle/PRD/mirrlogBpaging00            paging     64      128     2    closed/syncd  N/Apaging01            paging     80      160     2    closed/syncd  N/A

4. 丟失的卷如下

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

5. 可以手動刪除缺失的pv，略

   第二部分 資料庫還原/更改SID
6. 正常啟動資料庫，進行crash恢複

   MMNL started with pid=16, OS id=13238340ORACLE_BASE from environment = /oracleFri Jan 26 09:42:03 2018alter database mountFri Jan 26 09:42:08 2018Successful mount of redo thread 1, with mount id 2030095339Database mounted in Exclusive ModeLost write protection disabledCompleted: alter database mountalter database openFri Jan 26 09:42:14 2018Block change tracking file is current.Beginning crash recovery of 1 threadsparallel recovery started with 7 processesStarted redo scanCompleted redo scanread 81129 KB redo, 17401 data blocks need recoveryFri Jan 26 09:42:26 2018Started redo application atThread 1: logseq 452162, block 92297Recovery of Online Redo Log: Thread 1 Group 4 Seq 452162 Reading mem 0Mem# 0: /oracle/PRD/origlogB/log_g14m1.dbfMem# 1: /oracle/PRD/mirrlogB/log_g14m2.dbfRecovery of Online Redo Log: Thread 1 Group 5 Seq 452163 Reading mem 0Mem# 0: /oracle/PRD/origlogA/log_g15m1.dbfMem# 1: /oracle/PRD/mirrlogA/log_g15m2.dbfCompleted redo application of 65.45MBCompleted crash recovery atThread 1: logseq 452163, block 62783, scn 613392435217401 data blocks read, 17400 data blocks written, 81129 redo k-bytes readFri Jan 26 09:42:30 2018...SMON: enabling tx recoveryDatabase Characterset is UTF8No Resource Manager plan activeFri Jan 26 09:42:39 2018Starting background process QMNCFri Jan 26 09:42:39 2018QMNC started with pid=31, OS id=30015654Completed: alter database open

7. 備份spfile並更改參數如下（重啟驗證再備份為pfile）

   create pfile from spfile;aleter system set memory_max_target=24G scope=spfile;aleter system set memory_target=10G scope=spfile;aleter system set sga_max_size=5G scope=spfile;aleter system set db_cache_size=2G scope=spfile;aleter system set large_pool_size 1G scope=spfile;aleter system set shared_pool_size=2G scope=spfile;

8. 備份控制檔案到trace

   alter database backup controlfile to trace;

9. 關閉資料庫變更檔系統路徑(卸載狀態)

   chfs -m /oracle/Q05 /oracle/PRDchfs -m /oracle/Q05/sapdata1 /oracle/PRD/sapdata1chfs -m /oracle/Q05/sapdata2 /oracle/PRD/sapdata2chfs -m /oracle/Q05/sapdata3 /oracle/PRD/sapdata3chfs -m /oracle/Q05/sapdata4 /oracle/PRD/sapdata4chfs -m /oracle/Q05/oraarch /oracle/PRD/oraarchchfs -m /oracle/Q05/origlogA /oracle/PRD/origlogAchfs -m /oracle/Q05/origlogB /oracle/PRD/origlogBchfs -m /oracle/Q05/mirrlogA /oracle/PRD/mirrlogAchfs -m /oracle/Q05/mirrlogB /oracle/PRD/mirrlogB

10. 建立OS使用者並更改環境變數，更改下面檔案名稱並替換檔案中的舊SID為新SID
    原hostname：SAPPRDA
    新hostname：ECCQASQ05
    原SID：PRD
    新SID：Q05

    .dbenv.csh.dbenv_SAPPRDA.csh.sapenv_SAPPRDA.csh

11. 更改listener和tnsname檔案中的舊SID為新SID
    目錄：/oracle/SID/112_64/network/admin
12. 更改profile檔案名稱和裡面的路徑資訊
    檔案：/oracle/SID/112_64/dbs/initSID.ora
13. 編輯之前的controlfile備份trace，指定新SID，最終如下：

    STARTUP NOMOUNTCREATE CONTROLFILE set DATABASE "Q05" RESETLOGS  ARCHIVELOGMAXLOGFILES 255MAXLOGMEMBERS 3MAXDATAFILES 254MAXINSTANCES 50MAXLOGHISTORY 23360LOGFILEGROUP 1 (‘/oracle/Q05/origlogA/log_g11m1.dbf‘,‘/oracle/Q05/mirrlogA/log_g11m2.dbf‘) SIZE 200M BLOCKSIZE 512,GROUP 2 (‘/oracle/Q05/origlogB/log_g12m1.dbf‘,‘/oracle/Q05/mirrlogB/log_g12m2.dbf‘) SIZE 200M BLOCKSIZE 512,GROUP 3 (‘/oracle/Q05/origlogA/log_g13m1.dbf‘,‘/oracle/Q05/mirrlogA/log_g13m2.dbf‘) SIZE 200M BLOCKSIZE 512,GROUP 4 (‘/oracle/Q05/origlogB/log_g14m1.dbf‘,‘/oracle/Q05/mirrlogB/log_g14m2.dbf‘) SIZE 200M BLOCKSIZE 512,GROUP 5 (‘/oracle/Q05/origlogA/log_g15m1.dbf‘,‘/oracle/Q05/mirrlogA/log_g15m2.dbf‘) SIZE 200M BLOCKSIZE 512,GROUP 6 (‘/oracle/Q05/origlogB/log_g16m1.dbf‘,‘/oracle/Q05/mirrlogB/log_g16m2.dbf‘) SIZE 200M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE‘/oracle/Q05/sapdata1/system_1/system.data1‘,‘/oracle/Q05/sapdata3/undo_1/undo.data1‘,‘/oracle/Q05/sapdata1/sysaux_1/sysaux.data1‘,‘/oracle/Q05/sapdata1/sr3_1/sr3.data1‘,‘/oracle/Q05/sapdata1/sr3_2/sr3.data2‘,‘/oracle/Q05/sapdata1/sr3_3/sr3.data3‘,‘/oracle/Q05/sapdata1/sr3_4/sr3.data4‘,‘/oracle/Q05/sapdata1/sr3_5/sr3.data5‘,‘/oracle/Q05/sapdata2/sr3_6/sr3.data6‘,‘/oracle/Q05/sapdata2/sr3_7/sr3.data7‘,‘/oracle/Q05/sapdata2/sr3_8/sr3.data8‘,‘/oracle/Q05/sapdata2/sr3_9/sr3.data9‘,‘/oracle/Q05/sapdata2/sr3_10/sr3.data10‘,‘/oracle/Q05/sapdata3/sr3_11/sr3.data11‘,‘/oracle/Q05/sapdata3/sr3_12/sr3.data12‘,‘/oracle/Q05/sapdata3/sr3_13/sr3.data13‘,‘/oracle/Q05/sapdata3/sr3_14/sr3.data14‘,‘/oracle/Q05/sapdata3/sr3_15/sr3.data15‘,‘/oracle/Q05/sapdata4/sr3_16/sr3.data16‘,‘/oracle/Q05/sapdata4/sr3_17/sr3.data17‘,‘/oracle/Q05/sapdata4/sr3_18/sr3.data18‘,‘/oracle/Q05/sapdata4/sr3_19/sr3.data19‘,‘/oracle/Q05/sapdata4/sr3_20/sr3.data20‘,‘/oracle/Q05/sapdata1/sr3700_1/sr3700.data1‘,‘/oracle/Q05/sapdata1/sr3700_2/sr3700.data2‘,‘/oracle/Q05/sapdata1/sr3700_3/sr3700.data3‘,‘/oracle/Q05/sapdata1/sr3700_4/sr3700.data4‘,‘/oracle/Q05/sapdata2/sr3700_5/sr3700.data5‘,‘/oracle/Q05/sapdata2/sr3700_6/sr3700.data6‘,‘/oracle/Q05/sapdata2/sr3700_7/sr3700.data7‘,‘/oracle/Q05/sapdata2/sr3700_8/sr3700.data8‘,‘/oracle/Q05/sapdata3/sr3700_9/sr3700.data9‘,‘/oracle/Q05/sapdata3/sr3700_10/sr3700.data10‘,‘/oracle/Q05/sapdata3/sr3700_11/sr3700.data11‘,‘/oracle/Q05/sapdata3/sr3700_12/sr3700.data12‘,‘/oracle/Q05/sapdata4/sr3700_13/sr3700.data13‘,‘/oracle/Q05/sapdata4/sr3700_14/sr3700.data14‘,‘/oracle/Q05/sapdata4/sr3700_15/sr3700.data15‘,‘/oracle/Q05/sapdata4/sr3700_16/sr3700.data16‘,‘/oracle/Q05/sapdata1/sr3usr_1/sr3usr.data1‘,‘/oracle/Q05/sapdata4/sr3_21/sr3.data21‘,‘/oracle/Q05/sapdata4/sr3_22/sr3.data22‘,‘/oracle/Q05/sapdata4/sr3_23/sr3.data23‘,‘/oracle/Q05/sapdata4/sr3_24/sr3.data24‘,‘/oracle/Q05/sapdata1/sr3_25/sr3.data25‘,‘/oracle/Q05/sapdata1/sr3_26/sr3.data26‘,‘/oracle/Q05/sapdata1/sr3_27/sr3.data27‘,‘/oracle/Q05/sapdata1/sr3_28/sr3.data28‘,‘/oracle/Q05/sapdata2/sr3_29/sr3.data29‘,‘/oracle/Q05/sapdata2/sr3_30/sr3.data30‘,‘/oracle/Q05/sapdata2/sr3_31/sr3.data31‘,‘/oracle/Q05/sapdata2/sr3_32/sr3.data32‘,‘/oracle/Q05/sapdata3/sr3_33/sr3.data33‘,‘/oracle/Q05/sapdata3/sr3_34/sr3.data34‘,‘/oracle/Q05/sapdata3/sr3_35/sr3.data35‘,‘/oracle/Q05/sapdata3/sr3_36/sr3.data36‘,‘/oracle/Q05/sapdata3/sr3_37/sr3.data37‘,‘/oracle/Q05/sapdata3/sr3_38/sr3.data38‘,‘/oracle/Q05/sapdata3/sr3_39/sr3.data39‘,‘/oracle/Q05/sapdata3/sr3_40/sr3.data40‘,‘/oracle/Q05/sapdata3/sr3_41/sr3.data41‘,‘/oracle/Q05/sapdata3/sr3_42/sr3.data42‘,‘/oracle/Q05/sapdata3/sr3_43/sr3.data43‘,‘/oracle/Q05/sapdata3/sr3_44/sr3.data44‘,‘/oracle/Q05/sapdata1/sr3_45/sr3.data45‘,‘/oracle/Q05/sapdata1/sr3_46/sr3.data46‘,‘/oracle/Q05/sapdata1/sr3_47/sr3.data47‘,‘/oracle/Q05/sapdata1/sr3_48/sr3.data48‘,‘/oracle/Q05/sapdata1/sr3_49/sr3.data49‘,‘/oracle/Q05/sapdata1/sysaux_2/sysaux.data2‘,‘/oracle/Q05/sapdata1/sr3_50/sr3.data50‘,‘/oracle/Q05/sapdata1/sr3_51/sr3.data51‘,‘/oracle/Q05/sapdata1/sr3_52/sr3.data52‘,‘/oracle/Q05/sapdata1/sr3_53/sr3.data53‘,‘/oracle/Q05/sapdata1/sr3_54/sr3.data54‘,‘/oracle/Q05/sapdata1/sr3_55/sr3.data55‘,‘/oracle/Q05/sapdata1/sr3_56/sr3.data56‘,‘/oracle/Q05/sapdata1/sr3_57/sr3.data57‘,‘/oracle/Q05/sapdata1/sr3_58/sr3.data58‘,‘/oracle/Q05/sapdata1/sr3_59/sr3.data59‘,‘/oracle/Q05/sapdata1/sr3_60/sr3.data60‘,‘/oracle/Q05/sapdata1/sr3_61/sr3.data61‘,‘/oracle/Q05/sapdata1/sr3_62/sr3.data62‘,‘/oracle/Q05/sapdata1/sr3_63/sr3.data63‘,‘/oracle/Q05/sapdata1/sr3_64/sr3.data64‘,‘/oracle/Q05/sapdata1/sr3_65/sr3.data65‘,‘/oracle/Q05/sapdata1/sr3_66/sr3.data66‘,‘/oracle/Q05/sapdata1/sr3_67/sr3.data67‘,‘/oracle/Q05/sapdata1/sr3_68/sr3.data68‘,‘/oracle/Q05/sapdata1/sr3_69/sr3.data69‘,‘/oracle/Q05/sapdata1/sr3_70/sr3.data70‘,‘/oracle/Q05/sapdata1/sr3_71/sr3.data71‘,‘/oracle/Q05/sapdata1/sr3_72/sr3.data72‘,‘/oracle/Q05/sapdata1/sr3_73/sr3.data73‘,‘/oracle/Q05/sapdata1/sr3_74/sr3.data74‘,‘/oracle/Q05/sapdata1/sr3_75/sr3.data75‘,‘/oracle/Q05/sapdata1/sr3_76/sr3.data76‘,‘/oracle/Q05/sapdata1/sr3_77/sr3.data77‘,‘/oracle/Q05/sapdata1/sr3_78/sr3.data78‘,‘/oracle/Q05/sapdata1/sr3_79/sr3.data79‘,‘/oracle/Q05/sapdata1/sr3usr_2/sr3usr.data2‘,‘/oracle/Q05/sapdata1/sr3_80/sr3.data80‘,‘/oracle/Q05/sapdata1/sr3_81/sr3.data81‘,‘/oracle/Q05/sapdata1/sr3_82/sr3.data82‘,‘/oracle/Q05/sapdata1/sr3_83/sr3.data83‘,‘/oracle/Q05/sapdata1/sr3_84/sr3.data84‘,‘/oracle/Q05/sapdata1/sr3_85/sr3.data85‘,‘/oracle/Q05/sapdata1/sr3_86/sr3.data86‘,‘/oracle/Q05/sapdata1/sr3_87/sr3.data87‘,‘/oracle/Q05/sapdata1/sr3_88/sr3.data88‘,‘/oracle/Q05/sapdata1/sr3_89/sr3.data89‘,‘/oracle/Q05/sapdata1/sr3_90/sr3.data90‘,‘/oracle/Q05/sapdata1/sr3_91/sr3.data91‘,‘/oracle/Q05/sapdata1/sr3_92/sr3.data92‘,‘/oracle/Q05/sapdata1/sr3_93/sr3.data93‘,‘/oracle/Q05/sapdata1/sr3_94/sr3.data94‘,‘/oracle/Q05/sapdata1/sr3_95/sr3.data95‘,‘/oracle/Q05/sapdata1/sr3_96/sr3.data96‘,‘/oracle/Q05/sapdata1/sr3_97/sr3.data97‘,‘/oracle/Q05/sapdata1/sr3_98/sr3.data98‘,‘/oracle/Q05/sapdata1/sr3_99/sr3.data99‘,‘/oracle/Q05/sapdata1/sr3_100/sr3.data100‘,‘/oracle/Q05/sapdata1/sr3_101/sr3.data101‘,‘/oracle/Q05/sapdata1/sr3_102/sr3.data102‘,‘/oracle/Q05/sapdata1/sr3_103/sr3.data103‘,‘/oracle/Q05/sapdata1/sr3_104/sr3.data104‘,‘/oracle/Q05/sapdata1/sr3_105/sr3.data105‘,‘/oracle/Q05/sapdata1/sr3_106/sr3.data106‘,‘/oracle/Q05/sapdata1/sr3_107/sr3.data107‘,‘/oracle/Q05/sapdata1/sr3_108/sr3.data108‘,‘/oracle/Q05/sapdata1/sr3_109/sr3.data109‘,‘/oracle/Q05/sapdata1/sr3_110/sr3.data110‘,‘/oracle/Q05/sapdata1/sr3_111/sr3.data111‘,‘/oracle/Q05/sapdata1/sr3_112/sr3.data112‘,‘/oracle/Q05/sapdata1/sr3_113/sr3.data113‘,‘/oracle/Q05/sapdata1/sr3_114/sr3.data114‘,‘/oracle/Q05/sapdata4/sr3700_17/sr3700.data17‘,‘/oracle/Q05/sapdata4/sr3700_18/sr3700.data18‘,‘/oracle/Q05/sapdata4/sr3700_19/sr3700.data19‘,‘/oracle/Q05/sapdata4/sr3700_20/sr3700.data20‘,‘/oracle/Q05/sapdata4/sr3700_21/sr3700.data21‘,‘/oracle/Q05/sapdata4/sr3700_22/sr3700.data22‘,‘/oracle/Q05/sapdata4/sr3700_23/sr3700.data23‘,‘/oracle/Q05/sapdata1/system_2/system.data2‘,‘/oracle/Q05/sapdata1/sr3_115/sr3.data115‘,‘/oracle/Q05/sapdata1/sr3_116/sr3.data116‘,‘/oracle/Q05/sapdata1/sr3_117/sr3.data117‘,‘/oracle/Q05/sapdata1/sr3_118/sr3.data118‘,‘/oracle/Q05/sapdata1/sr3_119/sr3.data119‘,‘/oracle/Q05/sapdata1/sr3_120/sr3.data120‘,‘/oracle/Q05/sapdata2/sr3_121/sr3.data121‘,‘/oracle/Q05/sapdata2/sr3_122/sr3.data122‘,‘/oracle/Q05/sapdata2/sr3_123/sr3.data123‘,‘/oracle/Q05/sapdata2/sr3_124/sr3.data124‘,‘/oracle/Q05/sapdata2/sr3_125/sr3.data125‘,‘/oracle/Q05/sapdata2/sr3_126/sr3.data126‘,‘/oracle/Q05/sapdata2/sr3_127/sr3.data127‘,‘/oracle/Q05/sapdata2/sr3_128/sr3.data128‘,‘/oracle/Q05/sapdata2/sr3_129/sr3.data129‘,‘/oracle/Q05/sapdata2/sr3_130/sr3.data130‘,‘/oracle/Q05/sapdata2/sr3_131/sr3.data131‘,‘/oracle/Q05/sapdata2/sr3_132/sr3.data132‘,‘/oracle/Q05/sapdata2/sr3_133/sr3.data133‘,‘/oracle/Q05/sapdata2/sr3_134/sr3.data134‘,‘/oracle/Q05/sapdata2/sr3_135/sr3.data135‘,‘/oracle/Q05/sapdata2/sr3_136/sr3.data136‘,‘/oracle/Q05/sapdata2/sr3_137/sr3.data137‘,‘/oracle/Q05/sapdata2/sr3_138/sr3.data138‘,‘/oracle/Q05/sapdata2/sr3_138/sr3.data139‘,‘/oracle/Q05/sapdata2/sr3_140/sr3.data140‘,‘/oracle/Q05/sapdata2/sr3_141/sr3.data141‘,‘/oracle/Q05/sapdata2/sr3_142/sr3.data142‘,‘/oracle/Q05/sapdata2/sr3_142/sr3.data143‘,‘/oracle/Q05/sapdata2/sr3_144/sr3.data144‘,‘/oracle/Q05/sapdata2/sr3_145/sr3.data145‘,‘/oracle/Q05/sapdata2/sr3_146/sr3.data146‘,‘/oracle/Q05/sapdata2/sr3_147/sr3.data147‘,‘/oracle/Q05/sapdata2/sr3_148/sr3.data148‘,‘/oracle/Q05/sapdata2/sr3_149/sr3.data149‘,‘/oracle/Q05/sapdata2/sr3_150/sr3.data150‘,‘/oracle/Q05/sapdata2/sr3_151/sr3.data151‘,‘/oracle/Q05/sapdata2/sr3_152/sr3.data152‘CHARACTER SET UTF8;ALTER DATABASE OPEN RESETLOGS;ALTER TABLESPACE PSAPTEMP ADD TEMPFILE ‘/oracle/Q05/sapdata2/temp_1/temp.data1‘ REUSE;

14. 運行sql

    SQL> @control.sqlORACLE instance started.

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.

> 習慣手動運行最後兩條命令  

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

10. 恢複並更改SID完畢。  ###### 第三部分 BASIS

SAP系統拷貝-ORACLE更改SID