How To Gather & Backup ASM/ACFS Metadata In A Formatted Manner version 10.1, 10.2, 11.1, 11.2, 12.1, 12.2, 18.x and 19.x (Doc ID 470211.1)

 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:

Exadata Database Machine X2-2 Hardware - Version All Versions to All Versions [Release All Releases]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

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):

 

-- Property: Oracle Corporation

 

SPOOL ASM<#>_GENERIC_ASM_METADATA.html
-- ASM VERSIONS 10.1, 10.2, 11.1, 11.2, 12.1 & 12.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 'INSTANCE NAME: ==)> ' , INSTANCE_NAME " " FROM V$INSTANCE;

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 GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, MODE_STATUS, STATE, OS_MB, TOTAL_MB, FREE_MB, NAME, FAILGROUP, PATH
FROM V$ASM_DISK ORDER BY GROUP_NUMBER, FAILGROUP, DISK_NUMBER;

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;

-- SPARSE Diskgroups VIEW

SELECT * FROM V$ASM_DISK_SPARSE;
SELECT * FROM V$ASM_DISKGROUP_SPARSE;

-- FLEX Diskgroup Info.

set lines 300
SELECT * FROM V$ASM_FILEGROUP;
SELECT FILEGROUP_NUMBER, file_type, NAME, VALUE FROM V$ASM_FILEGROUP_PROPERTY;

SPOOL OFF

EXIT

 

 

---

 

 

Script #2 (ASM Files & ASM Alias):

 

 

-- Property: Oracle Corporation

 

spool asm<#>_alias+files.html
-- ASM VERSIONS 10.1, 10.2, 11.1, 11.2, 12.1 & 12.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):

 

 

-- Property: Oracle Corporation

 

 

spool asm<#>_full_path_alias_directory.html
-- ASM VERSIONS 10.1, 10.2, 11.1, 11.2, 12.1 & 12.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 ###
################################################################################################
###                                                                 ###
################################################################################################
###  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.

From 12.1.0.2, command "asmcmd -p volinfo -a" should be replaced to "asmcmd -p volinfo --all"
 

 

Execution Example:

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


Output file:

[grid@<HOSTNAME2> ~]$ 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: ==)>	<HOSTNAME2>.<DOMAIN_NAME>

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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<INST_NAME>	<DB_NAME>	CONNECTED	11.2.0.3.0	11.2.0.0.0
1	<INST_NAME>	<DB_NAME>	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	<INST_NAME>	<DB_NAME>	11.2.0.3.0	11.2.0.0.0
RECO	<INST_NAME>	<DB_NAME>	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/<VOL1>		TRUE	14336	14271.3203
/u03acfs	/dev/asm/<VOL2>		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	<VOL_NAME1>	67108865	14336	1	UNPROT	4	128	ENABLED	256	779907659	0	32	ACFS	/dev/asm/<VOL1>	/u02acfs
5	<VOL_NAME2>	83886081	14336	1	UNPROT	4	128	ENABLED	256	779910073	0	32	ACFS	/dev/asm/<VOL2>	/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	<VOL_NAME1>	67108865	1	285	7604	0	0	.615	20.395	274944	30898176
5	<VOL_NAME2>	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
<INST_NAME>	<DB_NAME>	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
<INST_NAME>	<DB_NAME>	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
<INST_NAME>	<DB_NAME>	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
<INST_NAME>	<DB_NAME>	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
<INST_NAME>	<DB_NAME>	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
<INST_NAME>	<DB_NAME>	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
<INST_NAME>	<DB_NAME>	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
<INST_NAME>	<DB_NAME>	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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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	<DB_NAME>: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/registry.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: ==)>	<HOSTNAME2>.<DOMAIN_NAME>

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

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