Flashback Recovery Area - Control Files and Online Redo

From: Palooka <nobody_at_nowhere.com>
Date: Sat, 26 Jul 2008 14:25:58 +0100
Message-ID: <EBFik.31024$wd5.30408@newsfe17.ams2> on AIX 5.3

I've searched the Oracle documentation, and Googled, but haven't found quite what I'm looking for. It is more than possible I have missed something, so perhaps some kind soul here has the answer?

Oracle recommends putting one copy of the control file and one member of each redo log group into the FRA. I have seen much about doing so at the time of database creation, but not how to achieve this afterwards.

In our particular case, the database creation is done by the suppliers of the application. At that point there is no FRA.

We have created a FRA, and the archivelogs and RMAN backups are going there. But how do we do the controlfile and online redo moves? Clearly we should do so in such a way such that Oracle 'knows' where they are; i.e. they show up properly in V$FLASH_RECOVERY_AREA_USAGE.

Palooka Received on Sat Jul 26 2008 - 08:25:58 CDT

Original text of this message