No data is salvable from inside the block

  • From: Francesco.Borgoglio@xxxxxxxxxx
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Tue, 14 Dec 2004 10:42:16 +0100

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. 

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

Other related posts: