Wednesday, June 18, 2008

ASM Db Admin -- 2

A good guide to ASM basics

1. spfile and pfile for ASM darabases:

 

Same location as non-ASM dbs:

$ORACLE_HOME/dbs

#sislsd34 :/home/oracle> cd $ORACLE_HOME
#sislsd34 :/home/oracle/db> cd dbs
#sislsd34 :/home/oracle/db/dbs> ll
total 208
-rw-rw----   1 oracle     dba           1431 Jun 17 09:03 ab_+ASM2.dat
-rw-rw----   1 oracle     dba           1552 Jun 17 09:03 hc_+ASM2.dat
-rw-rw----   1 oracle     dba           1552 Jun 16 04:14 hc_dbcl2.dat
-rw-rw----   1 oracle     dba           1552 Jun 17 09:05 hc_orcl2.dat
lrwxrwxrwx   1 oracle     dba    41 Jun  7 14:38 init+ASM2.ora -> /home/oracle/db/admin/+ASM/pfile/init.ora
-rw-r-----   1 oracle     dba           8385 Sep 11  1998 init.ora
-rw-r-----   1 oracle     dba             36 Jun 14 10:19 initdbcl2.ora
-rw-r--r--   1 oracle     dba          12920 May  3  2001 initdw.ora
-rw-r-----   1 oracle     dba             35 Jun  7 23:48 initorcl2.ora
-rw-r-----   1 oracle     dba           3072 Jun  7 14:38 orapw+ASM2
-rw-r-----   1 oracle     dba           3072 Jun 14 10:15 orapwdbcl2
-rw-r-----   1 oracle     dba           3072 Jun  7 23:44 orapworcl2
#sislsd34 :/home/oracle/db/dbs> strings initorcl2.ora
SPFILE='+PQSI/orcl/spfileorcl.ora'

 

#sislsd34 :/home/oracle/db/dbs> strings init+ASM2.ora
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cluster Database
###########################################
cluster_database=true
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/home/oracle/db/admin/+ASM/bdump
core_dump_dest=/home/oracle/db/admin/+ASM/cdump
user_dump_dest=/home/oracle/db/admin/+ASM/udump
###########################################
# Miscellaneous
###########################################
instance_type=asm
###########################################
# Pools
###########################################
large_pool_size=12M
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=exclusive
asm_diskgroups='PQSI','DSSVPAR','PQSC','PQSI2'
+ASM4.instance_number=4
+ASM3.instance_number=3
+ASM2.instance_number=2
+ASM1.instance_number=1

 

------------------ End of File ------------------------

 

#sislsd34 :/home/oracle/db/admin/+ASM/pfile> ll
total 16
-rw-r-----   1 oracle     dba           1166 Jun 14 10:11 init.ora
#sislsd34 :/home/oracle/db/admin/+ASM/pfile>

 

SQL> select name, path from v$asm_disk where name is not null;

NAME                           PATH
-------------------------------------------------------------------------------------------
PQSI_0000                      /dev/rdsk/database1

You can see all the disks as below :

#sislsd34 :/dev/rdsk> ls d* v* o*

database1  database3  database5  database2  database4 

ocr1       ocr2      

vote1  vote2  vote3

 

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

NAME                           TYPE     TOTAL_MB    FREE_MB
------------------------------ ------ ---------- ----------
DSSVPAR                      EXTERN     102400     102223
PQSC                           EXTERN     102400     102223
PQSI2                          EXTERN     102400     100735
PQSI                           EXTERN     102400      82435

No comments:

Post a Comment