Re: Flashback Recovery Area - Control Files and Online Redo

Palooka wrote:
> 10.2.0.4 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