Gather/Backup ASM Metadata In A Formatted Manner version 10g/11g/12c_470211.1
In this Document
Goal |
Ask Questions, Get Help, And Share Your Experiences With This Article |
Solution |
Script #1 (Generic ASM metadata): |
Script #2 (ASM Files & ASM Alias): |
Script #3 (ASM Full Path Alias Directory): |
Script #4 (ASMCMD commands to gather complementary metadata information): |
Example Output (Script #1): |
Example Output (Script #3): |
Example Output (Script #4): |
References |
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]Information in this document applies to any platform.
***Checked for relevance on 30-Apr-2010***
Goal
You can use the SQLPLUS “SET MARKUP HTML ON” to generate a formatted report from the existing ASM metadata and also using ASMCMD commands to gather complementary metadata information, which can be used as well as an ASM metadata backup or as a report for Oracle Support to troubleshot ASM issues.
Ask Questions, Get Help, And Share Your Experiences With This Article
Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?
Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Install/Upgrade.
Solution
1) Connect to your ASM instance(s) and execute the first 3 scripts below (on each node if this is RAC configuration).
2) Also, execute the script #4 (located below) through ASMCMD to gather complementary metadata information (on each node if this is RAC configuration).
Note 1: Scripts #1, #2 & #3 could report the <<< ORA-01219: database not open: queries allowed on fixed tables/views only >>> error on some specific queries, due to some V$ASM_* performance views are only present on early ASM releases, therefore this errors can be ignored depending the ASM release.
Note: 2: This is the same case with the Script # 4 (ASMCMD commands), which could not interpret some ASMCMD commands, due to the some commands/options are not present on early releases.
Script #1 (Generic ASM metadata):
-- Author: Esteban D. Bernal
-- Property: Oracle Corporation
SPOOL ASM_GENERIC_ASM_METADATA.html
-- ASM VERSIONS 10.1, 10.2, 11.1, 11.2 & 12.1
SET MARKUP HTML ON
SET ECHO ON
SET PAGESIZE 200
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';
SELECT 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , SYSDATE " " FROM DUAL;
SELECT 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " FROM V$SESSION WHERE PROGRAM LIKE '%SMON%';
SELECT * FROM V$INSTANCE;
SELECT * FROM GV$INSTANCE;
SELECT * FROM V$ASM_DISKGROUP;
SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;
SELECT SUBSTR(D.NAME,1,16) AS ASMDISK, D.MOUNT_STATUS, D.STATE,
DG.NAME AS DISKGROUP FROM V$ASM_DISKGROUP DG, V$ASM_DISK D
WHERE DG.GROUP_NUMBER = D.GROUP_NUMBER;
SELECT * FROM V$ASM_CLIENT;
SELECT DG.NAME AS DISKGROUP, SUBSTR(C.INSTANCE_NAME,1,12) AS INSTANCE,
SUBSTR(C.DB_NAME,1,12) AS DBNAME, SUBSTR(C.SOFTWARE_VERSION,1,12) AS SOFTWARE,
SUBSTR(C.COMPATIBLE_VERSION,1,12) AS COMPATIBLE
FROM V$ASM_DISKGROUP DG, V$ASM_CLIENT C
WHERE DG.GROUP_NUMBER = C.GROUP_NUMBER;
SELECT * FROM V$ASM_ATTRIBUTE;
SELECT * FROM V$ASM_OPERATION;
SELECT * FROM GV$ASM_OPERATION;
SELECT * FROM V$VERSION;
SELECT * FROM V$ASM_ACFSSNAPSHOTS;
SELECT * FROM V$ASM_ACFSVOLUMES;
SELECT * FROM V$ASM_FILESYSTEM;
SELECT * FROM V$ASM_VOLUME;
SELECT * FROM V$ASM_VOLUME_STAT;
SELECT * FROM V$ASM_USER;
SELECT * FROM V$ASM_USERGROUP;
SELECT * FROM V$ASM_USERGROUP_MEMBER;
SELECT * FROM V$ASM_DISK_IOSTAT;
SELECT * FROM V$ASM_DISK_STAT;
SELECT * FROM V$ASM_DISKGROUP_STAT;
SELECT * FROM V$ASM_TEMPLATE;
SHOW PARAMETER
SHOW SGA
!echo "SELECT '" > /tmp/GPNPTOOL.SQL 2> /dev/null
! $ORACLE_HOME/bin/gpnptool get >> /tmp/GPNPTOOL.SQL 2>> /dev/null
!echo "' FROM DUAL;" >> /tmp/GPNPTOOL.SQL 2>> /dev/null
! cat /tmp/GPNPTOOL.SQL
SET ECHO OFF
--DISPLAYS INFORMATION ABOUT THE CONTENTS OF THE SPFILE.
SELECT * FROM V$SPPARAMETER ORDER BY 2;
SELECT * FROM GV$SPPARAMETER ORDER BY 3;
--DISPLAYS INFORMATION ABOUT THE INITIALIZATION PARAMETERS THAT ARE CURRENTLY IN EFFECT IN THE INSTANCE.
SELECT * FROM V$SYSTEM_PARAMETER ORDER BY 2;
SELECT * FROM GV$SYSTEM_PARAMETER ORDER BY 3;
-- 12C ACFS VIEWS
SELECT * FROM V$ASM_ACFS_ENCRYPTION_INFO;
SELECT * FROM V$ASM_ACFSREPL;
SELECT * FROM V$ASM_ACFSREPLTAG;
SELECT * FROM V$ASM_ACFS_SEC_ADMIN;
SELECT * FROM V$ASM_ACFS_SEC_CMDRULE;
SELECT * FROM V$ASM_ACFS_SEC_REALM;
SELECT * FROM V$ASM_ACFS_SEC_REALM_FILTER;
SELECT * FROM V$ASM_ACFS_SEC_REALM_GROUP;
SELECT * FROM V$ASM_ACFS_SEC_REALM_USER;
SELECT * FROM V$ASM_ACFS_SEC_RULE;
SELECT * FROM V$ASM_ACFS_SEC_RULESET;
SELECT * FROM V$ASM_ACFS_SEC_RULESET_RULE;
SELECT * FROM V$ASM_ACFS_SECURITY_INFO;
SELECT * FROM V$ASM_ACFSTAG;
-- 12C ASM AUDIT VIEWS
SELECT * FROM V$ASM_AUDIT_CLEAN_EVENTS;
SELECT * FROM V$ASM_AUDIT_CLEANUP_JOBS;
SELECT * FROM V$ASM_AUDIT_CONFIG_PARAMS;
SELECT * FROM V$ASM_AUDIT_LAST_ARCH_TS;
-- 12C ASM ESTIMATE VIEW
SELECT * FROM V$ASM_ESTIMATE;
SELECT * FROM GV$ASM_ESTIMATE;
SPOOL OFF
EXIT
Script #2 (ASM Files & ASM Alias):
-- Property: Oracle Corporation
-- ASM Versions 10.1, 10.2, 11.1 & 11.2
SET MARKUP HTML ON
set echo on
set pagesize 200
COLUMN BYTES FORMAT 9999999999999999
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;
select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';
select * from v$asm_alias;
select * from v$asm_file;
show parameter asm
show parameter cluster
show parameter instance_type
show parameter instance_name
show parameter spfile
show sga
spool off
exit
Script #3 (ASM Full Path Alias Directory):
-- Author: Esteban D. Bernal
-- Property: Oracle Corporation
-- ASM Versions 10.1, 10.2, 11.1 & 11.2
SET MARKUP HTML ON
set echo on
set pagesize 200
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;
select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';
SELECT CONCAT('+'||GNAME, SYS_CONNECT_BY_PATH(ANAME, '/'))
FULL_PATH, SYSTEM_CREATED, ALIAS_DIRECTORY, FILE_TYPE
FROM ( SELECT B.NAME GNAME, A.PARENT_INDEX PINDEX,
A.NAME ANAME, A.REFERENCE_INDEX RINDEX,
A.SYSTEM_CREATED, A.ALIAS_DIRECTORY,
C.TYPE FILE_TYPE
FROM V$ASM_ALIAS A, V$ASM_DISKGROUP B, V$ASM_FILE C
WHERE A.GROUP_NUMBER = B.GROUP_NUMBER
AND A.GROUP_NUMBER = C.GROUP_NUMBER(+)
AND A.FILE_NUMBER = C.FILE_NUMBER(+)
AND A.FILE_INCARNATION = C.INCARNATION(+)
)
START WITH (MOD(PINDEX, POWER(2, 24))) = 0
CONNECT BY PRIOR RINDEX = PINDEX;
spool off
exit
Script #4 (ASMCMD commands to gather complementary metadata information):
### The next script generates additional ASM metadata information thru the ASMCMD interface ###
################################################################################################
### Author: Esteban D. Bernal ###
################################################################################################
### Property: Oracle Corporation ###
################################################################################################
echo "ASMCMD commands to gather complementary metadata information:" > /tmp/asmcmd_script.out 2> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p ls -ls >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsattr >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsct >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsdg >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsdsk >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsof >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsod >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p iostat >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p dsget >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsop >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p spget >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lstmpl >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsusr >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lsgrp >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p lspwusr >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
asmcmd -p volinfo -a >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo "==================================" >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
echo " " >> /tmp/asmcmd_script.out 2>> /tmp/asmcmd_script.out
##############################################################################################################
Note: On Windows environments the “2> /tmp/asmcmd_script.out” or “2>> /tmp/asmcmd_script.out” statements is not required, thus it can be omitted.
Execution Example:
[grid@asmlnx2 ~]$ . oraenv
ORACLE_SID = [+ASM] ? +ASM
The Oracle base remains unchanged with value /u01/app/grid
[grid@asmlnx2 ~]$
[grid@asmlnx2 ~]$ ./asmcmd_script.sh
[grid@asmlnx2 ~]$
Output file:
[grid@asmlnx2 ~]$ ls -l /tmp/asmcmd_script.out
-rw-r--r-- 1 grid oinstall 15873 Jun 6 11:03 /tmp/asmcmd_script.out
Example Output (Script #1):
SQL> -- Version 11.2 SQL> SET MARKUP HTML ON SQL> set echo on
SQL>
SQL> set pagesize 200
SQL>
SQL> alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
Session altered.
SQL>
SQL> select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;
'THISASMREPORTWASGENERATEDAT:==)>' | |
---|---|
THIS ASM REPORT WAS GENERATED AT: ==)> | 05-JUN-2012 15:29:52 |
SQL>
SQL>
SQL> select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';
'HOSTNAMEASSOCIATEDWITHTHISASMINSTANCE:==)>' | |
---|---|
HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> | asmlnx2.us.oracle.com |
SQL>
SQL> select * from v$asm_diskgroup;
GROUP_NUMBER | NAME | SECTOR_SIZE | BLOCK_SIZE | ALLOCATION_UNIT_SIZE | STATE | TYPE | TOTAL_MB | FREE_MB | HOT_USED_MB | COLD_USED_MB | REQUIRED_MIRROR_FREE_MB | USABLE_FILE_MB | OFFLINE_DISKS | COMPATIBILITY | DATABASE_COMPATIBILITY | V |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DATA | 512 | 4096 | 2097152 | MOUNTED | NORMAL | 78152 | 73888 | 0 | 4264 | 19538 | 27175 | 0 | 11.2.0.0.0 | 11.2.0.0.0 | N |
2 | RECO | 512 | 4096 | 2097152 | MOUNTED | NORMAL | 78152 | 44792 | 0 | 33360 | 19538 | 12627 | 0 | 11.2.0.0.0 | 11.2.0.0.0 | N |
3 | SPFILE | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 8887 | 8828 | 0 | 59 | 0 | 8828 | 0 | 11.2.0.0.0 | 10.1.0.0.0 | N |
4 | ACFS | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 14653 | 262 | 0 | 14391 | 0 | 262 | 0 | 11.2.0.0.0 | 11.2.0.0.0 | N |
5 | ACFSDG | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 14653 | 262 | 0 | 14391 | 0 | 262 | 0 | 11.2.0.0.0 | 11.2.0.0.0 | N |
7 | TESTDG2 | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 14653 | 14603 | 0 | 50 | 0 | 14603 | 0 | 10.1.0.0.0 | 10.1.0.0.0 | N |
6 | TESTDG | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 14653 | 14603 | 0 | 50 | 0 | 14603 | 0 | 10.1.0.0.0 | 10.1.0.0.0 | N |
7 rows selected.
SQL>
SQL> SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;
GROUP_NUMBER | DISK_NUMBER | COMPOUND_INDEX | INCARNATION | MOUNT_S | HEADER_STATU | MODE_ST | STATE | REDUNDA | LIBRARY | OS_MB | TOTAL_MB | FREE_MB | HOT_USED_MB | COLD_USED_MB | NAME | FAILGROUP | LABEL | PATH | UDID | PRODUCT | CREATE_DATE | MOUNT_DATE | REPAIR_TIMER | READS | WRITES | READ_ERRS | WRITE_ERRS | READ_TIME | WRITE_TIME | BYTES_READ | BYTES_WRITTEN | P | HASH_VALUE | HOT_READS | HOT_WRITES | HOT_BYTES_READ | HOT_BYTES_WRITTEN | COLD_READS | COLD_WRITES | COLD_BYTES_READ | COLD_BYTES_WRITTEN | V | SECTOR_SIZE | FAILGRO |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 4 | 4 | 3915944009 | CLOSED | PROVISIONED | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 0 | 0 | 0 | 0 | ASMDISKNEW13 | ORCL:ASMDISKNEW13 | 0 | 0 | N | 512 | REGULAR | |||||||||||||||||||||||
1 | 0 | 16777216 | 3915944019 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 18468 | 0 | 1070 | ASMDISKNEW1 | FG1 | ASMDISKNEW1 | ORCL:ASMDISKNEW1 | 05-APR-2012 18:19:29 | 06-APR-2012 16:47:24 | 0 | 60708 | 3111911 | 0 | 0 | 1470.504 | 36714.442 | 584798208 | 4.4288E+10 | U | 1858933910 | 0 | 0 | 0 | 0 | 43244 | 1402352 | 511352832 | 3.7283E+10 | N | 512 | REGULAR | ||
1 | 1 | 16777217 | 3915944020 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 18476 | 0 | 1062 | ASMDISKNEW2 | FG1 | ASMDISKNEW2 | ORCL:ASMDISKNEW2 | 05-APR-2012 18:19:29 | 06-APR-2012 16:47:24 | 0 | 44514 | 1183769 | 0 | 0 | 613.766 | 5546.148 | 560709632 | 2.5913E+10 | U | 4238862529 | 0 | 0 | 0 | 0 | 44269 | 1183710 | 559702016 | 2.5912E+10 | N | 512 | REGULAR | ||
1 | 2 | 16777218 | 3915944021 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 18476 | 0 | 1062 | ASMDISKNEW3 | FG2 | ASMDISKNEW3 | ORCL:ASMDISKNEW3 | 05-APR-2012 18:19:29 | 06-APR-2012 16:47:24 | 0 | 61144 | 2899094 | 0 | 0 | 1628.494 | 36883.674 | 605405184 | 3.8833E+10 | U | 3481199486 | 0 | 0 | 0 | 0 | 43838 | 1190066 | 534519808 | 3.1831E+10 | N | 512 | REGULAR | ||
1 | 3 | 16777219 | 3915944022 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 18468 | 0 | 1070 | ASMDISKNEW4 | FG2 | ASMDISKNEW4 | ORCL:ASMDISKNEW4 | 05-APR-2012 18:19:29 | 06-APR-2012 16:47:24 | 0 | 54503 | 1396586 | 0 | 0 | 595.334 | 7263.726 | 623169536 | 3.1368E+10 | U | 3420979251 | 0 | 0 | 0 | 0 | 54271 | 1395996 | 622215168 | 3.1365E+10 | N | 512 | REGULAR | ||
2 | 0 | 33554432 | 3915944023 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 11232 | 0 | 8306 | ASMDISKNEW5 | FG1 | ASMDISKNEW5 | ORCL:ASMDISKNEW5 | 05-APR-2012 18:23:20 | 06-APR-2012 16:47:24 | 0 | 403312 | 2865390 | 0 | 0 | 15607.657 | 85127.551 | 9628065792 | 2.5349E+10 | U | 3900773597 | 0 | 0 | 0 | 0 | 385852 | 1148616 | 9554624512 | 1.8314E+10 | N | 512 | REGULAR | ||
2 | 1 | 33554433 | 3915944024 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 11164 | 0 | 8374 | ASMDISKNEW6 | FG1 | ASMDISKNEW6 | ORCL:ASMDISKNEW6 | 05-APR-2012 18:23:20 | 06-APR-2012 16:47:24 | 0 | 1515522 | 2838605 | 0 | 0 | 44598.36 | 112913.043 | 2.8083E+10 | 4.6116E+10 | U | 3327682112 | 0 | 0 | 0 | 0 | 1515288 | 2836417 | 2.8082E+10 | 4.6107E+10 | N | 512 | REGULAR | ||
2 | 2 | 33554434 | 3915944025 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 11204 | 0 | 8334 | ASMDISKNEW7 | FG2 | ASMDISKNEW7 | ORCL:ASMDISKNEW7 | 05-APR-2012 18:23:20 | 06-APR-2012 16:47:24 | 0 | 792368 | 4564232 | 0 | 0 | 20262.698 | 74186.724 | 1.5932E+10 | 5.3111E+10 | U | 2514475167 | 0 | 0 | 0 | 0 | 773357 | 2850429 | 1.5853E+10 | 4.6088E+10 | N | 512 | REGULAR | ||
2 | 3 | 33554435 | 3915944026 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 11192 | 0 | 8346 | ASMDISKNEW8 | FG2 | ASMDISKNEW8 | ORCL:ASMDISKNEW8 | 05-APR-2012 18:23:20 | 06-APR-2012 16:47:24 | 0 | 2956876 | 1139767 | 0 | 0 | 26584.755 | 145227.893 | 5.1566E+10 | 1.8354E+10 | U | 3833053942 | 0 | 0 | 0 | 0 | 2956648 | 1134604 | 5.1565E+10 | 1.8332E+10 | N | 512 | REGULAR | ||
3 | 0 | 50331648 | 3915944027 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 8887 | 8887 | 8828 | 0 | 59 | ASMDISKNEW14 | ASMDISKNEW14 | ASMDISKNEW14 | ORCL:ASMDISKNEW14 | 05-APR-2012 18:16:20 | 06-APR-2012 16:47:25 | 0 | 17425 | 1709056 | 0 | 0 | 434.096 | 6902.094 | 72137728 | 6999970816 | 3227115283 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N | 512 | REGULAR | |||
4 | 0 | 67108864 | 3915944030 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 14653 | 262 | 0 | 14391 | ASMDISKNEW9 | ASMDISKNEW9 | ASMDISKNEW9 | ORCL:ASMDISKNEW9 | 06-APR-2012 16:59:54 | 06-APR-2012 17:00:05 | 0 | 17635 | 1709439 | 0 | 0 | 492.145842 | 1920.14 | 72299008 | 7005509632 | 3936317828 | 0 | 0 | 0 | 0 | 258 | 78 | 164352 | 71680 | N | 512 | REGULAR | |||
5 | 0 | 83886080 | 3915944033 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 14653 | 262 | 0 | 14391 | ASMDISKNEW10 | ASMDISKNEW10 | ASMDISKNEW10 | ORCL:ASMDISKNEW10 | 06-APR-2012 17:38:54 | 06-APR-2012 17:39:03 | 0 | 17587 | 1708669 | 0 | 0 | 517.996849 | 1631.214 | 72134656 | 7002355712 | 405308562 | 0 | 0 | 0 | 0 | 249 | 78 | 159744 | 71680 | N | 512 | REGULAR | |||
6 | 0 | 100663296 | 3915944054 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 14653 | 14603 | 0 | 14391 | ASMDISKNEW11 | ASMDISKNEW11 | ASMDISKNEW11 | ORCL:ASMDISKNEW11 | 12-APR-2012 11:33:52 | 12-APR-2012 11:40:05 | 0 | 15564 | 1543933 | 0 | 0 | 525.707 | 1418.396 | 64712704 | 6323949568 | 3808981697 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N | 512 | REGULAR | |||
7 | 0 | 117440512 | 3915944057 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 14653 | 14603 | 0 | 14391 | ASMDISKNEW12 | ASMDISKNEW12 | ASMDISKNEW12 | ORCL:ASMDISKNEW12 | 24-APR-2012 12:30:14 | 24-APR-2012 12:30:26 | 0 | 12072 | 1200844 | 0 | 0 | 175.236 | 894.613 | 50409472 | 4918657024 | 1517235067 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N | 512 | REGULAR |
14 rows selected.
SQL>
SQL> SELECT SUBSTR(d.name,1,16) AS asmdisk, d.mount_status, d.state,
2 dg.name AS diskgroup FROM V$ASM_DISKGROUP dg, V$ASM_DISK d
3 WHERE dg.group_number = d.group_number;
ASMDISK | MOUNT_S | STATE | DISKGROUP |
---|---|---|---|
ASMDISKNEW1 | CACHED | NORMAL | DATA |
ASMDISKNEW2 | CACHED | NORMAL | DATA |
ASMDISKNEW4 | CACHED | NORMAL | DATA |
ASMDISKNEW3 | CACHED | NORMAL | DATA |
ASMDISKNEW5 | CACHED | NORMAL | RECO |
ASMDISKNEW6 | CACHED | NORMAL | RECO |
ASMDISKNEW8 | CACHED | NORMAL | RECO |
ASMDISKNEW7 | CACHED | NORMAL | RECO |
ASMDISKNEW14 | CACHED | NORMAL | SPFILE |
ASMDISKNEW9 | CACHED | NORMAL | ACFS |
ASMDISKNEW10 | CACHED | NORMAL | ACFSDG |
ASMDISKNEW11 | CACHED | NORMAL | TESTDG |
ASMDISKNEW12 | CACHED | NORMAL | TESTDG2 |
13 rows selected.
SQL>
SQL>
SQL> SELECT * FROM V$ASM_CLIENT;
GROUP_NUMBER | INSTANCE_NAME | DB_NAME | STATUS | SOFTWARE_VERSION | COMPATIBLE_VERSION |
---|---|---|---|---|---|
2 | DBASM112 | DBASM112 | CONNECTED | 11.2.0.3.0 | 11.2.0.0.0 |
1 | DBASM112 | DBASM112 | CONNECTED | 11.2.0.3.0 | 11.2.0.0.0 |
4 | +ASM | asmvol | CONNECTED | 11.2.0.3.0 | 11.2.0.3.0 |
5 | +ASM | asmvol | CONNECTED | 11.2.0.3.0 | 11.2.0.3.0 |
SQL>
SQL> SELECT dg.name AS diskgroup, SUBSTR(c.instance_name,1,12) AS instance,
2 SUBSTR(c.db_name,1,12) AS dbname, SUBSTR(c.SOFTWARE_VERSION,1,12) AS software,
3 SUBSTR(c.COMPATIBLE_VERSION,1,12) AS compatible
4 FROM V$ASM_DISKGROUP dg, V$ASM_CLIENT c
5 WHERE dg.group_number = c.group_number;
DISKGROUP | INSTANCE | DBNAME | SOFTWARE | COMPATIBLE |
---|---|---|---|---|
DATA | DBASM112 | DBASM112 | 11.2.0.3.0 | 11.2.0.0.0 |
RECO | DBASM112 | DBASM112 | 11.2.0.3.0 | 11.2.0.0.0 |
ACFS | +ASM | asmvol | 11.2.0.3.0 | 11.2.0.3.0 |
ACFSDG | +ASM | asmvol | 11.2.0.3.0 | 11.2.0.3.0 |
SQL>
SQL> select * from V$ASM_ATTRIBUTE;
NAME | VALUE | GROUP_NUMBER | ATTRIBUTE_INDEX | ATTRIBUTE_INCARNATION | READ_ON | SYSTEM_ |
---|---|---|---|---|---|---|
disk_repair_time | 3.6h | 1 | 0 | 1 | N | Y |
au_size | 2097152 | 1 | 5 | 1 | Y | Y |
sector_size | 512 | 1 | 6 | 1 | Y | Y |
compatible.asm | 11.2.0.0.0 | 1 | 20 | 1 | N | Y |
compatible.rdbms | 11.2.0.0.0 | 1 | 21 | 1 | N | Y |
compatible.advm | 11.2.0.0.0 | 1 | 22 | 1 | N | Y |
cell.smart_scan_capable | FALSE | 1 | 30 | 1 | N | N |
access_control.enabled | FALSE | 1 | 40 | 1 | N | Y |
access_control.umask | 066 | 1 | 41 | 1 | N | Y |
template_version | 186646528 | 1 | 50 | 1 | N | Y |
template.PARAMETERFILE.stripe | 0 | 1 | 71 | 1 | N | Y |
template.PARAMETERFILE.redundancy | 18 | 1 | 74 | 1 | N | Y |
template.PARAMETERFILE.primary_region | 0 | 1 | 75 | 1 | N | Y |
template.PARAMETERFILE.mirror_region | 0 | 1 | 76 | 1 | N | Y |
template.ASMPARAMETERFILE.stripe | 0 | 1 | 81 | 1 | N | Y |
template.ASMPARAMETERFILE.redundancy | 18 | 1 | 84 | 1 | N | Y |
template.ASMPARAMETERFILE.primary_region | 0 | 1 | 85 | 1 | N | Y |
template.ASMPARAMETERFILE.mirror_region | 0 | 1 | 86 | 1 | N | Y |
template.DUMPSET.stripe | 0 | 1 | 101 | 1 | N | Y |
template.DUMPSET.redundancy | 18 | 1 | 104 | 1 | N | Y |
template.DUMPSET.primary_region | 0 | 1 | 105 | 1 | N | Y |
template.DUMPSET.mirror_region | 0 | 1 | 106 | 1 | N | Y |
template.CONTROLFILE.stripe | 1 | 1 | 111 | 1 | N | Y |
template.CONTROLFILE.redundancy | 19 | 1 | 114 | 1 | N | Y |
template.CONTROLFILE.primary_region | 0 | 1 | 115 | 1 | N | Y |
template.CONTROLFILE.mirror_region | 0 | 1 | 116 | 1 | N | Y |
template.FLASHFILE.stripe | 0 | 1 | 121 | 1 | N | Y |
template.FLASHFILE.redundancy | 18 | 1 | 124 | 1 | N | Y |
template.FLASHFILE.primary_region | 0 | 1 | 125 | 1 | N | Y |
template.FLASHFILE.mirror_region | 0 | 1 | 126 | 1 | N | Y |
template.ARCHIVELOG.stripe | 0 | 1 | 131 | 1 | N | Y |
template.ARCHIVELOG.redundancy | 18 | 1 | 134 | 1 | N | Y |
template.ARCHIVELOG.primary_region | 0 | 1 | 135 | 1 | N | Y |
template.ARCHIVELOG.mirror_region | 0 | 1 | 136 | 1 | N | Y |
template.ONLINELOG.stripe | 0 | 1 | 141 | 1 | N | Y |
template.ONLINELOG.redundancy | 18 | 1 | 144 | 1 | N | Y |
template.ONLINELOG.primary_region | 0 | 1 | 145 | 1 | N | Y |
template.ONLINELOG.mirror_region | 0 | 1 | 146 | 1 | N | Y |
template.DATAFILE.stripe | 0 | 1 | 151 | 1 | N | Y |
template.DATAFILE.redundancy | 18 | 1 | 154 | 1 | N | Y |
template.DATAFILE.primary_region | 0 | 1 | 155 | 1 | N | Y |
template.DATAFILE.mirror_region | 0 | 1 | 156 | 1 | N | Y |
template.TEMPFILE.stripe | 0 | 1 | 161 | 1 | N | Y |
template.TEMPFILE.redundancy | 18 | 1 | 164 | 1 | N | Y |
template.TEMPFILE.primary_region | 0 | 1 | 165 | 1 | N | Y |
template.TEMPFILE.mirror_region | 0 | 1 | 166 | 1 | N | Y |
template.BACKUPSET.stripe | 0 | 1 | 181 | 1 | N | Y |
template.BACKUPSET.redundancy | 18 | 1 | 184 | 1 | N | Y |
template.BACKUPSET.primary_region | 0 | 1 | 185 | 1 | N | Y |
template.BACKUPSET.mirror_region | 0 | 1 | 186 | 1 | N | Y |
template.AUTOBACKUP.stripe | 0 | 1 | 191 | 1 | N | Y |
template.AUTOBACKUP.redundancy | 18 | 1 | 194 | 1 | N | Y |
template.AUTOBACKUP.primary_region | 0 | 1 | 195 | 1 | N | Y |
template.AUTOBACKUP.mirror_region | 0 | 1 | 196 | 1 | N | Y |
template.XTRANSPORT.stripe | 0 | 1 | 201 | 1 | N | Y |
template.XTRANSPORT.redundancy | 18 | 1 | 204 | 1 | N | Y |
template.XTRANSPORT.primary_region | 0 | 1 | 205 | 1 | N | Y |
template.XTRANSPORT.mirror_region | 0 | 1 | 206 | 1 | N | Y |
template.CHANGETRACKING.stripe | 0 | 1 | 211 | 1 | N | Y |
template.CHANGETRACKING.redundancy | 18 | 1 | 214 | 1 | N | Y |
template.CHANGETRACKING.primary_region | 0 | 1 | 215 | 1 | N | Y |
template.CHANGETRACKING.mirror_region | 0 | 1 | 216 | 1 | N | Y |
template.FLASHBACK.stripe | 0 | 1 | 221 | 1 | N | Y |
template.FLASHBACK.redundancy | 18 | 1 | 224 | 1 | N | Y |
template.FLASHBACK.primary_region | 0 | 1 | 225 | 1 | N | Y |
template.FLASHBACK.mirror_region | 0 | 1 | 226 | 1 | N | Y |
template.DATAGUARDCONFIG.stripe | 0 | 1 | 231 | 1 | N | Y |
template.DATAGUARDCONFIG.redundancy | 18 | 1 | 234 | 1 | N | Y |
template.DATAGUARDCONFIG.primary_region | 0 | 1 | 235 | 1 | N | Y |
template.DATAGUARDCONFIG.mirror_region | 0 | 1 | 236 | 1 | N | Y |
template.OCRFILE.stripe | 0 | 1 | 241 | 1 | N | Y |
template.OCRFILE.redundancy | 18 | 1 | 244 | 1 | N | Y |
template.OCRFILE.primary_region | 0 | 1 | 245 | 1 | N | Y |
template.OCRFILE.mirror_region | 0 | 1 | 246 | 1 | N | Y |
disk_repair_time | 3.6h | 2 | 0 | 1 | N | Y |
au_size | 2097152 | 2 | 5 | 1 | Y | Y |
sector_size | 512 | 2 | 6 | 1 | Y | Y |
compatible.asm | 11.2.0.0.0 | 2 | 20 | 1 | N | Y |
compatible.rdbms | 11.2.0.0.0 | 2 | 21 | 1 | N | Y |
compatible.advm | 11.2.0.0.0 | 2 | 22 | 1 | N | Y |
cell.smart_scan_capable | FALSE | 2 | 30 | 1 | N | N |
access_control.enabled | FALSE | 2 | 40 | 1 | N | Y |
access_control.umask | 066 | 2 | 41 | 1 | N | Y |
template_version | 186646528 | 2 | 50 | 1 | N | Y |
template.PARAMETERFILE.stripe | 0 | 2 | 71 | 1 | N | Y |
template.PARAMETERFILE.redundancy | 18 | 2 | 74 | 1 | N | Y |
template.PARAMETERFILE.primary_region | 0 | 2 | 75 | 1 | N | Y |
template.PARAMETERFILE.mirror_region | 0 | 2 | 76 | 1 | N | Y |
template.ASMPARAMETERFILE.stripe | 0 | 2 | 81 | 1 | N | Y |
template.ASMPARAMETERFILE.redundancy | 18 | 2 | 84 | 1 | N | Y |
template.ASMPARAMETERFILE.primary_region | 0 | 2 | 85 | 1 | N | Y |
template.ASMPARAMETERFILE.mirror_region | 0 | 2 | 86 | 1 | N | Y |
template.DUMPSET.stripe | 0 | 2 | 101 | 1 | N | Y |
template.DUMPSET.redundancy | 18 | 2 | 104 | 1 | N | Y |
template.DUMPSET.primary_region | 0 | 2 | 105 | 1 | N | Y |
template.DUMPSET.mirror_region | 0 | 2 | 106 | 1 | N | Y |
template.CONTROLFILE.stripe | 1 | 2 | 111 | 1 | N | Y |
template.CONTROLFILE.redundancy | 19 | 2 | 114 | 1 | N | Y |
template.CONTROLFILE.primary_region | 0 | 2 | 115 | 1 | N | Y |
template.CONTROLFILE.mirror_region | 0 | 2 | 116 | 1 | N | Y |
template.FLASHFILE.stripe | 0 | 2 | 121 | 1 | N | Y |
template.FLASHFILE.redundancy | 18 | 2 | 124 | 1 | N | Y |
template.FLASHFILE.primary_region | 0 | 2 | 125 | 1 | N | Y |
template.FLASHFILE.mirror_region | 0 | 2 | 126 | 1 | N | Y |
template.ARCHIVELOG.stripe | 0 | 2 | 131 | 1 | N | Y |
template.ARCHIVELOG.redundancy | 18 | 2 | 134 | 1 | N | Y |
template.ARCHIVELOG.primary_region | 0 | 2 | 135 | 1 | N | Y |
template.ARCHIVELOG.mirror_region | 0 | 2 | 136 | 1 | N | Y |
template.ONLINELOG.stripe | 0 | 2 | 141 | 1 | N | Y |
template.ONLINELOG.redundancy | 18 | 2 | 144 | 1 | N | Y |
template.ONLINELOG.primary_region | 0 | 2 | 145 | 1 | N | Y |
template.ONLINELOG.mirror_region | 0 | 2 | 146 | 1 | N | Y |
template.DATAFILE.stripe | 0 | 2 | 151 | 1 | N | Y |
template.DATAFILE.redundancy | 18 | 2 | 154 | 1 | N | Y |
template.DATAFILE.primary_region | 0 | 2 | 155 | 1 | N | Y |
template.DATAFILE.mirror_region | 0 | 2 | 156 | 1 | N | Y |
template.TEMPFILE.stripe | 0 | 2 | 161 | 1 | N | Y |
template.TEMPFILE.redundancy | 18 | 2 | 164 | 1 | N | Y |
template.TEMPFILE.primary_region | 0 | 2 | 165 | 1 | N | Y |
template.TEMPFILE.mirror_region | 0 | 2 | 166 | 1 | N | Y |
template.BACKUPSET.stripe | 0 | 2 | 181 | 1 | N | Y |
template.BACKUPSET.redundancy | 18 | 2 | 184 | 1 | N | Y |
template.BACKUPSET.primary_region | 0 | 2 | 185 | 1 | N | Y |
template.BACKUPSET.mirror_region | 0 | 2 | 186 | 1 | N | Y |
template.AUTOBACKUP.stripe | 0 | 2 | 191 | 1 | N | Y |
template.AUTOBACKUP.redundancy | 18 | 2 | 194 | 1 | N | Y |
template.AUTOBACKUP.primary_region | 0 | 2 | 195 | 1 | N | Y |
template.AUTOBACKUP.mirror_region | 0 | 2 | 196 | 1 | N | Y |
template.XTRANSPORT.stripe | 0 | 2 | 201 | 1 | N | Y |
template.XTRANSPORT.redundancy | 18 | 2 | 204 | 1 | N | Y |
template.XTRANSPORT.primary_region | 0 | 2 | 205 | 1 | N | Y |
template.XTRANSPORT.mirror_region | 0 | 2 | 206 | 1 | N | Y |
template.CHANGETRACKING.stripe | 0 | 2 | 211 | 1 | N | Y |
template.CHANGETRACKING.redundancy | 18 | 2 | 214 | 1 | N | Y |
template.CHANGETRACKING.primary_region | 0 | 2 | 215 | 1 | N | Y |
template.CHANGETRACKING.mirror_region | 0 | 2 | 216 | 1 | N | Y |
template.FLASHBACK.stripe | 0 | 2 | 221 | 1 | N | Y |
template.FLASHBACK.redundancy | 18 | 2 | 224 | 1 | N | Y |
template.FLASHBACK.primary_region | 0 | 2 | 225 | 1 | N | Y |
template.FLASHBACK.mirror_region | 0 | 2 | 226 | 1 | N | Y |
template.DATAGUARDCONFIG.stripe | 0 | 2 | 231 | 1 | N | Y |
template.DATAGUARDCONFIG.redundancy | 18 | 2 | 234 | 1 | N | Y |
template.DATAGUARDCONFIG.primary_region | 0 | 2 | 235 | 1 | N | Y |
template.DATAGUARDCONFIG.mirror_region | 0 | 2 | 236 | 1 | N | Y |
template.OCRFILE.stripe | 0 | 2 | 241 | 1 | N | Y |
template.OCRFILE.redundancy | 18 | 2 | 244 | 1 | N | Y |
template.OCRFILE.primary_region | 0 | 2 | 245 | 1 | N | Y |
template.OCRFILE.mirror_region | 0 | 2 | 246 | 1 | N | Y |
disk_repair_time | 3.6h | 3 | 0 | 1 | N | Y |
au_size | 1048576 | 3 | 5 | 1 | Y | Y |
sector_size | 512 | 3 | 6 | 1 | Y | Y |
compatible.asm | 11.2.0.0.0 | 3 | 20 | 1 | N | Y |
compatible.rdbms | 10.1.0.0.0 | 3 | 21 | 1 | N | Y |
cell.smart_scan_capable | FALSE | 3 | 30 | 1 | N | N |
access_control.enabled | FALSE | 3 | 40 | 1 | N | Y |
access_control.umask | 066 | 3 | 41 | 1 | N | Y |
template_version | 186646528 | 3 | 50 | 1 | N | Y |
template.PARAMETERFILE.stripe | 0 | 3 | 71 | 1 | N | Y |
template.PARAMETERFILE.redundancy | 17 | 3 | 74 | 1 | N | Y |
template.PARAMETERFILE.primary_region | 0 | 3 | 75 | 1 | N | Y |
template.PARAMETERFILE.mirror_region | 0 | 3 | 76 | 1 | N | Y |
template.ASMPARAMETERFILE.stripe | 0 | 3 | 81 | 1 | N | Y |
template.ASMPARAMETERFILE.redundancy | 17 | 3 | 84 | 1 | N | Y |
template.ASMPARAMETERFILE.primary_region | 0 | 3 | 85 | 1 | N | Y |
template.ASMPARAMETERFILE.mirror_region | 0 | 3 | 86 | 1 | N | Y |
template.DUMPSET.stripe | 0 | 3 | 101 | 1 | N | Y |
template.DUMPSET.redundancy | 17 | 3 | 104 | 1 | N | Y |
template.DUMPSET.primary_region | 0 | 3 | 105 | 1 | N | Y |
template.DUMPSET.mirror_region | 0 | 3 | 106 | 1 | N | Y |
template.CONTROLFILE.stripe | 1 | 3 | 111 | 1 | N | Y |
template.CONTROLFILE.redundancy | 17 | 3 | 114 | 1 | N | Y |
template.CONTROLFILE.primary_region | 0 | 3 | 115 | 1 | N | Y |
template.CONTROLFILE.mirror_region | 0 | 3 | 116 | 1 | N | Y |
template.FLASHFILE.stripe | 0 | 3 | 121 | 1 | N | Y |
template.FLASHFILE.redundancy | 17 | 3 | 124 | 1 | N | Y |
template.FLASHFILE.primary_region | 0 | 3 | 125 | 1 | N | Y |
template.FLASHFILE.mirror_region | 0 | 3 | 126 | 1 | N | Y |
template.ARCHIVELOG.stripe | 0 | 3 | 131 | 1 | N | Y |
template.ARCHIVELOG.redundancy | 17 | 3 | 134 | 1 | N | Y |
template.ARCHIVELOG.primary_region | 0 | 3 | 135 | 1 | N | Y |
template.ARCHIVELOG.mirror_region | 0 | 3 | 136 | 1 | N | Y |
template.ONLINELOG.stripe | 0 | 3 | 141 | 1 | N | Y |
template.ONLINELOG.redundancy | 17 | 3 | 144 | 1 | N | Y |
template.ONLINELOG.primary_region | 0 | 3 | 145 | 1 | N | Y |
template.ONLINELOG.mirror_region | 0 | 3 | 146 | 1 | N | Y |
template.DATAFILE.stripe | 0 | 3 | 151 | 1 | N | Y |
template.DATAFILE.redundancy | 17 | 3 | 154 | 1 | N | Y |
template.DATAFILE.primary_region | 0 | 3 | 155 | 1 | N | Y |
template.DATAFILE.mirror_region | 0 | 3 | 156 | 1 | N | Y |
template.TEMPFILE.stripe | 0 | 3 | 161 | 1 | N | Y |
template.TEMPFILE.redundancy | 17 | 3 | 164 | 1 | N | Y |
template.TEMPFILE.primary_region | 0 | 3 | 165 | 1 | N | Y |
template.TEMPFILE.mirror_region | 0 | 3 | 166 | 1 | N | Y |
template.BACKUPSET.stripe | 0 | 3 | 181 | 1 | N | Y |
template.BACKUPSET.redundancy | 17 | 3 | 184 | 1 | N | Y |
template.BACKUPSET.primary_region | 0 | 3 | 185 | 1 | N | Y |
template.BACKUPSET.mirror_region | 0 | 3 | 186 | 1 | N | Y |
template.AUTOBACKUP.stripe | 0 | 3 | 191 | 1 | N | Y |
template.AUTOBACKUP.redundancy | 17 | 3 | 194 | 1 | N | Y |
template.AUTOBACKUP.primary_region | 0 | 3 | 195 | 1 | N | Y |
NAME | VALUE | GROUP_NUMBER | ATTRIBUTE_INDEX | ATTRIBUTE_INCARNATION | READ_ON | SYSTEM_ |
template.AUTOBACKUP.mirror_region | 0 | 3 | 196 | 1 | N | Y |
template.XTRANSPORT.stripe | 0 | 3 | 201 | 1 | N | Y |
template.XTRANSPORT.redundancy | 17 | 3 | 204 | 1 | N | Y |
template.XTRANSPORT.primary_region | 0 | 3 | 205 | 1 | N | Y |
template.XTRANSPORT.mirror_region | 0 | 3 | 206 | 1 | N | Y |
template.CHANGETRACKING.stripe | 0 | 3 | 211 | 1 | N | Y |
template.CHANGETRACKING.redundancy | 17 | 3 | 214 | 1 | N | Y |
template.CHANGETRACKING.primary_region | 0 | 3 | 215 | 1 | N | Y |
template.CHANGETRACKING.mirror_region | 0 | 3 | 216 | 1 | N | Y |
template.FLASHBACK.stripe | 0 | 3 | 221 | 1 | N | Y |
template.FLASHBACK.redundancy | 17 | 3 | 224 | 1 | N | Y |
template.FLASHBACK.primary_region | 0 | 3 | 225 | 1 | N | Y |
template.FLASHBACK.mirror_region | 0 | 3 | 226 | 1 | N | Y |
template.DATAGUARDCONFIG.stripe | 0 | 3 | 231 | 1 | N | Y |
template.DATAGUARDCONFIG.redundancy | 17 | 3 | 234 | 1 | N | Y |
template.DATAGUARDCONFIG.primary_region | 0 | 3 | 235 | 1 | N | Y |
template.DATAGUARDCONFIG.mirror_region | 0 | 3 | 236 | 1 | N | Y |
template.OCRFILE.stripe | 0 | 3 | 241 | 1 | N | Y |
template.OCRFILE.redundancy | 17 | 3 | 244 | 1 | N | Y |
template.OCRFILE.primary_region | 0 | 3 | 245 | 1 | N | Y |
template.OCRFILE.mirror_region | 0 | 3 | 246 | 1 | N | Y |
disk_repair_time | 3.6h | 4 | 0 | 1 | N | Y |
au_size | 1048576 | 4 | 5 | 1 | Y | Y |
sector_size | 512 | 4 | 6 | 1 | Y | Y |
compatible.asm | 11.2.0.0.0 | 4 | 20 | 1 | N | Y |
compatible.rdbms | 11.2.0.0.0 | 4 | 21 | 1 | N | Y |
compatible.advm | 11.2.0.0.0 | 4 | 22 | 1 | N | Y |
cell.smart_scan_capable | FALSE | 4 | 30 | 1 | N | N |
access_control.enabled | FALSE | 4 | 40 | 1 | N | Y |
access_control.umask | 066 | 4 | 41 | 1 | N | Y |
template_version | 186646528 | 4 | 50 | 1 | N | Y |
template.PARAMETERFILE.stripe | 0 | 4 | 71 | 1 | N | Y |
template.PARAMETERFILE.redundancy | 17 | 4 | 74 | 1 | N | Y |
template.PARAMETERFILE.primary_region | 0 | 4 | 75 | 1 | N | Y |
template.PARAMETERFILE.mirror_region | 0 | 4 | 76 | 1 | N | Y |
template.ASMPARAMETERFILE.stripe | 0 | 4 | 81 | 1 | N | Y |
template.ASMPARAMETERFILE.redundancy | 17 | 4 | 84 | 1 | N | Y |
template.ASMPARAMETERFILE.primary_region | 0 | 4 | 85 | 1 | N | Y |
template.ASMPARAMETERFILE.mirror_region | 0 | 4 | 86 | 1 | N | Y |
template.DUMPSET.stripe | 0 | 4 | 101 | 1 | N | Y |
template.DUMPSET.redundancy | 17 | 4 | 104 | 1 | N | Y |
template.DUMPSET.primary_region | 0 | 4 | 105 | 1 | N | Y |
template.DUMPSET.mirror_region | 0 | 4 | 106 | 1 | N | Y |
template.CONTROLFILE.stripe | 1 | 4 | 111 | 1 | N | Y |
template.CONTROLFILE.redundancy | 17 | 4 | 114 | 1 | N | Y |
template.CONTROLFILE.primary_region | 0 | 4 | 115 | 1 | N | Y |
template.CONTROLFILE.mirror_region | 0 | 4 | 116 | 1 | N | Y |
template.FLASHFILE.stripe | 0 | 4 | 121 | 1 | N | Y |
template.FLASHFILE.redundancy | 17 | 4 | 124 | 1 | N | Y |
template.FLASHFILE.primary_region | 0 | 4 | 125 | 1 | N | Y |
template.FLASHFILE.mirror_region | 0 | 4 | 126 | 1 | N | Y |
template.ARCHIVELOG.stripe | 0 | 4 | 131 | 1 | N | Y |
template.ARCHIVELOG.redundancy | 17 | 4 | 134 | 1 | N | Y |
template.ARCHIVELOG.primary_region | 0 | 4 | 135 | 1 | N | Y |
template.ARCHIVELOG.mirror_region | 0 | 4 | 136 | 1 | N | Y |
template.ONLINELOG.stripe | 0 | 4 | 141 | 1 | N | Y |
template.ONLINELOG.redundancy | 17 | 4 | 144 | 1 | N | Y |
template.ONLINELOG.primary_region | 0 | 4 | 145 | 1 | N | Y |
template.ONLINELOG.mirror_region | 0 | 4 | 146 | 1 | N | Y |
template.DATAFILE.stripe | 0 | 4 | 151 | 1 | N | Y |
template.DATAFILE.redundancy | 17 | 4 | 154 | 1 | N | Y |
template.DATAFILE.primary_region | 0 | 4 | 155 | 1 | N | Y |
template.DATAFILE.mirror_region | 0 | 4 | 156 | 1 | N | Y |
template.TEMPFILE.stripe | 0 | 4 | 161 | 1 | N | Y |
template.TEMPFILE.redundancy | 17 | 4 | 164 | 1 | N | Y |
template.TEMPFILE.primary_region | 0 | 4 | 165 | 1 | N | Y |
template.TEMPFILE.mirror_region | 0 | 4 | 166 | 1 | N | Y |
template.BACKUPSET.stripe | 0 | 4 | 181 | 1 | N | Y |
template.BACKUPSET.redundancy | 17 | 4 | 184 | 1 | N | Y |
template.BACKUPSET.primary_region | 0 | 4 | 185 | 1 | N | Y |
template.BACKUPSET.mirror_region | 0 | 4 | 186 | 1 | N | Y |
template.AUTOBACKUP.stripe | 0 | 4 | 191 | 1 | N | Y |
template.AUTOBACKUP.redundancy | 17 | 4 | 194 | 1 | N | Y |
template.AUTOBACKUP.primary_region | 0 | 4 | 195 | 1 | N | Y |
template.AUTOBACKUP.mirror_region | 0 | 4 | 196 | 1 | N | Y |
template.XTRANSPORT.stripe | 0 | 4 | 201 | 1 | N | Y |
template.XTRANSPORT.redundancy | 17 | 4 | 204 | 1 | N | Y |
template.XTRANSPORT.primary_region | 0 | 4 | 205 | 1 | N | Y |
template.XTRANSPORT.mirror_region | 0 | 4 | 206 | 1 | N | Y |
template.CHANGETRACKING.stripe | 0 | 4 | 211 | 1 | N | Y |
template.CHANGETRACKING.redundancy | 17 | 4 | 214 | 1 | N | Y |
template.CHANGETRACKING.primary_region | 0 | 4 | 215 | 1 | N | Y |
template.CHANGETRACKING.mirror_region | 0 | 4 | 216 | 1 | N | Y |
template.FLASHBACK.stripe | 0 | 4 | 221 | 1 | N | Y |
template.FLASHBACK.redundancy | 17 | 4 | 224 | 1 | N | Y |
template.FLASHBACK.primary_region | 0 | 4 | 225 | 1 | N | Y |
template.FLASHBACK.mirror_region | 0 | 4 | 226 | 1 | N | Y |
template.DATAGUARDCONFIG.stripe | 0 | 4 | 231 | 1 | N | Y |
template.DATAGUARDCONFIG.redundancy | 17 | 4 | 234 | 1 | N | Y |
template.DATAGUARDCONFIG.primary_region | 0 | 4 | 235 | 1 | N | Y |
template.DATAGUARDCONFIG.mirror_region | 0 | 4 | 236 | 1 | N | Y |
template.OCRFILE.stripe | 0 | 4 | 241 | 1 | N | Y |
template.OCRFILE.redundancy | 17 | 4 | 244 | 1 | N | Y |
template.OCRFILE.primary_region | 0 | 4 | 245 | 1 | N | Y |
template.OCRFILE.mirror_region | 0 | 4 | 246 | 1 | N | Y |
disk_repair_time | 3.6h | 5 | 0 | 1 | N | Y |
au_size | 1048576 | 5 | 5 | 1 | Y | Y |
sector_size | 512 | 5 | 6 | 1 | Y | Y |
compatible.asm | 11.2.0.0.0 | 5 | 20 | 1 | N | Y |
compatible.rdbms | 11.2.0.0.0 | 5 | 21 | 1 | N | Y |
compatible.advm | 11.2.0.0.0 | 5 | 22 | 1 | N | Y |
cell.smart_scan_capable | FALSE | 5 | 30 | 1 | N | N |
access_control.enabled | FALSE | 5 | 40 | 1 | N | Y |
access_control.umask | 066 | 5 | 41 | 1 | N | Y |
template_version | 186646528 | 5 | 50 | 1 | N | Y |
template.PARAMETERFILE.stripe | 0 | 5 | 71 | 1 | N | Y |
template.PARAMETERFILE.redundancy | 17 | 5 | 74 | 1 | N | Y |
template.PARAMETERFILE.primary_region | 0 | 5 | 75 | 1 | N | Y |
template.PARAMETERFILE.mirror_region | 0 | 5 | 76 | 1 | N | Y |
template.ASMPARAMETERFILE.stripe | 0 | 5 | 81 | 1 | N | Y |
template.ASMPARAMETERFILE.redundancy | 17 | 5 | 84 | 1 | N | Y |
template.ASMPARAMETERFILE.primary_region | 0 | 5 | 85 | 1 | N | Y |
template.ASMPARAMETERFILE.mirror_region | 0 | 5 | 86 | 1 | N | Y |
template.DUMPSET.stripe | 0 | 5 | 101 | 1 | N | Y |
template.DUMPSET.redundancy | 17 | 5 | 104 | 1 | N | Y |
template.DUMPSET.primary_region | 0 | 5 | 105 | 1 | N | Y |
template.DUMPSET.mirror_region | 0 | 5 | 106 | 1 | N | Y |
template.CONTROLFILE.stripe | 1 | 5 | 111 | 1 | N | Y |
template.CONTROLFILE.redundancy | 17 | 5 | 114 | 1 | N | Y |
template.CONTROLFILE.primary_region | 0 | 5 | 115 | 1 | N | Y |
template.CONTROLFILE.mirror_region | 0 | 5 | 116 | 1 | N | Y |
template.FLASHFILE.stripe | 0 | 5 | 121 | 1 | N | Y |
template.FLASHFILE.redundancy | 17 | 5 | 124 | 1 | N | Y |
template.FLASHFILE.primary_region | 0 | 5 | 125 | 1 | N | Y |
template.FLASHFILE.mirror_region | 0 | 5 | 126 | 1 | N | Y |
template.ARCHIVELOG.stripe | 0 | 5 | 131 | 1 | N | Y |
template.ARCHIVELOG.redundancy | 17 | 5 | 134 | 1 | N | Y |
template.ARCHIVELOG.primary_region | 0 | 5 | 135 | 1 | N | Y |
template.ARCHIVELOG.mirror_region | 0 | 5 | 136 | 1 | N | Y |
template.ONLINELOG.stripe | 0 | 5 | 141 | 1 | N | Y |
template.ONLINELOG.redundancy | 17 | 5 | 144 | 1 | N | Y |
template.ONLINELOG.primary_region | 0 | 5 | 145 | 1 | N | Y |
template.ONLINELOG.mirror_region | 0 | 5 | 146 | 1 | N | Y |
template.DATAFILE.stripe | 0 | 5 | 151 | 1 | N | Y |
template.DATAFILE.redundancy | 17 | 5 | 154 | 1 | N | Y |
template.DATAFILE.primary_region | 0 | 5 | 155 | 1 | N | Y |
template.DATAFILE.mirror_region | 0 | 5 | 156 | 1 | N | Y |
template.TEMPFILE.stripe | 0 | 5 | 161 | 1 | N | Y |
template.TEMPFILE.redundancy | 17 | 5 | 164 | 1 | N | Y |
template.TEMPFILE.primary_region | 0 | 5 | 165 | 1 | N | Y |
template.TEMPFILE.mirror_region | 0 | 5 | 166 | 1 | N | Y |
template.BACKUPSET.stripe | 0 | 5 | 181 | 1 | N | Y |
template.BACKUPSET.redundancy | 17 | 5 | 184 | 1 | N | Y |
template.BACKUPSET.primary_region | 0 | 5 | 185 | 1 | N | Y |
template.BACKUPSET.mirror_region | 0 | 5 | 186 | 1 | N | Y |
template.AUTOBACKUP.stripe | 0 | 5 | 191 | 1 | N | Y |
template.AUTOBACKUP.redundancy | 17 | 5 | 194 | 1 | N | Y |
template.AUTOBACKUP.primary_region | 0 | 5 | 195 | 1 | N | Y |
template.AUTOBACKUP.mirror_region | 0 | 5 | 196 | 1 | N | Y |
template.XTRANSPORT.stripe | 0 | 5 | 201 | 1 | N | Y |
template.XTRANSPORT.redundancy | 17 | 5 | 204 | 1 | N | Y |
template.XTRANSPORT.primary_region | 0 | 5 | 205 | 1 | N | Y |
template.XTRANSPORT.mirror_region | 0 | 5 | 206 | 1 | N | Y |
template.CHANGETRACKING.stripe | 0 | 5 | 211 | 1 | N | Y |
template.CHANGETRACKING.redundancy | 17 | 5 | 214 | 1 | N | Y |
template.CHANGETRACKING.primary_region | 0 | 5 | 215 | 1 | N | Y |
template.CHANGETRACKING.mirror_region | 0 | 5 | 216 | 1 | N | Y |
template.FLASHBACK.stripe | 0 | 5 | 221 | 1 | N | Y |
template.FLASHBACK.redundancy | 17 | 5 | 224 | 1 | N | Y |
template.FLASHBACK.primary_region | 0 | 5 | 225 | 1 | N | Y |
template.FLASHBACK.mirror_region | 0 | 5 | 226 | 1 | N | Y |
template.DATAGUARDCONFIG.stripe | 0 | 5 | 231 | 1 | N | Y |
template.DATAGUARDCONFIG.redundancy | 17 | 5 | 234 | 1 | N | Y |
template.DATAGUARDCONFIG.primary_region | 0 | 5 | 235 | 1 | N | Y |
template.DATAGUARDCONFIG.mirror_region | 0 | 5 | 236 | 1 | N | Y |
template.OCRFILE.stripe | 0 | 5 | 241 | 1 | N | Y |
template.OCRFILE.redundancy | 17 | 5 | 244 | 1 | N | Y |
template.OCRFILE.primary_region | 0 | 5 | 245 | 1 | N | Y |
template.OCRFILE.mirror_region | 0 | 5 | 246 | 1 | N | Y |
369 rows selected.
SQL>
SQL> select * from v$asm_operation;
no rows selected
SQL> select * from gv$asm_operation;
no rows selected
SQL>
SQL>
SQL> select * from v$version;
BANNER |
---|
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production |
PL/SQL Release 11.2.0.3.0 - Production |
CORE 11.2.0.3.0 Production |
TNS for Linux: Version 11.2.0.3.0 - Production |
NLSRTL Version 11.2.0.3.0 - Production |
SQL>
SQL>
SQL> select * from V$ASM_ACFSSNAPSHOTS;
no rows selected
SQL> select * from V$ASM_ACFSVOLUMES;
FS_NAME | VOL_DEVICE | VOL_LABEL | PRIMA | TOTAL_MB | FREE_MB |
---|---|---|---|---|---|
/u02acfs | /dev/asm/storageteam-215 | TRUE | 14336 | 14271.3203 | |
/u03acfs | /dev/asm/ebernalvol-168 | TRUE | 14336 | 14271.3203 |
SQL> select * from V$ASM_FILESYSTEM;
FS_NAME | AVAILABLE_TIME | BLOCK_SIZE | STATE | CORRU | NUM_VOL | TOTAL_SIZE | TOTAL_FREE | TOTAL_SNAP_SPACE_USAGE |
---|---|---|---|---|---|---|---|---|
/u02acfs | 06-APR-2012 17:06:23 | 4 | AVAILABLE | FALSE | 1 | 14336 | 14271.3203 | 0 |
/u03acfs | 06-APR-2012 17:52:02 | 4 | AVAILABLE | FALSE | 1 | 14336 | 14271.3203 | 0 |
SQL> select * from V$ASM_VOLUME;
GROUP_NUMBER | VOLUME_NAME | COMPOUND_INDEX | SIZE_MB | VOLUME_NUMBER | REDUND | STRIPE_COLUMNS | STRIPE_WIDTH_K | STATE | FILE_NUMBER | INCARNATION | DRL_FILE_NUMBER | RESIZE_UNIT_MB | USAGE | VOLUME_DEVICE | MOUNTPATH |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | STORAGETEAM | 67108865 | 14336 | 1 | UNPROT | 4 | 128 | ENABLED | 256 | 779907659 | 0 | 32 | ACFS | /dev/asm/storageteam-215 | /u02acfs |
5 | EBERNALVOL | 83886081 | 14336 | 1 | UNPROT | 4 | 128 | ENABLED | 256 | 779910073 | 0 | 32 | ACFS | /dev/asm/ebernalvol-168 | /u03acfs |
SQL> select * from V$ASM_VOLUME_STAT;
GROUP_NUMBER | VOLUME_NAME | COMPOUND_INDEX | VOLUME_NUMBER | READS | WRITES | READ_ERRS | WRITE_ERRS | READ_TIME | WRITE_TIME | BYTES_READ | BYTES_WRITTEN |
---|---|---|---|---|---|---|---|---|---|---|---|
4 | STORAGETEAM | 67108865 | 1 | 285 | 7604 | 0 | 0 | .615 | 20.395 | 274944 | 30898176 |
5 | EBERNALVOL | 83886081 | 1 | 285 | 7604 | 0 | 0 | .654 | 21.107 | 274944 | 30898176 |
SQL>
SQL> select * from V$ASM_USER;
no rows selected
SQL> select * from V$ASM_USERGROUP;
no rows selected
SQL> select * from V$ASM_USERGROUP_MEMBER;
no rows selected
SQL>
SQL> select * from V$ASM_DISK_IOSTAT;
INSTNAME | DBNAME | GROUP_NUMBER | DISK_NUMBER | FAILGROUP | READS | WRITES | READ_ERRS | WRITE_ERRS | READ_TIME | WRITE_TIME | BYTES_READ | BYTES_WRITTEN | HOT_READS | HOT_WRITES | HOT_BYTES_READ | HOT_BYTES_WRITTEN | COLD_READS | COLD_WRITES | COLD_BYTES_READ | COLD_BYTES_WRITTEN |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DBASM112 | DBASM112 | 1 | 1 | FG1 | 44269 | 1183715 | 0 | 0 | 607.725 | 5545.88 | 559702016 | 2.5912E+10 | 0 | 0 | 0 | 0 | 44269 | 1183715 | 559702016 | 2.5912E+10 |
DBASM112 | DBASM112 | 1 | 2 | FG2 | 43838 | 1190070 | 0 | 0 | 500.843 | 7674.55 | 534519808 | 3.1831E+10 | 0 | 0 | 0 | 0 | 43838 | 1190070 | 534519808 | 3.1831E+10 |
DBASM112 | DBASM112 | 2 | 0 | FG1 | 385852 | 1148616 | 0 | 0 | 15249.51 | 80105.074 | 9554624512 | 1.8314E+10 | 0 | 0 | 0 | 0 | 385852 | 1148616 | 9554624512 | 1.8314E+10 |
DBASM112 | DBASM112 | 2 | 3 | FG2 | 2956649 | 1134604 | 0 | 0 | 26570.468 | 144429.493 | 5.1565E+10 | 1.8332E+10 | 0 | 0 | 0 | 0 | 2956649 | 1134604 | 5.1565E+10 | 1.8332E+10 |
DBASM112 | DBASM112 | 2 | 1 | FG1 | 1515289 | 2836420 | 0 | 0 | 44587.405 | 112692.255 | 2.8082E+10 | 4.6107E+10 | 0 | 0 | 0 | 0 | 1515289 | 2836420 | 2.8082E+10 | 4.6107E+10 |
DBASM112 | DBASM112 | 1 | 0 | FG1 | 43244 | 1402356 | 0 | 0 | 587.954 | 8740.533 | 511352832 | 3.7284E+10 | 0 | 0 | 0 | 0 | 43244 | 1402356 | 511352832 | 3.7284E+10 |
DBASM112 | DBASM112 | 2 | 2 | FG2 | 773358 | 2850432 | 0 | 0 | 19526.818 | 69717.233 | 1.5853E+10 | 4.6088E+10 | 0 | 0 | 0 | 0 | 773358 | 2850432 | 1.5853E+10 | 4.6088E+10 |
DBASM112 | DBASM112 | 1 | 3 | FG2 | 54269 | 1396001 | 0 | 0 | 587.521 | 7257.44 | 622213632 | 3.1365E+10 | 0 | 0 | 0 | 0 | 54269 | 1396001 | 622213632 | 3.1365E+10 |
+ASM | asmvol | 4 | 0 | ASMDISKNEW9 | 258 | 78 | 0 | 0 | .531842 | .102998 | 164352 | 71680 | 0 | 0 | 0 | 0 | 258 | 78 | 164352 | 71680 |
+ASM | asmvol | 5 | 0 | ASMDISKNEW10 | 258 | 78 | 0 | 0 | .564845 | .101998 | 164352 | 71680 | 0 | 0 | 0 | 0 | 258 | 78 | 164352 | 71680 |
10 rows selected.
SQL> select * from V$ASM_DISK_STAT;
GROUP_NUMBER | DISK_NUMBER | COMPOUND_INDEX | INCARNATION | MOUNT_S | HEADER_STATU | MODE_ST | STATE | REDUNDA | LIBRARY | OS_MB | TOTAL_MB | FREE_MB | HOT_USED_MB | COLD_USED_MB | NAME | FAILGROUP | LABEL | PATH | UDID | PRODUCT | CREATE_DATE | MOUNT_DATE | REPAIR_TIMER | READS | WRITES | READ_ERRS | WRITE_ERRS | READ_TIME | WRITE_TIME | BYTES_READ | BYTES_WRITTEN | P | HASH_VALUE | HOT_READS | HOT_WRITES | HOT_BYTES_READ | HOT_BYTES_WRITTEN | COLD_READS | COLD_WRITES | COLD_BYTES_READ | COLD_BYTES_WRITTEN | V | SECTOR_SIZE | FAILGRO |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0 | 16777216 | 3915944019 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 18468 | 0 | 1070 | ASMDISKNEW1 | FG1 | ASMDISKNEW1 | ORCL:ASMDISKNEW1 | 05-APR-2012 18:19:29 | 06-APR-2012 16:47:24 | 0 | 60710 | 3111918 | 0 | 0 | 1470.738 | 36714.504 | 584806400 | 4.4288E+10 | U | 1858933910 | 0 | 0 | 0 | 0 | 43244 | 1402356 | 511352832 | 3.7284E+10 | N | 512 | REGULAR | ||
5 | 0 | 83886080 | 3915944033 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 14653 | 262 | 0 | 14391 | ASMDISKNEW10 | ASMDISKNEW10 | ASMDISKNEW10 | ORCL:ASMDISKNEW10 | 06-APR-2012 17:38:54 | 06-APR-2012 17:39:03 | 0 | 17598 | 1708672 | 0 | 0 | 518.172845 | 1631.218 | 72147456 | 7002368000 | 405308562 | 0 | 0 | 0 | 0 | 258 | 78 | 164352 | 71680 | N | 512 | REGULAR | |||
6 | 0 | 100663296 | 3915944054 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 14653 | 14603 | 0 | 14391 | ASMDISKNEW11 | ASMDISKNEW11 | ASMDISKNEW11 | ORCL:ASMDISKNEW11 | 12-APR-2012 11:33:52 | 12-APR-2012 11:40:05 | 0 | 15566 | 1543936 | 0 | 0 | 525.87 | 1418.397 | 64720896 | 6323961856 | 3808981697 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N | 512 | REGULAR | |||
7 | 0 | 117440512 | 3915944057 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 14653 | 14603 | 0 | 14391 | ASMDISKNEW12 | ASMDISKNEW12 | ASMDISKNEW12 | ORCL:ASMDISKNEW12 | 24-APR-2012 12:30:14 | 24-APR-2012 12:30:26 | 0 | 12074 | 1200847 | 0 | 0 | 175.415 | 894.616 | 50417664 | 4918669312 | 1517235067 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N | 512 | REGULAR | |||
3 | 0 | 50331648 | 3915944027 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 8887 | 8887 | 8828 | 0 | 59 | ASMDISKNEW14 | ASMDISKNEW14 | ASMDISKNEW14 | ORCL:ASMDISKNEW14 | 05-APR-2012 18:16:20 | 06-APR-2012 16:47:25 | 0 | 17427 | 1709059 | 0 | 0 | 434.306 | 6902.094 | 72145920 | 6999983104 | 3227115283 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N | 512 | REGULAR | |||
1 | 1 | 16777217 | 3915944020 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 18476 | 0 | 1062 | ASMDISKNEW2 | FG1 | ASMDISKNEW2 | ORCL:ASMDISKNEW2 | 05-APR-2012 18:19:29 | 06-APR-2012 16:47:24 | 0 | 44516 | 1183774 | 0 | 0 | 613.796 | 5546.153 | 560717824 | 2.5913E+10 | U | 4238862529 | 0 | 0 | 0 | 0 | 44269 | 1183715 | 559702016 | 2.5912E+10 | N | 512 | REGULAR | ||
1 | 2 | 16777218 | 3915944021 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 18476 | 0 | 1062 | ASMDISKNEW3 | FG2 | ASMDISKNEW3 | ORCL:ASMDISKNEW3 | 05-APR-2012 18:19:29 | 06-APR-2012 16:47:24 | 0 | 61146 | 2899101 | 0 | 0 | 1628.535 | 36883.737 | 605413376 | 3.8833E+10 | U | 3481199486 | 0 | 0 | 0 | 0 | 43838 | 1190070 | 534519808 | 3.1831E+10 | N | 512 | REGULAR | ||
1 | 3 | 16777219 | 3915944022 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 18468 | 0 | 1070 | ASMDISKNEW4 | FG2 | ASMDISKNEW4 | ORCL:ASMDISKNEW4 | 05-APR-2012 18:19:29 | 06-APR-2012 16:47:24 | 0 | 54505 | 1396591 | 0 | 0 | 595.391 | 7263.73 | 623177728 | 3.1368E+10 | U | 3420979251 | 0 | 0 | 0 | 0 | 54271 | 1396001 | 622215168 | 3.1365E+10 | N | 512 | REGULAR | ||
2 | 0 | 33554432 | 3915944023 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 11232 | 0 | 8306 | ASMDISKNEW5 | FG1 | ASMDISKNEW5 | ORCL:ASMDISKNEW5 | 05-APR-2012 18:23:20 | 06-APR-2012 16:47:24 | 0 | 403314 | 2865393 | 0 | 0 | 15607.731 | 85127.554 | 9628073984 | 2.5349E+10 | U | 3900773597 | 0 | 0 | 0 | 0 | 385852 | 1148616 | 9554624512 | 1.8314E+10 | N | 512 | REGULAR | ||
2 | 1 | 33554433 | 3915944024 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 11164 | 0 | 8374 | ASMDISKNEW6 | FG1 | ASMDISKNEW6 | ORCL:ASMDISKNEW6 | 05-APR-2012 18:23:20 | 06-APR-2012 16:47:24 | 0 | 1515525 | 2838609 | 0 | 0 | 44598.481 | 112913.049 | 2.8083E+10 | 4.6116E+10 | U | 3327682112 | 0 | 0 | 0 | 0 | 1515289 | 2836421 | 2.8082E+10 | 4.6107E+10 | N | 512 | REGULAR | ||
2 | 2 | 33554434 | 3915944025 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 11204 | 0 | 8334 | ASMDISKNEW7 | FG2 | ASMDISKNEW7 | ORCL:ASMDISKNEW7 | 05-APR-2012 18:23:20 | 06-APR-2012 16:47:24 | 0 | 792371 | 4564239 | 0 | 0 | 20262.815 | 74186.736 | 1.5932E+10 | 5.3111E+10 | U | 2514475167 | 0 | 0 | 0 | 0 | 773358 | 2850433 | 1.5853E+10 | 4.6088E+10 | N | 512 | REGULAR | ||
2 | 3 | 33554435 | 3915944026 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 19539 | 19538 | 11192 | 0 | 8346 | ASMDISKNEW8 | FG2 | ASMDISKNEW8 | ORCL:ASMDISKNEW8 | 05-APR-2012 18:23:20 | 06-APR-2012 16:47:24 | 0 | 2956880 | 1139767 | 0 | 0 | 26584.892 | 145227.893 | 5.1566E+10 | 1.8354E+10 | U | 3833053942 | 0 | 0 | 0 | 0 | 2956650 | 1134604 | 5.1565E+10 | 1.8332E+10 | N | 512 | REGULAR | ||
4 | 0 | 67108864 | 3915944030 | CACHED | MEMBER | ONLINE | NORMAL | UNKNOWN | ASM Library - Generic Linux, version 2.0.4 (KABI_V2) | 14653 | 14653 | 262 | 0 | 14391 | ASMDISKNEW9 | ASMDISKNEW9 | ASMDISKNEW9 | ORCL:ASMDISKNEW9 | 06-APR-2012 16:59:54 | 06-APR-2012 17:00:05 | 0 | 17637 | 1709442 | 0 | 0 | 492.279842 | 1920.143 | 72307200 | 7005521920 | 3936317828 | 0 | 0 | 0 | 0 | 258 | 78 | 164352 | 71680 | N | 512 | REGULAR |
13 rows selected.
SQL> select * from V$ASM_DISKGROUP_STAT;
GROUP_NUMBER | NAME | SECTOR_SIZE | BLOCK_SIZE | ALLOCATION_UNIT_SIZE | STATE | TYPE | TOTAL_MB | FREE_MB | HOT_USED_MB | COLD_USED_MB | REQUIRED_MIRROR_FREE_MB | USABLE_FILE_MB | OFFLINE_DISKS | COMPATIBILITY | DATABASE_COMPATIBILITY | V |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DATA | 512 | 4096 | 2097152 | MOUNTED | NORMAL | 78152 | 73888 | 0 | 4264 | 19538 | 27175 | 0 | 11.2.0.0.0 | 11.2.0.0.0 | N |
2 | RECO | 512 | 4096 | 2097152 | MOUNTED | NORMAL | 78152 | 44792 | 0 | 33360 | 19538 | 12627 | 0 | 11.2.0.0.0 | 11.2.0.0.0 | N |
3 | SPFILE | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 8887 | 8828 | 0 | 59 | 0 | 8828 | 0 | 11.2.0.0.0 | 10.1.0.0.0 | N |
4 | ACFS | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 14653 | 262 | 0 | 14391 | 0 | 262 | 0 | 11.2.0.0.0 | 11.2.0.0.0 | N |
5 | ACFSDG | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 14653 | 262 | 0 | 14391 | 0 | 262 | 0 | 11.2.0.0.0 | 11.2.0.0.0 | N |
7 | TESTDG2 | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 14653 | 14603 | 0 | 50 | 0 | 14603 | 0 | 10.1.0.0.0 | 10.1.0.0.0 | N |
6 | TESTDG | 512 | 4096 | 1048576 | MOUNTED | EXTERN | 14653 | 14603 | 0 | 50 | 0 | 14603 | 0 | 10.1.0.0.0 | 10.1.0.0.0 | N |
7 rows selected.
SQL>
SQL> select * from V$ASM_TEMPLATE;
GROUP_NUMBER | ENTRY_NUMBER | REDUND | STRIPE | S | NAME | PRIM | MIRR |
---|---|---|---|---|---|---|---|
1 | 60 | MIRROR | COARSE | Y | PARAMETERFILE | COLD | COLD |
1 | 61 | MIRROR | COARSE | Y | ASMPARAMETERFILE | COLD | COLD |
1 | 63 | MIRROR | COARSE | Y | DUMPSET | COLD | COLD |
1 | 64 | HIGH | FINE | Y | CONTROLFILE | COLD | COLD |
1 | 65 | MIRROR | COARSE | Y | FLASHFILE | COLD | COLD |
1 | 66 | MIRROR | COARSE | Y | ARCHIVELOG | COLD | COLD |
1 | 67 | MIRROR | COARSE | Y | ONLINELOG | COLD | COLD |
1 | 68 | MIRROR | COARSE | Y | DATAFILE | COLD | COLD |
1 | 69 | MIRROR | COARSE | Y | TEMPFILE | COLD | COLD |
1 | 170 | MIRROR | COARSE | Y | BACKUPSET | COLD | COLD |
1 | 171 | MIRROR | COARSE | Y | AUTOBACKUP | COLD | COLD |
1 | 172 | MIRROR | COARSE | Y | XTRANSPORT | COLD | COLD |
1 | 173 | MIRROR | COARSE | Y | CHANGETRACKING | COLD | COLD |
1 | 174 | MIRROR | COARSE | Y | FLASHBACK | COLD | COLD |
1 | 175 | MIRROR | COARSE | Y | DATAGUARDCONFIG | COLD | COLD |
1 | 176 | MIRROR | COARSE | Y | OCRFILE | COLD | COLD |
2 | 60 | MIRROR | COARSE | Y | PARAMETERFILE | COLD | COLD |
2 | 61 | MIRROR | COARSE | Y | ASMPARAMETERFILE | COLD | COLD |
2 | 63 | MIRROR | COARSE | Y | DUMPSET | COLD | COLD |
2 | 64 | HIGH | FINE | Y | CONTROLFILE | COLD | COLD |
2 | 65 | MIRROR | COARSE | Y | FLASHFILE | COLD | COLD |
2 | 66 | MIRROR | COARSE | Y | ARCHIVELOG | COLD | COLD |
2 | 67 | MIRROR | COARSE | Y | ONLINELOG | COLD | COLD |
2 | 68 | MIRROR | COARSE | Y | DATAFILE | COLD | COLD |
2 | 69 | MIRROR | COARSE | Y | TEMPFILE | COLD | COLD |
2 | 170 | MIRROR | COARSE | Y | BACKUPSET | COLD | COLD |
2 | 171 | MIRROR | COARSE | Y | AUTOBACKUP | COLD | COLD |
2 | 172 | MIRROR | COARSE | Y | XTRANSPORT | COLD | COLD |
2 | 173 | MIRROR | COARSE | Y | CHANGETRACKING | COLD | COLD |
2 | 174 | MIRROR | COARSE | Y | FLASHBACK | COLD | COLD |
2 | 175 | MIRROR | COARSE | Y | DATAGUARDCONFIG | COLD | COLD |
2 | 176 | MIRROR | COARSE | Y | OCRFILE | COLD | COLD |
3 | 60 | UNPROT | COARSE | Y | PARAMETERFILE | COLD | COLD |
3 | 61 | UNPROT | COARSE | Y | ASMPARAMETERFILE | COLD | COLD |
3 | 63 | UNPROT | COARSE | Y | DUMPSET | COLD | COLD |
3 | 64 | UNPROT | FINE | Y | CONTROLFILE | COLD | COLD |
3 | 65 | UNPROT | COARSE | Y | FLASHFILE | COLD | COLD |
3 | 66 | UNPROT | COARSE | Y | ARCHIVELOG | COLD | COLD |
3 | 67 | UNPROT | COARSE | Y | ONLINELOG | COLD | COLD |
3 | 68 | UNPROT | COARSE | Y | DATAFILE | COLD | COLD |
3 | 69 | UNPROT | COARSE | Y | TEMPFILE | COLD | COLD |
3 | 170 | UNPROT | COARSE | Y | BACKUPSET | COLD | COLD |
3 | 171 | UNPROT | COARSE | Y | AUTOBACKUP | COLD | COLD |
3 | 172 | UNPROT | COARSE | Y | XTRANSPORT | COLD | COLD |
3 | 173 | UNPROT | COARSE | Y | CHANGETRACKING | COLD | COLD |
3 | 174 | UNPROT | COARSE | Y | FLASHBACK | COLD | COLD |
3 | 175 | UNPROT | COARSE | Y | DATAGUARDCONFIG | COLD | COLD |
3 | 176 | UNPROT | COARSE | Y | OCRFILE | COLD | COLD |
4 | 60 | UNPROT | COARSE | Y | PARAMETERFILE | COLD | COLD |
4 | 61 | UNPROT | COARSE | Y | ASMPARAMETERFILE | COLD | COLD |
4 | 63 | UNPROT | COARSE | Y | DUMPSET | COLD | COLD |
4 | 64 | UNPROT | FINE | Y | CONTROLFILE | COLD | COLD |
4 | 65 | UNPROT | COARSE | Y | FLASHFILE | COLD | COLD |
4 | 66 | UNPROT | COARSE | Y | ARCHIVELOG | COLD | COLD |
4 | 67 | UNPROT | COARSE | Y | ONLINELOG | COLD | COLD |
4 | 68 | UNPROT | COARSE | Y | DATAFILE | COLD | COLD |
4 | 69 | UNPROT | COARSE | Y | TEMPFILE | COLD | COLD |
4 | 170 | UNPROT | COARSE | Y | BACKUPSET | COLD | COLD |
4 | 171 | UNPROT | COARSE | Y | AUTOBACKUP | COLD | COLD |
4 | 172 | UNPROT | COARSE | Y | XTRANSPORT | COLD | COLD |
4 | 173 | UNPROT | COARSE | Y | CHANGETRACKING | COLD | COLD |
4 | 174 | UNPROT | COARSE | Y | FLASHBACK | COLD | COLD |
4 | 175 | UNPROT | COARSE | Y | DATAGUARDCONFIG | COLD | COLD |
4 | 176 | UNPROT | COARSE | Y | OCRFILE | COLD | COLD |
5 | 60 | UNPROT | COARSE | Y | PARAMETERFILE | COLD | COLD |
5 | 61 | UNPROT | COARSE | Y | ASMPARAMETERFILE | COLD | COLD |
5 | 63 | UNPROT | COARSE | Y | DUMPSET | COLD | COLD |
5 | 64 | UNPROT | FINE | Y | CONTROLFILE | COLD | COLD |
5 | 65 | UNPROT | COARSE | Y | FLASHFILE | COLD | COLD |
5 | 66 | UNPROT | COARSE | Y | ARCHIVELOG | COLD | COLD |
5 | 67 | UNPROT | COARSE | Y | ONLINELOG | COLD | COLD |
5 | 68 | UNPROT | COARSE | Y | DATAFILE | COLD | COLD |
5 | 69 | UNPROT | COARSE | Y | TEMPFILE | COLD | COLD |
5 | 170 | UNPROT | COARSE | Y | BACKUPSET | COLD | COLD |
5 | 171 | UNPROT | COARSE | Y | AUTOBACKUP | COLD | COLD |
5 | 172 | UNPROT | COARSE | Y | XTRANSPORT | COLD | COLD |
5 | 173 | UNPROT | COARSE | Y | CHANGETRACKING | COLD | COLD |
5 | 174 | UNPROT | COARSE | Y | FLASHBACK | COLD | COLD |
5 | 175 | UNPROT | COARSE | Y | DATAGUARDCONFIG | COLD | COLD |
5 | 176 | UNPROT | COARSE | Y | OCRFILE | COLD | COLD |
7 | 0 | UNPROT | COARSE | Y | PARAMETERFILE | COLD | COLD |
7 | 1 | UNPROT | COARSE | Y | ASMPARAMETERFILE | COLD | COLD |
7 | 3 | UNPROT | COARSE | Y | DUMPSET | COLD | COLD |
7 | 4 | UNPROT | FINE | Y | CONTROLFILE | COLD | COLD |
7 | 5 | UNPROT | COARSE | Y | FLASHFILE | COLD | COLD |
7 | 6 | UNPROT | COARSE | Y | ARCHIVELOG | COLD | COLD |
7 | 7 | UNPROT | COARSE | Y | ONLINELOG | COLD | COLD |
7 | 8 | UNPROT | COARSE | Y | DATAFILE | COLD | COLD |
7 | 9 | UNPROT | COARSE | Y | TEMPFILE | COLD | COLD |
7 | 10 | UNPROT | COARSE | Y | BACKUPSET | COLD | COLD |
7 | 11 | UNPROT | COARSE | Y | AUTOBACKUP | COLD | COLD |
7 | 12 | UNPROT | COARSE | Y | XTRANSPORT | COLD | COLD |
7 | 13 | UNPROT | COARSE | Y | CHANGETRACKING | COLD | COLD |
7 | 14 | UNPROT | COARSE | Y | FLASHBACK | COLD | COLD |
7 | 15 | UNPROT | COARSE | Y | DATAGUARDCONFIG | COLD | COLD |
7 | 16 | UNPROT | COARSE | Y | OCRFILE | COLD | COLD |
6 | 0 | UNPROT | COARSE | Y | PARAMETERFILE | COLD | COLD |
6 | 1 | UNPROT | COARSE | Y | ASMPARAMETERFILE | COLD | COLD |
6 | 3 | UNPROT | COARSE | Y | DUMPSET | COLD | COLD |
6 | 4 | UNPROT | FINE | Y | CONTROLFILE | COLD | COLD |
6 | 5 | UNPROT | COARSE | Y | FLASHFILE | COLD | COLD |
6 | 6 | UNPROT | COARSE | Y | ARCHIVELOG | COLD | COLD |
6 | 7 | UNPROT | COARSE | Y | ONLINELOG | COLD | COLD |
6 | 8 | UNPROT | COARSE | Y | DATAFILE | COLD | COLD |
6 | 9 | UNPROT | COARSE | Y | TEMPFILE | COLD | COLD |
6 | 10 | UNPROT | COARSE | Y | BACKUPSET | COLD | COLD |
6 | 11 | UNPROT | COARSE | Y | AUTOBACKUP | COLD | COLD |
6 | 12 | UNPROT | COARSE | Y | XTRANSPORT | COLD | COLD |
6 | 13 | UNPROT | COARSE | Y | CHANGETRACKING | COLD | COLD |
6 | 14 | UNPROT | COARSE | Y | FLASHBACK | COLD | COLD |
6 | 15 | UNPROT | COARSE | Y | DATAGUARDCONFIG | COLD | COLD |
6 | 16 | UNPROT | COARSE | Y | OCRFILE | COLD | COLD |
112 rows selected.
SQL>
SQL> show parameter asm
NAME | TYPE | VALUE |
---|---|---|
asm_diskgroups | string | DATA, RECO, ACFS, ACFSDG, TEST DG, TESTDG2 |
asm_diskstring | string | |
asm_power_limit | integer | 1 |
asm_preferred_read_failure_groups | string |
SQL> show parameter cluster
NAME | TYPE | VALUE |
---|---|---|
cluster_database | boolean | FALSE |
cluster_database_instances | integer | 1 |
cluster_interconnects | string |
SQL> show parameter instance_type
NAME | TYPE | VALUE |
---|---|---|
instance_type | string | asm |
SQL> show parameter instance_name
NAME | TYPE | VALUE |
---|---|---|
instance_name | string | +ASM |
SQL> show parameter spfile
NAME | TYPE | VALUE |
---|---|---|
spfile | string | +SPFILE/asm/asmparameterfile/r egistry.253.779825791 |
SQL>
SQL> show sga
Total System Global Area | 284565504 | bytes |
Fixed Size | 1344456 | bytes |
Variable Size | 258055224 | bytes |
ASM Cache | 25165824 | bytes |
SQL>
SQL> spool off
Example Output (Script #3):
SQL> -- ASM Versions 10.1, 10.2, 11.1 & 11.2 SQL> SET MARKUP HTML ON SQL> set echo on
SQL>
SQL> set pagesize 200
SQL>
SQL> alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
Session altered.
SQL>
SQL> select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;
'THISASMREPORTWASGENERATEDAT:==)>' | |
---|---|
THIS ASM REPORT WAS GENERATED AT: ==)> | 05-JUN-2012 23:58:18 |
SQL>
SQL>
SQL> select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';
'HOSTNAMEASSOCIATEDWITHTHISASMINSTANCE:==)>' | |
---|---|
HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> | asmlnx2.us.oracle.com |
SQL>
SQL> SELECT CONCAT('+'||GNAME, SYS_CONNECT_BY_PATH(ANAME, '/'))
2 FULL_PATH, SYSTEM_CREATED, ALIAS_DIRECTORY, FILE_TYPE
3 FROM ( SELECT B.NAME GNAME, A.PARENT_INDEX PINDEX,
4 A.NAME ANAME, A.REFERENCE_INDEX RINDEX,
5 A.SYSTEM_CREATED, A.ALIAS_DIRECTORY,
6 C.TYPE FILE_TYPE
7 FROM V$ASM_ALIAS A, V$ASM_DISKGROUP B, V$ASM_FILE C
8 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER
9 AND A.GROUP_NUMBER = C.GROUP_NUMBER(+)
10 AND A.FILE_NUMBER = C.FILE_NUMBER(+)
11 AND A.FILE_INCARNATION = C.INCARNATION(+)
12 )
13 START WITH (MOD(PINDEX, POWER(2, 24))) = 0
14 CONNECT BY PRIOR RINDEX = PINDEX;
FULL_PATH | S | A | FILE_TYPE |
---|---|---|---|
+DATA/DBASM112 | Y | Y | |
+DATA/DBASM112/DATAFILE | Y | Y | |
+DATA/DBASM112/DATAFILE/USERS.259.779841377 | Y | N | DATAFILE |
+DATA/DBASM112/DATAFILE/EXAMPLE.261.779841663 | Y | N | DATAFILE |
+DATA/DBASM112/DATAFILE/SYSTEM.256.779841377 | Y | N | DATAFILE |
+DATA/DBASM112/DATAFILE/SYSAUX.257.779841377 | Y | N | DATAFILE |
+DATA/DBASM112/DATAFILE/UNDOTBS1.258.779841377 | Y | N | DATAFILE |
+DATA/DBASM112/TEMPFILE | Y | Y | |
+DATA/DBASM112/TEMPFILE/TEMP.260.779841641 | Y | N | TEMPFILE |
+DATA/DBASM112/PARAMETERFILE | Y | Y | |
+DATA/DBASM112/PARAMETERFILE/spfile.262.779842391 | Y | N | PARAMETERFILE |
+DATA/DBASM112/spfileDBASM112.ora | N | N | PARAMETERFILE |
+RECO/DBASM112 | Y | Y | |
+RECO/DBASM112/CONTROLFILE | Y | Y | |
+RECO/DBASM112/CONTROLFILE/Current.256.779841609 | Y | N | CONTROLFILE |
+RECO/DBASM112/ONLINELOG | Y | Y | |
+RECO/DBASM112/ONLINELOG/group_2.258.779841617 | Y | N | ONLINELOG |
+RECO/DBASM112/ONLINELOG/group_1.257.779841613 | Y | N | ONLINELOG |
+RECO/DBASM112/ONLINELOG/group_3.259.779841623 | Y | N | ONLINELOG |
+RECO/DBASM112/ARCHIVELOG | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_05 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_05/thread_1_seq_5.260.779842897 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_06 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_6.261.779850057 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_9.264.779883133 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_12.267.779920349 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_11.266.779906875 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_10.265.779890895 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_13.268.779928493 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_8.263.779882737 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_06/thread_1_seq_7.262.779868367 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_07 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_18.273.780008639 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_14.269.779940249 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_15.270.779958047 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_16.271.779976037 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_07/thread_1_seq_17.272.779993501 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_08 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_23.278.780086045 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_19.274.780022137 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_24.279.780102033 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_20.275.780038245 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_21.276.780055231 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_08/thread_1_seq_22.277.780072793 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_09 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_29.284.780181243 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_25.280.780116431 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_26.281.780134451 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_27.282.780150939 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_09/thread_1_seq_28.283.780166299 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_10 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_34.289.780258743 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_30.285.780195647 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_35.290.780274831 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_31.286.780212197 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_32.287.780228145 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_10/thread_1_seq_33.288.780245763 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_11 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_40.295.780354139 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_36.291.780289243 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_37.292.780307015 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_38.293.780322741 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_11/thread_1_seq_39.294.780339095 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_12 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_45.300.780430731 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_41.296.780368459 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_46.301.780447445 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_42.297.780385739 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_43.298.780401843 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_12/thread_1_seq_44.299.780418243 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_13 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_47.302.780458447 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_52.307.780535235 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_51.306.780519651 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_50.305.780505843 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_49.304.780490819 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_13/thread_1_seq_48.303.780474035 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_14 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_53.308.780548419 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_58.313.780617857 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_57.312.780602449 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_56.311.780595229 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_55.310.780580191 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_14/thread_1_seq_54.309.780563947 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_15 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_59.314.780631217 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_64.319.780698045 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_63.318.780688901 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_62.317.780677437 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_61.316.780661237 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_15/thread_1_seq_60.315.780645743 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_16 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_65.320.780710641 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_68.323.780757209 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_70.325.780775447 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_69.324.780771845 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_71.326.780791541 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_67.322.780742243 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_16/thread_1_seq_66.321.780726037 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_17 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_77.332.780873443 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_72.327.780806063 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_73.328.780822007 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_74.329.780836739 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_75.330.780852745 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_17/thread_1_seq_76.331.780861889 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_18 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_83.338.780951635 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_78.333.780886829 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_84.339.780966053 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_79.334.780902347 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_80.335.780918453 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_81.336.780933605 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_18/thread_1_seq_82.337.780946605 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_19 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_90.345.781045217 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_85.340.780979739 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_86.341.780994825 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_87.342.781009239 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_88.343.781024745 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_19/thread_1_seq_89.344.781034871 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_20 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_96.351.781122357 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_91.346.781059631 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_97.352.781138241 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_92.347.781074045 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_93.348.781089541 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_94.349.781105649 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_20/thread_1_seq_95.350.781117965 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_21 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_103.358.781217339 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_98.353.781150265 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_99.354.781166043 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_100.355.781181869 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_101.356.781196423 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_21/thread_1_seq_102.357.781207851 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_22 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_109.364.781294349 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_104.359.781229943 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_110.365.781310043 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_105.360.781245885 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_106.361.781261209 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_107.362.781275741 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_22/thread_1_seq_108.363.781290037 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_23 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_111.366.781322549 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_113.368.781354139 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_115.370.781380835 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_114.369.781369233 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_116.371.781390043 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_23/thread_1_seq_112.367.781337945 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_24 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_121.376.781462297 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_117.372.781402649 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_118.373.781418041 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_119.374.781434011 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_120.375.781448427 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_122.377.781467331 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_24/thread_1_seq_123.378.781481847 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_25 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_128.383.781552809 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_129.384.781556421 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_130.385.781571045 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_126.381.781525041 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_127.382.781540345 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_124.379.781495231 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_25/thread_1_seq_125.380.781510211 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_26 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_136.391.781649273 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_131.386.781584545 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_132.387.781599607 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_133.388.781614065 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_134.389.781629049 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_26/thread_1_seq_135.390.781640311 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_27 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_142.397.781732853 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_137.392.781661041 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_143.398.781741227 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_138.393.781675567 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_139.394.781690649 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_140.395.781705241 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_27/thread_1_seq_141.396.781720445 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_28 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_144.399.781750945 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_150.405.781827721 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_149.404.781822865 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_148.403.781808421 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_147.402.781795141 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_146.401.781780523 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_28/thread_1_seq_145.400.781765529 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_29 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_151.406.781840857 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_157.412.781917449 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_156.411.781913137 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_155.410.781898457 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_154.409.781885945 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_153.408.781870739 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_29/thread_1_seq_152.407.781855599 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_30 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_163.418.782000695 | Y | N | ARCHIVELOG |
FULL_PATH | S | A | FILE_TYPE |
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_158.413.781930807 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_159.414.781945211 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_160.415.781959649 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_161.416.781974355 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_04_30/thread_1_seq_162.417.781987741 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_01 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_169.424.782164845 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_164.419.782093223 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_170.425.782173591 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_165.420.782108239 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_166.421.782122815 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_167.422.782138047 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_01/thread_1_seq_168.423.782153239 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_02 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_171.426.782184095 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_177.432.782260087 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_176.431.782254855 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_175.430.782240409 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_174.429.782228135 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_173.428.782213637 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_02/thread_1_seq_172.427.782198433 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_03 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_178.433.782272845 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_181.436.782317147 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_183.438.782344861 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_182.437.782330423 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_184.439.782348639 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_180.435.782302503 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_03/thread_1_seq_179.434.782287441 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_04 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_190.445.782424239 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_185.440.782362047 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_186.441.782377047 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_187.442.782391655 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_188.443.782406039 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_04/thread_1_seq_189.444.782418843 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_05 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_196.451.782510429 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_191.446.782438465 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_197.452.782514039 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_192.447.782452941 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_193.448.782467523 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_194.449.782483641 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_05/thread_1_seq_195.450.782497239 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_06 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_198.453.782526847 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_204.459.782604053 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_203.458.782597037 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_202.457.782585435 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_201.456.782570843 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_200.455.782555671 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_06/thread_1_seq_199.454.782541147 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_07 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_205.460.782617741 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_211.466.782694057 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_210.465.782683533 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_209.464.782673635 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_208.463.782661623 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_207.462.782647227 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_07/thread_1_seq_206.461.782632155 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_08 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_217.472.782770029 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_212.467.782706941 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_213.468.782722045 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_214.469.782737207 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_215.470.782751649 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_08/thread_1_seq_216.471.782764447 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_09 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_223.478.782855343 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_218.473.782784021 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_224.479.782859043 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_219.474.782798459 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_220.475.782812973 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_221.476.782827439 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_09/thread_1_seq_222.477.782841967 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_10 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_225.480.782870731 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_228.483.782914711 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_230.485.782942445 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_229.484.782929811 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_231.486.782946061 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_227.482.782900159 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_10/thread_1_seq_226.481.782885139 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_11 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_234.489.782989205 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_232.487.782959747 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_233.488.782974239 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_235.490.783003649 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_236.491.783017493 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_237.492.783029493 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_11/thread_1_seq_238.493.783037947 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_12 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_241.496.783079443 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_242.497.783094461 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_243.498.783107347 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_244.499.783115989 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_245.500.783127947 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_239.494.783050407 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_12/thread_1_seq_240.495.783064855 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_13 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_246.501.783140431 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_248.503.783169977 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_250.505.783198017 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_249.504.783184743 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_251.506.783202487 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_13/thread_1_seq_247.502.783154945 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_14 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_252.507.783216013 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_258.513.783291657 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_257.512.783288043 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_256.511.783274741 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_255.510.783260155 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_254.509.783245049 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_14/thread_1_seq_253.508.783230455 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_15 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_259.514.783305187 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_265.520.783384003 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_264.519.783375467 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_263.518.783363099 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_262.517.783349227 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_261.516.783334125 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_15/thread_1_seq_260.515.783319525 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_16 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_266.521.783396053 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_271.526.783461963 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_270.525.783453613 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_269.524.783440243 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_268.523.783425215 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_16/thread_1_seq_267.522.783410647 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_17 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_272.527.783475217 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_278.533.783550845 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_277.532.783547233 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_276.531.783534419 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_275.530.783519445 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_274.529.783504343 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_17/thread_1_seq_273.528.783489747 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_18 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_279.534.783563851 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_285.540.783637349 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_284.539.783633745 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_283.538.783622269 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_282.537.783608063 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_281.536.783593249 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_18/thread_1_seq_280.535.783578045 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_19 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_286.541.783650947 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_292.547.783728241 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_291.546.783721435 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_290.545.783708695 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_289.544.783694815 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_288.543.783680325 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_19/thread_1_seq_287.542.783665339 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_20 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_293.548.783741609 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_299.554.783820237 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_298.553.783807931 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_297.552.783798547 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_296.551.783785045 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_295.550.783770447 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_20/thread_1_seq_294.549.783756009 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_21 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_304.559.783892045 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_305.560.783901635 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_300.555.783835153 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_301.556.783849617 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_302.557.783864049 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_21/thread_1_seq_303.558.783878645 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_22 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_311.566.783979213 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_312.567.783988127 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_306.561.783907439 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_307.562.783921841 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_308.563.783936643 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_309.564.783951539 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_22/thread_1_seq_310.565.783966311 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_23 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_313.568.783998433 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_319.574.784074627 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_318.573.784069263 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_317.572.784054849 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_316.571.784042699 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_315.570.784027949 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_23/thread_1_seq_314.569.784012747 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_24 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_320.575.784087219 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_326.581.784162863 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_325.580.784159243 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_324.579.784144825 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_323.578.784131439 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_322.577.784116503 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_24/thread_1_seq_321.576.784101847 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_25 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_327.582.784175641 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_330.585.784220439 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_332.587.784247541 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_331.586.784232347 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_333.588.784251197 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_329.584.784205347 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_25/thread_1_seq_328.583.784190655 | Y | N | ARCHIVELOG |
FULL_PATH | S | A | FILE_TYPE |
+RECO/DBASM112/ARCHIVELOG/2012_05_26 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_334.589.784263651 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_339.594.784326041 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_338.593.784321231 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_337.592.784307847 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_336.591.784293203 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_26/thread_1_seq_335.590.784278239 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_27 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_340.595.784339229 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_343.598.784382643 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_345.600.784408835 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_344.599.784396939 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_346.601.784412345 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_342.597.784368053 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_27/thread_1_seq_341.596.784353613 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_28 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_347.602.784425647 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_350.605.784468857 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_352.607.784495233 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_351.606.784483237 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_353.608.784498793 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_349.604.784454413 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_28/thread_1_seq_348.603.784440031 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_29 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_354.609.784512063 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_360.615.784585377 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_359.614.784581861 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_358.613.784569651 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_357.612.784555237 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_356.611.784540823 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_29/thread_1_seq_355.610.784526443 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_30 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_361.616.784598409 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_367.622.784671959 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_366.621.784668419 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_365.620.784656053 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_364.619.784641611 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_363.618.784627231 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_30/thread_1_seq_362.617.784612839 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_31 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_368.623.784684821 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_369.624.784699211 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_371.626.784728027 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_372.627.784742409 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_373.628.784754057 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_374.629.784757555 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_05_31/thread_1_seq_370.625.784713625 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_01 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_381.636.784844407 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_376.631.784785619 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_375.630.784771237 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_377.632.784800059 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_378.633.784814437 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_379.634.784828827 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_01/thread_1_seq_380.635.784840745 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_02 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_382.637.784857645 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_388.643.784930537 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_387.642.784926011 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_386.641.784913643 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_385.640.784900141 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_384.639.784886369 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_02/thread_1_seq_383.638.784872015 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_03 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_389.644.784944035 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_395.650.785017163 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_394.649.785013637 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_393.648.785001631 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_392.647.784987237 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_391.646.784972855 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_03/thread_1_seq_390.645.784958417 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_04 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_396.651.785030435 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_402.657.785103517 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_401.656.785099387 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_400.655.785088011 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_399.654.785073633 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_398.653.785059233 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_04/thread_1_seq_397.652.785044809 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_05 | Y | Y | |
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_403.658.785116823 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_409.664.785190039 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_408.663.785186435 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_407.662.785174463 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_406.661.785160019 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_405.660.785145641 | Y | N | ARCHIVELOG |
+RECO/DBASM112/ARCHIVELOG/2012_06_05/thread_1_seq_404.659.785131249 | Y | N | ARCHIVELOG |
+SPFILE/ASM | Y | Y | |
+SPFILE/ASM/ASMPARAMETERFILE | Y | Y | |
+SPFILE/ASM/ASMPARAMETERFILE/REGISTRY.253.779825791 | Y | N | ASMPARAMETERFILE |
490 rows selected.
SQL>
SQL>
SQL> spool off
Example Output (Script #4):
ASMCMD commands to gather complementary metadata information:
==================================
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 14653 262 0 262 0 N ACFS/
MOUNTED EXTERN N 512 4096 1048576 14653 262 0 262 0 N ACFSDG/
MOUNTED NORMAL N 512 4096 2097152 78152 73888 19538 27175 0 N DATA/
MOUNTED NORMAL N 512 4096 2097152 78152 44300 19538 12381 0 N RECO/
MOUNTED EXTERN N 512 4096 1048576 8887 8828 0 8828 0 N SPFILE/
MOUNTED EXTERN N 512 4096 1048576 14653 14603 0 14603 0 N TESTDG/
MOUNTED EXTERN N 512 4096 1048576 14653 14603 0 14603 0 N TESTDG2/
==================================
Name
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.advm
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.advm
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.advm
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.advm
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
access_control.enabled
access_control.umask
au_size
cell.smart_scan_capable
compatible.asm
compatible.rdbms
disk_repair_time
sector_size
==================================
DB_Name Status Software_Version Compatible_version Instance_Name Disk_Group
asmvol CONNECTED 11.2.0.3.0 11.2.0.3.0 +ASM ACFS
asmvol CONNECTED 11.2.0.3.0 11.2.0.3.0 +ASM ACFSDG
DBASM112 CONNECTED 11.2.0.3.0 11.2.0.0.0 DBASM112 RECO
DBASM112 CONNECTED 11.2.0.3.0 11.2.0.0.0 DBASM112 DATA
==================================
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 14653 262 0 262 0 N ACFS/
MOUNTED EXTERN N 512 4096 1048576 14653 262 0 262 0 N ACFSDG/
MOUNTED NORMAL N 512 4096 2097152 78152 73888 19538 27175 0 N DATA/
MOUNTED NORMAL N 512 4096 2097152 78152 44300 19538 12381 0 N RECO/
MOUNTED EXTERN N 512 4096 1048576 8887 8828 0 8828 0 N SPFILE/
MOUNTED EXTERN N 512 4096 1048576 14653 14603 0 14603 0 N TESTDG/
MOUNTED EXTERN N 512 4096 1048576 14653 14603 0 14603 0 N TESTDG2/
==================================
Path
ORCL:ASMDISKNEW1
ORCL:ASMDISKNEW10
ORCL:ASMDISKNEW11
ORCL:ASMDISKNEW12
ORCL:ASMDISKNEW14
ORCL:ASMDISKNEW2
ORCL:ASMDISKNEW3
ORCL:ASMDISKNEW4
ORCL:ASMDISKNEW5
ORCL:ASMDISKNEW6
ORCL:ASMDISKNEW7
ORCL:ASMDISKNEW8
ORCL:ASMDISKNEW9
==================================
DB_Name Instance_Name Path
DBASM112 DBASM112 +data/dbasm112/datafile/example.261.779841663
DBASM112 DBASM112 +data/dbasm112/datafile/sysaux.257.779841377
DBASM112 DBASM112 +data/dbasm112/datafile/system.256.779841377
DBASM112 DBASM112 +data/dbasm112/datafile/undotbs1.258.779841377
DBASM112 DBASM112 +data/dbasm112/datafile/users.259.779841377
DBASM112 DBASM112 +data/dbasm112/tempfile/temp.260.779841641
DBASM112 DBASM112 +reco/dbasm112/controlfile/current.256.779841609
DBASM112 DBASM112 +reco/dbasm112/onlinelog/group_1.257.779841613
DBASM112 DBASM112 +reco/dbasm112/onlinelog/group_2.258.779841617
DBASM112 DBASM112 +reco/dbasm112/onlinelog/group_3.259.779841623
asmvol +ASM +acfs/STORAGETEAM.256.779907659
asmvol +ASM +acfsdg/EBERNALVOL.256.779910073
==================================
Instance Process OSPID Path
1 oracle@asmlnx2.us.oracle.com (DBW0) 6937 ORCL:ASMDISKNEW1
1 oracle@asmlnx2.us.oracle.com (DBW0) 6937 ORCL:ASMDISKNEW14
1 oracle@asmlnx2.us.oracle.com (DBW0) 6937 ORCL:ASMDISKNEW4
1 oracle@asmlnx2.us.oracle.com (DBW0) 6937 ORCL:ASMDISKNEW5
1 oracle@asmlnx2.us.oracle.com (DBW0) 6937 ORCL:ASMDISKNEW8
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW1
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW14
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW2
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW3
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW4
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW5
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW6
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW7
1 oracle@asmlnx2.us.oracle.com (GMON) 6947 ORCL:ASMDISKNEW8
1 oracle@asmlnx2.us.oracle.com (LGWR) 6939 ORCL:ASMDISKNEW1
1 oracle@asmlnx2.us.oracle.com (LGWR) 6939 ORCL:ASMDISKNEW14
1 oracle@asmlnx2.us.oracle.com (LGWR) 6939 ORCL:ASMDISKNEW4
1 oracle@asmlnx2.us.oracle.com (LGWR) 6939 ORCL:ASMDISKNEW5
1 oracle@asmlnx2.us.oracle.com (LGWR) 6939 ORCL:ASMDISKNEW7
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW1
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW1
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW10
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW10
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW11
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW12
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW14
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW14
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW2
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW2
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW3
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW3
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW4
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW4
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW5
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW5
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW6
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW6
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW7
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW7
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW8
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW8
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW9
1 oracle@asmlnx2.us.oracle.com (RBAL) 6945 ORCL:ASMDISKNEW9
1 oracle@asmlnx2.us.oracle.com (TNS V1-V3) 6953 ORCL:ASMDISKNEW1
==================================
Group_Name Dsk_Name Reads Writes
DATA ASMDISKNEW1 597954560 44995096576
DATA ASMDISKNEW2 578252800 26305249280
DATA ASMDISKNEW3 618582016 39451017216
DATA ASMDISKNEW4 641384448 31851446272
RECO ASMDISKNEW5 9860640768 25827047936
RECO ASMDISKNEW6 28642817024 46931074560
RECO ASMDISKNEW7 16262656512 53971575296
RECO ASMDISKNEW8 52397307904 18746672640
SPFILE ASMDISKNEW14 73194496 7095116800
ACFS ASMDISKNEW9 73355776 7100655616
ACFSDG ASMDISKNEW10 73196032 7097501696
TESTDG ASMDISKNEW11 65769472 6419095552
TESTDG2 ASMDISKNEW12 51470336 5013803008
==================================
[oracle@dmorldb04 ~]$ asmcmd -p dsget
parameter:o/*/*
profile:o/*/*
==================================
Group_Name Dsk_Num State Power
==================================
+SPFILE/asm/asmparameterfile/registry.253.779825791
==================================
Group_Name Group_Num Name
DATA 1 ARCHIVELOG
DATA 1 ASMPARAMETERFILE
DATA 1 AUTOBACKUP
DATA 1 BACKUPSET
DATA 1 CHANGETRACKING
DATA 1 CONTROLFILE
DATA 1 DATAFILE
DATA 1 DATAGUARDCONFIG
DATA 1 DUMPSET
DATA 1 FLASHBACK
DATA 1 FLASHFILE
DATA 1 OCRFILE
DATA 1 ONLINELOG
DATA 1 PARAMETERFILE
DATA 1 TEMPFILE
DATA 1 XTRANSPORT
RECO 2 ARCHIVELOG
RECO 2 ASMPARAMETERFILE
RECO 2 AUTOBACKUP
RECO 2 BACKUPSET
RECO 2 CHANGETRACKING
RECO 2 CONTROLFILE
RECO 2 DATAFILE
RECO 2 DATAGUARDCONFIG
RECO 2 DUMPSET
RECO 2 FLASHBACK
RECO 2 FLASHFILE
RECO 2 OCRFILE
RECO 2 ONLINELOG
RECO 2 PARAMETERFILE
RECO 2 TEMPFILE
RECO 2 XTRANSPORT
SPFILE 3 ARCHIVELOG
SPFILE 3 ASMPARAMETERFILE
SPFILE 3 AUTOBACKUP
SPFILE 3 BACKUPSET
SPFILE 3 CHANGETRACKING
SPFILE 3 CONTROLFILE
SPFILE 3 DATAFILE
SPFILE 3 DATAGUARDCONFIG
SPFILE 3 DUMPSET
SPFILE 3 FLASHBACK
SPFILE 3 FLASHFILE
SPFILE 3 OCRFILE
SPFILE 3 ONLINELOG
SPFILE 3 PARAMETERFILE
SPFILE 3 TEMPFILE
SPFILE 3 XTRANSPORT
ACFS 4 ARCHIVELOG
ACFS 4 ASMPARAMETERFILE
ACFS 4 AUTOBACKUP
ACFS 4 BACKUPSET
ACFS 4 CHANGETRACKING
ACFS 4 CONTROLFILE
ACFS 4 DATAFILE
ACFS 4 DATAGUARDCONFIG
ACFS 4 DUMPSET
ACFS 4 FLASHBACK
ACFS 4 FLASHFILE
ACFS 4 OCRFILE
ACFS 4 ONLINELOG
ACFS 4 PARAMETERFILE
ACFS 4 TEMPFILE
ACFS 4 XTRANSPORT
ACFSDG 5 ARCHIVELOG
ACFSDG 5 ASMPARAMETERFILE
ACFSDG 5 AUTOBACKUP
ACFSDG 5 BACKUPSET
ACFSDG 5 CHANGETRACKING
ACFSDG 5 CONTROLFILE
ACFSDG 5 DATAFILE
ACFSDG 5 DATAGUARDCONFIG
ACFSDG 5 DUMPSET
ACFSDG 5 FLASHBACK
ACFSDG 5 FLASHFILE
ACFSDG 5 OCRFILE
ACFSDG 5 ONLINELOG
ACFSDG 5 PARAMETERFILE
ACFSDG 5 TEMPFILE
ACFSDG 5 XTRANSPORT
TESTDG 6 ARCHIVELOG
TESTDG 6 ASMPARAMETERFILE
TESTDG 6 AUTOBACKUP
TESTDG 6 BACKUPSET
TESTDG 6 CHANGETRACKING
TESTDG 6 CONTROLFILE
TESTDG 6 DATAFILE
TESTDG 6 DATAGUARDCONFIG
TESTDG 6 DUMPSET
TESTDG 6 FLASHBACK
TESTDG 6 FLASHFILE
TESTDG 6 OCRFILE
TESTDG 6 ONLINELOG
TESTDG 6 PARAMETERFILE
TESTDG 6 TEMPFILE
TESTDG 6 XTRANSPORT
TESTDG2 7 ARCHIVELOG
TESTDG2 7 ASMPARAMETERFILE
TESTDG2 7 AUTOBACKUP
TESTDG2 7 BACKUPSET
TESTDG2 7 CHANGETRACKING
TESTDG2 7 CONTROLFILE
TESTDG2 7 DATAFILE
TESTDG2 7 DATAGUARDCONFIG
TESTDG2 7 DUMPSET
TESTDG2 7 FLASHBACK
TESTDG2 7 FLASHFILE
TESTDG2 7 OCRFILE
TESTDG2 7 ONLINELOG
TESTDG2 7 PARAMETERFILE
TESTDG2 7 TEMPFILE
TESTDG2 7 XTRANSPORT
==================================
DG_Name User_Num OS_ID OS_Name
==================================
DG_Name Grp_Name Owner
==================================
Username sysdba sysoper sysasm
SYS TRUE TRUE TRUE
ASMSNMP TRUE FALSE FALSE
==================================
Diskgroup Name: ACFS
Volume Name: STORAGETEAM
Volume Device: /dev/asm/storageteam-215
State: ENABLED
Size (MB): 14336
Resize Unit (MB): 32
Redundancy: UNPROT
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: /u02acfs
Diskgroup Name: ACFSDG
Volume Name: EBERNALVOL
Volume Device: /dev/asm/ebernalvol-168
State: ENABLED
Size (MB): 14336
Resize Unit (MB): 32
Redundancy: UNPROT
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: /u03acfs
==================================
References
NOTE:1092213.1 - ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only).
NOTE:950200.1 - ASM 11gR2: How To Upgrade An ASM Instance To Release 11gR2 (11.2.0.X)?
NOTE:1376731.1 - ASM 11gR2 Grid Infrastructure And RDBMS/Database Installation & Configuration Using ASM Job Role Separation (A Complete Guide).
NOTE:1422517.1 - Reconfiguring & Recreating The 11gR2 Restart/OHAS/SIHA Stack Configuration (Standalone).
NOTE:580153.1 - How To Setup ASM on Linux Using ASMLIB Disks, Raw Devices, Block Devices or UDEV Devices?
NOTE:788273.1 - ASM Upgrade From Release 10g To 11gR1 (11.1).
NOTE:1528148.1 - How To Setup Partitioned Linux Block Devices Using UDEV (Non-ASMLIB) And Assign Them To ASM?
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1107628/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- CRS-2101:The OLR was formatted using version 3 ORACLE單機ASM報錯ORMOracleASM
- 11g asm metadata 備份恢復演練ASM
- 11g asm md_backup md_restoreASMREST
- Oracle OCP 1Z0-053 Q142(ASM Metadata Backup)OracleASM
- ASM Metadata and InternalsASM
- Oracle OCP 1Z0-053 Q116(ASM Metadata Backup)OracleASM
- ASM file metadata operationASM
- ASM Metadata Dump UtilityASM
- Oracle AMDU- ASM Metadata Dump UtilityOracleASM
- flashback version query in oracle 10gOracle 10g
- oracle asm 10gOracleASM
- oracle 11g rman backup scriptOracle
- DUPLICATE (Backup based) DATABASE from non ASM to ASM to different host_382669.1DatabaseASM
- upgrade oracle version 9i to 10gOracle
- [WK-T]ORACLE RAC +ASM Backup and Recovery(四)OracleASM
- [WK-T]ORACLE RAC +ASM Backup and Recovery(三)OracleASM
- 10g 單機使用asmASM
- 10g ASM OEM 相關ASM
- 配置Oracle 10g ASM磁碟Oracle 10gASM
- 10g資料庫例項使用11g asm錯誤問題處理資料庫ASM
- 11g ASM asm_preferred_read_failure_groupASMAI
- ASM(10g/11g)在Normal或High冗餘模式下如何寫資料ASMORM模式
- 11g單機使用asmASM
- oracle 11g ASM問題OracleASM
- ASM 11g New Features - How ASM Disk Resync WorksASM
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- 一篇介紹asm邏輯metadata的好文章ASM
- 【ASM】ASMCMD 之md_backup,md_restore介紹ASMREST
- zt:Different type of RMAN backup compression in 11G
- 11G R2 ASM管理ASM
- 11g rac standby asm---04ASM
- oracle 10g flashback version query 和 flashback transaction query實驗Oracle 10g
- check the OS support version before install the oracle 11gOracle
- 11g rac multipath asmlib ASM asm_open error Operation not permittedASMErrorMIT
- oracle 11g asm自動備份asm磁頭任務OracleASM
- oracle 10g r2 ASM RAC on aixOracle 10gASMAI
- 11g asm Oracle 系統核心修改ASMOracle
- 11g資料庫遷移ASM資料庫ASM