1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE jy-dbs
$ crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'jy-dbs'
CRS-2672: Attempting to start 'ora.diskmon' on 'jy-dbs'
CRS-2676: Start of 'ora.diskmon' on 'jy-dbs' succeeded
CRS-2676: Start of 'ora.cssd' on 'jy-dbs' succeeded
$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
OFFLINE OFFLINE jy-dbs
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE jy-dbs
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE jy-dbs
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 16 10:55:39 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 1135747072 bytes
Fixed Size 2260728 bytes
Variable Size 1108320520 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> select status from v$instance;
STATUS
------------------------
STARTED
col description for a35
col process for a35
set linesize 120
select sid, serial#, process, name, description from v$session join v$bgprocess using(paddr);
col path for a45
col name for a30
select group_number, disk_number, mount_status, name, path from v$asm_disk order by group_number, disk_number;
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS NAME PATH
------------ ----------- -------------- ------------------------------ ---------------------------------------------
0 0 CLOSED /dev/mapper/ora_vg-lv_asm3
0 1 CLOSED /dev/mapper/ora_vg-lv_asm2
0 2 CLOSED /dev/mapper/ora_vg-lv_asm1
查看A机器的磁盘组信息:
select group_number, name, type, total_mb, free_mb from v$asm_diskgroup
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ------------------------------------------------------------ ------------ ---------- ----------
1 DATA1 EXTERN 30708 29017
B机器创建ASM磁盘组DATA1:
select group_number, name, type, total_mb, free_mb from v$asm_diskgroup;
no rows selected
CREATE DISKGROUP data1 EXTERNAL REDUNDANCY DISK '/dev/mapper/ora*';
Diskgroup created.
select group_number, name, type, total_mb, free_mb from v$asm_diskgroup;