如何遷移Oracle 10g RAC ASM儲存

使用VBOX類比儲存遷移的環境，OS：RHEL5.9，DB：Oracle 10.2.0.4 RAC ASM 2Nodes。

ASM使用Extern Redundancy，不使用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

[oracle@racdb1 ~]$ ocrcheck

Status of Oracle Cluster Registry is as follows :

Version                  :          2

Total space (kbytes)     :     497744

Used space (kbytes)      :       4360

Available space (kbytes) :     493384

ID                       :  803449477

Device/File Name         : /dev/raw/raw1

                           Device/File integrity check succeeded

Device/File Name         : /dev/raw/raw2

                           Device/File integrity check succeeded

    Cluster registry integrity check succeeded

[oracle@racdb1 ~]$

[oracle@racdb1 ~]$ crsctl query css votedisk

0.     0    /dev/raw/raw3

1.     0    /dev/raw/raw4

2.     0    /dev/raw/raw5

located 3 votedisk(s).

關閉RAC環境的crs

[root@racdb1 ~]# /etc/init.d/init.crs stop

Shutting down Oracle Cluster Ready Services (CRS):

Nov 24 16:06:49.700 | INF | daemon shutting down

Stopping resources. This could take several minutes.

Successfully stopped CRS resources.

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

Shutdown has begun. The daemons should exit soon.

[root@racdb2 ~]# /etc/init.d/init.crs stop

Shutting down Oracle Cluster Ready Services (CRS):

Nov 24 16:07:11.360 | INF | daemon shutting down

Stopping resources. This could take several minutes.

Successfully stopped CRS resources.

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

Shutdown has begun. The daemons should exit soon.

備份votedisk

[root@racdb1 ~]# dd if=/dev/raw/raw3 of=/u01/votedisk.bak

添加votedisk

[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl add css votedisk /dev/raw/raw8 -force

Now formatting voting disk: /dev/raw/raw8

successful addition of votedisk /dev/raw/raw8.

[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl add css votedisk /dev/raw/raw9 -force

Now formatting voting disk: /dev/raw/raw9

successful addition of votedisk /dev/raw/raw9.

[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl add css votedisk /dev/raw/raw10 -force

Now formatting voting disk: /dev/raw/raw10

successful addition of votedisk /dev/raw/raw10.

刪除舊的votedisk

[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl delete css votedisk /dev/raw/raw3 -force

successful deletion of votedisk /dev/raw/raw3.

[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl delete css votedisk /dev/raw/raw4 -force

successful deletion of votedisk /dev/raw/raw4.

[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl delete css votedisk /dev/raw/raw5 -force

successful deletion of votedisk /dev/raw/raw5.

啟動crs

[root@racdb1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl start crs

Attempting to start CRS stack

The CRS stack will be started shortly

[root@racdb2 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl start crs

Attempting to start CRS stack

The CRS stack will be started shortly

檢查crs狀態，votedisk路徑

[oracle@racdb1 ~]$ crsctl check crs

CSS appears healthy

CRS appears healthy

EVM appears healthy

[oracle@racdb1 ~]$ crs_stat -t

Name           Type           Target    State     Host  

------------------------------------------------------------

ora....SM1.asm application    ONLINE    ONLINE    racdb1

ora....B1.lsnr application    ONLINE    ONLINE    racdb1

ora.racdb1.gsd application    ONLINE    ONLINE    racdb1

ora.racdb1.ons application    ONLINE    ONLINE    racdb1

ora.racdb1.vip application    ONLINE    ONLINE    racdb1

ora....SM2.asm application    ONLINE    ONLINE    racdb2

ora....B2.lsnr application    ONLINE    ONLINE    racdb2

ora.racdb2.gsd application    ONLINE    ONLINE    racdb2

ora.racdb2.ons application    ONLINE    ONLINE    racdb2

ora.racdb2.vip application    ONLINE    ONLINE    racdb2

ora.zhongwc.db application    ONLINE    ONLINE    racdb2

ora....c1.inst application    ONLINE    ONLINE    racdb1

ora....c2.inst application    ONLINE    ONLINE    racdb2

ora.....zwc.cs application    ONLINE    ONLINE    racdb1

ora....wc1.srv application    ONLINE    ONLINE    racdb1

[oracle@racdb1 ~]$

[oracle@racdb1 ~]$ crsctl query css votedisk

0.     0    /dev/raw/raw8

1.     0    /dev/raw/raw9

2.     0    /dev/raw/raw10

located 3 votedisk(s).

備份ocr

[root@racdb1 bin]# /u01/app/oracle/product/10.2.0/crs/bin/ocrcheck

Status of Oracle Cluster Registry is as follows :

Version                  :          2

Total space (kbytes)     :     497744

Used space (kbytes)      :       4360

Available space (kbytes) :     493384

ID                       :  803449477

Device/File Name         : /dev/raw/raw1

                           Device/File integrity check succeeded

Device/File Name         : /dev/raw/raw2

                           Device/File integrity check succeeded

    Cluster registry integrity check succeeded

[root@racdb1 bin]#

[root@racdb1 bin]# /u01/app/oracle/product/10.2.0/crs/bin/ocrconfig -export /u01/ocr_bak -s online

遷移ocr

[root@racdb1 bin]# /u01/app/oracle/product/10.2.0/crs/bin/ocrconfig -replace ocr /dev/raw/raw6

[root@racdb1 bin]# /u01/app/oracle/product/10.2.0/crs/bin/ocrconfig -replace ocrmirror /dev/raw/raw7

check ocr

[oracle@racdb2 ~]$ ocrcheck

Status of Oracle Cluster Registry is as follows :

Version                  :          2

Total space (kbytes)     :     497744

Used space (kbytes)      :       4360

Available space (kbytes) :     493384

ID                       :  803449477

Device/File Name         : /dev/raw/raw6

                           Device/File integrity check succeeded

Device/File Name         : /dev/raw/raw7

                           Device/File integrity check succeeded

    Cluster registry integrity check succeeded

遷移datafile，controlfile，logfile，spfile

建立ASM DISKGROUP

asm_diskgroups='DATA','FRA','DATADG','FRADG'

[oracle@racdb1 ~]$ export ORACLE_SID=+ASM1

[oracle@racdb1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Nov 24 16:40:05 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> col name for a8

SQL> col path for a15

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;

PATH            NAME     STATE

--------------- -------- ----------------------

/dev/asm-diskb  DATA     MOUNTED

/dev/asm-diskc  FRA      MOUNTED

/dev/asm-diskd

/dev/asm-diske

SQL> create diskgroup datadg external redundancy disk '/dev/asm-diskd';

Diskgroup created.

SQL> create diskgroup fradg external redundancy disk '/dev/asm-diske';

Diskgroup created.

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;

PATH            NAME     STATE

--------------- -------- ----------------------