Gather/Backup ASM Metadata In A Formatted Manner version 10g/11g/12c_470211.1

rongshiyuan發表於2014-03-11

In this Document

Goal
  Ask Questions, Get Help, And Share Your Experiences With This Article
Solution
  Script #1 (Generic ASM metadata):
  Script #2 (ASM Files & ASM Alias):
  Script #3 (ASM Full Path Alias Directory):
  Script #4 (ASMCMD commands to gather complementary metadata information):
  Example Output (Script #1):
  Example Output (Script #3):
  Example Output (Script #4):
References

Applies to: 

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 30-Apr-2010***


Goal

You can use the SQLPLUS “SET MARKUP HTML ON” to generate a formatted report from the existing ASM metadata and also using ASMCMD commands to gather complementary metadata information, which can be used as well as an ASM metadata backup or as a report for Oracle Support to troubleshot ASM issues.

 

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Install/Upgrade.

 

 

Solution

1) Connect to your ASM instance(s) and execute the first 3 scripts below (on each node if this is RAC configuration).

 

2) Also, execute the script #4  (located below) through ASMCMD to gather complementary metadata information (on each node if this is RAC configuration).

 


 

 

Note 1:  Scripts #1, #2 & #3 could report the <<< ORA-01219: database not open: queries allowed on fixed tables/views only >>> error on some specific queries, due to some V$ASM_* performance views are only present on early ASM releases, therefore this errors can be ignored depending the ASM release.

 

Note: 2: This is the same case with the Script # 4 (ASMCMD commands), which could not interpret some ASMCMD commands, due to the some commands/options are not present on early releases.

 

 


 

 

 

Script #1 (Generic ASM metadata):

 

-- Author: Esteban D. Bernal
-- Property: Oracle Corporation

 



SPOOL ASM_GENERIC_ASM_METADATA.html
-- ASM VERSIONS 10.1, 10.2, 11.1,  11.2 & 12.1
SET MARKUP HTML ON
SET ECHO ON

SET PAGESIZE 200

ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';

SELECT 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , SYSDATE " "  FROM DUAL;


SELECT 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " FROM V$SESSION WHERE PROGRAM LIKE '%SMON%';

SELECT * FROM V$INSTANCE;

SELECT * FROM GV$INSTANCE;

SELECT * FROM V$ASM_DISKGROUP;

SELECT * FROM  V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;  

SELECT SUBSTR(D.NAME,1,16) AS ASMDISK, D.MOUNT_STATUS, D.STATE,
     DG.NAME AS DISKGROUP FROM V$ASM_DISKGROUP DG, V$ASM_DISK D
     WHERE DG.GROUP_NUMBER = D.GROUP_NUMBER;


SELECT * FROM V$ASM_CLIENT;

 SELECT DG.NAME AS DISKGROUP, SUBSTR(C.INSTANCE_NAME,1,12) AS INSTANCE,
    SUBSTR(C.DB_NAME,1,12) AS DBNAME, SUBSTR(C.SOFTWARE_VERSION,1,12) AS SOFTWARE,
    SUBSTR(C.COMPATIBLE_VERSION,1,12) AS COMPATIBLE
    FROM V$ASM_DISKGROUP DG, V$ASM_CLIENT C  
    WHERE DG.GROUP_NUMBER = C.GROUP_NUMBER;

SELECT * FROM V$ASM_ATTRIBUTE;

SELECT * FROM V$ASM_OPERATION;
SELECT * FROM GV$ASM_OPERATION;


SELECT * FROM V$VERSION;


SELECT * FROM   V$ASM_ACFSSNAPSHOTS;
SELECT * FROM   V$ASM_ACFSVOLUMES;
SELECT * FROM   V$ASM_FILESYSTEM;
SELECT * FROM   V$ASM_VOLUME;
SELECT * FROM   V$ASM_VOLUME_STAT;

SELECT * FROM   V$ASM_USER;
SELECT * FROM   V$ASM_USERGROUP;
SELECT * FROM   V$ASM_USERGROUP_MEMBER;

SELECT * FROM   V$ASM_DISK_IOSTAT;
SELECT * FROM   V$ASM_DISK_STAT;
SELECT * FROM   V$ASM_DISKGROUP_STAT;

SELECT * FROM   V$ASM_TEMPLATE;

SHOW PARAMETER

SHOW SGA

!echo "SELECT '" > /tmp/GPNPTOOL.SQL 2> /dev/null
! $ORACLE_HOME/bin/gpnptool get >> /tmp/GPNPTOOL.SQL 2>> /dev/null
!echo "'  FROM DUAL;" >> /tmp/GPNPTOOL.SQL 2>> /dev/null
! cat /tmp/GPNPTOOL.SQL
SET ECHO OFF

--DISPLAYS INFORMATION ABOUT THE CONTENTS OF THE SPFILE.
SELECT *  FROM  V$SPPARAMETER  ORDER BY 2;
SELECT *  FROM  GV$SPPARAMETER  ORDER BY 3;

--DISPLAYS INFORMATION ABOUT THE INITIALIZATION PARAMETERS THAT ARE CURRENTLY IN EFFECT IN THE INSTANCE.
SELECT *  FROM  V$SYSTEM_PARAMETER ORDER BY 2;
SELECT *  FROM  GV$SYSTEM_PARAMETER ORDER BY 3;


-- 12C ACFS VIEWS

SELECT * FROM  V$ASM_ACFS_ENCRYPTION_INFO;
SELECT * FROM  V$ASM_ACFSREPL;
SELECT * FROM  V$ASM_ACFSREPLTAG;
SELECT * FROM  V$ASM_ACFS_SEC_ADMIN;
SELECT * FROM  V$ASM_ACFS_SEC_CMDRULE;
SELECT * FROM  V$ASM_ACFS_SEC_REALM;
SELECT * FROM  V$ASM_ACFS_SEC_REALM_FILTER;
SELECT * FROM  V$ASM_ACFS_SEC_REALM_GROUP;
SELECT * FROM  V$ASM_ACFS_SEC_REALM_USER;
SELECT * FROM  V$ASM_ACFS_SEC_RULE;
SELECT * FROM  V$ASM_ACFS_SEC_RULESET;
SELECT * FROM  V$ASM_ACFS_SEC_RULESET_RULE;
SELECT * FROM  V$ASM_ACFS_SECURITY_INFO;
SELECT * FROM  V$ASM_ACFSTAG;

-- 12C ASM AUDIT VIEWS

SELECT * FROM  V$ASM_AUDIT_CLEAN_EVENTS;
SELECT * FROM  V$ASM_AUDIT_CLEANUP_JOBS;
SELECT * FROM  V$ASM_AUDIT_CONFIG_PARAMS;
SELECT * FROM  V$ASM_AUDIT_LAST_ARCH_TS;

-- 12C ASM ESTIMATE VIEW

SELECT * FROM  V$ASM_ESTIMATE;
SELECT * FROM  GV$ASM_ESTIMATE;


SPOOL OFF

EXIT


 

 


 

 

Script #2 (ASM Files & ASM Alias):

 

 

-- Author: Esteban D. Bernal
-- Property: Oracle Corporation

 

spool asm_alias+files.html
-- ASM Versions 10.1, 10.2, 11.1  & 11.2
SET MARKUP HTML ON
set echo on

set pagesize 200

COLUMN BYTES FORMAT  9999999999999999

alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';

select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " "  from dual;


select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';

select * from v$asm_alias;

select * from v$asm_file;

show parameter asm
show parameter cluster
show parameter instance_type
show parameter instance_name
show parameter spfile

show sga

spool off

exit

 

 


 

 

Script #3 (ASM Full Path Alias Directory):


 

-- Author: Esteban D. Bernal
-- Property: Oracle Corporation

 


spool asm_full_path_alias_directory.html
-- ASM Versions 10.1, 10.2, 11.1  & 11.2
SET MARKUP HTML ON
set echo on

set pagesize 200

alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';

select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " "  from dual;


select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';

SELECT CONCAT('+'||GNAME, SYS_CONNECT_BY_PATH(ANAME, '/'))
 FULL_PATH, SYSTEM_CREATED, ALIAS_DIRECTORY, FILE_TYPE
 FROM ( SELECT B.NAME GNAME, A.PARENT_INDEX PINDEX,
 A.NAME ANAME, A.REFERENCE_INDEX RINDEX,
 A.SYSTEM_CREATED, A.ALIAS_DIRECTORY,
 C.TYPE FILE_TYPE
 FROM V$ASM_ALIAS A, V$ASM_DISKGROUP B, V$ASM_FILE C
 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER
 AND A.GROUP_NUMBER = C.GROUP_NUMBER(+)
 AND A.FILE_NUMBER = C.FILE_NUMBER(+)
 AND A.FILE_INCARNATION = C.INCARNATION(+)
 )
 START WITH (MOD(PINDEX, POWER(2, 24))) = 0
 CONNECT BY PRIOR RINDEX = PINDEX;


spool off

exit

 


 

 

Script #4 (ASMCMD commands to gather complementary metadata information):

 

################################################################################################
### Script Name:  asmcmd_script.sh                                                                                     ###   
################################################################################################
###  The next script generates additional ASM metadata information thru the ASMCMD interface ###
################################################################################################
###  Author: Esteban D. Bernal                                                               ###
################################################################################################
###  Property: Oracle Corporation                                                            ###
################################################################################################


echo "ASMCMD commands to gather complementary metadata information:"    > /tmp/asmcmd_script.out                2> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p ls -ls        >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p lsattr        >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p lsct  >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p lsdg  >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p lsdsk >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p lsof  >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p lsod  >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p iostat        >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p dsget >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p lsop  >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p spget >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p  lstmpl       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p   lsusr       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p  lsgrp        >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p   lspwusr     >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
asmcmd -p   volinfo -a  >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "=================================="       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
echo "                                  "       >> /tmp/asmcmd_script.out               2>> /tmp/asmcmd_script.out
##############################################################################################################

 

Note: On Windows environments the “2> /tmp/asmcmd_script.out” or “2>> /tmp/asmcmd_script.out” statements is not required, thus it can be omitted.
 

 

Execution Example:


[grid@asmlnx2 ~]$ . oraenv
ORACLE_SID = [+ASM] ? +ASM
The Oracle base remains unchanged with value /u01/app/grid
[grid@asmlnx2 ~]$
[grid@asmlnx2 ~]$ ./asmcmd_script.sh
[grid@asmlnx2 ~]$


Output file:

[grid@asmlnx2 ~]$ ls -l /tmp/asmcmd_script.out
-rw-r--r-- 1 grid oinstall 15873 Jun  6 11:03 /tmp/asmcmd_script.out

 

 






 

 

Example Output (Script #1):

 

 

SQL> -- Version 11.2 SQL> SET MARKUP HTML ON SQL> set echo on
SQL>
SQL> set pagesize 200
SQL>
SQL> alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
Session altered.

SQL>
SQL> select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;

'THISASMREPORTWASGENERATEDAT:==)>'  
THIS ASM REPORT WAS GENERATED AT: ==)> 05-JUN-2012 15:29:52

SQL>
SQL>
SQL> select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';

'HOSTNAMEASSOCIATEDWITHTHISASMINSTANCE:==)>'  
HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> asmlnx2.us.oracle.com

SQL>
SQL> select * from v$asm_diskgroup;

GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS COMPATIBILITY DATABASE_COMPATIBILITY V
1 DATA 512 4096 2097152 MOUNTED NORMAL 78152 73888 0 4264 19538 27175 0 11.2.0.0.0 11.2.0.0.0 N
2 RECO 512 4096 2097152 MOUNTED NORMAL 78152 44792 0 33360 19538 12627 0 11.2.0.0.0 11.2.0.0.0 N
3 SPFILE 512 4096 1048576 MOUNTED EXTERN 8887 8828 0 59 0 8828 0 11.2.0.0.0 10.1.0.0.0 N
4 ACFS 512 4096 1048576 MOUNTED EXTERN 14653 262 0 14391 0 262 0 11.2.0.0.0 11.2.0.0.0 N
5 ACFSDG 512 4096 1048576 MOUNTED EXTERN 14653 262 0 14391 0 262 0 11.2.0.0.0 11.2.0.0.0 N
7 TESTDG2 512 4096 1048576 MOUNTED EXTERN 14653 14603 0 50 0 14603 0 10.1.0.0.0 10.1.0.0.0 N
6 TESTDG 512 4096 1048576 MOUNTED EXTERN 14653 14603 0 50 0 14603 0 10.1.0.0.0 10.1.0.0.0 N

7 rows selected.

SQL>
SQL> SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;

GROUP_NUMBER DISK_NUMBER COMPOUND_INDEX INCARNATION MOUNT_S HEADER_STATU MODE_ST STATE REDUNDA LIBRARY OS_MB TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB NAME FAILGROUP LABEL PATH UDID PRODUCT CREATE_DATE MOUNT_DATE REPAIR_TIMER READS WRITES READ_ERRS WRITE_ERRS READ_TIME WRITE_TIME BYTES_READ BYTES_WRITTEN P HASH_VALUE HOT_READS HOT_WRITES HOT_BYTES_READ HOT_BYTES_WRITTEN COLD_READS COLD_WRITES COLD_BYTES_READ COLD_BYTES_WRITTEN V SECTOR_SIZE FAILGRO
0 4 4 3915944009 CLOSED PROVISIONED ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 0 0 0 0     ASMDISKNEW13 ORCL:ASMDISKNEW13         0                   0                 N 512 REGULAR
1 0 16777216 3915944019 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 18468 0 1070 ASMDISKNEW1 FG1 ASMDISKNEW1 ORCL:ASMDISKNEW1     05-APR-2012 18:19:29 06-APR-2012 16:47:24 0 60708 3111911 0 0 1470.504 36714.442 584798208 4.4288E+10 U 1858933910 0 0 0 0 43244 1402352 511352832 3.7283E+10 N 512 REGULAR
1 1 16777217 3915944020 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 18476 0 1062 ASMDISKNEW2 FG1 ASMDISKNEW2 ORCL:ASMDISKNEW2     05-APR-2012 18:19:29 06-APR-2012 16:47:24 0 44514 1183769 0 0 613.766 5546.148 560709632 2.5913E+10 U 4238862529 0 0 0 0 44269 1183710 559702016 2.5912E+10 N 512 REGULAR
1 2 16777218 3915944021 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 18476 0 1062 ASMDISKNEW3 FG2 ASMDISKNEW3 ORCL:ASMDISKNEW3     05-APR-2012 18:19:29 06-APR-2012 16:47:24 0 61144 2899094 0 0 1628.494 36883.674 605405184 3.8833E+10 U 3481199486 0 0 0 0 43838 1190066 534519808 3.1831E+10 N 512 REGULAR
1 3 16777219 3915944022 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 18468 0 1070 ASMDISKNEW4 FG2 ASMDISKNEW4 ORCL:ASMDISKNEW4     05-APR-2012 18:19:29 06-APR-2012 16:47:24 0 54503 1396586 0 0 595.334 7263.726 623169536 3.1368E+10 U 3420979251 0 0 0 0 54271 1395996 622215168 3.1365E+10 N 512 REGULAR
2 0 33554432 3915944023 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 11232 0 8306 ASMDISKNEW5 FG1 ASMDISKNEW5 ORCL:ASMDISKNEW5     05-APR-2012 18:23:20 06-APR-2012 16:47:24 0 403312 2865390 0 0 15607.657 85127.551 9628065792 2.5349E+10 U 3900773597 0 0 0 0 385852 1148616 9554624512 1.8314E+10 N 512 REGULAR
2 1 33554433 3915944024 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 11164 0 8374 ASMDISKNEW6 FG1 ASMDISKNEW6 ORCL:ASMDISKNEW6     05-APR-2012 18:23:20 06-APR-2012 16:47:24 0 1515522 2838605 0 0 44598.36 112913.043 2.8083E+10 4.6116E+10 U 3327682112 0 0 0 0 1515288 2836417 2.8082E+10 4.6107E+10 N 512 REGULAR
2 2 33554434 3915944025 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 11204 0 8334 ASMDISKNEW7 FG2 ASMDISKNEW7 ORCL:ASMDISKNEW7     05-APR-2012 18:23:20 06-APR-2012 16:47:24 0 792368 4564232 0 0 20262.698 74186.724 1.5932E+10 5.3111E+10 U 2514475167 0 0 0 0 773357 2850429 1.5853E+10 4.6088E+10 N 512 REGULAR
2 3 33554435 3915944026 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 11192 0 8346 ASMDISKNEW8 FG2 ASMDISKNEW8 ORCL:ASMDISKNEW8     05-APR-2012 18:23:20 06-APR-2012 16:47:24 0 2956876 1139767 0 0 26584.755 145227.893 5.1566E+10 1.8354E+10 U 3833053942 0 0 0 0 2956648 1134604 5.1565E+10 1.8332E+10 N 512 REGULAR
3 0 50331648 3915944027 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 8887 8887 8828 0 59 ASMDISKNEW14 ASMDISKNEW14 ASMDISKNEW14 ORCL:ASMDISKNEW14     05-APR-2012 18:16:20 06-APR-2012 16:47:25 0 17425 1709056 0 0 434.096 6902.094 72137728 6999970816   3227115283 0 0 0 0 0 0 0 0 N 512 REGULAR
4 0 67108864 3915944030 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 14653 262 0 14391 ASMDISKNEW9 ASMDISKNEW9 ASMDISKNEW9 ORCL:ASMDISKNEW9     06-APR-2012 16:59:54 06-APR-2012 17:00:05 0 17635 1709439 0 0 492.145842 1920.14 72299008 7005509632   3936317828 0 0 0 0 258 78 164352 71680 N 512 REGULAR
5 0 83886080 3915944033 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 14653 262 0 14391 ASMDISKNEW10 ASMDISKNEW10 ASMDISKNEW10 ORCL:ASMDISKNEW10     06-APR-2012 17:38:54 06-APR-2012 17:39:03 0 17587 1708669 0 0 517.996849 1631.214 72134656 7002355712   405308562 0 0 0 0 249 78 159744 71680 N 512 REGULAR
6 0 100663296 3915944054 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 14653 14603 0 14391 ASMDISKNEW11 ASMDISKNEW11 ASMDISKNEW11 ORCL:ASMDISKNEW11     12-APR-2012 11:33:52 12-APR-2012 11:40:05 0 15564 1543933 0 0 525.707 1418.396 64712704 6323949568   3808981697 0 0 0 0 0 0 0 0 N 512 REGULAR
7 0 117440512 3915944057 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 14653 14603 0 14391 ASMDISKNEW12 ASMDISKNEW12 ASMDISKNEW12 ORCL:ASMDISKNEW12     24-APR-2012 12:30:14 24-APR-2012 12:30:26 0 12072 1200844 0 0 175.236 894.613 50409472 4918657024   1517235067 0 0 0 0 0 0 0 0 N 512 REGULAR

14 rows selected.

SQL>
SQL> SELECT SUBSTR(d.name,1,16) AS asmdisk, d.mount_status, d.state,
2 dg.name AS diskgroup FROM V$ASM_DISKGROUP dg, V$ASM_DISK d
3 WHERE dg.group_number = d.group_number;

ASMDISK MOUNT_S STATE DISKGROUP
ASMDISKNEW1 CACHED NORMAL DATA
ASMDISKNEW2 CACHED NORMAL DATA
ASMDISKNEW4 CACHED NORMAL DATA
ASMDISKNEW3 CACHED NORMAL DATA
ASMDISKNEW5 CACHED NORMAL RECO
ASMDISKNEW6 CACHED NORMAL RECO
ASMDISKNEW8 CACHED NORMAL RECO
ASMDISKNEW7 CACHED NORMAL RECO
ASMDISKNEW14 CACHED NORMAL SPFILE
ASMDISKNEW9 CACHED NORMAL ACFS
ASMDISKNEW10 CACHED NORMAL ACFSDG
ASMDISKNEW11 CACHED NORMAL TESTDG
ASMDISKNEW12 CACHED NORMAL TESTDG2

13 rows selected.

SQL>
SQL>
SQL> SELECT * FROM V$ASM_CLIENT;

GROUP_NUMBER INSTANCE_NAME DB_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION
2 DBASM112 DBASM112 CONNECTED 11.2.0.3.0 11.2.0.0.0
1 DBASM112 DBASM112 CONNECTED 11.2.0.3.0 11.2.0.0.0
4 +ASM asmvol CONNECTED 11.2.0.3.0 11.2.0.3.0
5 +ASM asmvol CONNECTED 11.2.0.3.0 11.2.0.3.0

SQL>
SQL> SELECT dg.name AS diskgroup, SUBSTR(c.instance_name,1,12) AS instance,
2 SUBSTR(c.db_name,1,12) AS dbname, SUBSTR(c.SOFTWARE_VERSION,1,12) AS software,
3 SUBSTR(c.COMPATIBLE_VERSION,1,12) AS compatible
4 FROM V$ASM_DISKGROUP dg, V$ASM_CLIENT c
5 WHERE dg.group_number = c.group_number;

DISKGROUP INSTANCE DBNAME SOFTWARE COMPATIBLE
DATA DBASM112 DBASM112 11.2.0.3.0 11.2.0.0.0
RECO DBASM112 DBASM112 11.2.0.3.0 11.2.0.0.0
ACFS +ASM asmvol 11.2.0.3.0 11.2.0.3.0
ACFSDG +ASM asmvol 11.2.0.3.0 11.2.0.3.0

SQL>
SQL> select * from V$ASM_ATTRIBUTE;

NAME VALUE GROUP_NUMBER ATTRIBUTE_INDEX ATTRIBUTE_INCARNATION READ_ON SYSTEM_
disk_repair_time 3.6h 1 0 1 N Y
au_size 2097152 1 5 1 Y Y
sector_size 512 1 6 1 Y Y
compatible.asm 11.2.0.0.0 1 20 1 N Y
compatible.rdbms 11.2.0.0.0 1 21 1 N Y
compatible.advm 11.2.0.0.0 1 22 1 N Y
cell.smart_scan_capable FALSE 1 30 1 N N
access_control.enabled FALSE 1 40 1 N Y
access_control.umask 066 1 41 1 N Y
template_version 186646528 1 50 1 N Y
template.PARAMETERFILE.stripe 0 1 71 1 N Y
template.PARAMETERFILE.redundancy 18 1 74 1 N Y
template.PARAMETERFILE.primary_region 0 1 75 1 N Y
template.PARAMETERFILE.mirror_region 0 1 76 1 N Y
template.ASMPARAMETERFILE.stripe 0 1 81 1 N Y
template.ASMPARAMETERFILE.redundancy 18 1 84 1 N Y
template.ASMPARAMETERFILE.primary_region 0 1 85 1 N Y
template.ASMPARAMETERFILE.mirror_region 0 1 86 1 N Y
template.DUMPSET.stripe 0 1 101 1 N Y
template.DUMPSET.redundancy 18 1 104 1 N Y
template.DUMPSET.primary_region 0 1 105 1 N Y
template.DUMPSET.mirror_region 0 1 106 1 N Y
template.CONTROLFILE.stripe 1 1 111 1 N Y
template.CONTROLFILE.redundancy 19 1 114 1 N Y
template.CONTROLFILE.primary_region 0 1 115 1 N Y
template.CONTROLFILE.mirror_region 0 1 116 1 N Y
template.FLASHFILE.stripe 0 1 121 1 N Y
template.FLASHFILE.redundancy 18 1 124 1 N Y
template.FLASHFILE.primary_region 0 1 125 1 N Y
template.FLASHFILE.mirror_region 0 1 126 1 N Y
template.ARCHIVELOG.stripe 0 1 131 1 N Y
template.ARCHIVELOG.redundancy 18 1 134 1 N Y
template.ARCHIVELOG.primary_region 0 1 135 1 N Y
template.ARCHIVELOG.mirror_region 0 1 136 1 N Y
template.ONLINELOG.stripe 0 1 141 1 N Y
template.ONLINELOG.redundancy 18 1 144 1 N Y
template.ONLINELOG.primary_region 0 1 145 1 N Y
template.ONLINELOG.mirror_region 0 1 146 1 N Y
template.DATAFILE.stripe 0 1 151 1 N Y
template.DATAFILE.redundancy 18 1 154 1 N Y
template.DATAFILE.primary_region 0 1 155 1 N Y
template.DATAFILE.mirror_region 0 1 156 1 N Y
template.TEMPFILE.stripe 0 1 161 1 N Y
template.TEMPFILE.redundancy 18 1 164 1 N Y
template.TEMPFILE.primary_region 0 1 165 1 N Y
template.TEMPFILE.mirror_region 0 1 166 1 N Y
template.BACKUPSET.stripe 0 1 181 1 N Y
template.BACKUPSET.redundancy 18 1 184 1 N Y
template.BACKUPSET.primary_region 0 1 185 1 N Y
template.BACKUPSET.mirror_region 0 1 186 1 N Y
template.AUTOBACKUP.stripe 0 1 191 1 N Y
template.AUTOBACKUP.redundancy 18 1 194 1 N Y
template.AUTOBACKUP.primary_region 0 1 195 1 N Y
template.AUTOBACKUP.mirror_region 0 1 196 1 N Y
template.XTRANSPORT.stripe 0 1 201 1 N Y
template.XTRANSPORT.redundancy 18 1 204 1 N Y
template.XTRANSPORT.primary_region 0 1 205 1 N Y
template.XTRANSPORT.mirror_region 0 1 206 1 N Y
template.CHANGETRACKING.stripe 0 1 211 1 N Y
template.CHANGETRACKING.redundancy 18 1 214 1 N Y
template.CHANGETRACKING.primary_region 0 1 215 1 N Y
template.CHANGETRACKING.mirror_region 0 1 216 1 N Y
template.FLASHBACK.stripe 0 1 221 1 N Y
template.FLASHBACK.redundancy 18 1 224 1 N Y
template.FLASHBACK.primary_region 0 1 225 1 N Y
template.FLASHBACK.mirror_region 0 1 226 1 N Y
template.DATAGUARDCONFIG.stripe 0 1 231 1 N Y
template.DATAGUARDCONFIG.redundancy 18 1 234 1 N Y
template.DATAGUARDCONFIG.primary_region 0 1 235 1 N Y
template.DATAGUARDCONFIG.mirror_region 0 1 236 1 N Y
template.OCRFILE.stripe 0 1 241 1 N Y
template.OCRFILE.redundancy 18 1 244 1 N Y
template.OCRFILE.primary_region 0 1 245 1 N Y
template.OCRFILE.mirror_region 0 1 246 1 N Y
disk_repair_time 3.6h 2 0 1 N Y
au_size 2097152 2 5 1 Y Y
sector_size 512 2 6 1 Y Y
compatible.asm 11.2.0.0.0 2 20 1 N Y
compatible.rdbms 11.2.0.0.0 2 21 1 N Y
compatible.advm 11.2.0.0.0 2 22 1 N Y
cell.smart_scan_capable FALSE 2 30 1 N N
access_control.enabled FALSE 2 40 1 N Y
access_control.umask 066 2 41 1 N Y
template_version 186646528 2 50 1 N Y
template.PARAMETERFILE.stripe 0 2 71 1 N Y
template.PARAMETERFILE.redundancy 18 2 74 1 N Y
template.PARAMETERFILE.primary_region 0 2 75 1 N Y
template.PARAMETERFILE.mirror_region 0 2 76 1 N Y
template.ASMPARAMETERFILE.stripe 0 2 81 1 N Y
template.ASMPARAMETERFILE.redundancy 18 2 84 1 N Y
template.ASMPARAMETERFILE.primary_region 0 2 85 1 N Y
template.ASMPARAMETERFILE.mirror_region 0 2 86 1 N Y
template.DUMPSET.stripe 0 2 101 1 N Y
template.DUMPSET.redundancy 18 2 104 1 N Y
template.DUMPSET.primary_region 0 2 105 1 N Y
template.DUMPSET.mirror_region 0 2 106 1 N Y
template.CONTROLFILE.stripe 1 2 111 1 N Y
template.CONTROLFILE.redundancy 19 2 114 1 N Y
template.CONTROLFILE.primary_region 0 2 115 1 N Y
template.CONTROLFILE.mirror_region 0 2 116 1 N Y
template.FLASHFILE.stripe 0 2 121 1 N Y
template.FLASHFILE.redundancy 18 2 124 1 N Y
template.FLASHFILE.primary_region 0 2 125 1 N Y
template.FLASHFILE.mirror_region 0 2 126 1 N Y
template.ARCHIVELOG.stripe 0 2 131 1 N Y
template.ARCHIVELOG.redundancy 18 2 134 1 N Y
template.ARCHIVELOG.primary_region 0 2 135 1 N Y
template.ARCHIVELOG.mirror_region 0 2 136 1 N Y
template.ONLINELOG.stripe 0 2 141 1 N Y
template.ONLINELOG.redundancy 18 2 144 1 N Y
template.ONLINELOG.primary_region 0 2 145 1 N Y
template.ONLINELOG.mirror_region 0 2 146 1 N Y
template.DATAFILE.stripe 0 2 151 1 N Y
template.DATAFILE.redundancy 18 2 154 1 N Y
template.DATAFILE.primary_region 0 2 155 1 N Y
template.DATAFILE.mirror_region 0 2 156 1 N Y
template.TEMPFILE.stripe 0 2 161 1 N Y
template.TEMPFILE.redundancy 18 2 164 1 N Y
template.TEMPFILE.primary_region 0 2 165 1 N Y
template.TEMPFILE.mirror_region 0 2 166 1 N Y
template.BACKUPSET.stripe 0 2 181 1 N Y
template.BACKUPSET.redundancy 18 2 184 1 N Y
template.BACKUPSET.primary_region 0 2 185 1 N Y
template.BACKUPSET.mirror_region 0 2 186 1 N Y
template.AUTOBACKUP.stripe 0 2 191 1 N Y
template.AUTOBACKUP.redundancy 18 2 194 1 N Y
template.AUTOBACKUP.primary_region 0 2 195 1 N Y
template.AUTOBACKUP.mirror_region 0 2 196 1 N Y
template.XTRANSPORT.stripe 0 2 201 1 N Y
template.XTRANSPORT.redundancy 18 2 204 1 N Y
template.XTRANSPORT.primary_region 0 2 205 1 N Y
template.XTRANSPORT.mirror_region 0 2 206 1 N Y
template.CHANGETRACKING.stripe 0 2 211 1 N Y
template.CHANGETRACKING.redundancy 18 2 214 1 N Y
template.CHANGETRACKING.primary_region 0 2 215 1 N Y
template.CHANGETRACKING.mirror_region 0 2 216 1 N Y
template.FLASHBACK.stripe 0 2 221 1 N Y
template.FLASHBACK.redundancy 18 2 224 1 N Y
template.FLASHBACK.primary_region 0 2 225 1 N Y
template.FLASHBACK.mirror_region 0 2 226 1 N Y
template.DATAGUARDCONFIG.stripe 0 2 231 1 N Y
template.DATAGUARDCONFIG.redundancy 18 2 234 1 N Y
template.DATAGUARDCONFIG.primary_region 0 2 235 1 N Y
template.DATAGUARDCONFIG.mirror_region 0 2 236 1 N Y
template.OCRFILE.stripe 0 2 241 1 N Y
template.OCRFILE.redundancy 18 2 244 1 N Y
template.OCRFILE.primary_region 0 2 245 1 N Y
template.OCRFILE.mirror_region 0 2 246 1 N Y
disk_repair_time 3.6h 3 0 1 N Y
au_size 1048576 3 5 1 Y Y
sector_size 512 3 6 1 Y Y
compatible.asm 11.2.0.0.0 3 20 1 N Y
compatible.rdbms 10.1.0.0.0 3 21 1 N Y
cell.smart_scan_capable FALSE 3 30 1 N N
access_control.enabled FALSE 3 40 1 N Y
access_control.umask 066 3 41 1 N Y
template_version 186646528 3 50 1 N Y
template.PARAMETERFILE.stripe 0 3 71 1 N Y
template.PARAMETERFILE.redundancy 17 3 74 1 N Y
template.PARAMETERFILE.primary_region 0 3 75 1 N Y
template.PARAMETERFILE.mirror_region 0 3 76 1 N Y
template.ASMPARAMETERFILE.stripe 0 3 81 1 N Y
template.ASMPARAMETERFILE.redundancy 17 3 84 1 N Y
template.ASMPARAMETERFILE.primary_region 0 3 85 1 N Y
template.ASMPARAMETERFILE.mirror_region 0 3 86 1 N Y
template.DUMPSET.stripe 0 3 101 1 N Y
template.DUMPSET.redundancy 17 3 104 1 N Y
template.DUMPSET.primary_region 0 3 105 1 N Y
template.DUMPSET.mirror_region 0 3 106 1 N Y
template.CONTROLFILE.stripe 1 3 111 1 N Y
template.CONTROLFILE.redundancy 17 3 114 1 N Y
template.CONTROLFILE.primary_region 0 3 115 1 N Y
template.CONTROLFILE.mirror_region 0 3 116 1 N Y
template.FLASHFILE.stripe 0 3 121 1 N Y
template.FLASHFILE.redundancy 17 3 124 1 N Y
template.FLASHFILE.primary_region 0 3 125 1 N Y
template.FLASHFILE.mirror_region 0 3 126 1 N Y
template.ARCHIVELOG.stripe 0 3 131 1 N Y
template.ARCHIVELOG.redundancy 17 3 134 1 N Y
template.ARCHIVELOG.primary_region 0 3 135 1 N Y
template.ARCHIVELOG.mirror_region 0 3 136 1 N Y
template.ONLINELOG.stripe 0 3 141 1 N Y
template.ONLINELOG.redundancy 17 3 144 1 N Y
template.ONLINELOG.primary_region 0 3 145 1 N Y
template.ONLINELOG.mirror_region 0 3 146 1 N Y
template.DATAFILE.stripe 0 3 151 1 N Y
template.DATAFILE.redundancy 17 3 154 1 N Y
template.DATAFILE.primary_region 0 3 155 1 N Y
template.DATAFILE.mirror_region 0 3 156 1 N Y
template.TEMPFILE.stripe 0 3 161 1 N Y
template.TEMPFILE.redundancy 17 3 164 1 N Y
template.TEMPFILE.primary_region 0 3 165 1 N Y
template.TEMPFILE.mirror_region 0 3 166 1 N Y
template.BACKUPSET.stripe 0 3 181 1 N Y
template.BACKUPSET.redundancy 17 3 184 1 N Y
template.BACKUPSET.primary_region 0 3 185 1 N Y
template.BACKUPSET.mirror_region 0 3 186 1 N Y
template.AUTOBACKUP.stripe 0 3 191 1 N Y
template.AUTOBACKUP.redundancy 17 3 194 1 N Y
template.AUTOBACKUP.primary_region 0 3 195 1 N Y
NAME VALUE GROUP_NUMBER ATTRIBUTE_INDEX ATTRIBUTE_INCARNATION READ_ON SYSTEM_
template.AUTOBACKUP.mirror_region 0 3 196 1 N Y
template.XTRANSPORT.stripe 0 3 201 1 N Y
template.XTRANSPORT.redundancy 17 3 204 1 N Y
template.XTRANSPORT.primary_region 0 3 205 1 N Y
template.XTRANSPORT.mirror_region 0 3 206 1 N Y
template.CHANGETRACKING.stripe 0 3 211 1 N Y
template.CHANGETRACKING.redundancy 17 3 214 1 N Y
template.CHANGETRACKING.primary_region 0 3 215 1 N Y
template.CHANGETRACKING.mirror_region 0 3 216 1 N Y
template.FLASHBACK.stripe 0 3 221 1 N Y
template.FLASHBACK.redundancy 17 3 224 1 N Y
template.FLASHBACK.primary_region 0 3 225 1 N Y
template.FLASHBACK.mirror_region 0 3 226 1 N Y
template.DATAGUARDCONFIG.stripe 0 3 231 1 N Y
template.DATAGUARDCONFIG.redundancy 17 3 234 1 N Y
template.DATAGUARDCONFIG.primary_region 0 3 235 1 N Y
template.DATAGUARDCONFIG.mirror_region 0 3 236 1 N Y
template.OCRFILE.stripe 0 3 241 1 N Y
template.OCRFILE.redundancy 17 3 244 1 N Y
template.OCRFILE.primary_region 0 3 245 1 N Y
template.OCRFILE.mirror_region 0 3 246 1 N Y
disk_repair_time 3.6h 4 0 1 N Y
au_size 1048576 4 5 1 Y Y
sector_size 512 4 6 1 Y Y
compatible.asm 11.2.0.0.0 4 20 1 N Y
compatible.rdbms 11.2.0.0.0 4 21 1 N Y
compatible.advm 11.2.0.0.0 4 22 1 N Y
cell.smart_scan_capable FALSE 4 30 1 N N
access_control.enabled FALSE 4 40 1 N Y
access_control.umask 066 4 41 1 N Y
template_version 186646528 4 50 1 N Y
template.PARAMETERFILE.stripe 0 4 71 1 N Y
template.PARAMETERFILE.redundancy 17 4 74 1 N Y
template.PARAMETERFILE.primary_region 0 4 75 1 N Y
template.PARAMETERFILE.mirror_region 0 4 76 1 N Y
template.ASMPARAMETERFILE.stripe 0 4 81 1 N Y
template.ASMPARAMETERFILE.redundancy 17 4 84 1 N Y
template.ASMPARAMETERFILE.primary_region 0 4 85 1 N Y
template.ASMPARAMETERFILE.mirror_region 0 4 86 1 N Y
template.DUMPSET.stripe 0 4 101 1 N Y
template.DUMPSET.redundancy 17 4 104 1 N Y
template.DUMPSET.primary_region 0 4 105 1 N Y
template.DUMPSET.mirror_region 0 4 106 1 N Y
template.CONTROLFILE.stripe 1 4 111 1 N Y
template.CONTROLFILE.redundancy 17 4 114 1 N Y
template.CONTROLFILE.primary_region 0 4 115 1 N Y
template.CONTROLFILE.mirror_region 0 4 116 1 N Y
template.FLASHFILE.stripe 0 4 121 1 N Y
template.FLASHFILE.redundancy 17 4 124 1 N Y
template.FLASHFILE.primary_region 0 4 125 1 N Y
template.FLASHFILE.mirror_region 0 4 126 1 N Y
template.ARCHIVELOG.stripe 0 4 131 1 N Y
template.ARCHIVELOG.redundancy 17 4 134 1 N Y
template.ARCHIVELOG.primary_region 0 4 135 1 N Y
template.ARCHIVELOG.mirror_region 0 4 136 1 N Y
template.ONLINELOG.stripe 0 4 141 1 N Y
template.ONLINELOG.redundancy 17 4 144 1 N Y
template.ONLINELOG.primary_region 0 4 145 1 N Y
template.ONLINELOG.mirror_region 0 4 146 1 N Y
template.DATAFILE.stripe 0 4 151 1 N Y
template.DATAFILE.redundancy 17 4 154 1 N Y
template.DATAFILE.primary_region 0 4 155 1 N Y
template.DATAFILE.mirror_region 0 4 156 1 N Y
template.TEMPFILE.stripe 0 4 161 1 N Y
template.TEMPFILE.redundancy 17 4 164 1 N Y
template.TEMPFILE.primary_region 0 4 165 1 N Y
template.TEMPFILE.mirror_region 0 4 166 1 N Y
template.BACKUPSET.stripe 0 4 181 1 N Y
template.BACKUPSET.redundancy 17 4 184 1 N Y
template.BACKUPSET.primary_region 0 4 185 1 N Y
template.BACKUPSET.mirror_region 0 4 186 1 N Y
template.AUTOBACKUP.stripe 0 4 191 1 N Y
template.AUTOBACKUP.redundancy 17 4 194 1 N Y
template.AUTOBACKUP.primary_region 0 4 195 1 N Y
template.AUTOBACKUP.mirror_region 0 4 196 1 N Y
template.XTRANSPORT.stripe 0 4 201 1 N Y
template.XTRANSPORT.redundancy 17 4 204 1 N Y
template.XTRANSPORT.primary_region 0 4 205 1 N Y
template.XTRANSPORT.mirror_region 0 4 206 1 N Y
template.CHANGETRACKING.stripe 0 4 211 1 N Y
template.CHANGETRACKING.redundancy 17 4 214 1 N Y
template.CHANGETRACKING.primary_region 0 4 215 1 N Y
template.CHANGETRACKING.mirror_region 0 4 216 1 N Y
template.FLASHBACK.stripe 0 4 221 1 N Y
template.FLASHBACK.redundancy 17 4 224 1 N Y
template.FLASHBACK.primary_region 0 4 225 1 N Y
template.FLASHBACK.mirror_region 0 4 226 1 N Y
template.DATAGUARDCONFIG.stripe 0 4 231 1 N Y
template.DATAGUARDCONFIG.redundancy 17 4 234 1 N Y
template.DATAGUARDCONFIG.primary_region 0 4 235 1 N Y
template.DATAGUARDCONFIG.mirror_region 0 4 236 1 N Y
template.OCRFILE.stripe 0 4 241 1 N Y
template.OCRFILE.redundancy 17 4 244 1 N Y
template.OCRFILE.primary_region 0 4 245 1 N Y
template.OCRFILE.mirror_region 0 4 246 1 N Y
disk_repair_time 3.6h 5 0 1 N Y
au_size 1048576 5 5 1 Y Y
sector_size 512 5 6 1 Y Y
compatible.asm 11.2.0.0.0 5 20 1 N Y
compatible.rdbms 11.2.0.0.0 5 21 1 N Y
compatible.advm 11.2.0.0.0 5 22 1 N Y
cell.smart_scan_capable FALSE 5 30 1 N N
access_control.enabled FALSE 5 40 1 N Y
access_control.umask 066 5 41 1 N Y
template_version 186646528 5 50 1 N Y
template.PARAMETERFILE.stripe 0 5 71 1 N Y
template.PARAMETERFILE.redundancy 17 5 74 1 N Y
template.PARAMETERFILE.primary_region 0 5 75 1 N Y
template.PARAMETERFILE.mirror_region 0 5 76 1 N Y
template.ASMPARAMETERFILE.stripe 0 5 81 1 N Y
template.ASMPARAMETERFILE.redundancy 17 5 84 1 N Y
template.ASMPARAMETERFILE.primary_region 0 5 85 1 N Y
template.ASMPARAMETERFILE.mirror_region 0 5 86 1 N Y
template.DUMPSET.stripe 0 5 101 1 N Y
template.DUMPSET.redundancy 17 5 104 1 N Y
template.DUMPSET.primary_region 0 5 105 1 N Y
template.DUMPSET.mirror_region 0 5 106 1 N Y
template.CONTROLFILE.stripe 1 5 111 1 N Y
template.CONTROLFILE.redundancy 17 5 114 1 N Y
template.CONTROLFILE.primary_region 0 5 115 1 N Y
template.CONTROLFILE.mirror_region 0 5 116 1 N Y
template.FLASHFILE.stripe 0 5 121 1 N Y
template.FLASHFILE.redundancy 17 5 124 1 N Y
template.FLASHFILE.primary_region 0 5 125 1 N Y
template.FLASHFILE.mirror_region 0 5 126 1 N Y
template.ARCHIVELOG.stripe 0 5 131 1 N Y
template.ARCHIVELOG.redundancy 17 5 134 1 N Y
template.ARCHIVELOG.primary_region 0 5 135 1 N Y
template.ARCHIVELOG.mirror_region 0 5 136 1 N Y
template.ONLINELOG.stripe 0 5 141 1 N Y
template.ONLINELOG.redundancy 17 5 144 1 N Y
template.ONLINELOG.primary_region 0 5 145 1 N Y
template.ONLINELOG.mirror_region 0 5 146 1 N Y
template.DATAFILE.stripe 0 5 151 1 N Y
template.DATAFILE.redundancy 17 5 154 1 N Y
template.DATAFILE.primary_region 0 5 155 1 N Y
template.DATAFILE.mirror_region 0 5 156 1 N Y
template.TEMPFILE.stripe 0 5 161 1 N Y
template.TEMPFILE.redundancy 17 5 164 1 N Y
template.TEMPFILE.primary_region 0 5 165 1 N Y
template.TEMPFILE.mirror_region 0 5 166 1 N Y
template.BACKUPSET.stripe 0 5 181 1 N Y
template.BACKUPSET.redundancy 17 5 184 1 N Y
template.BACKUPSET.primary_region 0 5 185 1 N Y
template.BACKUPSET.mirror_region 0 5 186 1 N Y
template.AUTOBACKUP.stripe 0 5 191 1 N Y
template.AUTOBACKUP.redundancy 17 5 194 1 N Y
template.AUTOBACKUP.primary_region 0 5 195 1 N Y
template.AUTOBACKUP.mirror_region 0 5 196 1 N Y
template.XTRANSPORT.stripe 0 5 201 1 N Y
template.XTRANSPORT.redundancy 17 5 204 1 N Y
template.XTRANSPORT.primary_region 0 5 205 1 N Y
template.XTRANSPORT.mirror_region 0 5 206 1 N Y
template.CHANGETRACKING.stripe 0 5 211 1 N Y
template.CHANGETRACKING.redundancy 17 5 214 1 N Y
template.CHANGETRACKING.primary_region 0 5 215 1 N Y
template.CHANGETRACKING.mirror_region 0 5 216 1 N Y
template.FLASHBACK.stripe 0 5 221 1 N Y
template.FLASHBACK.redundancy 17 5 224 1 N Y
template.FLASHBACK.primary_region 0 5 225 1 N Y
template.FLASHBACK.mirror_region 0 5 226 1 N Y
template.DATAGUARDCONFIG.stripe 0 5 231 1 N Y
template.DATAGUARDCONFIG.redundancy 17 5 234 1 N Y
template.DATAGUARDCONFIG.primary_region 0 5 235 1 N Y
template.DATAGUARDCONFIG.mirror_region 0 5 236 1 N Y
template.OCRFILE.stripe 0 5 241 1 N Y
template.OCRFILE.redundancy 17 5 244 1 N Y
template.OCRFILE.primary_region 0 5 245 1 N Y
template.OCRFILE.mirror_region 0 5 246 1 N Y

369 rows selected.

SQL>
SQL> select * from v$asm_operation;
no rows selected
SQL> select * from gv$asm_operation;
no rows selected
SQL>
SQL>
SQL> select * from v$version;

BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL>
SQL>
SQL> select * from V$ASM_ACFSSNAPSHOTS;
no rows selected
SQL> select * from V$ASM_ACFSVOLUMES;

FS_NAME VOL_DEVICE VOL_LABEL PRIMA TOTAL_MB FREE_MB
/u02acfs /dev/asm/storageteam-215   TRUE 14336 14271.3203
/u03acfs /dev/asm/ebernalvol-168   TRUE 14336 14271.3203

SQL> select * from V$ASM_FILESYSTEM;

FS_NAME AVAILABLE_TIME BLOCK_SIZE STATE CORRU NUM_VOL TOTAL_SIZE TOTAL_FREE TOTAL_SNAP_SPACE_USAGE
/u02acfs 06-APR-2012 17:06:23 4 AVAILABLE FALSE 1 14336 14271.3203 0
/u03acfs 06-APR-2012 17:52:02 4 AVAILABLE FALSE 1 14336 14271.3203 0

SQL> select * from V$ASM_VOLUME;

GROUP_NUMBER VOLUME_NAME COMPOUND_INDEX SIZE_MB VOLUME_NUMBER REDUND STRIPE_COLUMNS STRIPE_WIDTH_K STATE FILE_NUMBER INCARNATION DRL_FILE_NUMBER RESIZE_UNIT_MB USAGE VOLUME_DEVICE MOUNTPATH
4 STORAGETEAM 67108865 14336 1 UNPROT 4 128 ENABLED 256 779907659 0 32 ACFS /dev/asm/storageteam-215 /u02acfs
5 EBERNALVOL 83886081 14336 1 UNPROT 4 128 ENABLED 256 779910073 0 32 ACFS /dev/asm/ebernalvol-168 /u03acfs

SQL> select * from V$ASM_VOLUME_STAT;

GROUP_NUMBER VOLUME_NAME COMPOUND_INDEX VOLUME_NUMBER READS WRITES READ_ERRS WRITE_ERRS READ_TIME WRITE_TIME BYTES_READ BYTES_WRITTEN
4 STORAGETEAM 67108865 1 285 7604 0 0 .615 20.395 274944 30898176
5 EBERNALVOL 83886081 1 285 7604 0 0 .654 21.107 274944 30898176

SQL>
SQL> select * from V$ASM_USER;
no rows selected
SQL> select * from V$ASM_USERGROUP;
no rows selected
SQL> select * from V$ASM_USERGROUP_MEMBER;
no rows selected
SQL>
SQL> select * from V$ASM_DISK_IOSTAT;

INSTNAME DBNAME GROUP_NUMBER DISK_NUMBER FAILGROUP READS WRITES READ_ERRS WRITE_ERRS READ_TIME WRITE_TIME BYTES_READ BYTES_WRITTEN HOT_READS HOT_WRITES HOT_BYTES_READ HOT_BYTES_WRITTEN COLD_READS COLD_WRITES COLD_BYTES_READ COLD_BYTES_WRITTEN
DBASM112 DBASM112 1 1 FG1 44269 1183715 0 0 607.725 5545.88 559702016 2.5912E+10 0 0 0 0 44269 1183715 559702016 2.5912E+10
DBASM112 DBASM112 1 2 FG2 43838 1190070 0 0 500.843 7674.55 534519808 3.1831E+10 0 0 0 0 43838 1190070 534519808 3.1831E+10
DBASM112 DBASM112 2 0 FG1 385852 1148616 0 0 15249.51 80105.074 9554624512 1.8314E+10 0 0 0 0 385852 1148616 9554624512 1.8314E+10
DBASM112 DBASM112 2 3 FG2 2956649 1134604 0 0 26570.468 144429.493 5.1565E+10 1.8332E+10 0 0 0 0 2956649 1134604 5.1565E+10 1.8332E+10
DBASM112 DBASM112 2 1 FG1 1515289 2836420 0 0 44587.405 112692.255 2.8082E+10 4.6107E+10 0 0 0 0 1515289 2836420 2.8082E+10 4.6107E+10
DBASM112 DBASM112 1 0 FG1 43244 1402356 0 0 587.954 8740.533 511352832 3.7284E+10 0 0 0 0 43244 1402356 511352832 3.7284E+10
DBASM112 DBASM112 2 2 FG2 773358 2850432 0 0 19526.818 69717.233 1.5853E+10 4.6088E+10 0 0 0 0 773358 2850432 1.5853E+10 4.6088E+10
DBASM112 DBASM112 1 3 FG2 54269 1396001 0 0 587.521 7257.44 622213632 3.1365E+10 0 0 0 0 54269 1396001 622213632 3.1365E+10
+ASM asmvol 4 0 ASMDISKNEW9 258 78 0 0 .531842 .102998 164352 71680 0 0 0 0 258 78 164352 71680
+ASM asmvol 5 0 ASMDISKNEW10 258 78 0 0 .564845 .101998 164352 71680 0 0 0 0 258 78 164352 71680

10 rows selected.

SQL> select * from V$ASM_DISK_STAT;

GROUP_NUMBER DISK_NUMBER COMPOUND_INDEX INCARNATION MOUNT_S HEADER_STATU MODE_ST STATE REDUNDA LIBRARY OS_MB TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB NAME FAILGROUP LABEL PATH UDID PRODUCT CREATE_DATE MOUNT_DATE REPAIR_TIMER READS WRITES READ_ERRS WRITE_ERRS READ_TIME WRITE_TIME BYTES_READ BYTES_WRITTEN P HASH_VALUE HOT_READS HOT_WRITES HOT_BYTES_READ HOT_BYTES_WRITTEN COLD_READS COLD_WRITES COLD_BYTES_READ COLD_BYTES_WRITTEN V SECTOR_SIZE FAILGRO
1 0 16777216 3915944019 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 18468 0 1070 ASMDISKNEW1 FG1 ASMDISKNEW1 ORCL:ASMDISKNEW1     05-APR-2012 18:19:29 06-APR-2012 16:47:24 0 60710 3111918 0 0 1470.738 36714.504 584806400 4.4288E+10 U 1858933910 0 0 0 0 43244 1402356 511352832 3.7284E+10 N 512 REGULAR
5 0 83886080 3915944033 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 14653 262 0 14391 ASMDISKNEW10 ASMDISKNEW10 ASMDISKNEW10 ORCL:ASMDISKNEW10     06-APR-2012 17:38:54 06-APR-2012 17:39:03 0 17598 1708672 0 0 518.172845 1631.218 72147456 7002368000   405308562 0 0 0 0 258 78 164352 71680 N 512 REGULAR
6 0 100663296 3915944054 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 14653 14603 0 14391 ASMDISKNEW11 ASMDISKNEW11 ASMDISKNEW11 ORCL:ASMDISKNEW11     12-APR-2012 11:33:52 12-APR-2012 11:40:05 0 15566 1543936 0 0 525.87 1418.397 64720896 6323961856   3808981697 0 0 0 0 0 0 0 0 N 512 REGULAR
7 0 117440512 3915944057 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 14653 14603 0 14391 ASMDISKNEW12 ASMDISKNEW12 ASMDISKNEW12 ORCL:ASMDISKNEW12     24-APR-2012 12:30:14 24-APR-2012 12:30:26 0 12074 1200847 0 0 175.415 894.616 50417664 4918669312   1517235067 0 0 0 0 0 0 0 0 N 512 REGULAR
3 0 50331648 3915944027 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 8887 8887 8828 0 59 ASMDISKNEW14 ASMDISKNEW14 ASMDISKNEW14 ORCL:ASMDISKNEW14     05-APR-2012 18:16:20 06-APR-2012 16:47:25 0 17427 1709059 0 0 434.306 6902.094 72145920 6999983104   3227115283 0 0 0 0 0 0 0 0 N 512 REGULAR
1 1 16777217 3915944020 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 18476 0 1062 ASMDISKNEW2 FG1 ASMDISKNEW2 ORCL:ASMDISKNEW2     05-APR-2012 18:19:29 06-APR-2012 16:47:24 0 44516 1183774 0 0 613.796 5546.153 560717824 2.5913E+10 U 4238862529 0 0 0 0 44269 1183715 559702016 2.5912E+10 N 512 REGULAR
1 2 16777218 3915944021 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 18476 0 1062 ASMDISKNEW3 FG2 ASMDISKNEW3 ORCL:ASMDISKNEW3     05-APR-2012 18:19:29 06-APR-2012 16:47:24 0 61146 2899101 0 0 1628.535 36883.737 605413376 3.8833E+10 U 3481199486 0 0 0 0 43838 1190070 534519808 3.1831E+10 N 512 REGULAR
1 3 16777219 3915944022 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 18468 0 1070 ASMDISKNEW4 FG2 ASMDISKNEW4 ORCL:ASMDISKNEW4     05-APR-2012 18:19:29 06-APR-2012 16:47:24 0 54505 1396591 0 0 595.391 7263.73 623177728 3.1368E+10 U 3420979251 0 0 0 0 54271 1396001 622215168 3.1365E+10 N 512 REGULAR
2 0 33554432 3915944023 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 11232 0 8306 ASMDISKNEW5 FG1 ASMDISKNEW5 ORCL:ASMDISKNEW5     05-APR-2012 18:23:20 06-APR-2012 16:47:24 0 403314 2865393 0 0 15607.731 85127.554 9628073984 2.5349E+10 U 3900773597 0 0 0 0 385852 1148616 9554624512 1.8314E+10 N 512 REGULAR
2 1 33554433 3915944024 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 11164 0 8374 ASMDISKNEW6 FG1 ASMDISKNEW6 ORCL:ASMDISKNEW6     05-APR-2012 18:23:20 06-APR-2012 16:47:24 0 1515525 2838609 0 0 44598.481 112913.049 2.8083E+10 4.6116E+10 U 3327682112 0 0 0 0 1515289 2836421 2.8082E+10 4.6107E+10 N 512 REGULAR
2 2 33554434 3915944025 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 11204 0 8334 ASMDISKNEW7 FG2 ASMDISKNEW7 ORCL:ASMDISKNEW7     05-APR-2012 18:23:20 06-APR-2012 16:47:24 0 792371 4564239 0 0 20262.815 74186.736 1.5932E+10 5.3111E+10 U 2514475167 0 0 0 0 773358 2850433 1.5853E+10 4.6088E+10 N 512 REGULAR
2 3 33554435 3915944026 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 19539 19538 11192 0 8346 ASMDISKNEW8 FG2 ASMDISKNEW8 ORCL:ASMDISKNEW8     05-APR-2012 18:23:20 06-APR-2012 16:47:24 0 2956880 1139767 0 0 26584.892 145227.893 5.1566E+10 1.8354E+10 U 3833053942 0 0 0 0 2956650 1134604 5.1565E+10 1.8332E+10 N 512 REGULAR
4 0 67108864 3915944030 CACHED MEMBER ONLINE NORMAL UNKNOWN ASM Library - Generic Linux, version 2.0.4 (KABI_V2) 14653 14653 262 0 14391 ASMDISKNEW9 ASMDISKNEW9 ASMDISKNEW9 ORCL:ASMDISKNEW9     06-APR-2012 16:59:54 06-APR-2012 17:00:05 0 17637 1709442 0 0 492.279842 1920.143 72307200 7005521920   3936317828 0 0 0 0 258 78 164352 71680 N 512 REGULAR

13 rows selected.

SQL> select * from V$ASM_DISKGROUP_STAT;

GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB HOT_USED_MB COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS COMPATIBILITY DATABASE_COMPATIBILITY V
1 DATA 512 4096 2097152 MOUNTED NORMAL 78152 73888 0 4264 19538 27175 0 11.2.0.0.0 11.2.0.0.0 N
2 RECO 512 4096 2097152 MOUNTED NORMAL 78152 44792 0 33360 19538 12627 0 11.2.0.0.0 11.2.0.0.0 N
3 SPFILE 512 4096 1048576 MOUNTED EXTERN 8887 8828 0 59 0 8828 0 11.2.0.0.0 10.1.0.0.0 N
4 ACFS 512 4096 1048576 MOUNTED EXTERN 14653 262 0 14391 0 262 0 11.2.0.0.0 11.2.0.0.0 N
5 ACFSDG 512 4096 1048576 MOUNTED EXTERN 14653 262 0 14391 0 262 0 11.2.0.0.0 11.2.0.0.0 N
7 TESTDG2 512 4096 1048576 MOUNTED EXTERN 14653 14603 0 50 0 14603 0 10.1.0.0.0 10.1.0.0.0 N
6 TESTDG 512 4096 1048576 MOUNTED EXTERN 14653 14603 0 50 0 14603 0 10.1.0.0.0 10.1.0.0.0 N

7 rows selected.

SQL>
SQL> select * from V$ASM_TEMPLATE;

GROUP_NUMBER ENTRY_NUMBER REDUND STRIPE S NAME PRIM MIRR
1 60 MIRROR COARSE Y PARAMETERFILE COLD COLD
1 61 MIRROR COARSE Y ASMPARAMETERFILE COLD COLD
1 63 MIRROR COARSE Y DUMPSET COLD COLD
1 64 HIGH FINE Y CONTROLFILE COLD COLD
1 65 MIRROR COARSE Y FLASHFILE COLD COLD
1 66 MIRROR COARSE Y ARCHIVELOG COLD COLD
1 67 MIRROR COARSE Y ONLINELOG COLD COLD
1 68 MIRROR COARSE Y DATAFILE COLD COLD
1 69 MIRROR COARSE Y TEMPFILE COLD COLD
1 170 MIRROR COARSE Y BACKUPSET COLD COLD
1 171 MIRROR COARSE Y AUTOBACKUP COLD COLD
1 172 MIRROR COARSE Y XTRANSPORT COLD COLD
1 173 MIRROR COARSE Y CHANGETRACKING COLD COLD
1 174 MIRROR COARSE Y FLASHBACK COLD COLD
1 175 MIRROR COARSE Y DATAGUARDCONFIG COLD COLD
1 176 MIRROR COARSE Y OCRFILE COLD COLD
2 60 MIRROR COARSE Y PARAMETERFILE COLD COLD
2 61 MIRROR COARSE Y ASMPARAMETERFILE COLD COLD
2 63 MIRROR COARSE Y DUMPSET COLD COLD
2 64 HIGH FINE Y CONTROLFILE COLD COLD
2 65 MIRROR COARSE Y FLASHFILE COLD COLD
2 66 MIRROR COARSE Y ARCHIVELOG COLD COLD
2 67 MIRROR COARSE Y ONLINELOG COLD COLD
2 68 MIRROR COARSE Y DATAFILE COLD COLD
2 69 MIRROR COARSE Y TEMPFILE COLD COLD
2 170 MIRROR COARSE Y BACKUPSET COLD COLD
2 171 MIRROR COARSE Y AUTOBACKUP COLD COLD
2 172 MIRROR COARSE Y XTRANSPORT COLD COLD
2 173 MIRROR COARSE Y CHANGETRACKING COLD COLD
2 174 MIRROR COARSE Y FLASHBACK COLD COLD
2 175 MIRROR COARSE Y DATAGUARDCONFIG COLD COLD
2 176 MIRROR COARSE Y OCRFILE COLD COLD
3 60 UNPROT COARSE Y PARAMETERFILE COLD COLD
3 61 UNPROT COARSE Y ASMPARAMETERFILE COLD COLD
3 63 UNPROT COARSE Y DUMPSET COLD COLD
3 64 UNPROT FINE Y CONTROLFILE COLD COLD
3 65 UNPROT COARSE Y FLASHFILE COLD COLD
3 66 UNPROT COARSE Y ARCHIVELOG COLD COLD
3 67 UNPROT COARSE Y ONLINELOG COLD COLD
3 68 UNPROT COARSE Y DATAFILE COLD COLD
3 69 UNPROT COARSE Y TEMPFILE COLD COLD
3 170 UNPROT COARSE Y BACKUPSET COLD COLD
3 171 UNPROT COARSE Y AUTOBACKUP COLD COLD
3 172 UNPROT COARSE Y XTRANSPORT COLD COLD
3 173 UNPROT COARSE Y CHANGETRACKING COLD COLD
3 174 UNPROT COARSE Y FLASHBACK COLD COLD
3 175 UNPROT COARSE Y DATAGUARDCONFIG COLD COLD
3 176 UNPROT COARSE Y OCRFILE COLD COLD
4 60 UNPROT COARSE Y PARAMETERFILE COLD COLD
4 61 UNPROT COARSE Y ASMPARAMETERFILE COLD COLD
4 63 UNPROT COARSE Y DUMPSET COLD COLD
4 64 UNPROT FINE Y CONTROLFILE COLD COLD
4 65 UNPROT COARSE Y FLASHFILE COLD COLD
4 66 UNPROT COARSE Y ARCHIVELOG COLD COLD
4 67 UNPROT COARSE Y ONLINELOG COLD COLD
4 68 UNPROT COARSE Y DATAFILE COLD COLD
4 69 UNPROT COARSE Y TEMPFILE COLD COLD
4 170 UNPROT COARSE Y BACKUPSET COLD COLD
4 171 UNPROT COARSE Y AUTOBACKUP COLD COLD
4 172 UNPROT COARSE Y XTRANSPORT COLD COLD
4 173 UNPROT COARSE Y CHANGETRACKING COLD COLD
4 174 UNPROT COARSE Y FLASHBACK COLD COLD
4 175 UNPROT COARSE Y DATAGUARDCONFIG COLD COLD
4 176 UNPROT COARSE Y OCRFILE COLD COLD
5 60 UNPROT COARSE Y PARAMETERFILE COLD COLD
5 61 UNPROT COARSE Y ASMPARAMETERFILE COLD COLD
5 63 UNPROT COARSE Y DUMPSET COLD COLD
5 64 UNPROT FINE Y CONTROLFILE COLD COLD
5 65 UNPROT COARSE Y FLASHFILE COLD COLD
5 66 UNPROT COARSE Y ARCHIVELOG COLD COLD
5 67 UNPROT COARSE Y ONLINELOG COLD COLD
5 68 UNPROT COARSE Y DATAFILE COLD COLD
5 69 UNPROT COARSE Y TEMPFILE COLD COLD
5 170 UNPROT COARSE Y BACKUPSET COLD COLD
5 171 UNPROT COARSE Y AUTOBACKUP COLD COLD
5 172 UNPROT COARSE Y XTRANSPORT COLD COLD
5 173 UNPROT COARSE Y CHANGETRACKING COLD COLD
5 174 UNPROT COARSE Y FLASHBACK COLD COLD
5 175 UNPROT COARSE Y DATAGUARDCONFIG COLD COLD
5 176 UNPROT COARSE Y OCRFILE COLD COLD
7 0 UNPROT COARSE Y PARAMETERFILE COLD COLD
7 1 UNPROT COARSE Y ASMPARAMETERFILE COLD COLD
7 3 UNPROT COARSE Y DUMPSET COLD COLD
7 4 UNPROT FINE Y CONTROLFILE COLD COLD
7 5 UNPROT COARSE Y FLASHFILE COLD COLD
7 6 UNPROT COARSE Y ARCHIVELOG COLD COLD
7 7 UNPROT COARSE Y ONLINELOG COLD COLD
7 8 UNPROT COARSE Y DATAFILE COLD COLD
7 9 UNPROT COARSE Y TEMPFILE COLD COLD
7 10 UNPROT COARSE Y BACKUPSET COLD COLD
7 11 UNPROT COARSE Y AUTOBACKUP COLD COLD
7 12 UNPROT COARSE Y XTRANSPORT COLD COLD
7 13 UNPROT COARSE Y CHANGETRACKING COLD COLD
7 14 UNPROT COARSE Y FLASHBACK COLD COLD
7 15 UNPROT COARSE Y DATAGUARDCONFIG COLD COLD
7 16 UNPROT COARSE Y OCRFILE COLD COLD
6 0 UNPROT COARSE Y PARAMETERFILE COLD COLD
6 1 UNPROT COARSE Y ASMPARAMETERFILE COLD COLD
6 3 UNPROT COARSE Y DUMPSET COLD COLD
6 4 UNPROT FINE Y CONTROLFILE COLD COLD
6 5 UNPROT COARSE Y FLASHFILE COLD COLD
6 6 UNPROT COARSE Y ARCHIVELOG COLD COLD
6 7 UNPROT COARSE Y ONLINELOG COLD COLD
6 8 UNPROT COARSE Y DATAFILE COLD COLD
6 9 UNPROT COARSE Y TEMPFILE COLD COLD
6 10 UNPROT COARSE Y BACKUPSET COLD COLD
6 11 UNPROT COARSE Y AUTOBACKUP COLD COLD
6 12 UNPROT COARSE Y XTRANSPORT COLD COLD
6 13 UNPROT COARSE Y CHANGETRACKING COLD COLD
6 14 UNPROT COARSE Y FLASHBACK COLD COLD
6 15 UNPROT COARSE Y DATAGUARDCONFIG COLD COLD
6 16 UNPROT COARSE Y OCRFILE COLD COLD

112 rows selected.

SQL>
SQL> show parameter asm

NAME TYPE VALUE
asm_diskgroups string DATA, RECO, ACFS, ACFSDG, TEST DG, TESTDG2
asm_diskstring string  
asm_power_limit integer 1
asm_preferred_read_failure_groups string  


SQL> show parameter cluster

NAME TYPE VALUE
cluster_database boolean FALSE
cluster_database_instances integer 1
cluster_interconnects string  


SQL> show parameter instance_type

NAME TYPE VALUE
instance_type string asm


SQL> show parameter instance_name

NAME TYPE VALUE
instance_name string +ASM


SQL> show parameter spfile

NAME TYPE VALUE
spfile string +SPFILE/asm/asmparameterfile/r egistry.253.779825791


SQL>
SQL> show sga

Total System Global Area 284565504 bytes
Fixed Size 1344456 bytes
Variable Size 258055224 bytes
ASM Cache 25165824 bytes


SQL>
SQL> spool off

 


 

 

Example Output (Script #3):

 

 

SQL> -- ASM Versions 10.1, 10.2, 11.1 & 11.2 SQL> SET MARKUP HTML ON SQL> set echo on
SQL>
SQL> set pagesize 200
SQL>
SQL> alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
Session altered.

SQL>
SQL> select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;

'THISASMREPORTWASGENERATEDAT:==)>'  
THIS ASM REPORT WAS GENERATED AT: ==)> 05-JUN-2012 23:58:18

SQL>
SQL>
SQL> select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';

'HOSTNAMEASSOCIATEDWITHTHISASMINSTANCE:==)>'  
HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> asmlnx2.us.oracle.com

SQL>
SQL> SELECT CONCAT('+'||GNAME, SYS_CONNECT_BY_PATH(ANAME, '/'))
2 FULL_PATH, SYSTEM_CREATED, ALIAS_DIRECTORY, FILE_TYPE
3 FROM ( SELECT B.NAME GNAME, A.PARENT_INDEX PINDEX,
4 A.NAME ANAME, A.REFERENCE_INDEX RINDEX,
5 A.SYSTEM_CREATED, A.ALIAS_DIRECTORY,
6 C.TYPE FILE_TYPE
7 FROM V$ASM_ALIAS A, V$ASM_DISKGROUP B, V$ASM_FILE C
8 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER
9 AND A.GROUP_NUMBER = C.GROUP_NUMBER(+)
10 AND A.FILE_NUMBER = C.FILE_NUMBER(+)
11 AND A.FILE_INCARNATION = C.INCARNATION(+)
12 )
13 START WITH (MOD(PINDEX, POWER(2, 24))) = 0
14 CONNECT BY PRIOR RINDEX = PINDEX;

FULL_PATH S A FILE_TYPE
+DATA/DBASM112 Y Y  
+DATA/DBASM112/DATAFILE Y Y  
+DATA/DBASM112/DATAFILE/USERS.259.779841377 Y N DATAFILE
+DATA/DBASM112/DATAFILE/EXAMPLE.261.779841663 Y N DATAFILE
+DATA/DBASM112/DATAFILE/SYSTEM.256.779841377 Y N DATAFILE
+DATA/DBASM112/DATAFILE/SYSAUX.257.779841377 Y N DATAFILE
+DATA/DBASM112/DATAFILE/UNDOTBS1.258.779841377 Y N DATAFILE
+DATA/DBASM112/TEMPFILE Y Y  
+DATA/DBASM112/TEMPFILE/TEMP.260.779841641 Y N TEMPFILE
+DATA/DBASM112/PARAMETERFILE Y Y  
+DATA/DBASM112/PARAMETERFILE/spfile.262.779842391 Y N PARAMETERFILE
+DATA/DBASM112/spfileDBASM112.ora N N PARAMETERFILE
+RECO/DBASM112 Y Y  
+RECO/DBASM112/CONTROLFILE Y Y  
+RECO/DBASM112/CONTROLFILE/Current.256.779841609 Y N CONTROLFILE
+RECO/DBASM112/ONLINELOG Y Y  
+RECO/DBASM112/ONLINELOG/group_2.258.779841617 Y N ONLINELOG
+RECO/DBASM112/ONLINELOG/group_1.257.779841613 Y N ONLINELOG
+RECO/DBASM112/ONLINELOG/group_3.259.779841623 Y N ONLINELOG
+RECO/DBASM112/ARCHIVELOG Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_05 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_05/thread_1_seq_5.260.779842897 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_06 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_6.261.779850057 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_9.264.779883133 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_12.267.779920349 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_11.266.779906875 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_10.265.779890895 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_13.268.779928493 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_8.263.779882737 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_7.262.779868367 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_07 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_18.273.780008639 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_14.269.779940249 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_15.270.779958047 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_16.271.779976037 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_17.272.779993501 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_08 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_23.278.780086045 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_19.274.780022137 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_24.279.780102033 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_20.275.780038245 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_21.276.780055231 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_22.277.780072793 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_09 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_29.284.780181243 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_25.280.780116431 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_26.281.780134451 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_27.282.780150939 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_28.283.780166299 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_10 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_34.289.780258743 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_30.285.780195647 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_35.290.780274831 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_31.286.780212197 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_32.287.780228145 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_33.288.780245763 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_11 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_40.295.780354139 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_36.291.780289243 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_37.292.780307015 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_38.293.780322741 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_39.294.780339095 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_12 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_45.300.780430731 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_41.296.780368459 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_46.301.780447445 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_42.297.780385739 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_43.298.780401843 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_44.299.780418243 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_13 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_47.302.780458447 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_52.307.780535235 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_51.306.780519651 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_50.305.780505843 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_49.304.780490819 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_48.303.780474035 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_14 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_53.308.780548419 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_58.313.780617857 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_57.312.780602449 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_56.311.780595229 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_55.310.780580191 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_54.309.780563947 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_15 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_59.314.780631217 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_64.319.780698045 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_63.318.780688901 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_62.317.780677437 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_61.316.780661237 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_60.315.780645743 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_16 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_65.320.780710641 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_68.323.780757209 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_70.325.780775447 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_69.324.780771845 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_71.326.780791541 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_67.322.780742243 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_66.321.780726037 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_17 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_77.332.780873443 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_72.327.780806063 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_73.328.780822007 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_74.329.780836739 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_75.330.780852745 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_76.331.780861889 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_18 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_83.338.780951635 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_78.333.780886829 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_84.339.780966053 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_79.334.780902347 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_80.335.780918453 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_81.336.780933605 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_82.337.780946605 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_19 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_90.345.781045217 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_85.340.780979739 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_86.341.780994825 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_87.342.781009239 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_88.343.781024745 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_89.344.781034871 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_20 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_96.351.781122357 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_91.346.781059631 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_97.352.781138241 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_92.347.781074045 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_93.348.781089541 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_94.349.781105649 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_95.350.781117965 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_21 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_103.358.781217339 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_98.353.781150265 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_99.354.781166043 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_100.355.781181869 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_101.356.781196423 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_102.357.781207851 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_22 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_109.364.781294349 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_104.359.781229943 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_110.365.781310043 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_105.360.781245885 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_106.361.781261209 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_107.362.781275741 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_108.363.781290037 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_23 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_111.366.781322549 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_113.368.781354139 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_115.370.781380835 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_114.369.781369233 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_116.371.781390043 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_112.367.781337945 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_24 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_121.376.781462297 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_117.372.781402649 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_118.373.781418041 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_119.374.781434011 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_120.375.781448427 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_122.377.781467331 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_123.378.781481847 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_25 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_128.383.781552809 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_129.384.781556421 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_130.385.781571045 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_126.381.781525041 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_127.382.781540345 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_124.379.781495231 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_125.380.781510211 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_26 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_136.391.781649273 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_131.386.781584545 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_132.387.781599607 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_133.388.781614065 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_134.389.781629049 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_135.390.781640311 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_27 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_142.397.781732853 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_137.392.781661041 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_143.398.781741227 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_138.393.781675567 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_139.394.781690649 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_140.395.781705241 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_141.396.781720445 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_28 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_144.399.781750945 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_150.405.781827721 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_149.404.781822865 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_148.403.781808421 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_147.402.781795141 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_146.401.781780523 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_145.400.781765529 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_29 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_151.406.781840857 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_157.412.781917449 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_156.411.781913137 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_155.410.781898457 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_154.409.781885945 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_153.408.781870739 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_152.407.781855599 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_30 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_163.418.782000695 Y N ARCHIVELOG
FULL_PATH S A FILE_TYPE
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_158.413.781930807 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_159.414.781945211 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_160.415.781959649 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_161.416.781974355 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_162.417.781987741 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_01 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_169.424.782164845 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_164.419.782093223 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_170.425.782173591 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_165.420.782108239 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_166.421.782122815 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_167.422.782138047 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_168.423.782153239 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_02 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_171.426.782184095 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_177.432.782260087 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_176.431.782254855 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_175.430.782240409 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_174.429.782228135 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_173.428.782213637 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_172.427.782198433 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_03 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_178.433.782272845 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_181.436.782317147 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_183.438.782344861 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_182.437.782330423 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_184.439.782348639 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_180.435.782302503 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_179.434.782287441 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_04 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_190.445.782424239 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_185.440.782362047 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_186.441.782377047 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_187.442.782391655 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_188.443.782406039 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_189.444.782418843 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_05 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_196.451.782510429 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_191.446.782438465 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_197.452.782514039 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_192.447.782452941 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_193.448.782467523 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_194.449.782483641 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_195.450.782497239 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_06 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_198.453.782526847 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_204.459.782604053 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_203.458.782597037 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_202.457.782585435 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_201.456.782570843 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_200.455.782555671 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_199.454.782541147 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_07 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_205.460.782617741 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_211.466.782694057 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_210.465.782683533 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_209.464.782673635 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_208.463.782661623 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_207.462.782647227 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_206.461.782632155 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_08 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_217.472.782770029 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_212.467.782706941 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_213.468.782722045 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_214.469.782737207 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_215.470.782751649 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_216.471.782764447 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_09 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_223.478.782855343 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_218.473.782784021 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_224.479.782859043 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_219.474.782798459 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_220.475.782812973 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_221.476.782827439 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_222.477.782841967 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_10 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_225.480.782870731 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_228.483.782914711 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_230.485.782942445 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_229.484.782929811 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_231.486.782946061 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_227.482.782900159 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_226.481.782885139 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_11 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_234.489.782989205 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_232.487.782959747 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_233.488.782974239 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_235.490.783003649 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_236.491.783017493 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_237.492.783029493 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_238.493.783037947 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_12 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_241.496.783079443 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_242.497.783094461 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_243.498.783107347 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_244.499.783115989 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_245.500.783127947 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_239.494.783050407 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_240.495.783064855 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_13 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_246.501.783140431 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_248.503.783169977 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_250.505.783198017 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_249.504.783184743 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_251.506.783202487 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_247.502.783154945 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_14 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_252.507.783216013 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_258.513.783291657 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_257.512.783288043 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_256.511.783274741 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_255.510.783260155 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_254.509.783245049 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_253.508.783230455 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_15 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_259.514.783305187 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_265.520.783384003 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_264.519.783375467 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_263.518.783363099 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_262.517.783349227 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_261.516.783334125 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_260.515.783319525 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_16 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_266.521.783396053 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_271.526.783461963 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_270.525.783453613 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_269.524.783440243 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_268.523.783425215 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_267.522.783410647 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_17 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_272.527.783475217 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_278.533.783550845 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_277.532.783547233 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_276.531.783534419 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_275.530.783519445 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_274.529.783504343 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_273.528.783489747 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_18 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_279.534.783563851 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_285.540.783637349 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_284.539.783633745 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_283.538.783622269 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_282.537.783608063 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_281.536.783593249 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_280.535.783578045 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_19 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_286.541.783650947 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_292.547.783728241 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_291.546.783721435 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_290.545.783708695 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_289.544.783694815 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_288.543.783680325 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_287.542.783665339 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_20 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_293.548.783741609 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_299.554.783820237 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_298.553.783807931 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_297.552.783798547 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_296.551.783785045 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_295.550.783770447 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_294.549.783756009 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_21 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_304.559.783892045 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_305.560.783901635 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_300.555.783835153 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_301.556.783849617 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_302.557.783864049 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_303.558.783878645 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_22 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_311.566.783979213 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_312.567.783988127 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_306.561.783907439 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_307.562.783921841 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_308.563.783936643 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_309.564.783951539 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_310.565.783966311 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_23 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_313.568.783998433 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_319.574.784074627 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_318.573.784069263 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_317.572.784054849 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_316.571.784042699 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_315.570.784027949 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_314.569.784012747 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_24 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_320.575.784087219 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_326.581.784162863 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_325.580.784159243 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_324.579.784144825 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_323.578.784131439 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_322.577.784116503 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_321.576.784101847 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_25 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_327.582.784175641 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_330.585.784220439 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_332.587.784247541 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_331.586.784232347 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_333.588.784251197 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_329.584.784205347 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_328.583.784190655 Y N ARCHIVELOG
FULL_PATH S A FILE_TYPE
+RECO/DBASM112/ARCHIVELOG/2012_05_26 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_334.589.784263651 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_339.594.784326041 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_338.593.784321231 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_337.592.784307847 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_336.591.784293203 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_335.590.784278239 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_27 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_340.595.784339229 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_343.598.784382643 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_345.600.784408835 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_344.599.784396939 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_346.601.784412345 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_342.597.784368053 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_341.596.784353613 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_28 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_347.602.784425647 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_350.605.784468857 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_352.607.784495233 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_351.606.784483237 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_353.608.784498793 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_349.604.784454413 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_348.603.784440031 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_29 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_354.609.784512063 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_360.615.784585377 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_359.614.784581861 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_358.613.784569651 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_357.612.784555237 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_356.611.784540823 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_355.610.784526443 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_30 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_361.616.784598409 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_367.622.784671959 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_366.621.784668419 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_365.620.784656053 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_364.619.784641611 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_363.618.784627231 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_362.617.784612839 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_31 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_368.623.784684821 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_369.624.784699211 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_371.626.784728027 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_372.627.784742409 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_373.628.784754057 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_374.629.784757555 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_370.625.784713625 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_01 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_381.636.784844407 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_376.631.784785619 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_375.630.784771237 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_377.632.784800059 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_378.633.784814437 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_379.634.784828827 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_380.635.784840745 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_02 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_382.637.784857645 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_388.643.784930537 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_387.642.784926011 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_386.641.784913643 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_385.640.784900141 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_384.639.784886369 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_383.638.784872015 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_03 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_389.644.784944035 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_395.650.785017163 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_394.649.785013637 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_393.648.785001631 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_392.647.784987237 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_391.646.784972855 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_390.645.784958417 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_04 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_396.651.785030435 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_402.657.785103517 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_401.656.785099387 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_400.655.785088011 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_399.654.785073633 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_398.653.785059233 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_397.652.785044809 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_05 Y Y  
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_403.658.785116823 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_409.664.785190039 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_408.663.785186435 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_407.662.785174463 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_406.661.785160019 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_405.660.785145641 Y N ARCHIVELOG
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_404.659.785131249 Y N ARCHIVELOG
+SPFILE/ASM Y Y  
+SPFILE/ASM/ASMPARAMETERFILE Y Y  
+SPFILE/ASM/ASMPARAMETERFILE/REGISTRY.253.779825791 Y N ASMPARAMETERFILE

490 rows selected.

SQL>
SQL>
SQL> spool off

 


 

 

Example Output (Script #4):

 

[grid@asmlnx2 ~]$ cat /tmp/asmcmd_script.out
ASMCMD commands to gather complementary metadata information:
==================================
                                  
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     14653      262                0             262              0             N  ACFS/
MOUNTED  EXTERN  N         512   4096  1048576     14653      262                0             262              0             N  ACFSDG/
MOUNTED  NORMAL  N         512   4096  2097152     78152    73888            19538           27175              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  2097152     78152    44300            19538           12381              0             N  RECO/
MOUNTED  EXTERN  N         512   4096  1048576      8887     8828                0            8828              0             N  SPFILE/
MOUNTED  EXTERN  N         512   4096  1048576     14653    14603                0           14603              0             N  TESTDG/
MOUNTED  EXTERN  N         512   4096  1048576     14653    14603                0           14603              0             N  TESTDG2/
==================================
                                  
Name                     
access_control.enabled   
access_control.umask     
au_size                  
cell.smart_scan_capable  
compatible.advm          
compatible.asm           
compatible.rdbms         
disk_repair_time         
sector_size              
access_control.enabled   
access_control.umask     
au_size                  
cell.smart_scan_capable  
compatible.advm          
compatible.asm           
compatible.rdbms         
disk_repair_time         
sector_size              
access_control.enabled   
access_control.umask     
au_size                  
cell.smart_scan_capable  
compatible.advm          
compatible.asm           
compatible.rdbms         
disk_repair_time         
sector_size              
access_control.enabled   
access_control.umask     
au_size                  
cell.smart_scan_capable  
compatible.advm          
compatible.asm           
compatible.rdbms         
disk_repair_time         
sector_size              
access_control.enabled   
access_control.umask     
au_size                  
cell.smart_scan_capable  
compatible.asm           
compatible.rdbms         
disk_repair_time         
sector_size              
==================================
                                  
DB_Name   Status     Software_Version  Compatible_version  Instance_Name  Disk_Group
asmvol    CONNECTED        11.2.0.3.0          11.2.0.3.0  +ASM           ACFS      
asmvol    CONNECTED        11.2.0.3.0          11.2.0.3.0  +ASM           ACFSDG    
DBASM112  CONNECTED        11.2.0.3.0          11.2.0.0.0  DBASM112       RECO      
DBASM112  CONNECTED        11.2.0.3.0          11.2.0.0.0  DBASM112       DATA      
==================================
                                  
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     14653      262                0             262              0             N  ACFS/
MOUNTED  EXTERN  N         512   4096  1048576     14653      262                0             262              0             N  ACFSDG/
MOUNTED  NORMAL  N         512   4096  2097152     78152    73888            19538           27175              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  2097152     78152    44300            19538           12381              0             N  RECO/
MOUNTED  EXTERN  N         512   4096  1048576      8887     8828                0            8828              0             N  SPFILE/
MOUNTED  EXTERN  N         512   4096  1048576     14653    14603                0           14603              0             N  TESTDG/
MOUNTED  EXTERN  N         512   4096  1048576     14653    14603                0           14603              0             N  TESTDG2/
==================================
                                  
Path
ORCL:ASMDISKNEW1
ORCL:ASMDISKNEW10
ORCL:ASMDISKNEW11
ORCL:ASMDISKNEW12
ORCL:ASMDISKNEW14
ORCL:ASMDISKNEW2
ORCL:ASMDISKNEW3
ORCL:ASMDISKNEW4
ORCL:ASMDISKNEW5
ORCL:ASMDISKNEW6
ORCL:ASMDISKNEW7
ORCL:ASMDISKNEW8
ORCL:ASMDISKNEW9
==================================
                                  
DB_Name   Instance_Name  Path                                              
DBASM112  DBASM112       +data/dbasm112/datafile/example.261.779841663     
DBASM112  DBASM112       +data/dbasm112/datafile/sysaux.257.779841377      
DBASM112  DBASM112       +data/dbasm112/datafile/system.256.779841377      
DBASM112  DBASM112       +data/dbasm112/datafile/undotbs1.258.779841377    
DBASM112  DBASM112       +data/dbasm112/datafile/users.259.779841377       
DBASM112  DBASM112       +data/dbasm112/tempfile/temp.260.779841641        
DBASM112  DBASM112       +reco/dbasm112/controlfile/current.256.779841609  
DBASM112  DBASM112       +reco/dbasm112/onlinelog/group_1.257.779841613    
DBASM112  DBASM112       +reco/dbasm112/onlinelog/group_2.258.779841617    
DBASM112  DBASM112       +reco/dbasm112/onlinelog/group_3.259.779841623    
asmvol    +ASM           +acfs/STORAGETEAM.256.779907659                   
asmvol    +ASM           +acfsdg/EBERNALVOL.256.779910073                  
==================================
                                  
Instance Process                                  OSPID Path              
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937  ORCL:ASMDISKNEW1  
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937  ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937  ORCL:ASMDISKNEW4  
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937  ORCL:ASMDISKNEW5  
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937  ORCL:ASMDISKNEW8  
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW1  
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW2  
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW3  
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW4  
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW5  
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW6  
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW7  
1        oracle@asmlnx2.us.oracle.com (GMON)      6947  ORCL:ASMDISKNEW8  
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939  ORCL:ASMDISKNEW1  
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939  ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939  ORCL:ASMDISKNEW4  
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939  ORCL:ASMDISKNEW5  
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939  ORCL:ASMDISKNEW7  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW1  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW1  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW10
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW10
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW11
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW12
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW2  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW2  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW3  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW3  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW4  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW4  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW5  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW5  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW6  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW6  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW7  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW7  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW8  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW8  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW9  
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945  ORCL:ASMDISKNEW9  
1        oracle@asmlnx2.us.oracle.com (TNS V1-V3) 6953  ORCL:ASMDISKNEW1  
==================================
                                  
Group_Name  Dsk_Name      Reads        Writes       
DATA        ASMDISKNEW1   597954560    44995096576  
DATA        ASMDISKNEW2   578252800    26305249280  
DATA        ASMDISKNEW3   618582016    39451017216  
DATA        ASMDISKNEW4   641384448    31851446272  
RECO        ASMDISKNEW5   9860640768   25827047936  
RECO        ASMDISKNEW6   28642817024  46931074560  
RECO        ASMDISKNEW7   16262656512  53971575296  
RECO        ASMDISKNEW8   52397307904  18746672640  
SPFILE      ASMDISKNEW14  73194496     7095116800   
ACFS        ASMDISKNEW9   73355776     7100655616   
ACFSDG      ASMDISKNEW10  73196032     7097501696   
TESTDG      ASMDISKNEW11  65769472     6419095552   
TESTDG2     ASMDISKNEW12  51470336     5013803008   
==================================
                                  
[oracle@dmorldb04 ~]$  asmcmd -p dsget
parameter:o/*/*
profile:o/*/*

==================================
                                  
Group_Name  Dsk_Num  State  Power  
==================================
                                  
+SPFILE/asm/asmparameterfile/registry.253.779825791
==================================
                                  
Group_Name  Group_Num  Name              
DATA        1          ARCHIVELOG        
DATA        1          ASMPARAMETERFILE  
DATA        1          AUTOBACKUP        
DATA        1          BACKUPSET         
DATA        1          CHANGETRACKING    
DATA        1          CONTROLFILE       
DATA        1          DATAFILE          
DATA        1          DATAGUARDCONFIG   
DATA        1          DUMPSET           
DATA        1          FLASHBACK         
DATA        1          FLASHFILE         
DATA        1          OCRFILE           
DATA        1          ONLINELOG         
DATA        1          PARAMETERFILE     
DATA        1          TEMPFILE          
DATA        1          XTRANSPORT        
RECO        2          ARCHIVELOG        
RECO        2          ASMPARAMETERFILE  
RECO        2          AUTOBACKUP        
RECO        2          BACKUPSET         
RECO        2          CHANGETRACKING    
RECO        2          CONTROLFILE       
RECO        2          DATAFILE          
RECO        2          DATAGUARDCONFIG   
RECO        2          DUMPSET           
RECO        2          FLASHBACK         
RECO        2          FLASHFILE         
RECO        2          OCRFILE           
RECO        2          ONLINELOG         
RECO        2          PARAMETERFILE     
RECO        2          TEMPFILE          
RECO        2          XTRANSPORT        
SPFILE      3          ARCHIVELOG        
SPFILE      3          ASMPARAMETERFILE  
SPFILE      3          AUTOBACKUP        
SPFILE      3          BACKUPSET         
SPFILE      3          CHANGETRACKING    
SPFILE      3          CONTROLFILE       
SPFILE      3          DATAFILE          
SPFILE      3          DATAGUARDCONFIG   
SPFILE      3          DUMPSET           
SPFILE      3          FLASHBACK         
SPFILE      3          FLASHFILE         
SPFILE      3          OCRFILE           
SPFILE      3          ONLINELOG         
SPFILE      3          PARAMETERFILE     
SPFILE      3          TEMPFILE          
SPFILE      3          XTRANSPORT        
ACFS        4          ARCHIVELOG        
ACFS        4          ASMPARAMETERFILE  
ACFS        4          AUTOBACKUP        
ACFS        4          BACKUPSET         
ACFS        4          CHANGETRACKING    
ACFS        4          CONTROLFILE       
ACFS        4          DATAFILE          
ACFS        4          DATAGUARDCONFIG   
ACFS        4          DUMPSET           
ACFS        4          FLASHBACK         
ACFS        4          FLASHFILE         
ACFS        4          OCRFILE           
ACFS        4          ONLINELOG         
ACFS        4          PARAMETERFILE     
ACFS        4          TEMPFILE          
ACFS        4          XTRANSPORT        
ACFSDG      5          ARCHIVELOG        
ACFSDG      5          ASMPARAMETERFILE  
ACFSDG      5          AUTOBACKUP        
ACFSDG      5          BACKUPSET         
ACFSDG      5          CHANGETRACKING    
ACFSDG      5          CONTROLFILE       
ACFSDG      5          DATAFILE          
ACFSDG      5          DATAGUARDCONFIG   
ACFSDG      5          DUMPSET           
ACFSDG      5          FLASHBACK         
ACFSDG      5          FLASHFILE         
ACFSDG      5          OCRFILE           
ACFSDG      5          ONLINELOG         
ACFSDG      5          PARAMETERFILE     
ACFSDG      5          TEMPFILE          
ACFSDG      5          XTRANSPORT        
TESTDG      6          ARCHIVELOG        
TESTDG      6          ASMPARAMETERFILE  
TESTDG      6          AUTOBACKUP        
TESTDG      6          BACKUPSET         
TESTDG      6          CHANGETRACKING    
TESTDG      6          CONTROLFILE       
TESTDG      6          DATAFILE          
TESTDG      6          DATAGUARDCONFIG   
TESTDG      6          DUMPSET           
TESTDG      6          FLASHBACK         
TESTDG      6          FLASHFILE         
TESTDG      6          OCRFILE           
TESTDG      6          ONLINELOG         
TESTDG      6          PARAMETERFILE     
TESTDG      6          TEMPFILE          
TESTDG      6          XTRANSPORT        
TESTDG2     7          ARCHIVELOG        
TESTDG2     7          ASMPARAMETERFILE  
TESTDG2     7          AUTOBACKUP        
TESTDG2     7          BACKUPSET         
TESTDG2     7          CHANGETRACKING    
TESTDG2     7          CONTROLFILE       
TESTDG2     7          DATAFILE          
TESTDG2     7          DATAGUARDCONFIG   
TESTDG2     7          DUMPSET           
TESTDG2     7          FLASHBACK         
TESTDG2     7          FLASHFILE         
TESTDG2     7          OCRFILE           
TESTDG2     7          ONLINELOG         
TESTDG2     7          PARAMETERFILE     
TESTDG2     7          TEMPFILE          
TESTDG2     7          XTRANSPORT        
==================================
                                  
DG_Name User_Num OS_ID OS_Name
==================================
                                  
DG_Name  Grp_Name  Owner  
==================================
                                  
Username sysdba sysoper sysasm
     SYS   TRUE    TRUE   TRUE
 ASMSNMP   TRUE   FALSE  FALSE
==================================
                                  
Diskgroup Name: ACFS

         Volume Name: STORAGETEAM
         Volume Device: /dev/asm/storageteam-215
         State: ENABLED
         Size (MB): 14336
         Resize Unit (MB): 32
         Redundancy: UNPROT
         Stripe Columns: 4
         Stripe Width (K): 128
         Usage: ACFS
         Mountpath: /u02acfs

Diskgroup Name: ACFSDG

         Volume Name: EBERNALVOL
         Volume Device: /dev/asm/ebernalvol-168
         State: ENABLED
         Size (MB): 14336
         Resize Unit (MB): 32
         Redundancy: UNPROT
         Stripe Columns: 4
         Stripe Width (K): 128
         Usage: ACFS
         Mountpath: /u03acfs

==================================




References

NOTE:1092213.1 - ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only).
NOTE:950200.1 - ASM 11gR2: How To Upgrade An ASM Instance To Release 11gR2 (11.2.0.X)?
NOTE:1376731.1 - ASM 11gR2 Grid Infrastructure And RDBMS/Database Installation & Configuration Using ASM Job Role Separation (A Complete Guide).
NOTE:1422517.1 - Reconfiguring & Recreating The 11gR2 Restart/OHAS/SIHA Stack Configuration (Standalone).
NOTE:580153.1 - How To Setup ASM on Linux Using ASMLIB Disks, Raw Devices, Block Devices or UDEV Devices?
NOTE:788273.1 - ASM Upgrade From Release 10g To 11gR1 (11.1).
NOTE:1528148.1 - How To Setup Partitioned Linux Block Devices Using UDEV (Non-ASMLIB) And Assign Them To ASM?


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1107628/,如需轉載,請註明出處,否則將追究法律責任。

相關文章