ASM 安装配置
- 格式：pdf
- 大小：85.24 KB
- 文档页数：4
下载如下RPM包然后安装
oracleasmlib-2.0.4-1.el5.i386.rpm
oracleasm-support-2.1.3-1.el5.i386.rpm
oracleasm-2.6.18-128.el5-2.0.5-1.el5.i686.rpm
创建4块硬盘。然后分区（一定要分primary,不能分extend） 不用格式化
和挂载。
先进入$ORACLE_HOME/dbs目录，然后创建init+ASM.ora，内容如下：
*.asm_diskstring='ORCL:VOL*'
*.background_dump_dest='/opt/oracle/admin/+ASM/bdump'
*.core_dump_dest='/opt/oracle/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/opt/oracle/admin/+ASM/udump'
在$ORACLE_HOME/dbs目录下，运
行orapwd file=orapw+AMS password=dba
Export ORACLE_SID=+ASM.
重新登录oralce用户
>sqlplus /nolog
>conn / as sysdba;
>startup
DBCA删除数据库实例和数据库。
之后创建ASM
/etc/init.d/oracleasm configure 按照下面的步骤。
Default user to own the driver interface [oracle]: oracle
Default group to own the driver interface [dba]: dba
Start Oracle ASM library driver on boot (y/n) [y]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: OK ]Scanning the system for Oracle ASMLib disks:
加磁盘：
/etc/init.d/oracleasm createdisk VOL1 /dev/sdb1
/etc/init.d/oracleasm createdisk VOL2 /dev/sdc1
/etc/init.d/oracleasm createdisk VOL3 /dev/sdd1
/etc/init.d/oracleasm createdisk VOL4 /dev/sde1
再启动CRS集群服务：
到$ORACLE_HOME/bin这个目录下
./localconfig delete
./localconfig add
启动oracle然后登录进去。创建ASM磁盘组。
SQL>create diskgroup dgroup1 normal redundancy
failgroup fgroup1 disk 'ORCL:VOL1','ORCL:VOL2'
failgroup fgroup2 disk 'ORCL:VOL3','ORCL:VOL4';
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DGROUP1 CONNECTED
然后再DBCA,创建实例和数据库。
在第7步，创建ASM instance的时候先shutdown数据库。
一直下一步知道创建完成。
Export oracle_SID=asmdemo.
登录oracle
Select * from v$instance;
Select * from v$datafile;
将ASM磁盘组数据迁移到硬盘上
SQL> select name from v$datafile;
NAME
------------------------------------------------------
+DGROUP1/asmdemo/datafile/system.256.720227135
+DGROUP1/asmdemo/datafile/undotbs1.258.720227139+DGROUP1/asmdemo/datafile/sysaux.257.720227139
+DGROUP1/asmdemo/datafile/users.259.720227141
+DGROUP1/asmdemo/datafile/example.265.720227307
+DGROUP2/asmdemo/datafile/jinjiang.265.720312915
+DGROUP2/asmdemo/datafile/zhangyh.268.720455185
将数据文件+DGROUP2/asmdemo/datafile/zhangyh.268.720455185 offline
alter database datafile
'+DGROUP2/asmdemo/datafile/zhangyh.268.720455185' offline;
切换到rman
RMAN> connect target /
connected to target database: ASMDEMO (DBID=1648369767)
RMAN>
使用copy，switch命令转储数据文件
RMAN> copy datafile
'+DGROUP2/asmdemo/datafile/zhangyh.268.720455185' to
'/oradata/asmdemo/zhangyh.dbf';
switch datafile 7 to copy;
RMAN> switch datafile 7 to copy;
datafile 7 switched to datafile copy "/oradata/asmdemo/zhangyh.dbf"
再recover datafile
Recover datafile 7;
Alter database datafile 7 online;
SQL> select name from v$datafile;
NAME
----------------------------------------------------------
+DGROUP1/asmdemo/datafile/system.256.720227135
+DGROUP1/asmdemo/datafile/undotbs1.258.720227139
+DGROUP1/asmdemo/datafile/sysaux.257.720227139
+DGROUP1/asmdemo/datafile/users.259.720227141
+DGROUP1/asmdemo/datafile/example.265.720227307
+DGROUP2/asmdemo/datafile/jinjiang.265.720312915
/oradata/asmdemo/zhangyh.dbf
7 rows selected.
将数据文件迁移到ASM磁盘上
SQL> select name from v$datafile;
NAME
------------------------------------------------------------+DGROUP1/asmdemo/datafile/system.256.720227135
+DGROUP1/asmdemo/datafile/undotbs1.258.720227139
+DGROUP1/asmdemo/datafile/sysaux.257.720227139
+DGROUP1/asmdemo/datafile/users.259.720227141
+DGROUP1/asmdemo/datafile/example.265.720227307
+DGROUP2/asmdemo/datafile/jinjiang.265.720312915
/oradata/asmdemo/zhangyh.dbf
7 rows selected.
将数据文件’ /oradata/asmdemo/zhangyh.dbf’ offline
SQL> alter database datafile '/oradata/asmdemo/zhangyh.dbf' offline;
Database altered.
切换到rnan
Connect target /
使用backup as copy 命令copy数据文件
RMAN> backup as copy datafile '/oradata/asmdemo/zhangyh.dbf' format
'+DGROUP2';
Switch datafile 到copy
命令：switch datafile 7 to copy;
切换到sqlplus 使用recover datafile 恢复数据文件
SQL> recover datafile 7;
Media recovery complete.
最后将数据文件online
Alter database datafile 7 online
再次查询数据文件
SQL> select name from v$datafile;
NAME
---------------------------------------------------
+DGROUP1/asmdemo/datafile/system.256.720227135
+DGROUP1/asmdemo/datafile/undotbs1.258.720227139
+DGROUP1/asmdemo/datafile/sysaux.257.720227139
+DGROUP1/asmdemo/datafile/users.259.720227141
+DGROUP1/asmdemo/datafile/example.265.720227307
+DGROUP2/asmdemo/datafile/jinjiang.265.720312915
+DGROUP2/asmdemo/datafile/zhangyh.269.720461829
7 rows selected.
