oracle 10g rac hacmp 迁移到asm实验步骤

1    实验目的
oracle 11gR2版本开始在建库选项中不支持裸设备来创建数据库，只能用共享文件系统和asm来创建数据库，不再支持raw来存放数据文件。
很多客户都是用裸设备来管理数据库,Oracle 提供了方法把裸设备迁移到asm中，以下为具体的实验步骤。
2    实验环境和原来裸设备信息
 
           迁移前的数据库环境信息 
数据库版本        环境      数据库名    实例名    IP地址    操作系统和主机名
oracle10.2.0.4 hacmp5.5    orcl     orcl1 192.168.3.225    aix6.1+p520
RAC                         orcl     orcl2 192.168.3.223    aix6.1+p650
      
         
       迁移后的数据库环境信息
数据库版本    环境    数据库名    实例名    IP地址    操作系统和主机名
数据库版本        环境      数据库名    实例名    IP地址    操作系统和主机名
oracle10.2.0.4 asm         orcl     orcl1 192.168.3.225    aix6.1+p520
RAC                         orcl     orcl2 192.168.3.223    aix6.1+p650
 
 
      原lv信息
vg名称    lv名称    作用
datavg    ocrnewlv    ocr盘
    rvotenewlv    vote盘
    system_lv    数据库system表空间
    undo1_lv    节点1 undo表空间
    sysaux_lv    数据库 sysaux表空间
    user_lv    数据库 user表空间
    Undo2_lv    节点2 undo 表空间
    temp_lv    数据库 temp表空间
    redo11_lv    数据库重做日志
    redo12_lv    数据库重做日志
    redo21_lv    数据库重做日志
    redo22_lv    数据库重做日志
    control1_lv    数据库控制文件
    control2_lv    数据库控制文件
    control3_lv    数据库控制文件
    spfile_lv    数据库参数文件
      
 
 
 
迁移到asm磁盘组信息
磁盘组名称    磁盘名称    作用
    hdisk11    ocr盘
    hdisk10    vote盘
dgtest hdisk5    存放数据文件，控制文件，参数文件，重做日志文件
    hdisk6     
    hdisk7     
 
      
 
3    实验步骤
     前提是hdisk5,hdisk6,hdisk7,hdisk10,hdisk11已经是从存储中划分到p520,p650节点上，并且赋予权限给oracle用户,并且两边节点先创建好asm实例和磁盘组dgtest。
3.1    迁移ocr盘到hdisk11磁盘中
在线做，不需要停crs
查看当前ocr盘
[oracle@p650:/oracle/app/oracle]$ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     130852
         Used space (kbytes)      :       4636
         Available space (kbytes) :     126216
         ID                       : 1542042236
         Device/File Name         : /dev/rocrnewlv
         Device/File integrity check succeeded
         Cluster registry integrity check succeeded
对当前ocr盘增加镜象
[root@p650:/crs/app/oracle/product/crs_1/bin]#./ocrconfig -replace ocrmirror /dev/rhdisk11
 
查看镜象后的ocr盘
ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     130852
         Used space (kbytes)      :       4636
         Available space (kbytes) :     126216
         ID                       : 1542042236
         Device/File Name         : /dev/rocrnewlv
         Device/File integrity check succeeded
         Device/File Name         : /dev/rhdisk11
         Device/File integrity check succeeded
Cluster registry integrity check succeeded
从ocr盘去掉ocrnewlv裸设备
[root@p520:/crs/app/oracle/product/crs_1/bin]#./ocrconfig -replace ocr
        查看最后的设置,成功迁移到hdisk11磁盘中
[root@p520:/crs/app/oracle/product/crs_1/bin]#./ocrcheck 
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     130852
         Used space (kbytes)      :       4636
         Available space (kbytes) :     126216
         ID                       : 1542042236
         Device/File Name         : /dev/rhdisk11
         Device/File integrity check succeeded
         Device/File not configured
         Cluster registry integrity check succeeded
