backup files location?
- From: Ram Raman <veeeraman@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Mar 2012 17:53:38 -0500
List,
v10.2. We have a dev db whose backups have been failing with message that
db_recovery_file_dest_size is full. Our location in FLASH group in ASM.
Upon looking into the FLASH diskgroup I see that there are only 2 files
taking about 670Mb:
*
ASMCMD [+FLASH/FDEV/BACKUPSET] > du .
Used_MB Mirror_used_MB
678 678
ASMCMD [+FLASH/FDEV/BACKUPSET] >
ASMCMD [+FLASH/FDEV] > du .
Used_MB Mirror_used_MB
678 678
ASMCMD [+FLASH] > du FDEV
Used_MB Mirror_used_MB
678 678
The archives go to +ARCH, but out there also:
ASMCMD [+ARCH] > du FDEV/
Used_MB Mirror_used_MB
3057 3057
*but the output from rec_file_dest and FRA_Usage are like this:
*
1* SELECT * FROM V$recovery_file_dest
SQL> /
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
--------------- ---------------- ---------------- -----------------
---------------
+FLASH 85,899,345,920 83,370,180,608 0 70
SQL>
*
*1* SELECT * FROM V$flash_recovery_area_usage*
*SQL> /*
*FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES*
*------------ ------------------ ------------------------- ---------------*
*CONTROLFILE 0 0 0*
*ONLINELOG 0 0 0*
*ARCHIVELOG 0 0 0*
*BACKUPPIECE 97.06 0 70*
*IMAGECOPY 0 0 0*
*FLASHBACKLOG 0 0 0*
I am trying to figure out where the 70 files that make up the 97% are
located. I did check in RMAN for location of files with 'list backup' and
'crosscheck' commands. I cannot seem to find the 70 files.. ggrrrr...
Probably a simple thing, but is escaping me :(
Thanks
Ram
--
//www.freelists.org/webpage/oracle-l
Other related posts:
