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: 199
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: Rman backup valid or not
Next Topic: recovery scenario
Goto Forum:

Current Time: Sun Aug 20 10:38:58 CDT 2017

Total time taken to generate the page: 0.07002 seconds