SEO

#1 (**permalink**) 02-24-2008, 12:52 PM

Hi,
If I use "alter database backup controlfile to trace", suppose I lose
all control files. How can I recover from the trace file?
Thank you

#2 (**permalink**) 02-24-2008, 12:52 PM

Brian Leung <c50342182003@yahoo.com.hk> wrote in
news:d4dl9q$dd0$1@news.hgc.com.hk:

> Hi,
> If I use "alter database backup controlfile to trace", suppose I lose
> all control files. How can I recover from the trace file?
> Thank you
>

By invoking the edited trace file from SQL*Plus.
I suggest that you at least look at the contents of the file;
it might give you a clue or two.

#3 (**permalink**) 02-24-2008, 12:52 PM

On Sat, 23 Apr 2005 21:47:20 +0800, Brian Leung
<c50342182003@yahoo.com.hk> wrote:

>Hi,
>If I use "alter database backup controlfile to trace", suppose I lose
>all control files. How can I recover from the trace file?
>Thank you

It depends on what you understand by 'recover from the trace file'
As the trace file doesn't contain any information with respect to the
SCN, applying the trace file will force you to open the database with
resetlogs. You can't go back in time before resetlogs.

If you would look for one sec at the contents of the trace file, you
will find instructions and a create controlfile command.

--
Sybrand Bakker, Senior Oracle DBA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

backup control file