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: Incomplete Recovery of tablespace

Re: Incomplete Recovery of tablespace

From: Roman Klesel <rupa_at_noris.de>
Date: Mon, 27 Feb 2006 15:15:37 +0100
Message-ID: <44030989.1010809@noris.de>


drops schrieb:
>
> I read somewhere that you can only make incomplete recoveries of the
> whole database. Is this true?
>

You mean :"You can only make incomplete recoveries of a full restore" ?

True!

Oracle checks the SCN of all data files when opening. If they are not equal, Oracle refuses to open with an error like:

File xy needs recovery!

You can't change this behaviour unless you do really nasty things ...

Greetings Roman Received on Mon Feb 27 2006 - 08:15:37 CST

Original text of this message

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