Hello,
This is a 11.2.0.1 2-node RAC setup with ASM storage.
I am trying to figure out the size of archived logs generated for a day. I used following 2 ways to derive this information but I am not sure which one is correct (and why)
Using ASM Command Line:
ASMCMD [+fra/<DB Id>/archivelog] > du
Used_MB Mirror_used_MB
23365 23365
ASMCMD [+fra/<DB Id>/archivelog] > exit
Using SQL:
[oracle@<DB Id> ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 3 17:44:37 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> set lines 171 pages 999 arrays 151
SQL> select trunc(creation_date), inst_id, sum(bytes)/1024/1024 MB from gv$asm_file where type = 'ARCHIVELOG' group by trunc(creation_date), inst_id ;
TRUNC(CREATION_DAT INST_ID MB
------------------ ---------- ----------
03-MAY-11 1 23051.1655
03-MAY-11 2 23051.1655
Can anybody help?