Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to apply archived redo logfiles on a consistent database

Re: How to apply archived redo logfiles on a consistent database

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 6 Mar 2004 18:25:49 +0100
Message-ID: <404a096e$0$280$626a14ce@news.free.fr>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> a écrit dans le message de news:m2bj409jlljkf389qeciekgdmkjmlt42t7_at_4ax.com...
> On Sat, 6 Mar 2004 10:38:18 +0100, "Michel Cadot"
> <micadot{at}altern{dot}org> wrote:
>
> >I'm afraid i'm not agree with you, the main difference physical backup and
> >dump into trace is that there is no information of the current state and thank
> >for that Oracle can recover after the date of the original database.
>
> You are wrong. You NEVER do a RESETLOGS *Prior* to incomplete
> recovery, as during incomplete recovery (using backup controlfile) the
> SCN information in the controlfile is IGNORED.
> In fact you are putting your systems at risk.
> Where in the documentation does it tell you, you need to perform a
> RESETLOGS prior to INCOMPLETE recovery?
> NOWHERE!!!!!!!!!
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

I never said i'm doing a resetlogs prior to the recovery, never. Sorry if my poor english makes you think i say that. The server manager session i sent shows clearly that i don't do a such thing.

The actions were (in case of lost of control file):

1- restore files (data and control)
2- startup mount
3- backup to trace the old control file
4- shutdown, startup nomout, recreate the control file from the trace file
5- recover database using backup controlfile
6- open reset logs

I never opened the database before final step.

Thanks to you for teaching me that creating a new control file from trace or using a physical backup control file is the same thing as Oracle ignore the SCN information during this kind of recovery. I always used the trace precisely because there is no SCN information in it.

Regards
Michel Cadot Received on Sat Mar 06 2004 - 11:25:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US