Re: Flashback Recovery Area - Control Files and Online Redo

From: Palooka <>
Date: Wed, 30 Jul 2008 23:33:29 +0100
Message-ID: <W_5kk.87331$Eo3.67124@newsfe14.ams2>

Palooka wrote:

> Palooka wrote:

>> Palooka wrote:
>>> 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.
>>> Thanks,
>>> Palooka
>> And of course that IS_RECOVERY_DEST_FILE shows the correct value in

> Anyone?
No answer here?

Palooka Received on Wed Jul 30 2008 - 17:33:29 CDT

Original text of this message