Re: No data is salvable from inside the block

alter database force logging;

will get that for you (on 9i at least). Having a database in archilog mode does not enforce logging (so take a backup after everything you do with nologging basically)

That data is gone I believe

On Tue, 14 Dec 2004 10:42:16 +0100, Francesco.Borgoglio_at_cedacri.it <Francesco.Borgoglio_at_cedacri.it> wrote:
> Hi all.
> This is my problem.
> I have i database in archivelog mode,
> with tables containing lobs.
> After a database recover, the lob data blocks affected by the nologging
> operation are marked corrupted, i know that.
> Here are my questions.
> 1) These data are lost for ever?
> 2) Why after altering database in archivelog mode,
> tables with lobs remain in nologging mode?
> 3) What can i do to have a full archivelog mode,
> i would change the logging mode of all my tables with lobs?
>
> Thank you so much.
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l