Create ASM on windows

C:/Documents and Settings>cd c:/oracle/product/10.2.0/db_1/bin/

C:/Oracle/product/10.2.0/db_1/BIN>localconfig add
Step 1: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'user', privgrp ''..
Operation successful.
Step 2: creating new CSS service
successfully created local CSS service
successfully added CSS to home

C:/Oracle/product/10.2.0/db_1/BIN>notepad d:/asmdisks/asm.ini
_asm_allow_only_raw_disks=false
asm_diskstring='d:/asmdisks/_file*'
background_dump_dest=C:/Oracle/product/10.2.0/admin/+ASM/bdump
core_dump_dest=C:/Oracle/product/10.2.0/admin/+ASM/cdump
user_dump_dest=C:/Oracle/product/10.2.0/admin/+ASM/udump
instance_type=asm
compatible=10.2.0.1.0
large_pool_size=12M
remote_login_passwordfile=exclusive
C:/Oracle/product/10.2.0/db_1/BIN>oradim -new -asmsid +ASM -syspwd sys
实例已创建。

C:/Oracle/product/10.2.0/db_1/BIN>set ORACLE_SID=+ASM

C:/Oracle/product/10.2.0/db_1/BIN>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 5月 22 14:38:47 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

已连接到空闲例程。

SQL> startup pfile='d:/asmdisks/asm.ini'
ASM 实例已启动

Total System Global Area 83886080 bytes
Fixed Size 1247420 bytes
Variable Size 57472836 bytes
ASM Cache 25165824 bytes
ORA-15110: ??????


SQL> create spfile from pfile='d:/asmdisks/asm.ini';

文件已创建。

SQL> shutdown ;
ORA-15100: ??????????


ASM 实例已关闭
SQL> startup
ASM 实例已启动

Total System Global Area 83886080 bytes
Fixed Size 1247420 bytes
Variable Size 57472836 bytes
ASM Cache 25165824 bytes
ORA-15110: ??????


SQL> SELECT group_number, disk_number, mount_status, header_status, state, path
2 from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS
------------ ----------- -------------- ------------------------
STATE
----------------
PATH
--------------------------------------------------------------------------------
0 0 CLOSED CANDIDATE
NORMAL
D:/ASMDISKS/_FILE_DISK1

0 3 CLOSED CANDIDATE
NORMAL
D:/ASMDISKS/_FILE_DISK4

GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS
------------ ----------- -------------- ------------------------
STATE
----------------
PATH
--------------------------------------------------------------------------------

0 2 CLOSED CANDIDATE
NORMAL
D:/ASMDISKS/_FILE_DISK3

0 1 CLOSED CANDIDATE
NORMAL

GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS
------------ ----------- -------------- ------------------------
STATE
----------------
PATH
--------------------------------------------------------------------------------
D:/ASMDISKS/_FILE_DISK2



SQL>
SQL> create diskgroup DG1 normal redundancy
2 failgroup controller1 disk 'D:/ASMDISKS/_FILE_DISK1','D:/ASMDISKS/_FILE_DISK2'
3 failgroup controller2 disk 'D:/ASMDISKS/_FILE_DISK3','D:/ASMDISKS/_FILE_DISK4';

磁盘组已创建。

SQL> select group_number, name, total_mb, free_mb, state, type
2 from v$asm_diskgroup;

GROUP_NUMBER NAME
------------ ------------------------------------------------------------
TOTAL_MB FREE_MB STATE TYPE
---------- ---------- ---------------------- ------------
1 DG1
1996 1890 MOUNTED NORMAL


SQL>