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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 06 Mar 2004 11:49:58 +0100
Message-ID: <m2bj409jlljkf389qeciekgdmkjmlt42t7@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

Received on Sat Mar 06 2004 - 04:49:58 CST