| Flashback for Oracle 10g [message #314408] |
Wed, 16 April 2008 11:02  |
preet_kumar
Messages: 204
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.
Thanks
Preet
|
|
|
|
| Re: Flashback for Oracle 10g [message #314415 is a reply to message #314408] |
Wed, 16 April 2008 11:34  |
 |
ebrian
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
