SAP系统拷贝-ORACLE更改SID

1397535668

STARTUP NOMOUNT　　CREATE CONTROLFILE set DATABASE "Q05" RESETLOGS  ARCHIVELOG
　　MAXLOGFILES 255
　　MAXLOGMEMBERS 3
　　MAXDATAFILES 254
　　MAXINSTANCES 50
　　MAXLOGHISTORY 23360
　　LOGFILE
　　GROUP 1 (
　　'/oracle/Q05/origlogA/log_g11m1.dbf',
　　'/oracle/Q05/mirrlogA/log_g11m2.dbf'

　　)>　　GROUP 2 (
　　'/oracle/Q05/origlogB/log_g12m1.dbf',
　　'/oracle/Q05/mirrlogB/log_g12m2.dbf'

　　)>　　GROUP 3 (
　　'/oracle/Q05/origlogA/log_g13m1.dbf',
　　'/oracle/Q05/mirrlogA/log_g13m2.dbf'

　　)>　　GROUP 4 (
　　'/oracle/Q05/origlogB/log_g14m1.dbf',
　　'/oracle/Q05/mirrlogB/log_g14m2.dbf'

　　)>　　GROUP 5 (
　　'/oracle/Q05/origlogA/log_g15m1.dbf',
　　'/oracle/Q05/mirrlogA/log_g15m2.dbf'

　　)>　　GROUP 6 (
　　'/oracle/Q05/origlogB/log_g16m1.dbf',
　　'/oracle/Q05/mirrlogB/log_g16m2.dbf'

　　)>　　-- STANDBY LOGFILE
　　DATAFILE
　　'/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;