Re: TRUNCATE and ARCHIVELOG mode

The question remains "What happens to the OTHER database operation (by the same or other users) logs after the direct load with unrecoverable option is done? Will they ALL be invalid after that?". Imagine the loaded data was lated used in UPDATE statements - they probably will not be recovered. How about others? I doubt DBMS will be smart enough to do partial recovery...

Alexei Fox

John P. Higgins wrote:

> From the Oracle Server Utilities Manual:
>
> Specifying RECOVERABLE and UNRECOVERABLE
> The following options apply to direct path loads:
> RECOVERABLE
> Loaded data is logged in the redo log. This option is
> the default for direct path loads. All conventional
> loads are recoverable.
> UNRECOVERABLE
> This option can be specified for a direct path load
> only. Loaded data is not logged, which improves
> load performance. (Other changes to the database
> are logged.) For details, see page 8-9. This option
> cannot be specified with a conventional load.
>
> Specifying UNRECOVERABLE
> Use UNRECOVERABLE to save time and space in the redo log file. An
> UNRECOVERABLE load does not record loaded data in the redo log file,
> instead, it generates invalidation redo. Note that UNRECOVERABLE applies
> to all objects loaded during the load session (both data and index
> segments.)
> Therefore, media recovery is disabled for the loaded table, although
> database changes by other users may continue to be logged.
> Note: Because the data load is not logged, you may want to make a
> backup of the data after loading.
> If media recovery becomes necessary on data that was loaded with the
> UNRECOVERABLE phrase, the data blocks that were loaded are marked as
> logically corrupted.
> To recover the data, drop and re-create the data.
>
> Keith E. Moore wrote:
> >
> > Sorry to hop on to your post, but I have a similar question for the
> > oposite reason:
> >
> > I would also like to know if there is a way to do a SQL*Load which does
> > not create ARCHIVE logs.
Received on Tue Feb 17 1998 - 00:00:00 CST