Re: Flashback Recovery Area - Control Files and Online Redo

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

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20080730/news_1b30cell.html