Home » RDBMS Server » Backup & Recovery » Flashback for Oracle 10g (Oracle 10gR2)
Flashback for Oracle 10g [message #314408] Wed, 16 April 2008 11:02 Go to next message
Messages: 195
Registered: March 2007
Senior Member
How can i know which is the obsolete files in the FRA.
We are using flashback and created few restore points which we also drop after doing a flashback but now we see the Flash recovery area is getting huge so how to know which is obsolete files which can be cleared.
Re: Flashback for Oracle 10g [message #314415 is a reply to message #314408] Wed, 16 April 2008 11:34 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
Flashback logs are handled internally by Oracle. You could decrease the value of DB_RECOVERY_FILE_DEST_SIZE and let Oracle clean out the old files and then set the value back or you can remove any unnecessary archive logs.
Previous Topic: Dual backup strategy, backup to FRA and tape
Next Topic: data not acess
Goto Forum:

Current Time: Tue Oct 25 21:50:09 CDT 2016

Total time taken to generate the page: 0.11377 seconds