RAC安装之创建ASM
作者：八神 | 分类： 大话技术 | 标签： 大话技术 | 日期：2008-04-12
–编辑ASM的init.ora
myasm1.instance_number=1
myasm2.instance_number=2
myasm3.instance_number=3
myasm4.instance_number=4
myasm1.instance_name=myasm1
myasm2.instance_name=myasm2
myasm3.instance_name=myasm3
myasm4.instance_name=myasm4
instance_type=asm
cluster_database=true
asm_diskgroups=’datatomb’
asm_diskstring=’/opt/oracle/oradata/asmrac/disk*’
processes=200
large_pool_size=12M
remote_login_passwordfile=exclusive
core_dump_dest=/opt/oracle/admin/myasm/cdump
user_dump_dest=/opt/oracle/admin/myasm/udump
background_dump_dest=/opt/oracle/admin/myasm/bdump
export ORACLE_SID=myasm3
SQL> startup nomount;
ASM instance started
Total System Global Area 130023424 bytes
Fixed Size 2019032 bytes
Variable Size 102838568 bytes
ASM Cache 25165824 bytes
–ASM已经discover了指定的磁盘,状态为CANDIDATE
SQL> select header_status, path from v$asm_disk;
HEADER_ST PATH
——— ————————————————–
CANDIDATE /opt/oracle/oradata/asmrac/disk2
CANDIDATE /opt/oracle/oradata/asmrac/disk1
–创建磁盘组datatomb,不使用镜像
SQL> create diskgroup datatomb
2 external redundancy disk
3 ‘/opt/oracle/oradata/asmrac/disk1′,
4 ‘/opt/oracle/oradata/asmrac/disk2′;
Diskgroup created.
–disk状态已经是member
SQL> select header_status, path from v$asm_disk;
HEADER_ST PATH
——— ————————————————–
MEMBER /opt/oracle/oradata/asmrac/disk2
MEMBER /opt/oracle/oradata/asmrac/disk1
–1T的空间
SQL> select TOTAL_MB,free_mb from v$asm_diskgroup;
TOTAL_MB FREE_MB
———- ———-
1048570 1048467
–现在在其他接点已经可以直接启动并mount datatomb
SQL> startup;
ASM instance started
Total System Global Area 130023424 bytes
Fixed Size 2019032 bytes
Variable Size 102838568 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
oracle提供了一个命令行工具可以直接管理diskgroup里面的路径,别名等信息,类试一个小文件系统
[oracle@hack3 dbs]$ asmcmd
ASMCMD> ls -l
State Type Rebal Unbal Name
MOUNTED EXTERN N N DATATOMB/
ASMCMD> cd datatomb
ASMCMD> ls -l
ASMCMD> mkdir database
ASMCMD> mkdir archive
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N archive/
N database/
