remove or Free space on flash recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: remove or Free space on flash recovery

  1. #1
    Join Date
    Aug 2008
    Posts
    116

    remove or Free space on flash recovery

    hi,

    I have allocated 70 G for flash and right now it is only 10 g used but it sys only 34 G is free how can i free the space on this what command i need to run please let me know!

    thanks

  2. #2
    Join Date
    Aug 2009
    Posts
    21
    1)Are backups going to flash recovery area?

    2)Is flashback enabled?

    3)are archivelogs going to flash recovery?

    anyways this is what you could do in space constraint situations.

    If backups are first going to disk then to tape ,backup your flash recovery area to tape(backups configured with tape) then delete backup pieces from disk, if performing disk based backup then delete eveything from flash recovery and let rman know about it(crosscheck archivelog all and crosscheck backup then delete expired)which is compromising with the db recoverabilty,perform backup immediatey,assuming you don't have dataguard running and needs archivelogs(deleted)but you could always do incremental backup to sync up standby(10gR2).

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    How do you know the amount of space being used?
    Here is a query you might want to try.

    Code:
    col name format a40
    
    select
       name,
       to_char(space_limit, '999,999,999,999') as space_limit,
       to_char(space_limit - space_used + space_reclaimable,
       '999,999,999,999') as space_available,
       round((space_used - space_reclaimable)/space_limit * 100, 1) as pct_full
    from
       v$recovery_file_dest;
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width