ECCPRD TO Q05系统拷贝 2018.01.25
第一部分 V7000存储进行存储LUN拷贝
- 使用一致性组进行LUN克隆
- 将克隆卷映射到新主机
- 在新主机上强制导入卷组，因为AIX镜像丢失，无法正常导入卷组，需要加上-f参数
# 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- 丢失的卷如下
0001d23cde6a7b05 NONAME
00067a4bf5b39357 NONAME
00067a4bf5b39312 NONAME
0001d23cddef5de1 NONAME
00067a4bf5b39285 NONAME
00067a4bf5b392cf NONAME
- 可以手动删除缺失的pv，略
第二部分 数据库还原/更改SID
- 正常启动数据库，进行crash恢复
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- 备份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;- 备份控制文件到trace
alter database backup controlfile to trace;- 关闭数据库更改文件系统路径(卸载状态)
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- 创建OS用户并更改环境变量，更改下面文件名并替换文件中的旧SID为新SID 原hostname：SAPPRDA
新hostname：ECCQASQ05
原SID：PRD
新SID：Q05
.dbenv.csh
.dbenv_SAPPRDA.csh
.sapenv_SAPPRDA.csh- 更改listener和tnsname文件中的旧SID为新SID
目录：/oracle/SID/112_64/network/admin - 更改profile文件名和里面的路径信息
文件：/oracle/SID/112_64/dbs/initSID.ora - 编辑之前的controlfile备份trace，指定新SID，最终如下：
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;- 运行sql
SQL> @control.sql
ORACLE 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- 恢复并更改SID完毕。
526
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
