Flashback Recovery Area - Control Files and Online Redo

Palooka

unread,

Jul 26, 2008, 9:25:58 AM7/26/08

to

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

Palooka

unread,

Jul 26, 2008, 9:32:08 AM7/26/08

to

And of course that IS_RECOVERY_DEST_FILE shows the correct value in
V$CONTROLFILE and V$LOGFILE.

Thanks again
Palooka

Palooka

unread,

Jul 29, 2008, 3:21:37 PM7/29/08

to

Anyone?

Palooka

gazzag

unread,

Jul 30, 2008, 5:57:24 AM7/30/08

to

On 29 Jul, 20:21, Palooka <nob...@nowhere.com> wrote:
>
> Anyone?
>
> Palooka

Have you tried raising a SR with Oracle yet? Even they should be able
to have replied quicker than anyone in this group has done ;)

-g

Palooka

unread,

Jul 30, 2008, 6:33:29 PM7/30/08

to

No answer here?

Palooka

joel garry

unread,

Jul 30, 2008, 8:06:50 PM7/30/08

to

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

Palooka

unread,

Jul 31, 2008, 3:52:57 PM7/31/08

to

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.

Palooka

joel garry

unread,

Jul 31, 2008, 5:25:24 PM7/31/08

to

) 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.

jg
--
@home.com is bogus.

http://www.wired.com/politics/law/news/2008/07/autoadmit

newhorizon

unread,

Aug 4, 2008, 6:57:59 AM8/4/08

to

You can move one of your CFs or add a new redolog to the FRA that
should not be a problem.

BUT

I am not sure if they will show up in the V$FLASH_RECOVERY_AREA_USAGE
query.