How To Gather & Backup ASM/ACFS Metadata In A Formatted Manner version 10.1, 10.2, 11.1, 11.2, 12.1 and 12.2?

Asset ID:	1-71-470211.1
Update Date:	2017-10-24
Keywords:

Solution Type Technical Instruction Sure

Solution 470211.1 : How To Gather & Backup ASM/ACFS Metadata In A Formatted Manner version 10.1, 10.2, 11.1, 11.2, 12.1 and 12.2?

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.2.0.1 [Release 10.1 to 12.2]
Exadata Database Machine X2-2 Hardware - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.
***Checked for relevance on 30-Apr-2010***

Goal

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

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

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

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

Solution

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

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

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

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

Script #1 (Generic ASM metadata):

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

SPOOL ASM<#>_GENERIC_ASM_METADATA.html
-- ASM VERSIONS 10.1, 10.2, 11.1, 11.2, 12.1 & 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;

SPOOL OFF

EXIT

Script #2 (ASM Files & ASM Alias):

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

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

-- Author: Esteban D. Bernal
-- 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 ###
################################################################################################
### Author: Esteban D. Bernal                                                               ###
################################################################################################
### Property: Oracle Corporation                                                            ###
################################################################################################

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

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

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

Execution Example:

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

Output file:

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

Example Output (Script #1):

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

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

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

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

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

SQL>
SQL> select * from v$asm_diskgroup;

GROUP_NUMBER	NAME	SECTOR_SIZE	BLOCK_SIZE	ALLOCATION_UNIT_SIZE	STATE	TYPE	TOTAL_MB	FREE_MB	COLD_USED_MB	REQUIRED_MIRROR_FREE_MB	USABLE_FILE_MB	COMPATIBILITY	DATABASE_COMPATIBILITY	V
1	DATA	512	4096	2097152	MOUNTED	NORMAL	78152	73888	4264	19538	27175	11.2.0.0.0	11.2.0.0.0	N
2	RECO	512	4096	2097152	MOUNTED	NORMAL	78152	44792	33360	19538	12627	11.2.0.0.0	11.2.0.0.0	N
3	SPFILE	512	4096	1048576	MOUNTED	EXTERN	8887	8828	59	0	8828	11.2.0.0.0	10.1.0.0.0	N
4	ACFS	512	4096	1048576	MOUNTED	EXTERN	14653	262	14391	0	262	11.2.0.0.0	11.2.0.0.0	N
5	ACFSDG	512	4096	1048576	MOUNTED	EXTERN	14653	262	14391	0	262	11.2.0.0.0	11.2.0.0.0	N
7	TESTDG2	512	4096	1048576	MOUNTED	EXTERN	14653	14603	50	0	14603	10.1.0.0.0	10.1.0.0.0	N
6	TESTDG	512	4096	1048576	MOUNTED	EXTERN	14653	14603	50	0	14603	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	COLD_USED_MB	NAME	FAILGROUP	LABEL	PATH	CREATE_DATE	MOUNT_DATE	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			ASMDISKNEW13	ORCL:ASMDISKNEW13												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	1070	ASMDISKNEW1	FG1	ASMDISKNEW1	ORCL:ASMDISKNEW1	05-APR-2012 18:19:29	06-APR-2012 16:47:24	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	1062	ASMDISKNEW2	FG1	ASMDISKNEW2	ORCL:ASMDISKNEW2	05-APR-2012 18:19:29	06-APR-2012 16:47:24	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	1062	ASMDISKNEW3	FG2	ASMDISKNEW3	ORCL:ASMDISKNEW3	05-APR-2012 18:19:29	06-APR-2012 16:47:24	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	1070	ASMDISKNEW4	FG2	ASMDISKNEW4	ORCL:ASMDISKNEW4	05-APR-2012 18:19:29	06-APR-2012 16:47:24	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	8306	ASMDISKNEW5	FG1	ASMDISKNEW5	ORCL:ASMDISKNEW5	05-APR-2012 18:23:20	06-APR-2012 16:47:24	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	8374	ASMDISKNEW6	FG1	ASMDISKNEW6	ORCL:ASMDISKNEW6	05-APR-2012 18:23:20	06-APR-2012 16:47:24	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	8334	ASMDISKNEW7	FG2	ASMDISKNEW7	ORCL:ASMDISKNEW7	05-APR-2012 18:23:20	06-APR-2012 16:47:24	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	8346	ASMDISKNEW8	FG2	ASMDISKNEW8	ORCL:ASMDISKNEW8	05-APR-2012 18:23:20	06-APR-2012 16:47:24	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	59	ASMDISKNEW14	ASMDISKNEW14	ASMDISKNEW14	ORCL:ASMDISKNEW14	05-APR-2012 18:16:20	06-APR-2012 16:47:25	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	14391	ASMDISKNEW9	ASMDISKNEW9	ASMDISKNEW9	ORCL:ASMDISKNEW9	06-APR-2012 16:59:54	06-APR-2012 17:00:05	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	14391	ASMDISKNEW10	ASMDISKNEW10	ASMDISKNEW10	ORCL:ASMDISKNEW10	06-APR-2012 17:38:54	06-APR-2012 17:39:03	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	14391	ASMDISKNEW11	ASMDISKNEW11	ASMDISKNEW11	ORCL:ASMDISKNEW11	12-APR-2012 11:33:52	12-APR-2012 11:40:05	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	14391	ASMDISKNEW12	ASMDISKNEW12	ASMDISKNEW12	ORCL:ASMDISKNEW12	24-APR-2012 12:30:14	24-APR-2012 12:30:26	12072	1200844	0	0	175.236	894.613	50409472	4918657024		1517235067	0	0	0	0	0	0	0	0	N	512	REGULAR

14 rows selected.

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

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

13 rows selected.

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

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

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

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

SQL>
SQL> select * from V$ASM_ATTRIBUTE;

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

369 rows selected.

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

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

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

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

SQL> select * from V$ASM_FILESYSTEM;

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

SQL> select * from V$ASM_VOLUME;

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

SQL> select * from V$ASM_VOLUME_STAT;

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

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

INSTNAME	DBNAME	GROUP_NUMBER	DISK_NUMBER	FAILGROUP	READS	WRITES	READ_TIME	WRITE_TIME	BYTES_READ	BYTES_WRITTEN	COLD_READS	COLD_WRITES	COLD_BYTES_READ	COLD_BYTES_WRITTEN
DBASM112	DBASM112	1	1	FG1	44269	1183715	607.725	5545.88	559702016	2.5912E+10	44269	1183715	559702016	2.5912E+10
DBASM112	DBASM112	1	2	FG2	43838	1190070	500.843	7674.55	534519808	3.1831E+10	43838	1190070	534519808	3.1831E+10
DBASM112	DBASM112	2	0	FG1	385852	1148616	15249.51	80105.074	9554624512	1.8314E+10	385852	1148616	9554624512	1.8314E+10
DBASM112	DBASM112	2	3	FG2	2956649	1134604	26570.468	144429.493	5.1565E+10	1.8332E+10	2956649	1134604	5.1565E+10	1.8332E+10
DBASM112	DBASM112	2	1	FG1	1515289	2836420	44587.405	112692.255	2.8082E+10	4.6107E+10	1515289	2836420	2.8082E+10	4.6107E+10
DBASM112	DBASM112	1	0	FG1	43244	1402356	587.954	8740.533	511352832	3.7284E+10	43244	1402356	511352832	3.7284E+10
DBASM112	DBASM112	2	2	FG2	773358	2850432	19526.818	69717.233	1.5853E+10	4.6088E+10	773358	2850432	1.5853E+10	4.6088E+10
DBASM112	DBASM112	1	3	FG2	54269	1396001	587.521	7257.44	622213632	3.1365E+10	54269	1396001	622213632	3.1365E+10
+ASM	asmvol	4	0	ASMDISKNEW9	258	78	.531842	.102998	164352	71680	258	78	164352	71680
+ASM	asmvol	5	0	ASMDISKNEW10	258	78	.564845	.101998	164352	71680	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	COLD_USED_MB	NAME	FAILGROUP	LABEL	PATH	CREATE_DATE	MOUNT_DATE	READS	WRITES	READ_TIME	WRITE_TIME	BYTES_READ	BYTES_WRITTEN	P	HASH_VALUE	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	1070	ASMDISKNEW1	FG1	ASMDISKNEW1	ORCL:ASMDISKNEW1	05-APR-2012 18:19:29	06-APR-2012 16:47:24	60710	3111918	1470.738	36714.504	584806400	4.4288E+10	U	1858933910	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	14391	ASMDISKNEW10	ASMDISKNEW10	ASMDISKNEW10	ORCL:ASMDISKNEW10	06-APR-2012 17:38:54	06-APR-2012 17:39:03	17598	1708672	518.172845	1631.218	72147456	7002368000		405308562	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	14391	ASMDISKNEW11	ASMDISKNEW11	ASMDISKNEW11	ORCL:ASMDISKNEW11	12-APR-2012 11:33:52	12-APR-2012 11:40:05	15566	1543936	525.87	1418.397	64720896	6323961856		3808981697	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	14391	ASMDISKNEW12	ASMDISKNEW12	ASMDISKNEW12	ORCL:ASMDISKNEW12	24-APR-2012 12:30:14	24-APR-2012 12:30:26	12074	1200847	175.415	894.616	50417664	4918669312		1517235067	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	59	ASMDISKNEW14	ASMDISKNEW14	ASMDISKNEW14	ORCL:ASMDISKNEW14	05-APR-2012 18:16:20	06-APR-2012 16:47:25	17427	1709059	434.306	6902.094	72145920	6999983104		3227115283	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	1062	ASMDISKNEW2	FG1	ASMDISKNEW2	ORCL:ASMDISKNEW2	05-APR-2012 18:19:29	06-APR-2012 16:47:24	44516	1183774	613.796	5546.153	560717824	2.5913E+10	U	4238862529	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	1062	ASMDISKNEW3	FG2	ASMDISKNEW3	ORCL:ASMDISKNEW3	05-APR-2012 18:19:29	06-APR-2012 16:47:24	61146	2899101	1628.535	36883.737	605413376	3.8833E+10	U	3481199486	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	1070	ASMDISKNEW4	FG2	ASMDISKNEW4	ORCL:ASMDISKNEW4	05-APR-2012 18:19:29	06-APR-2012 16:47:24	54505	1396591	595.391	7263.73	623177728	3.1368E+10	U	3420979251	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	8306	ASMDISKNEW5	FG1	ASMDISKNEW5	ORCL:ASMDISKNEW5	05-APR-2012 18:23:20	06-APR-2012 16:47:24	403314	2865393	15607.731	85127.554	9628073984	2.5349E+10	U	3900773597	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	8374	ASMDISKNEW6	FG1	ASMDISKNEW6	ORCL:ASMDISKNEW6	05-APR-2012 18:23:20	06-APR-2012 16:47:24	1515525	2838609	44598.481	112913.049	2.8083E+10	4.6116E+10	U	3327682112	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	8334	ASMDISKNEW7	FG2	ASMDISKNEW7	ORCL:ASMDISKNEW7	05-APR-2012 18:23:20	06-APR-2012 16:47:24	792371	4564239	20262.815	74186.736	1.5932E+10	5.3111E+10	U	2514475167	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	8346	ASMDISKNEW8	FG2	ASMDISKNEW8	ORCL:ASMDISKNEW8	05-APR-2012 18:23:20	06-APR-2012 16:47:24	2956880	1139767	26584.892	145227.893	5.1566E+10	1.8354E+10	U	3833053942	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	14391	ASMDISKNEW9	ASMDISKNEW9	ASMDISKNEW9	ORCL:ASMDISKNEW9	06-APR-2012 16:59:54	06-APR-2012 17:00:05	17637	1709442	492.279842	1920.143	72307200	7005521920		3936317828	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	COLD_USED_MB	REQUIRED_MIRROR_FREE_MB	USABLE_FILE_MB	COMPATIBILITY	DATABASE_COMPATIBILITY	V
1	DATA	512	4096	2097152	MOUNTED	NORMAL	78152	73888	4264	19538	27175	11.2.0.0.0	11.2.0.0.0	N
2	RECO	512	4096	2097152	MOUNTED	NORMAL	78152	44792	33360	19538	12627	11.2.0.0.0	11.2.0.0.0	N
3	SPFILE	512	4096	1048576	MOUNTED	EXTERN	8887	8828	59	0	8828	11.2.0.0.0	10.1.0.0.0	N
4	ACFS	512	4096	1048576	MOUNTED	EXTERN	14653	262	14391	0	262	11.2.0.0.0	11.2.0.0.0	N
5	ACFSDG	512	4096	1048576	MOUNTED	EXTERN	14653	262	14391	0	262	11.2.0.0.0	11.2.0.0.0	N
7	TESTDG2	512	4096	1048576	MOUNTED	EXTERN	14653	14603	50	0	14603	10.1.0.0.0	10.1.0.0.0	N
6	TESTDG	512	4096	1048576	MOUNTED	EXTERN	14653	14603	50	0	14603	10.1.0.0.0	10.1.0.0.0	N

7 rows selected.

SQL>
SQL> select * from V$ASM_TEMPLATE;

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

112 rows selected.

SQL>
SQL> show parameter asm

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

SQL> show parameter cluster

NAME	TYPE	VALUE
cluster_database	boolean	FALSE
cluster_database_instances	integer	1
cluster_interconnects	string

SQL> show parameter instance_type

NAME	TYPE	VALUE
instance_type	string	asm

SQL> show parameter instance_name

NAME	TYPE	VALUE
instance_name	string	+ASM

SQL> show parameter spfile

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

SQL>
SQL> show sga

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

SQL>
SQL> spool off

Example Output (Script #3):

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

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

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

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

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

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

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

490 rows selected.

SQL>
SQL>
SQL> spool off

Example Output (Script #4):

[grid@asmlnx2 ~]$ cat /tmp/asmcmd_script.out
ASMCMD commands to gather complementary metadata information:
==================================

State    Type    Rebal Sector Block       AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N         512   4096 1048576     14653      262                0             262              0             N ACFS/
MOUNTED EXTERN N         512   4096 1048576     14653      262                0             262              0             N ACFSDG/
MOUNTED NORMAL N         512   4096 2097152     78152    73888            19538           27175              0             N DATA/
MOUNTED NORMAL N         512   4096 2097152     78152    44300            19538           12381              0             N RECO/
MOUNTED EXTERN N         512   4096 1048576      8887     8828                0            8828              0             N SPFILE/
MOUNTED EXTERN N         512   4096 1048576     14653    14603                0           14603              0             N TESTDG/
MOUNTED EXTERN N         512   4096 1048576     14653    14603                0           14603              0             N TESTDG2/
==================================

Name
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.advm
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.advm
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.advm
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.advm
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
==================================

DB_Name   Status     Software_Version Compatible_version Instance_Name Disk_Group
asmvol    CONNECTED        11.2.0.3.0          11.2.0.3.0 +ASM           ACFS
asmvol    CONNECTED        11.2.0.3.0          11.2.0.3.0 +ASM           ACFSDG
DBASM112 CONNECTED        11.2.0.3.0          11.2.0.0.0 DBASM112       RECO
DBASM112 CONNECTED        11.2.0.3.0          11.2.0.0.0 DBASM112       DATA
==================================

State    Type    Rebal Sector Block       AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N         512   4096 1048576     14653      262                0             262              0             N ACFS/
MOUNTED EXTERN N         512   4096 1048576     14653      262                0             262              0             N ACFSDG/
MOUNTED NORMAL N         512   4096 2097152     78152    73888            19538           27175              0             N DATA/
MOUNTED NORMAL N         512   4096 2097152     78152    44300            19538           12381              0             N RECO/
MOUNTED EXTERN N         512   4096 1048576      8887     8828                0            8828              0             N SPFILE/
MOUNTED EXTERN N         512   4096 1048576     14653    14603                0           14603              0             N TESTDG/
MOUNTED EXTERN N         512   4096 1048576     14653    14603                0           14603              0             N TESTDG2/
==================================

Path
ORCL:ASMDISKNEW1
ORCL:ASMDISKNEW10
ORCL:ASMDISKNEW11
ORCL:ASMDISKNEW12
ORCL:ASMDISKNEW14
ORCL:ASMDISKNEW2
ORCL:ASMDISKNEW3
ORCL:ASMDISKNEW4
ORCL:ASMDISKNEW5
ORCL:ASMDISKNEW6
ORCL:ASMDISKNEW7
ORCL:ASMDISKNEW8
ORCL:ASMDISKNEW9
==================================

DB_Name   Instance_Name Path
DBASM112 DBASM112       +data/dbasm112/datafile/example.261.779841663
DBASM112 DBASM112       +data/dbasm112/datafile/sysaux.257.779841377
DBASM112 DBASM112       +data/dbasm112/datafile/system.256.779841377
DBASM112 DBASM112       +data/dbasm112/datafile/undotbs1.258.779841377
DBASM112 DBASM112       +data/dbasm112/datafile/users.259.779841377
DBASM112 DBASM112       +data/dbasm112/tempfile/temp.260.779841641
DBASM112 DBASM112       +reco/dbasm112/controlfile/current.256.779841609
DBASM112 DBASM112       +reco/dbasm112/onlinelog/group_1.257.779841613
DBASM112 DBASM112       +reco/dbasm112/onlinelog/group_2.258.779841617
DBASM112 DBASM112       +reco/dbasm112/onlinelog/group_3.259.779841623
asmvol    +ASM           +acfs/STORAGETEAM.256.779907659
asmvol    +ASM           +acfsdg/EBERNALVOL.256.779910073
==================================

Instance Process                                  OSPID Path
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937 ORCL:ASMDISKNEW1
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937 ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937 ORCL:ASMDISKNEW4
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937 ORCL:ASMDISKNEW5
1        oracle@asmlnx2.us.oracle.com (DBW0)      6937 ORCL:ASMDISKNEW8
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW1
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW2
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW3
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW4
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW5
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW6
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW7
1        oracle@asmlnx2.us.oracle.com (GMON)      6947 ORCL:ASMDISKNEW8
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939 ORCL:ASMDISKNEW1
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939 ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939 ORCL:ASMDISKNEW4
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939 ORCL:ASMDISKNEW5
1        oracle@asmlnx2.us.oracle.com (LGWR)      6939 ORCL:ASMDISKNEW7
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW1
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW1
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW10
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW10
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW11
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW12
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW14
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW2
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW2
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW3
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW3
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW4
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW4
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW5
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW5
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW6
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW6
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW7
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW7
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW8
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW8
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW9
1        oracle@asmlnx2.us.oracle.com (RBAL)      6945 ORCL:ASMDISKNEW9
1        oracle@asmlnx2.us.oracle.com (TNS V1-V3) 6953 ORCL:ASMDISKNEW1
==================================

Group_Name Dsk_Name      Reads        Writes
DATA        ASMDISKNEW1   597954560    44995096576
DATA        ASMDISKNEW2   578252800    26305249280
DATA        ASMDISKNEW3   618582016    39451017216
DATA        ASMDISKNEW4   641384448    31851446272
RECO        ASMDISKNEW5   9860640768   25827047936
RECO        ASMDISKNEW6   28642817024 46931074560
RECO        ASMDISKNEW7   16262656512 53971575296
RECO        ASMDISKNEW8   52397307904 18746672640
SPFILE      ASMDISKNEW14 73194496     7095116800
ACFS        ASMDISKNEW9   73355776     7100655616
ACFSDG      ASMDISKNEW10 73196032     7097501696
TESTDG      ASMDISKNEW11 65769472     6419095552
TESTDG2     ASMDISKNEW12 51470336     5013803008
==================================

[oracle@dmorldb04 ~]$ asmcmd -p dsget
parameter:o/*/*
profile:o/*/*

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

Group_Name Dsk_Num State Power
==================================

+SPFILE/asm/asmparameterfile/registry.253.779825791
==================================

Group_Name Group_Num Name
DATA        1          ARCHIVELOG
DATA        1          ASMPARAMETERFILE
DATA        1          AUTOBACKUP
DATA        1          BACKUPSET
DATA        1          CHANGETRACKING
DATA        1          CONTROLFILE
DATA        1          DATAFILE
DATA        1          DATAGUARDCONFIG
DATA        1          DUMPSET
DATA        1          FLASHBACK
DATA        1          FLASHFILE
DATA        1          OCRFILE
DATA        1          ONLINELOG
DATA        1          PARAMETERFILE
DATA        1          TEMPFILE
DATA        1          XTRANSPORT
RECO        2          ARCHIVELOG
RECO        2          ASMPARAMETERFILE
RECO        2          AUTOBACKUP
RECO        2          BACKUPSET
RECO        2          CHANGETRACKING
RECO        2          CONTROLFILE
RECO        2          DATAFILE
RECO        2          DATAGUARDCONFIG
RECO        2          DUMPSET
RECO        2          FLASHBACK
RECO        2          FLASHFILE
RECO        2          OCRFILE
RECO        2          ONLINELOG
RECO        2          PARAMETERFILE
RECO        2          TEMPFILE
RECO        2          XTRANSPORT
SPFILE      3          ARCHIVELOG
SPFILE      3          ASMPARAMETERFILE
SPFILE      3          AUTOBACKUP
SPFILE      3          BACKUPSET
SPFILE      3          CHANGETRACKING
SPFILE      3          CONTROLFILE
SPFILE      3          DATAFILE
SPFILE      3          DATAGUARDCONFIG
SPFILE      3          DUMPSET
SPFILE      3          FLASHBACK
SPFILE      3          FLASHFILE
SPFILE      3          OCRFILE
SPFILE      3          ONLINELOG
SPFILE      3          PARAMETERFILE
SPFILE      3          TEMPFILE
SPFILE      3          XTRANSPORT
ACFS        4          ARCHIVELOG
ACFS        4          ASMPARAMETERFILE
ACFS        4          AUTOBACKUP
ACFS        4          BACKUPSET
ACFS        4          CHANGETRACKING
ACFS        4          CONTROLFILE
ACFS        4          DATAFILE
ACFS        4          DATAGUARDCONFIG
ACFS        4          DUMPSET
ACFS        4          FLASHBACK
ACFS        4          FLASHFILE
ACFS        4          OCRFILE
ACFS        4          ONLINELOG
ACFS        4          PARAMETERFILE
ACFS        4          TEMPFILE
ACFS        4          XTRANSPORT
ACFSDG      5          ARCHIVELOG
ACFSDG      5          ASMPARAMETERFILE
ACFSDG      5          AUTOBACKUP
ACFSDG      5          BACKUPSET
ACFSDG      5          CHANGETRACKING
ACFSDG      5          CONTROLFILE
ACFSDG      5          DATAFILE
ACFSDG      5          DATAGUARDCONFIG
ACFSDG      5          DUMPSET
ACFSDG      5          FLASHBACK
ACFSDG      5          FLASHFILE
ACFSDG      5          OCRFILE
ACFSDG      5          ONLINELOG
ACFSDG      5          PARAMETERFILE
ACFSDG      5          TEMPFILE
ACFSDG      5          XTRANSPORT
TESTDG      6          ARCHIVELOG
TESTDG      6          ASMPARAMETERFILE
TESTDG      6          AUTOBACKUP
TESTDG      6          BACKUPSET
TESTDG      6          CHANGETRACKING
TESTDG      6          CONTROLFILE
TESTDG      6          DATAFILE
TESTDG      6          DATAGUARDCONFIG
TESTDG      6          DUMPSET
TESTDG      6          FLASHBACK
TESTDG      6          FLASHFILE
TESTDG      6          OCRFILE
TESTDG      6          ONLINELOG
TESTDG      6          PARAMETERFILE
TESTDG      6          TEMPFILE
TESTDG      6          XTRANSPORT
TESTDG2     7          ARCHIVELOG
TESTDG2     7          ASMPARAMETERFILE
TESTDG2     7          AUTOBACKUP
TESTDG2     7          BACKUPSET
TESTDG2     7          CHANGETRACKING
TESTDG2     7          CONTROLFILE
TESTDG2     7          DATAFILE
TESTDG2     7          DATAGUARDCONFIG
TESTDG2     7          DUMPSET
TESTDG2     7          FLASHBACK
TESTDG2     7          FLASHFILE
TESTDG2     7          OCRFILE
TESTDG2     7          ONLINELOG
TESTDG2     7          PARAMETERFILE
TESTDG2     7          TEMPFILE
TESTDG2     7          XTRANSPORT
==================================

DG_Name User_Num OS_ID OS_Name
==================================

DG_Name Grp_Name Owner
==================================

Username sysdba sysoper sysasm
     SYS   TRUE    TRUE   TRUE
ASMSNMP   TRUE   FALSE FALSE
==================================

Diskgroup Name: ACFS

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

Diskgroup Name: ACFSDG

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

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

The window below is a live discussion of this article (not a screenshot). We encourage you to join the discussion by clicking the "Reply" link below for the entry you would like to provide feedback on. If you have questions or implementation issues with the information in the article above, please share that below.

References

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

Attachments

This solution has no attachment