Re: Flashback Recovery Area - Control Files and Online Redo

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
.

Relevant Pages

  • Re: Flashback Recovery area Full in Oracle 10g
    ... Note that your query shows "reclaimable space" being the same value ... This means that Oracle knows all used space in the ... FRA can be reused, so you don't need any extra steps to reclaim it ... Oracle still expects the log files to be in the flash recovery area, ...
    (comp.databases.oracle.server)
  • Re: Flashback Recovery Area - Control Files and Online Redo
    ... Oracle recommends putting one copy of the control file and one member ... the database creation is done by the ... At that point there is no FRA. ... database backup controlfile to trace; ...
    (comp.databases.oracle.server)
  • Flashback Recovery Area - Control Files and Online Redo
    ... 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. ...
    (comp.databases.oracle.server)
  • Re: Flashback Recovery Area - Control Files and Online Redo
    ... 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. ...
    (comp.databases.oracle.server)
  • Re: Flashback Recovery Area - Control Files and Online Redo
    ... 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. ...
    (comp.databases.oracle.server)