Re: recovering from archived redo logs

It is not even necessary to have a trace copy of the control file. All the trace file is, is a piece of SQL. It is perfectly possible, with adequate database documentation to hand, to simply issue the 'create controlfile' command as a regular piece of SQL in SQL Plus or Server Manager. I wouldn't *advise* it, but it can be done!

I once talked someone through doing just that over the telephone. The call took slightly over 2 and half hours, and I count it one of my greatest triumphs!!

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Simon Hume" <simon_at_publishers-market.com> wrote in message
news:J0JO7.1$vI3.72_at_news.ecrc.de...


> Thanks to everyone who replied, which solved my problem.  I want to find

> the absolute minimum required to restore a database.  Seems to me that

many


> people and much that is written (including Oracle manuals) are vague about

> this.  Say I don't have current redo logs, OR current controlfile, I CAN

> recover right up until my last archived log even if I have only an old

> controlfile or even NO controlfile (as long as i have a 'trace' copy with

> which to rebuild it)

>

> In the later case, I had to comment out the RECOVER DATABASE line in the

> trace script, and did the following:

>

> startup nomount

> @/location/of/trace/file/control01.trc (ignore error message ORA-01503:

> CREATE CONTROLFILE failed - it DID create one)

>

> recover database using backup controlfile until cancel

> auto

> alter database open resetlogs

>

> this took me right up to last archived redo log which is what I wanted.

>

> Simon Hume

> Publishers Market AG

> Lindwurmstrasse 129a

> D-80337 München

>