Re: Flashback Recovery Area - Control Files and Online Redo

From: Palooka <>
Date: Tue, 29 Jul 2008 20:21:37 +0100
Message-ID: <55Kjk.40805$3L5.3729@newsfe30.ams2>

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 


Palooka Received on Tue Jul 29 2008 - 14:21:37 CDT

Original text of this message