backup files location?

From: Ram Raman <veeeraman_at_gmail.com>
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-l
Received on Mon Mar 26 2012 - 17:53:38 CDT

Original text of this message