Re: Flashback Recovery Area - Control Files and Online Redo
Date: Thu, 31 Jul 2008 14:25:24 -0700 (PDT)
On Jul 31, 12:52 pm, Palooka <nob..._at_nowhere.com> wrote:
> 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.
) To move the controlfile from the old Flash Recovery Area to new one.
Change the location in the parameter CONTROL_FILES to the new location
and restart the instance in NOMOUNT.
RMAN> RESTORE CONTROLFILE FROM 'filename_of_old_control_file';
4) To move the online redo logs. Use the commands to add a a log file stored in
the new Flash Recovery Area and drop the logfile in the old Flash Recovery Area
for each redo log group.
SQL> alter database add logfile size 100M; SQL> alter database drop logfile 'name of the old redo log';
Finding the metalink note that this is pasted from is left as a learning exercise for those who can't search for How to change Flash Recovery Area to a new location on metalink.
-- @home.com is bogus. http://www.wired.com/politics/law/news/2008/07/autoadmitReceived on Thu Jul 31 2008 - 16:25:24 CDT