Oracle 10g RAC ASM存储迁移.docx
《Oracle 10g RAC ASM存储迁移.docx》由会员分享,可在线阅读,更多相关《Oracle 10g RAC ASM存储迁移.docx(25页珍藏版)》请在冰豆网上搜索。
Oracle10gRACASM存储迁移
使用VBOX模拟存储迁移的环境,OS:
RHEL5.9,DB:
Oracle10.2.0.4RACASM2Nodes。
ASM使用ExternRedundancy,不使用ASM的rebalance功能,ocr和votedisk存放在raw里。
迁移包括controlfile,datafile,tempfile,spfile,ocr,votedisk。
迁移前路径
ocr /dev/sdf1 /dev/raw/raw1, /dev/sdf2 /dev/raw/raw2
votedisk /dev/sdg1 /dev/raw/raw3, /dev/sdg2 /dev/raw/raw4, /dev/sdg3 /dev/raw/raw5
ASM +DATA /dev/sdb
ASM +FRA /dev/sdc
迁移后路径
ocr /dev/sdh1 /dev/raw/raw6, /dev/sdh2 /dev/raw/raw7
votedisk /dev/sdi1 /dev/raw/raw8, /dev/sdi2 /dev/raw/raw9, /dev/sdi3 /dev/raw/raw10
ASM +DATAFG /dev/sdd
ASM +FRADG /dev/sde
迁移votedisk和ocr
[plain] viewplain copy
print?
1.[oracle@racdb1 ~]$ ocrcheck
2.Status of Oracle Cluster Registry is as follows :
3. Version :
2
4. Total space (kbytes) :
497744
5. Used space (kbytes) :
4360
6. Available space (kbytes) :
493384
7. ID :
803449477
8. Device/File Name :
/dev/raw/raw1
9. Device/File integrity check succeeded
10. Device/File Name :
/dev/raw/raw2
11. Device/File integrity check succeeded
12.
13. Cluster registry integrity check succeeded
14.
15.[oracle@racdb1 ~]$
16.[oracle@racdb1 ~]$ crsctl query css votedisk
17. 0. 0 /dev/raw/raw3
18. 1. 0 /dev/raw/raw4
19. 2. 0 /dev/raw/raw5
20.
21.located 3 votedisk(s).
关闭RAC环境的crs
[plain] viewplain copy
print?
1.[root@racdb1 ~]# /etc/init.d/init.crs stop
2.Shutting down Oracle Cluster Ready Services (CRS):
3.Nov 24 16:
06:
49.700 | INF | daemon shutting down
4.Stopping resources. This could take several minutes.
5.Successfully stopped CRS resources.
6.Stopping CSSD.
7.Shutting down CSS daemon.
8.Shutdown request successfully issued.
9.Shutdown has begun. The daemons should exit soon.
[plain] viewplain copy
print?
1.[root@racdb2 ~]# /etc/init.d/init.crs stop
2.Shutting down Oracle Cluster Ready Services (CRS):
3.Nov 24 16:
07:
11.360 | INF | daemon shutting down
4.Stopping resources. This could take several minutes.
5.Successfully stopped CRS resources.
6.Stopping CSSD.
7.Shutting down CSS daemon.
8.Shutdown request successfully issued.
9.Shutdown has begun. The daemons should exit soon.
备份votedisk
[plain] viewplain copy
print?
1.[root@racdb1 ~]# dd if=/dev/raw/raw3 of=/u01/votedisk.bak
添加votedisk
[plain] viewplain copy
print?
1.[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl add css votedisk /dev/raw/raw8 -force
2.Now formatting voting disk:
/dev/raw/raw8
3.successful addition of votedisk /dev/raw/raw8.
4.[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl add css votedisk /dev/raw/raw9 -force
5.Now formatting voting disk:
/dev/raw/raw9
6.successful addition of votedisk /dev/raw/raw9.
7.[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl add css votedisk /dev/raw/raw10 -force
8.Now formatting voting disk:
/dev/raw/raw10
9.successful addition of votedisk /dev/raw/raw10.
删除旧的votedisk
[plain] viewplain copy
print?
1.[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl delete css votedisk /dev/raw/raw3 -force
2.successful deletion of votedisk /dev/raw/raw3.
3.[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl delete css votedisk /dev/raw/raw4 -force
4.successful deletion of votedisk /dev/raw/raw4.
5.[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl delete css votedisk /dev/raw/raw5 -force
6.successful deletion of votedisk /dev/raw/raw5.
启动crs
[plain] viewplain copy
print?
1.[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl start crs
2.Attempting to start CRS stack
3.The CRS stack will be started shortly
[plain] viewplain copy
print?
1.[root@racdb2 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl start crs
2.Attempting to start CRS stack
3.The CRS stack will be started shortly
检查crs状态,votedisk路径
[plain] viewplain copy
print?
1.[oracle@racdb1 ~]$ crsctl check crs
2.CSS appears healthy
3.CRS appears healthy
4.EVM appears healthy
5.[oracle@racdb1 ~]$ crs_stat -t
6.Name Type Target State Host
7.------------------------------------------------------------
8.ora....SM1.asm application ONLINE ONLINE racdb1
9.ora....B1.lsnr application ONLINE ONLINE racdb1
10.ora.racdb1.gsd application ONLINE ONLINE racdb1
11.ora.racdb1.ons application ONLINE ONLINE racdb1
12.ora.racdb1.vip application ONLINE ONLINE racdb1
13.ora....SM2.asm application ONLINE ONLINE racdb2
14.ora....B2.lsnr application ONLINE ONLINE racdb2
15.ora.racdb2.gsd application ONLINE ONLINE racdb2
16.ora.racdb2.ons application ONLINE ONLINE racdb2
17.ora.racdb2.vip application ONLINE ONLINE racdb2
18.ora.zhongwc.db application ONLINE ONLINE racdb2
19.ora....c1.inst application ONLINE ONLINE racdb1
20.ora....c2.inst application ONLINE ONLINE racdb2
21.ora.....zwc.cs application ONLINE ONLINE racdb1
22.ora....wc1.srv application ONLINE ONLINE racdb1
23.[oracle@racdb1 ~]$
24.[oracle@racdb1 ~]$ crsctl query css votedisk
25. 0. 0 /dev/raw/raw8
26. 1. 0 /dev/raw/raw9
27. 2. 0 /dev/raw/raw10
28.
29.located 3 votedisk(s).
备份ocr
[plain] viewplain copy
print?
1.[root@racdb1 bin]# /u01/app/oracle/product/10.2.0/crs/bin/ocrcheck
2.Status of Oracle Cluster Registry is as follows :
3. Version :
2
4. Total space (kbytes) :
497744
5. Used space (kbytes) :
4360
6. Available space (kbytes) :
493384
7. ID :
803449477
8. Device/File Name :
/dev/raw/raw1
9. Device/File integrity check succeeded
10. Device/File Name :
/dev/raw/raw2
11. Device/File integrity check succeeded
12.
13. Cluster registry integrity check succeeded
14.
15.[root@racdb1 bin]#
16.[root@racdb1 bin]# /u01/app/oracle/product/10.2.0/crs/bin/ocrconfig -export /u01/ocr_bak -s online
迁移ocr
[plain] viewplain copy
print?
1.[root@racdb1 bin]# /u01/app/oracle/product/10.2.0/crs/bin/ocrconfig -replace ocr /dev/raw/raw6
2.[root@racdb1 bin]# /u01/app/oracle/product/10.2.0/crs/bin/ocrconfig -replace ocrmirror /dev/raw/raw7
checkocr
[plain] viewplain copy
print?
1.[oracle@racdb2 ~]$ ocrcheck
2.Status of Oracle Cluster Registry is as follows :
3. Version :
2
4. Total space (kbytes) :
497744
5. Used space (kbytes) :
4360
6. Available space (kbytes) :
493384
7. ID :
803449477
8. Device/File Name :
/dev/raw/raw6
9. Device/File integrity check succeeded
10. Device/File Name :
/dev/raw/raw7
11. Device/File integrity check succeeded
12.
13. Cluster registry integrity check succeeded
迁移datafile,controlfile,logfile,spfile
创建ASMDISKGROUP
asm_diskgroups='DATA','FRA','DATADG','FRADG'
[plain] viewplain copy
print?
1.[oracle@racdb1 ~]$ export ORACLE_SID=+ASM1
2.[oracle@racdb1 ~]$ sqlplus / as sysdba
3.
4.SQL*Plus:
Release 10.2.0.4.0 - Production on Sun Nov 24 16:
40:
05 2013
5.
6.Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
7.
8.
9.Connected to:
10.Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
11.With the Partitioning, Real Application Clusters, OLAP, Data Mining
12.and Real Application Testing options
13.
14.SQL> col name for a8
15.SQL> col path for a15
16.SQL> select a.path,b.name,b.state from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number(+) order by 1;
17.
18.PATH NAME STATE
19.--------------- -------- ----------------------
20./dev/asm-diskb DATA MOUNTED
21./dev/asm-diskc FRA MOUNTED
22./dev/asm-diskd
23./dev/asm-diske
24.
25.SQL> create diskgroup datadg external redundancy disk '/dev/asm-diskd';
26.
27.Diskgroup created.
28.
29.SQL> create diskgroup fradg external redundancy disk '/dev/asm-diske';
30.
31.Diskgroup created.
32.
33.SQL> select a.path,b.name,b.state from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number(+) order by 1;
34.
35.PATH NAME STATE
36.--------------- -------- ----------------------
37./dev/asm-diskb DATA MOUNTED
38./dev/asm-diskc FRA MOUNTED
39./dev/asm-diskd DATADG MOUNTED
40./dev/asm-diske FRADG MOUNTED
rac2
[plain] viewplain copy
print?
1.SQL> alter diskgroup datadg mount;
2.
3.Diskgroup altered.
4.
5.SQL> alter diskgroup fradg mount;
6.
7.Diskgroup altered.
RAC1,RAC2rdbmsinstance启动到mount
[plain] viewplain copy
print?
1.[oracle@racdb1 ~]$ sqlplus / as sysdba
2.
3.SQL*Plus:
Release 10.2.0.4.0 - Production on Sun Nov 24 16:
47:
06 2013
4.
5.Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
6.