Date: Fri, 11 Dec 2009 10:23:43 -0700
Niall, I'm not sure what you meant by the statement in your post below - could you please elaborate? I would say it's for both recovery and flashback.
Jay, I would say there isn't much point in using an FRA unless you want to use it for Flashback Database, or if you want to use it to segregate backup/archivelog space between multiple databases running on the same file system, or you want to use the "backup recovery area" command in order to manage subsequent backups from disk to tape.
If you haven't already, I'd suggest searching MOS for "flash recovery area" and reading some of the articles on "benefits" and managing space issues, (e.g. 315098.1). Make sure you understand the part about not just clearing files at the OS level - you have to delete them through RMAN, or crosscheck them after deleting at the OS, in order to make the space available for other files again.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
. . . remember the area is about recovery not flashback
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
http://www.freelists.org/webpage/oracle-l Received on Fri Dec 11 2009 - 11:23:43 CST