Re: Flashback Recovery Area - Control Files and Online Redo
From: Palooka <nobody_at_nowhere.com>
Date: Wed, 30 Jul 2008 23:33:29 +0100
Message-ID: <W_5kk.87331$Eo3.67124@newsfe14.ams2>
>> 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?
Date: Wed, 30 Jul 2008 23:33:29 +0100
Message-ID: <W_5kk.87331$Eo3.67124@newsfe14.ams2>
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 Received on Wed Jul 30 2008 - 17:33:29 CDT