Re: Flashback Recovery Area - Control Files and Online Redo
From: Palooka <nobody_at_nowhere.com>
Date: Tue, 29 Jul 2008 20:21:37 +0100
Message-ID: <55Kjk.40805$3L5.3729@newsfe30.ams2>
>> 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
Anyone?
Date: Tue, 29 Jul 2008 20:21:37 +0100
Message-ID: <55Kjk.40805$3L5.3729@newsfe30.ams2>
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?
Palooka Received on Tue Jul 29 2008 - 14:21:37 CDT