3.2    迁移vote盘到hdisk10中
需要两边节点停止crs
查看当前vote盘
[root@p520:/crs/app/oracle/product/crs_1/bin]#./crsctl query css votedisk
0.     0    /dev/rvotenewv
located 1 votedisk(s).
       增加vote镜象盘
[root@p520:/crs/app/oracle/product/crs_1/bin]#./crsctl add css votedisk '/dev/rhdisk10' -force
Now formatting voting disk: /dev/rhdisk10
successful addition of votedisk /dev/rhdisk10
       查看镜象后的vote盘
[root@p520:/crs/app/oracle/product/crs_1/bin]#./crsctl query css votedisk
 0.     0    /dev/rvotenewlv
 1.     0    /dev/rhdisk10
从vote盘中删除votenewlv裸设备
[root@p520:/crs/app/oracle/product/crs_1/bin]#./crsctl delete css votedisk '/dev/rvotenewlv' -force
successful deletion of votedisk /dev/rvotenewlv
      查看最后vote盘，成功迁移到hdisk10磁盘中
[root@p650:/crs/app/oracle/product/crs_1/bin]#./crsctl query css votedisk
 0.     0    /dev/rhdisk10
located 1 votedisk(s).
两边节点启动crs
查看两边节点资源状态
crs_stat  -t
 
3.3    设置参数到asm磁盘组中
控制文件，数据文件，和日志文件到磁盘中。
sqlplus “/as sysdba”
SQL> alter system set db_create_file_dest='+dgtest' scope=spfile;
System altered.
SQL> alter system set db_create_online_log_dest_1='+dgtest' scope=spfile;
System altered.
SQL> alter system set db_create_online_log_dest_2='+dgtest' scope=spfile;
System altered.
SQL> alter system set control_files='+dgtest/orcl/control01.ctl' scope=spfile;
System altered.
3.4    迁移控制文件到磁盘组中 
关闭p520实例，在p650实例中做迁移
关闭p650实例，启动到nomount状态，恢复控制文件到asm磁盘组中
[oracle@p650:/oracle/app/oracle]$rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Fri May 28 18:12:36 2010
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area    4982833152 bytes
Fixed Size                     2090856 bytes
Variable Size                889194648 bytes
Database Buffers            4076863488 bytes
Redo Buffers                  14684160 bytes
RMAN> restore controlfile from '/dev/rcontrol1_lv';
Starting restore at 28-MAY-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=147 instance=orcl2 devtype=DISK
channel ORA_DISK_1: copied control file copy
output filename=+DGTEST/orcl/control01.ctl
Finished restore at 28-MAY-10
 
RMAN> alter database mount;   --把数据库启动到mount状态
database mounted
released channel: ORA_DISK_1
 
3.5    迁移数据文件到asm磁盘组中
RMAN> backup as copy database format '+dgtest';
Starting backup at 28-MAY-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/dev/rsystem_lv
output filename=+DGTEST/orcl/datafile/system.257.720209735 tag=TAG20100528T181535 recid=1 stamp=720209766
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/dev/rundo1_lv
output filename=+DGTEST/orcl/datafile/undotbs1.258.720209771 tag=TAG20100528T181535 recid=2 stamp=720209792
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=/dev/rundo2_lv
output filename=+DGTEST/orcl/datafile/undotbs2.259.720209797 tag=TAG20100528T181535 recid=3 stamp=720209816
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/dev/rsysaux_lv
output filename=+DGTEST/orcl/datafile/sysaux.260.720209821 tag=TAG20100528T181535 recid=4 stamp=720209834
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/dev/ruser_lv
output filename=+DGTEST/orcl/datafile/users.261.720209837 tag=TAG20100528T181535 recid=5 stamp=720209837
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=+DGTEST/orcl/controlfile/backup.262.720209837 tag=TAG20100528T181535 recid=6 stamp=720209838
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 28-MAY-10
channel ORA_DISK_1: finished piece 1 at 28-MAY-10
piece handle=+DGTEST/orcl/backupset/2010_05_28/nnsnf0_tag20100528t181535_0.263.720209843 tag=TAG20100528T181535 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 28-MAY-10
 
