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

Home -> Community -> Usenet -> c.d.o.misc -> Re: 8.1.7 Recover database until time

Re: 8.1.7 Recover database until time

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 26 Apr 2005 00:06:52 +0200
Message-ID: <rcqq6195a5lm7e9i61ljr0f0v7aq61e5jv@4ax.com>


On Mon, 25 Apr 2005 20:29:49 GMT, dsmcd <dsmcd_at_stopspamdormouse.net> wrote:

>Any suggestions?

Your recover statement doesn't have the using backup controlfile clause.
Consequently, Oracle assumes the SCN in the controlfile is correct, the controlfile is the live controlfile (which it isn't).

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Apr 25 2005 - 17:06:52 CDT

Original text of this message

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