Re: Oracle datafile consistent ?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 10 Jan 2000 07:38:34 +0100
Message-ID: <947486408.6117.0.pluto.d4ee154e@news.demon.nl>

The control file.

Hth

--
Sybrand Bakker, Oracle DBA
mkeene <matthew_keeneNOmaSPAM_at_ansett.com.au.invalid> wrote in message news:089f08e0.bba3863e_at_usw-ex0101-004.remarq.com...
> When you try to open a database that contains a datafile in need of
> media recovery you get the message:
>
> ORA-1194 file xxxx needs more recovery to be consistent
>
> My question is how does Oracle know this ? I assume that it's
> comparing the SCN from the datafile header to something else, but I'd
> like to know what that something else is.
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Jan 10 2000 - 00:38:34 CST