backup files location?
Date: Mon, 26 Mar 2012 17:53:38 -0500
Message-ID: <CAHSa0M3WLBzZZFXnVy1GYeC9VyMgpzHnpC-EMyUadU=XnBGBWA_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 26 2012 - 17:53:38 CDT