Re: Trace file during RECOVER DATABASE

From: Alexander Chupin <chupin_at_mail.mosbb.com>
Date: Mon, 12 Jul 1999 21:40:42 +0400
Message-ID: <378a2dea.0@ns.mosbb.com>

Hi,

Jurij Modic wrote in message <3789f935.27354875_at_news.siol.net>...

>Obviously part of your dat was loaded using DIRECT option of
>SQL*Loader with UNRECOVERABLE specified in the control file. This
>means that loaded data was not logged in the redo logs. You should
>always perform a backup after the UNRECOVERABLE loading.
>
>Now after the recovery all of your blocks that were loaded
>UNRECOVERABLE are marked as corrupt. The only way to make them
>available is to drop and recreate the involved tables and indexes and
>reload them again.

Thak you for your replay.
It's very strange, because nobody except me use import, sqlload, etc. utilities. But I don't use this utilities in direct mode.

WBR, Alexander. Received on Mon Jul 12 1999 - 12:40:42 CDT