I did following steps based on the guide,
1. Create initASM.ora file
INSTANCE_TYPE = ASM
asm_diskstring='/dev/raw/raw*' # this is important, not show up on the guide
2. SQL Plus connect as SYSDBA for SID=ASM
3. STARTUP NOMOUNT PFILE=initASM.ora
4. CREATE SPFILE FROM PFILE=initASM.ora
5. CREATE DISKGROUP dgroup1 EXTERNAL REDUNDANCY
DISK '/dev/raw/raw51','/dev/raw/raw52';
SELECT NAME,TYPE,TOTAL_MB,FREE_MB FROM V$ASM_DISKGROUP;
SELECT NAME,path FROM V$ASM_DISK;
CREATE DISKGROUP dgroup1 EXTERNAL REDUNDANCY
DISK '/dev/raw/raw51','/dev/raw/raw52','/dev/raw/raw53','/dev/raw/raw54' force;
5a. You can add disk from another group with <FORCE> option,
that is remove the disk from a group at same time.
alter diskgroup dgrp5 add disk '/dev/raw/raw51' FORCE;
alter diskgroup dgrp5 add disk '/dev/raw/raw52' FORCE,'/dev/raw/raw53' FORCE;
6. Create initDB.ora file
? INSTANCE_TYPE = RDBMS
? DB_CREATE_FILE_DEST = '+dgroup1'
7. SQL Plus connect as SYSDBA for SID=ASMDB
8. STARTUP NOMOUNT PFILE=initASMDB.ora
9. Create Oracle database and user tablespace using SQL,
create database ASMDB
controlfile reuse
logfile '+dgroup1' size 16 M
datafile '+dgroup1' size 2 G
sysaux datafile '+dgroup1' size 2 G
default temporary tablespace temp
tempfile '+dgroup1' size 8 G
undo tablespace undo
datafile '+dgroup1' size 8 G;
create tablespace USER_LOCAL
datafile '+dgroup1' size 60 G;
FYI,
http://otn.oracle.com/oramag/web ... les/scalzo_asm.html
衷心感谢各位老大捧场.
关于REDUNDANCY 的资料可以看ORACLE手册.
