ASM 在10g RAC 下，该怎么用?

qqone

ASM的库建起来了（redhat环境），
但是没用起来，应该说对她知道不多

zhu1

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手册.

zhu1

我用ASM Disks 放archived logs, 怎样维护，比如Copy,delete.

另外，怎样copy control file from one ASM diskgroup to another ASM diskgroup?

zhu1

明天给出详细步骤.

zhu1

1)
http://www.itpub.net/showthread. ... 1391595#post1391595
2)
http://forums.oracle.com/forums/ ... rt=0&msRange=15