| HOW CAN GET SPACE FROM PERCENT_SPACE_RECLAIMABLE COLUMN OF V$Flash_Recovery_Area_Usage [message #255711] |
Wed, 01 August 2007 09:54  |
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
|
Member |
|
|
sir
i have taken full and incremental backup in oracle 10g using RMAN.
my retention policy is
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
i use
RMAN>DELETE EXPIRED BACKUP
AFTER THAT
RMAN> DELETE EXPIRED ARCHIVELOG ALL
BUT SPACE IN PERCENT_SPACE_RECLAIMABLE COLUMN OF TABLE V$Flash_Recovery_Area_Usage NOT BECOME RELEASE AND EXPIRED ARCHIVE DOES NOT DELETE ;
|
|
|
|
| Re: HOW CAN GET SPACE FROM PERCENT_SPACE_RECLAIMABLE COLUMN OF V$Flash_Recovery_Area_Usage [message #255715 is a reply to message #255711] |
Wed, 01 August 2007 10:11  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Is your FRA is FUll??If yes then its a problem other wise its not.
Before if you manully delete backup or archivelogs from FRA then use CROSScheck prior to delete statement.
| Quote: | Oracle does not delete eligible files from the Flash Recovery Area until the space must be reclaimed for some other purpose. The effect is that files recently moved to tape are often still available on disk for use in recovery. The recovery area can thus serve as a kind of cache for tape. Once the Flash Recovery Area is full, Oracle automatically deletes eligible files to reclaim space in the Flash Recovery Area as needed.
|
http://www.pafumi.net/Flash_Recovery_Area.html
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
