Restore and Recover Fuzzy datafiles 2006-05-25 - By Andrey Kriushin
Never heard of "ending block". What version it was then? Mark, could
you, please, clarify?
I've been in the situation with recovery of fuzzy file(s). The customer
made the backups by "split mirror" or something similar, and yes - DB
was suspended before splitting the mirror. Then files from the broken
half of the mirror were copied (not by RMAN) somewhere to form the
"backup". However BEGIN BACKUP was not performed before the split.
Funny thing is that complete recovery was always working for them,
so the problem with fuzziness never arose. Unfortunately when the time
for incomplete recovery came, the customer had a big trouble. I've not
noticed any problems with the "ending blocks". Did I miss something
important? Server version was 9.2.0.4 if I remember correctly.
AFAIK, after opening the database all its online datafiles in read
write tablespaces are in some sense fuzzy. It shows up as "stop scn:
0xffff.ffffffff" in file_hdrs dump (comes from the controlfile record
for the file), and also can be seen as KCVFHOFZ flag set in
kcvfh.kcvfhsta field in the file header block.
There are also additional structs in the file header block with some
other meaning for "fuzzy", named as "Absolute fuzzy scn" and "Recovery
fuzzy scn". Probably somebody on the list could clarify their meaning?
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.
>
>
>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=KOI8-R" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Never heard of "ending block". What version it was then? Mark, could
you, please, clarify?<br>
<br>
I've been in the situation with recovery of fuzzy file(s). The customer
made the backups by "split mirror" or something similar, and yes - DB
was suspended before splitting the mirror. Then files from the broken
half of the mirror were copied (not by RMAN) somewhere to form the
"backup". However BEGIN BACKUP was not performed before the split. <br>
??? Funny thing is that complete recovery was always working for them,
so the problem with fuzziness never arose. Unfortunately when the time
for incomplete recovery came, the customer had a big trouble. I've not
noticed any problems with the "ending blocks". Did I miss something
important? Server version was 9.2.0.4 if I remember correctly.<br>
??? AFAIK, after opening the database all its online datafiles in read
write tablespaces are in some sense fuzzy. It shows up as "stop scn:
0xffff.ffffffff" in file_hdrs dump (comes from the controlfile record
for the file), and also can be seen as KCVFHOFZ flag set in
kcvfh.kcvfhsta field in the file header block.<br>
??? There are also additional structs in the file header block with
some other meaning for "fuzzy", named as "Absolute fuzzy scn" and
"Recovery fuzzy scn". Probably somebody on the list could clarify their
meaning?<br>
<br>
TIA<br>
<br>
- Andrey<br>
<br>
Mark W. Farnham wrote:
<blockquote cite="midKNEIIDHFLNJDHOOCFCDKGEPNIBAA.mwf@(protected)"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 9">
<meta name="Originator" content="Microsoft Word 9">
<link rel="File-List" href="cid:filelist.xml@(protected)">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-reply;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
@(protected) Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1"><span class="EmailStyle15"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><!--[endif]--> <o:p></o:p></span>
</font></span>
<p class="MsoNormal"><span class="EmailStyle15"><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.<o:p></o:p></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font color="navy"
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><!--[if !supportEmptyParas]-->?<!
--[endif]--><o:p></o:p></span></font></span></p>
</div>
</blockquote>
</body>
</html>
|
|
