Re: Flashback Recovery Area - Control Files and Online Redo

From: Palooka <nobody_at_nowhere.com>
Date: Thu, 31 Jul 2008 20:52:57 +0100
Message-ID: <lKokk.99744$8_2.20638@newsfe08.ams2>

joel garry wrote:

> On Jul 30, 3:33 pm, Palooka <nob..._at_nowhere.com> wrote:

>> Palooka wrote:
>>> Palooka wrote:
>>>> 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.
>>> Anyone?
>> No answer here?
>>
>> Palooka

> 
> In EM, click on Administration --> Controlfiles --> backup to trace.
> This creates a file in your udump directory that you can edit to put
> things whereever you feel is best.  The command line version is alter
> database backup controlfile to trace;  Read the tracefile, it tells
> exactly what to do.
> 
> Try the following search at tahiti.oracle.com:
> backup controlfile to trace
> 

Thanks for the response, but unfortunately it doesn't help much. I was looking for an answer which had some relevance to the original question.

Palooka Received on Thu Jul 31 2008 - 14:52:57 CDT