Linux平台 Oracle 11g DG测试环境快速搭建参考(2)

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;

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/3e8db39f3603081d372c77a371d3b5aa.html