RMAN> switch database to copy;
 
datafile 1 switched to datafile copy "+DGTEST/orcl/datafile/system.257.720209735"
datafile 2 switched to datafile copy "+DGTEST/orcl/datafile/undotbs1.258.720209771"
datafile 3 switched to datafile copy "+DGTEST/orcl/datafile/sysaux.260.720209821"
datafile 4 switched to datafile copy "+DGTEST/orcl/datafile/users.261.720209837"
datafile 5 switched to datafile copy "+DGTEST/orcl/datafile/undotbs2.259.720209797"
RMAN> recover database;
RMAN> alter database open;
 
3.6    迁移temp文件到asm磁盘组中
SQL> alter tablespace temp add tempfile '+dgtest' size 100M;
Tablespace altered.
SQL> alter database tempfile '/dev/rtemp_lv' drop;
Database altered.  
 
 
3.7    迁移重做日志到asm磁盘组中
SQL> alter database add logfile thread 1 group  5 size 50m;
Database altered.
SQL> alter database add logfile thread 1 group 6 size 50m; 
Database altered.
SQL> alter database add logfile thread 2 group 7 size 50m; 
Database altered.
SQL> alter database add logfile thread 2 group 8 size 50m;
Database altered.
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter database drop logfile group 4;
Database altered.
3.8    对控制文件做镜象
SQL> alter system set control_files='+dgtest/orcl/control01.ctl','+dgtest/orcl/control02.ctl' scope=spfile;
Database altered.
SQL>  alter database backup controlfile to '+dgtest/orcl/control02.ctl';       
Database altered.
 
3.9    检查是否全部迁移到asm磁盘组中
[oracle@p520:/oracle/app/oracle/admin/orcl/bdump]$rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Fri May 28 19:04:58 2010
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: ORCL (DBID=1247702683)
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    300      SYSTEM               ***     +DGTEST/orcl/datafile/system.257.720209735
2    200      UNDOTBS1             ***     +DGTEST/orcl/datafile/undotbs1.258.720209771
3    120      SYSAUX               ***     +DGTEST/orcl/datafile/sysaux.260.720209821
4    5        USERS                ***     +DGTEST/orcl/datafile/users.261.720209837
5    200      UNDOTBS2             ***     +DGTEST/orcl/datafile/undotbs2.259.720209797
 
List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
2    100      TEMP                 100         +DGTEST/orcl/tempfile/temp.264.720210427
数据文件已经全部迁移到asm磁盘组中
SQL> select member from v$logfile;
 
MEMBER
--------------------------------------------------------------------------------
+DGTEST/orcl/onlinelog/group_5.265.720210499
+DGTEST/orcl/onlinelog/group_5.266.720210503
+DGTEST/orcl/onlinelog/group_6.267.720210527
+DGTEST/orcl/onlinelog/group_6.268.720210531
+DGTEST/orcl/onlinelog/group_7.269.720210549
+DGTEST/orcl/onlinelog/group_7.270.720210553
+DGTEST/orcl/onlinelog/group_8.271.720210575
+DGTEST/orcl/onlinelog/group_8.272.720210579
日志文件已经全部迁移到asm磁盘组中
8 rows selected.
 
 
SQL> select name from v$tempfile;
 
NAME
--------------------------------------------------------------------------------
+DGTEST/orcl/tempfile/temp.264.720210427
临时数据文件已经全部迁移到asm磁盘组中
 
SQL> select name from v$controlfile;
NAME
+DGTEST/orcl/control01.ctl
+DGTEST/orcl/control02.ctl
控制文件已经全部迁移到asm磁盘组中
 
3.10    启动另外一节点
sqlplus “/as sysdba”
startup
 
迁移完毕
3.11    测试
两边节点关闭crs和重新启动crs
crsctl stop crs
crsctl start crs

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-666643/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-666643/