On 5/26/06, Andrey Kriushin <Andrey.Kriushin@(protected)> wrote: > > It seems, that Mark W. Farnham's reply didn't get into the list, so I'll > quote his valuable response. > > Probably, things have changed in some way at least starting from 9i. Now > there is always an extra block at the beginning of each datafile (so called > "zero" block) with some info about platform, actual file size etc, so the > total file size is BLOCKS+1. > > I've dumped the last block before and after "begin backup", with > checkpoint and log switch - nothing was changed there and the datafile size > was not changed either. > > HTH > > > - Andrey > > Mark W. Farnham wrote: > > All versions I'm aware of, though I haven't dumped the end of a 10g, and > maybe not a 9i, either. > > > > If you create a datafile, you'll probably notice that the size on disk is > at least 1 datablock size larger than you asked for. The very last OS set of > blocks adding up to the database block size is the same as the very first > one, except for a few key values that get resynchronized at checkpoints if I > remember correctly. If I recall correctly one of the values in these blocks > is also whether the tablespace was in backup. Prior to being able to lie to > the database with a command and "end backup" (intended really not for copies > of datafiles, but the current datafiles which cannot be block fractured in > the case that the database crashes while in backup mode), you had to > manually adjust that ending shadow end of the file block or Oracle would > still know something was "wrong" with the file. > > > > This is also the reason why you have to make raw partitions a little > bigger than the datafile you want to create there. I always thought it was > funny (strange, odd sense of funny) that Oracle gave you one block less than > the create size and took up one block more than the create size. > > > > If someone remembers the precise details of which programs update these > blocks and under what conditions, and is free to disclose it, I'd enjoy > reading that as well. > > > > In the case below, if DB writer is suspended for the split and the plex > split operation generates a clean copy (note that that engineering detail is > not necessarily required if the volume manager is only promising that the > plexes remaining associated with the volume are identical, and there is > possibly extra work flushing things at split time), then you're not going to > have fracture blocks. > > > > You get fractured blocks when an OS utility copying OS sectors (usually > 512 bytes) ends a particular read in the middle of an Oracle block and then > the database writer writes the Oracle block before the next OS read starts. > > > > > > Regards, > > > > mwf > > > > -- --Original Message-- -- > *From:* oracle-l-bounce@(protected) [ > mailto:oracle-l-bounce@(protected) <oracle-l-bounce@(protected)>]*On > Behalf Of *Andrey Kriushin > *Sent:* Thursday, May 25, 2006 10:05 AM > *To:* mwf@(protected) > *Cc:* Oracle-L Freelists > *Subject:* Re: Restore and Recover Fuzzy datafiles > > > > > Never heard of "ending block". What version it was then? Mark, could you, > please, clarify? > > [skipped] > > TIA > > - Andrey > > Mark W. Farnham wrote: > > Before you could tell the database to "end" backup, you also had to patch > the beginning and ending blocks of the file (lie to Oracle) so that Oracle > did not consider the file to be "fuzzy," but I doubt you're working with a > vintage of the Oracle software that old. If you are, you'll need some kind > of binary block editor. > >
-- regards,
Sinardy
Hi guys, thanks for the reply here are the result <br> <br> I used _allow_resetlogs_corruption<br> <br> recreate the controlfile<br> <br> open resetlogs<br> <br> now I have ORA-01092 (See ORA-01092.ora-code.com) (search metalink only hit 2 results)<br> <br> is upgraded 9i from 8i on W2K<br> <br> still searching for solution<br> <br> <br> <br> <br><br><div><span class="gmail_quote">On 5/26/06, <b class="gmail_sendername" >Andrey Kriushin</b> <<a href="mailto:Andrey.Kriushin@(protected)">Andrey .Kriushin@(protected)</a>> wrote:</span><blockquote class="gmail_quote" style= "border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding -left: 1ex;"> <div>
<div bgcolor="#ffffff" text="#000000"> It seems, that Mark W. Farnham's reply didn't get into the list, so I'll quote his valuable response.<br> <br> Probably, things have changed in some way at least starting from 9i. Now there is always an extra block at the beginning of each datafile (so called "zero" block) with some info about platform, actual file size etc, so the total file size is BLOCKS+1. <br> <br> I've dumped the last block before and after "begin backup", with checkpoint and log switch - nothing was changed there and the datafile size was not changed either.<br> <br> HTH</div><div><span class="q"><br> <br> - Andrey<br> <br> Mark W. Farnham wrote: </span></div><div><blockquote cite="http://midKNEIIDHFLNJDHOOCFCDKEEAHICAA.mwf @(protected)" type="cite">
<div></div><div><span class="q"> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">All versions I'm aware of, though I haven't dumped the end of a 10g, and maybe not a 9i, either.</span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">If you create a datafile, you'll probably notice that the size on disk is at least 1 datablock size larger than you asked for. The very last OS set of blocks adding up to the database block size is the same as the very first one, except for a few key values that get resynchronized at checkpoints if I remember correctly. If I recall correctly one of the values in these blocks is also whether the tablespace was in backup. Prior to being able to lie to the database with a command and "end backup" (intended really not for copies of datafiles, but the current datafiles which cannot be block fractured in the case that the database crashes while in backup mode), you had to manually adjust that ending shadow end of the file block or Oracle would still know something was "wrong" with the file.</span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">This is also the reason why you have to make raw partitions a little bigger than the datafile you want to create there. I always thought it was funny (strange, odd sense of funny) that Oracle gave you one block less than the create size and took up one block more than the create size.</span></font>< /span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">If someone remembers the precise details of which programs update these blocks and under what conditions, and is free to disclose it, I'd enjoy reading that as well.</span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">In the case below, if DB writer is suspended for the split and the plex split operation generates a clean copy (note that that engineering detail is not necessarily required if the volume manager is only promising that the plexes remaining associated with the volume are identical, and there is possibly extra work flushing things at split time), then you're not going to have fracture blocks.</span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">You get fractured blocks when an OS utility copying OS sectors (usually 512 bytes) ends a particular read in the middle of an Oracle block and then the database writer writes the Oracle block before the next OS read starts.</span>< /font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Regards,</span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">mwf</span></font></span></p> <p><span><font color="#993366" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></span></p> <p style="margin-left: 0.5in;"><font color="black" face="Tahoma" size="2"> <span style="font-size: 10pt; font-family: Tahoma;">-- --Original Message-- --<br> <b><span style="font-weight: bold;">From:</span></b> <a href="mailto:oracle-l-bounce@(protected)" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">oracle-l-bounce@(protected)</a> [<a href="mailto:oracle-l-bounce@(protected)" target="_blank" onclick="return top .js.OpenExtLink(window,event,this)"> mailto:oracle-l-bounce@(protected)</a>]<b><span style="font-weight: bold;">On Behalf Of </span></b>Andrey Kriushin<br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, May 25, 2006 10:05 AM<br> <b><span style="font-weight: bold;">To:</span></b> <a href="mailto:mwf@(protected) .com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mwf @(protected)</a><br> <b><span style="font-weight: bold;">Cc:</span></b> Oracle-L Freelists<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Restore and Recover Fuzzy datafiles</span></font></p> <p style="margin-left: 0.5in;"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p> <p style="margin-left: 0.5in;"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"><br> Never heard of "ending block". What version it was then? Mark, could you, please, clarify?<br> </span></font></p></span></div><div> </div> </blockquote> [skipped]</div><div><span class="q"><br> <blockquote cite="http://midKNEIIDHFLNJDHOOCFCDKEEAHICAA.mwf@(protected)" type= "cite"> <div> <p style="margin-left: 0.5in;"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;">TIA<br> <br> - Andrey<br> <br> Mark W. Farnham wrote: </span></font></p> <p style="margin-right: 0.5in; margin-left: 1in; margin-bottom: 0.0001pt;"> <span><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Before you could tell the database to "end" backup, you also had to patch the beginning and ending blocks of the file (lie to Oracle) so that Oracle did not consider the file to be "fuzzy," but I doubt you're working with a vintage of the Oracle software that old. If you are, you'll need some kind of binary block editor.</span></font></span></p> </div>
