-
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
-
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).
-
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|