Re: Flashback Recovery Area - Control Files and Online Redo

From: Palooka <>
Date: Sat, 26 Jul 2008 14:32:08 +0100
Message-ID: <qHFik.31025$wd5.14567@newsfe17.ams2>

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 V$CONTROLFILE and V$LOGFILE.

Thanks again
Palooka Received on Sat Jul 26 2008 - 08:32:08 CDT

Original text of this message