Flashback logs question. Restore points
The FlazJun 17 2010 — edited Jun 17 2010Hi
Oracle 10g 10.2.0.4
I have a couple of flashback questions that I can't find the answers to in the documentation
Firstly, Can I convert a restore point to a guaranteed retore point? Providing of course the logs are available?
Secondly, can I work out if my restore point is still valid?
I have just enabled flashback with a 10GB area for the logs. After 1 day I already have 5GB of logs. I need to monitor this so I can still flashback to the desired restore point
SQL> SELECT FILE_TYPE,PERCENT_SPACE_USED FROM V$FLASH_RECOVERY_AREA_USAGE where FILE_TYPE='FLASHBACKLOG';
FILE_TYPE PERCENT_SPACE_USED
------------ ------------------
FLASHBACKLOG 48.81
Many thanks for any help