Recovery Issues :) 2006-05-11 - By Bobak, Mark
Hi Paula,
Ok, it sounds like you've successfully recovered. Now, the problem w/
the "missing" rows. This may be where NOLOGGING is relevant. How is
this data loaded? If it was done as INSERT /*+ APPEND */, then the
problem is that, with nologging set, the data was not in the archive
logs you applied, so, the segment will need to be truncated and
reloaded. Ideally, the table is partitioned (is it?) so that you can
truncate and re-load just that partition. Right now, if you do a full
table scan of the segment, your query will eventually hit the logically
corrupt blocks and raise an ORA-26040 (See ORA-26040.ora-code.com). The only way to get rid of those
corrupt blocks is to either drop or truncate the segment containing
them.
For more info on direct load, nologging, and recovery implications, see:
http://dizwell.com/main/index.php?option=com_jd-wiki&Itemid=138&id=direc
tpathoperations
Hope that helps,
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Paula Stankus
Sent: Thursday, May 11, 2006 11:59 AM
To: Christo Kutrovsky
Cc: Oracle-L@(protected)
Subject: Re:Recovery Issues :)
Okay,
We used the following syntax to recover a database
ALTER DATABASE RECOVER DATABASE UNTIL TIME '2006-05-10:09:00:00' USING
BACKUP CONTROLFILE
Some of the archive files said "no longer needed for recovery"
Now, we are told there are rows missing from the night of the 9th (i.e.
the night before).
Help :)!
__ ____ ____ ____ ____ ____ ____
New Yahoo! Messenger with Voice. Call regular phones from your PC
<http://us.rd.yahoo.com/mail_us/taglines/postman5/*http://us.rd.yahoo.co
m/evt=39666/*http://messenger.yahoo.com> and save big.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff size=2>Hi
Paula,</FONT></SPAN></DIV>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff size=2>Ok,
it
sounds like you've successfully recovered. Now, the problem w/ the
"missing" rows. This may be where NOLOGGING is relevant. How is
this
data loaded? If it was done as INSERT /*+ APPEND */, then the problem is
that, with nologging set, the data was not in the archive logs you applied, so,
the segment will need to be truncated and reloaded. Ideally, the table is
partitioned (is it?) so that you can truncate and re-load just that
partition. Right now, if you do a full table scan of the segment, your
query will eventually hit the logically corrupt blocks and raise an
ORA-26040 (See ORA-26040.ora-code.com). The only way to get rid of those corrupt blocks is to either
drop or truncate the segment containing them.</FONT></SPAN></DIV>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff size=2>For
more info on direct load, nologging, and recovery implications, see: <A
href="http://dizwell.com/main/index.php?option=com_jd-wiki&Itemid=138&
;id=directpathoperations">http://dizwell.com/main/index.php?option=com_jd-wiki
&Itemid=138&id=directpathoperations</A></FONT></SPAN></DIV>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff size=2>Hope
that helps,</FONT></SPAN></DIV>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=828540516-11052006><FONT face=Arial color=#0000ff
size=2>-Mark</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><B><FONT face="Century Gothic" size=2>--</FONT></B> <BR><B><FONT
face="Century Gothic" size=2>Mark J. Bobak</FONT></B> <BR><B><FONT
face="Century Gothic" size=2>Senior Oracle Architect</FONT></B> <BR><B><FONT
face="Century Gothic" color=#000000 size=2>P</FONT><FONT face="Century Gothic"
size=2>ro</FONT><FONT face="Century Gothic" color=#ff0000 size=2>Q</FONT><FONT
face="Century Gothic" size=2>uest Information & Learning</FONT></B> </P>
<P><FONT face="Courier New" size=2>For a successful technology, reality must
take precedence over public relations, for Nature cannot be fooled.
--Richard P. Feynman, 1918-1988</FONT></P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Paula
Stankus<BR><B>Sent:</B> Thursday, May 11, 2006 11:59 AM<BR><B>To:</B> Christo
Kutrovsky<BR><B>Cc:</B> Oracle-L@(protected)<BR><B>Subject:</B> Re:Recovery
Issues :)<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Okay,</DIV>
<DIV> </DIV>
<DIV>We used the following syntax to recover a database </DIV>
<DIV> </DIV><FONT size=2>
<DIV>ALTER DATABASE RECOVER DATABASE UNTIL TIME '2006-05-10:09:00:00' USING
BACKUP CONTROLFILE</DIV>
<DIV> </DIV>
<DIV>Some of the archive files said "no longer needed for recovery"</DIV>
<DIV> </DIV>
<DIV>Now, we are told there are rows missing from the night of the 9th (i.e.
the
night before). </DIV>
<DIV> </DIV>
<DIV>Help :)!</DIV></FONT>
<P>
<HR SIZE=1>
New Yahoo! Messenger with Voice. <A
href="http://us.rd.yahoo.com/mail_us/taglines/postman5/*http://us.rd.yahoo.com
/evt=39666/*http://messenger.yahoo.com">Call
regular phones from your PC</A> and save big.</BODY></HTML>
|
|
