ASM Management

• „ Get details of ASM Disks

ƒ Execute following queries on ASM instance (+ASM1 or +ASM2)e to get details of disks

[oracle@crs1 ~]$ . /home/oracle/asm_profile
[oracle@crs1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/asm_1
[oracle@crs1 ~]$ sqlplus / as sysdba
SQL> SELECT SUM (total_mb) total_mb, SUM (free_mb) free_mb FROM v$asm_disk;
TOTAL_MB              FREE_MB
—————                     —————
 14320                             6579

• ƒ To find out the ASM disk details allocated by group name

SQL> SELECT a.name GRP_NAME,
a.state GRP_STATE,
a.TYPE GRP_TYPE,
a.total_mb GRP_TOTAL_MB,
a.free_mb grp_free_mb,
b.name,
b.PATH,
b.HEADER_STATUS,
b.MODE_STATUS,
b.MOUNT_STATUS,
b.TOTAL_MB,
b.FREE_MB
FROM v$asm_diskgroup a, V$ASM_DISK b
WHERE a.group_number (+) = b.group_number;

SQL> col NAME format a10
SQL> col PATH format a15

SQL> SELECT name,
PATH,
header_status,
mode_status,
total_mb,
free_mb
FROM v$asm_disk;

NAME PATH HEADER_STATU MODE_STTOTAL_MB FREE_MB
----------- ------------------ ------------------------------------ ------------------ ------------------
/dev/raw/raw1 FOREIGN ONLINE 511 0
/dev/raw/raw2 FOREIGN ONLINE 511 0
/dev/raw/raw3 FOREIGN ONLINE 511 0
/dev/raw/raw4 CANDIDATE ONLINE 511 0
/dev/raw/raw5 CANDIDATE ONLINE 511 0
ORCL:VOL3 PROVISIONED ONLINE 511 0
ORCL:VOL4 PROVISIONED ONLINE 511 0
ORCL:VOL9 PROVISIONED ONLINE 511 0
ORCL:VOL5 PROVISIONED ONLINE 511 0
ORCL:VOL6 PROVISIONED ONLINE 511 0
ORCL:VOL7 PROVISIONED ONLINE 511 0
ORCL:VOL8 PROVISIONED ONLINE 511 0
VOL1 ORCL:VOL1 MEMBER ONLINE 4094 2819
VOL2 ORCL:VOL2 MEMBER ONLINE 4094 3760

• Shutdown database cleanly to create new spfile from pfile;

SQL> SHUTDOWN immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> CREATE SPFILE=’+DATA/crsdb/spfilecrsdb.ora’ FROM PFILE=’/u01/app/oracle/product/10.2.0/db_1/dbs/initcrsdb.ora.20110226';
File created
ƒ Startup database again
SQL> STARTUP nomount;
SQL> SHOW PARAMETER control;

NAME TYPE VALUE
—————————————————— ————— ———————————————
control_file_record_keep_time integer 7
control_files string +DATA/crsdb/controlfile/curren
t.260.743634235, +FRA/crsdb/co
ntrolfile/current.256.74363423
5, +TEST4/crsdb/controlfile/co
ntrolfile3.ctl

SQL> ALTER DATABASE MOUNT;
SQL> ALTER DATABASE OPEN;

Advertisements