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: 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

Original text of this message

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