时间:2021-07-01 10:21:17 帮助过:11人阅读
- <code># importvg -y q05datavg -f hdisk11
- PV 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 NONAME
- varyonvg: 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.
- q05datavg
- PV 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 NONAME
- varyonvg: Volume group q05datavg is varied on.
- # lsvg
- rootvg
- q05datavg
- # lsvg -l q05datavg
- q05datavg:
- LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
- loglv00 jfs2log 1 2 2 closed/stale N/A
- dvdlv jfs2 200 400 2 closed/syncd /DVD
- sapmntlv jfs2 40 80 2 closed/stale /sapmnt
- usrsaplv jfs2 200 400 3 closed/syncd /usr/sap
- oraclelv jfs2 80 160 2 closed/syncd /oracle
- oraPRDlv jfs2 120 240 2 closed/syncd /oracle/PRD
- oradate1lv jfs2 6144 12288 8 closed/stale /oracle/PRD/sapdata1
- oradate2lv jfs2 6144 12288 10 closed/stale /oracle/PRD/sapdata2
- oradate3lv jfs2 1600 3200 2 closed/stale /oracle/PRD/sapdata3
- oradate4lv jfs2 1200 2400 2 closed/stale /oracle/PRD/sapdata4
- oraarchlv jfs2 800 1600 2 closed/syncd /oracle/PRD/oraarch
- origlogAlv jfs2 4 8 2 closed/stale /oracle/PRD/origlogA
- origlogBlv jfs2 4 8 2 closed/stale /oracle/PRD/origlogB
- mirrlogAlv jfs2 4 8 2 closed/stale /oracle/PRD/mirrlogA
- mirrlogBlv jfs2 4 8 2 closed/syncd /oracle/PRD/mirrlogB
- paging00 paging 64 128 2 closed/syncd N/A
- paging01 paging 80 160 2 closed/syncd N/A</code>
丢失的卷如下
0001d23cde6a7b05 NONAME
00067a4bf5b39357 NONAME
00067a4bf5b39312 NONAME
0001d23cddef5de1 NONAME
00067a4bf5b39285 NONAME
00067a4bf5b392cf NONAME
可以手动删除缺失的pv,略
- <code>MMNL started with pid=16, OS id=13238340
- ORACLE_BASE from environment = /oracle
- Fri Jan 26 09:42:03 2018
- alter database mount
- Fri Jan 26 09:42:08 2018
- Successful mount of redo thread 1, with mount id 2030095339
- Database mounted in Exclusive Mode
- Lost write protection disabled
- Completed: alter database mount
- alter database open
- Fri Jan 26 09:42:14 2018
- Block change tracking file is current.
- Beginning crash recovery of 1 threads
- parallel recovery started with 7 processes
- Started redo scan
- Completed redo scan
- read 81129 KB redo, 17401 data blocks need recovery
- Fri Jan 26 09:42:26 2018
- Started redo application at
- Thread 1: logseq 452162, block 92297
- Recovery of Online Redo Log: Thread 1 Group 4 Seq 452162 Reading mem 0
- Mem# 0: /oracle/PRD/origlogB/log_g14m1.dbf
- Mem# 1: /oracle/PRD/mirrlogB/log_g14m2.dbf
- Recovery of Online Redo Log: Thread 1 Group 5 Seq 452163 Reading mem 0
- Mem# 0: /oracle/PRD/origlogA/log_g15m1.dbf
- Mem# 1: /oracle/PRD/mirrlogA/log_g15m2.dbf
- Completed redo application of 65.45MB
- Completed crash recovery at
- Thread 1: logseq 452163, block 62783, scn 6133924352
- 17401 data blocks read, 17400 data blocks written, 81129 redo k-bytes read
- Fri Jan 26 09:42:30 2018
- ...
- SMON: enabling tx recovery
- Database Characterset is UTF8
- No Resource Manager plan active
- Fri Jan 26 09:42:39 2018
- Starting background process QMNC
- Fri Jan 26 09:42:39 2018
- QMNC started with pid=31, OS id=30015654
- Completed: alter database open</code>
- <code>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;</code>
- <code>alter database backup controlfile to trace;</code>
- <code>chfs -m /oracle/Q05 /oracle/PRD
- chfs -m /oracle/Q05/sapdata1 /oracle/PRD/sapdata1
- chfs -m /oracle/Q05/sapdata2 /oracle/PRD/sapdata2
- chfs -m /oracle/Q05/sapdata3 /oracle/PRD/sapdata3
- chfs -m /oracle/Q05/sapdata4 /oracle/PRD/sapdata4
- chfs -m /oracle/Q05/oraarch /oracle/PRD/oraarch
- chfs -m /oracle/Q05/origlogA /oracle/PRD/origlogA
- chfs -m /oracle/Q05/origlogB /oracle/PRD/origlogB
- chfs -m /oracle/Q05/mirrlogA /oracle/PRD/mirrlogA
- chfs -m /oracle/Q05/mirrlogB /oracle/PRD/mirrlogB</code>
- <code>.dbenv.csh
- .dbenv_SAPPRDA.csh
- .sapenv_SAPPRDA.csh</code>
- <code>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‘
- ) 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 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;</code>
- <code>
- SQL> @control.sql
- 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.
- <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
- <code>
- 10. 恢复并更改SID完毕。
- ###### 第三部分 BASIS</code>
SAP系统拷贝-ORACLE更改SID
标签:def sse crash 重启 smon round -- code usr