Hi there
According to documentation, DB_RECOVERY_FILE_DEST specifies the default location for the flash recovery area. The flash recovery area contains multiplexed copies of current control files and online redo logs, as well as archived redo logs
And DB_RECOVERY_FILE_DEST_SIZE specifies (in bytes) the hard limit on the total space to be used by target database recovery files created in the flash recovery area.
Here is the info from my database (10gR2, RHEL 64bit - database is in archivelog mode):
log_archive_dest_1 = 'LOCATION=+RECOVERY/'
db_recovery_file_dest='+RECOVERY'
db_recovery_file_dest_size=550GB
-- Total size of archivelog files:
select
SUM(BLOCKS * BLOCK_SIZE)/1024/1024/1024 SIZE_GB
from
V$ARCHIVED_LOG
---> 672.39 GB
If I query the flash recovery area used space, it comes out to be:
SELECT name
, ceil( space_limit / 1024 / 1024) SIZE_M
, ceil( space_used / 1024 / 1024) USED_M
, decode( nvl( space_used, 0),
0, 0
, ceil ( ( space_used / space_limit) * 100) ) PCT_USED
FROM v$recovery_file_dest
ORDER BY name
NAME SIZE_M USED_M PCT_USED
+RECOVERY 563200 8 1
I am confused where are the archivelogs being saved if not in +RECOVERY?
Archivelog files' total current total size if "672.39" but above query tell me that only 8% of the db_recovery_file_dest has been used. So obviously they are either not in +RECOVERY or they are not being accounted for.
I chedk on ASM using asmcmd:
ASMCMD> cd ARCHIVELOG
ASMCMD> ls
2013_09_05/
2013_09_06/
2013_09_09/
2013_09_10/
2013_09_11/
2013_09_12/
ASMCMD>
Whereas the query on V$ARCHIVED_LOG view shows me file names for the month of August as well.
I am sure I am misunderstanding/missing something. I am lost :-(
Please advise!
Thanks in advance!