<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoPlainText">Hi All,<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">I'm trialling the recovery of an x100 database. This means that I copy all the backups, dumps, journals and their vector equivalents to my recovery platform and do the rollforwarddb there. The basic process works well for non x100 enabled
databases and the extension to allow for the extra bits seemed easy enough...<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">However the recovery fails as follows:<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Thu Oct 24 11:12:47 2019 RFP: Preparing for database rollforward on : records <o:p></o:p></p>
<p class="MsoPlainText">Thu Oct 24 11:12:47 2019 RFP: The Archiver must drain any active log records<o:p></o:p></p>
<p class="MsoPlainText"> : from the Log File to the Journal Files before<o:p></o:p></p>
<p class="MsoPlainText"> : Rollforward can proceed. If the Archiver is<o:p></o:p></p>
<p class="MsoPlainText"> : not running this program will not continue.<o:p></o:p></p>
<p class="MsoPlainText"> : If this is the case, exit this program and have<o:p></o:p></p>
<p class="MsoPlainText"> : the appropriate person restart the archiver.<o:p></o:p></p>
<p class="MsoPlainText"><span style="background:yellow;mso-highlight:yellow">Thu Oct 24 11:13:51 2019 RFP: Commit id 14485 not found in journals<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="background:yellow;mso-highlight:yellow">Thu Oct 24 11:13:51 2019 E_DM1380_RFP_INVALID_JNL Rollforwarddb records #c8</span><o:p></o:p></p>
<p class="MsoPlainText">Journals are not valid from checkpoint 8.<o:p></o:p></p>
<p class="MsoPlainText">Journal processing will start at checkpoint 8, however journals taken<o:p></o:p></p>
<p class="MsoPlainText">after checkpoint 8 can not be applied. The final state of the database<o:p></o:p></p>
<p class="MsoPlainText">may not match its state previous to the start of rollforward.<o:p></o:p></p>
<p class="MsoPlainText">Rollforward will not proceed unless the '#f' flag has been specified.<o:p></o:p></p>
<p class="MsoPlainText">The '#f' flag must be used to rollforward using invalid journals.<o:p></o:p></p>
<p class="MsoPlainText">Thu Oct 24 11:13:51 2019 E_DM1307_RFP_RESTORE Error occurred restoring checkpoint.<o:p></o:p></p>
<p class="MsoPlainText">Thu Oct 24 11:13:51 2019 E_DM1301_RFP_ROLL_FORWARD An error occurred that prevents further processing.<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">Sadly there isn’t any extra information available in the errlog.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">The vector journals on the source host for ckp#8 are:<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">805527478 0 -rw------- 1 ingres ingres 0 Oct 20 20:56 ./0/location_map.part<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">805527477 12 -rw------- 1 ingres ingres 9532 Oct 20 20:56 ./0/main.wal.part<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">805527479 4 -rw------- 1 ingres ingres 224 Oct 20 20:56 ./0/map.0<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">288918817 0 -rw------- 1 ingres ingres 0 Oct 22 20:59 ./2/location_map.part<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">288918816 12 -rw------- 1 ingres ingres 9532 Oct 22 20:59 ./2/main.wal.part<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">288918818 4 -rw------- 1 ingres ingres 224 Oct 22 20:59 ./2/map.0<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">24963 0 -rw------- 1 ingres ingres 0 Oct 21 21:00 ./1/location_map.part<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">24962 12 -rw------- 1 ingres ingres 9532 Oct 21 21:00 ./1/main.wal.part<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">24964 4 -rw------- 1 ingres ingres 224 Oct 21 21:00 ./1/map.0<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">537383049 0 -rw------- 1 ingres ingres 0 Oct 23 21:04 ./3/location_map.part<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">537383028 12 -rw------- 1 ingres ingres 9532 Oct 23 21:04 ./3/main.wal.part<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">537383050 4 -rw------- 1 ingres ingres 224 Oct 23 21:04 ./3/map.0<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">537383041 4 -rw------- 1 ingres ingres 448 Oct 23 21:04 ./backup_sets<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">And I have confirmed that all these files are in place on my recovery host.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">What have I missed?<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">Martin Bowes<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
</div>
</body>
</html>