rhel4+oracle10g ASM配制及ASM與文件系統之間遷移

測試環境:rhel/oel + oracleg r + vmware
     
注雖然說官網都的提供那些包可根據自己的系統版本(`uname r`)下載可是官網提供的rpm包可能不是精確的(比如我的版本是EL可是官網提供和我相匹配的是EL)這樣可能的後果就是安裝好了包卻oracleasm configure 時出錯所以只要下載oracle yum 中沒有的包(oracleasmlib)其他的都用oracle yum安裝  (yum install oracleasm`uname r`*)這種方法最保險
     
    下面兩個oracle rhel的yum中好像沒有
    rpm ivh oracleasmELdebuginfox_  >(可不安裝)
    rpm ivh oracleasmlibelx_rpm   >(須要在上面網址下載)
    [root@oracleg /]# uname r
    EL
    yum install oracleasmsupport
    yum install oracleasm`uname r`*
    including :
    oracleasmELx_
    oracleasmELlargesmpx_
    oracleasmELsmpx_
    oracleasmELxenUx_
     
     
     
    創建一個新分區
    [root@oracleg ~]#fdisk /dev/sdc
     
    配置ASM
    #[root@oracleg ~]# /etc/initd/oracleasm configure
     
    創建ASM磁盤(asm磁盤組是在dbca中創建這裡創建的是asm磁盤而不是組)
     
    [root@oracleg ~]# /etc/initd/oracleasm createdisk vol /dev/sdc
     
        其中vol中asm磁盤名  把/dev/sdc這個區作為asm磁盤
     
    以root執行:($ORACLE_HOME/bin/localconfig add)
    [root@oracleg ~]#/u/app/oracle/oracle/product//db_/bin/localconfig add
     
    [root@oracleg ~]#export DISPLAY=:
    [root@oracleg ~]#xhost +
    [root@oracleg ~]#su oracle
    [oracle@oracleg ~]$dbca
     
    圖形界面配制略
     
    ASM實例export ORACLE_SID=+ASM
     
    查看ASM磁盤信息(v$asm_disk)
    select namefailgroup from v$asm_disk;
     
     
     
    查看ASM磁盤組信息(v$asm_diskgroup)
    select name type from v$asm_diskgroup;
     
     
     
    在oracle實例中若查看到asm磁盤組的名字則oracle實例可以訪問並使用asm磁盤組
    select name from v$asm_diskgroup;
     
    創建完之後asm實例的pfile
    init+ASMora
    +ASMasm_diskgroups=DBDB#Manual Mount
    *asm_diskgroups=DBDB
    *background_dump_dest=/u/app/oracle/admin/+ASM/bdump
    re_dump_dest=/u/app/oracle/admin/+ASM/cdump
    *instance_type=asm
    *large_pool_size=M
    *remote_login_passwordfile=SHARED
    *user_dump_dest=/u/app/oracle/admin/+ASM/udump
     
 

     
    訪問asm磁盤上的數據
    [oracle@oracleg ~]$export ORACLE_SID=+ASM
    [oracle@oracleg ~]$asmcmd
     
     
     
    要asm上創建表空間
    create smallfile tablespace user datafile +DB size m autoextend on;
     
     
     
    sys@DNDN> select name from v$datafile;
     
    NAME
    
    /u/app/oracle/oradata/dndn/systemdbf
    +DB/dndn/datafile/user
    /u/app/oracle/oradata/dndn/sysauxdbf
    /u/app/oracle/oradata/dndn/usersdbf
    /u/app/oracle/oradata/dndn/undotbsdbf
     
     
     
     
     
    ASM文件遷移
    使用rman 的方式(若不能脫機的表空間則在mount下操作)
    users表空間的遷移(從文件系統到asm)
    rman>backup tablespace users;
    rman>run{
    sql alter tablespace users offline immediate;
    set newname for datafile to +DB;
    restore tablespace users;
    switch datafile ;
    recover tablespace users;
    sql alter tablespace users online;
    }
     
    下面寫法和上面一樣(但一個表空間可能有多個數據文件):
    rman>run{
    sql alter database datafile offline;
    set newname for datafile to +DB;
    restore datafile ;
    switch datafile ;
    recover datafile ;
    sql alter database datafile online;
    }
     
    users表空間的遷移(從asm到文件系統)
    rman>backup tablespace users;
    rman>run{
    sql alter tablespace users offline immediate;
    set newname for datafile to /u/app/oracle/oradata/dndn/usersdbf;
    restore tablespace users;
    switch datafile ;
    recover tablespace users;
    sql alter tablespace users online;
    }
     

From:http://tw.wingwit.com/Article/program/Oracle/201311/18821.html