ORACLE10g新特性ASM的实现
环境PC
OS: RedHat AS2.1
DB:Oracle10g Beta
经过实践操作在LINUX上面实现了ASM
具体过程大致如下:
1、在OS级别来绑定raw device(DISKGROUP中要用到的)
#raw /dev/raw/raw1 /dev/hdb5
#raw /dev/raw/raw2 /dev/hdb6
#chmod oracle:dba /dev/raw/raw1
#chmod oracle:dba /dev/raw/raw2
#chmod 660 /dev/raw/raw1
#chmod 660 /dev/raw/raw2
2、通过DBCA来创建一个用来mount DISKGROUP的instance,它的名称默认是+OSM。
这里可以创建DISKGROUP
SQL> CREATE DISKGROUP dg DISK '/dev/raw/raw1','/dev/raw/raw2';
SQL>alter system set osm_diskgroups='dg';
SQL>shutdown;
SQL>startup /*这时就mout 了DISKGROUP*/
3、在使用ASM来放数据的instance中加上参数_osmsid=+OSM
启动数据库
SQL> startup pfile='$ORACLE_HOME/pfileorcl10i.ora';
ORACLE instance started.
Total System Global Area 141630216 bytes
Fixed Size 760584 bytes
Variable Size 88080384 bytes
Database Buffers 29360128 bytes
Redo Buffers 23429120 bytes
Database mounted.
Database opened.
SQL> create tablespace asm datafile '+dg' size 100M;
Tablespace created.
FILE# NAME
---------- --------------------------------------------------
1 /oracle/oracle10i/oradata/orcl10i/system01.dbf
2 /oracle/oracle10i/oradata/orcl10i/undotbs01.dbf
3 /oracle/oracle10i/oradata/orcl10i/sysaux01.dbf
4 /oracle/oracle10i/oradata/orcl10i/users01.dbf
5 +DG/orcl10i/datafile/asm.261.3
/*第5个文件就是ASM下得到的文件名*/
/*在ASM上面建对象*/
SQL> create table asm_tab tablespace asm as select * from all_objects;
Table created.
SQL>
|