<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi,<br><br>We already have TAF implemented, unfortunately that doesn't help. It suppose TAF might help if the instance was terminated, but that's not happening instead it terminates these individual sessions directly.<br><br>This happens on both nodes during writes to the OCFS2 partition at random times but never at the same time. There is nothing else in the db alert log or crs logs other than what I've included below.<br><br>Thanks,<br>Diane Petersen<br>ServerCare, Inc.<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Karim Alkhayer <kkhayer@gmail.com><br><b><span
style="font-weight: bold;">To:</span></b> Diane Petersen <diane_petersen@yahoo.com>; ocfs2-users@oss.oracle.com<br><b><span style="font-weight: bold;">Sent:</span></b> Monday, April 6, 2009 9:11:06 AM<br><b><span style="font-weight: bold;">Subject:</span></b> RE: [Ocfs2-users] Encountered disk I/O error 19502<br></font><br>
<style>
<!--
_filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
span.HTMLPreformattedChar
{font-family:Consolas;}
span.EmailStyle20
{font-family:"Calibri", "sans-serif";color:#1F497D;}
span.BalloonTextChar
{font-family:"Tahoma", "sans-serif";}
.MsoChpDefault
{font-size:10.0pt;}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
_filtered {}
_filtered {}
_filtered {}
_filtered {}
_filtered {}
_filtered {}
_filtered {}
_filtered {}
_filtered {}
_filtered {}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">Hello Diane,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">I believe that implementing TAF could help a bit in this case, at
least to become transparent to the end users, unless of course, the following
points are blocking in your case:</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"> </span></p>
<p class="MsoListParagraph" style=""><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"><span style="">1.<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">ALTER SESSION statements are lost: </span></p>
<p class="MsoNormal" style="margin-left: 0.5in;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">Statements such as "ALTER
SESSION ..." are not automatically re-issued to the server following a
failover. This can have a significant effect on application behavior. For
example: </span></p>
<p class="MsoNormal" style="background: rgb(219, 229, 241) none repeat scroll 0% 0%; margin-left: 1in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">ALTER SESSION
SET NLS_DATE_FORMAT='YYYY-MM-DD';</span></p>
<p class="MsoNormal" style="background: rgb(219, 229, 241) none repeat scroll 0% 0%; margin-left: 1in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">select sysdate
from dual;</span></p>
<p class="MsoNormal" style="background: rgb(219, 229, 241) none repeat scroll 0% 0%; margin-left: 1in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">Result>
2009-01-31</span></p>
<p class="MsoNormal" style="background: rgb(219, 229, 241) none repeat scroll 0% 0%; margin-left: 1in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><span style="font-size: 10pt; font-family: "Courier New"; color: black;"><< Fail
over the connection >></span></p>
<p class="MsoNormal" style="background: rgb(219, 229, 241) none repeat scroll 0% 0%; margin-left: 1in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">select sysdate
from dual;</span></p>
<p class="MsoNormal" style="background: rgb(219, 229, 241) none repeat scroll 0% 0%; margin-left: 1in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><span style="font-size: 10pt; font-family: "Courier New"; color: black;">Result>
31-JAN-09</span></p>
<p class="MsoListParagraph" style=""><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"><span style="">2.<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">In-progress transactions must be rolled back </span></p>
<p class="MsoListParagraph" style=""><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"><span style="">3.<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">Continuing work on existing cursors may raise an error (eg:
ORA-25401 "cannot continue fetches") </span></p>
<p class="MsoListParagraph" style=""><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"><span style="">4.<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">Failed over selects may take time to re-position (when FAILOVER_TYPE=SELECT)
</span></p>
<p class="MsoListParagraph" style=""><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"><span style="">5.<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">Client awareness of a Failover</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">Can we have an overview of the database setup, nature of
transactions, and parameters?</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">It would also help to examine the troublesome node behavior and
recovery measures.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">Best regards,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: black;">Karim Alkhayer</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">
ocfs2-users-bounces@oss.oracle.com [mailto:ocfs2-users-bounces@oss.oracle.com] <b>On
Behalf Of </b>Diane Petersen<br>
<b>Sent:</b> Monday, April 06, 2009 4:06 PM<br>
<b>To:</b> ocfs2-users@oss.oracle.com<br>
<b>Subject:</b> [Ocfs2-users] Encountered disk I/O error 19502</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">Hi,<br>
<br>
We have a 2-node 11g RAC database running OCFS2 1.4.1-1.el5 with Linux kernel
2.6.18-92.1.17.el5 64-bit. Lately we've been seeing errors on both nodes almost
ever other day. The system administrator has checked the SAN array and said
there are no issues being reported. <br>
<br>
Another part of the problem, it appears the instances alter the service_names
parameter not allowing new connections to the node with the reported error, but
also terminate sessions already connected using the RAC service. The errors all
start with - Encountered disk I/O error 19502 - and contain the following:</p>
<pre>ARC2: Encountered disk I/O error 19502<br>
<br>
</pre><pre> (ifxdb2)<br>
<br>
</pre><pre>Errors in file /u01/app/oracle/diag/rdbms/ifxdb/ifxdb2/trace/ifxdb2_arc2_15414.trc:<br>
<br>
</pre><pre>ORA-19502: write error on file</pre><pre> "/u03/arch/2_1917_656008464.dbf", block number 155649 (block size=512)<br>
<br>
</pre><pre>ORA-27072: File I/O error<br>
<br>
</pre><pre>Linux-x86_64 Error: 5: Input/output error<br>
<br>
</pre><pre>Additional information: 4<br>
<br>
</pre><pre>Additional information: 155649<br>
<br>
</pre><pre>Additional information: -1<br>
<br>
</pre><pre>ORA-19502: write error on file "/u03/arch/2_1917_656008464.dbf", block number 155649 (block size=512)<br>
<br>
</pre><pre>Errors in file /u01/app/oracle/diag/rdbms/ifxdb/ifxdb2/trace/ifxdb2_arc2_15414.trc:<br>
<br>
</pre><pre>ORA-19502: write error on file "/u03/arch/2_1917_656008464.dbf", block number 155649 (block size=512)<br>
<br>
</pre><pre>ORA-27072: File I/O error<br>
<br>
</pre><pre>Linux-x86_64 Error: 5: Input/output error<br>
<br>
</pre><pre>Additional information: 4<br>
<br>
</pre><pre>Additional information: 155649<br>
<br>
</pre><pre>Additional information: -1<br>
<br>
</pre><pre>ORA-19502: write error on file "/u03/arch/2_1917_656008464.dbf", block number 155649 (block size=512)<br>
<br>
</pre><pre>ARC2: I/O error 19502 archiving log 10 to '/u03/arch/2_1917_656008464.dbf'<br>
<br>
</pre><pre>ARCH: Archival stopped, error occurred. Will continue retrying<br>
<br>
</pre><pre>ORACLE</pre><pre> Instance ifxdb2 - Archival Error<br>
<br>
</pre><pre>ORA-16038: log 10 sequence# 1917 cannot be archived<br>
<br>
</pre><pre>ORA-19502: write error on file "", block number (block size=)<br>
<br>
</pre><pre>ORA-00312: online log 10 thread 2: '+REDO1/ifxdb/onlinelog/group_10.265.656605479'<br>
<br>
</pre><pre>Errors in file /u01/app/oracle/diag/rdbms/ifxdb/ifxdb2/trace/ifxdb2_arc2_15414.trc:<br>
<br>
</pre><pre>ORA-16038: log 10 sequence# 1917 cannot be archived<br>
<br>
</pre><pre>ORA-19502: write error on file "", block number (block size=)<br>
<br>
</pre><pre>ORA-00312: online log 10 thread 2: '+REDO1/ifxdb/onlinelog/group_10.265.656605479'<br>
<br>
</pre><pre>Sun Apr 05 15:05:16 2009<br>
<br>
</pre><pre>ALTER SYSTEM SET service_names='<a target="_blank" href="http://ifxdb.gointranet.com">ifxdb.gointranet.com</a>' SCOPE=MEMORY SID='ifxdb2';<br>
<br>
</pre><pre>Immediate Kill Session#: 185, Serial#: 40263<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1274fabc8 OS pid: 13270<br>
<br>
</pre><pre>Immediate Kill Session#: 187, Serial#: 41391<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1274fd710 OS pid: 27697<br>
<br>
</pre><pre>Immediate Kill Session#: 191, Serial#: 40464<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127502da0 OS pid:</pre><pre> 30697<br>
<br>
</pre><pre>Immediate Kill Session#: 195, Serial#: 57362<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127508430 OS pid: 27967<br>
<br>
</pre><pre>Immediate Kill Session#: 196, Serial#: 2028<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x124544048 OS pid: 22900<br>
<br>
</pre><pre>Immediate Kill Session#: 205, Serial#: 17412<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127515c98 OS pid: 20110<br>
<br>
</pre><pre>Immediate Kill Session#: 206, Serial#: 14805<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245518b0 OS pid: 10464<br>
<br>
</pre><pre>Immediate Kill Session#: 207, Serial#: 52184<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1275187e0 OS pid: 19787<br>
<br>
</pre><pre>Immediate Kill Session#: 208, Serial#: 62825<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245543f8 OS pid: 13578<br>
<br>
</pre><pre>Immediate Kill Session#: 213, Serial#: 36907<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1275209b8 OS pid: 31397<br>
<br>
</pre><pre>Immediate Kill Session#: 214, Serial#: 49032<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12455c5d0 OS pid: 2427<br>
<br>
</pre><pre>Immediate Kill Session#: 215, Serial#: 2711<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127523500 OS</pre><pre> pid: 15942<br>
<br>
</pre><pre>Immediate Kill Session#: 216, Serial#: 30060<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12455f118 OS pid: 1217<br>
<br>
</pre><pre>Immediate Kill Session#: 219, Serial#: 35932<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127528b90 OS pid: 27883<br>
<br>
</pre><pre>Immediate Kill Session#: 222, Serial#: 26007<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245672f0 OS pid: 1036<br>
<br>
</pre><pre>Immediate Kill Session#: 223, Serial#: 42462<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12752e220 OS pid: 13726<br>
<br>
</pre><pre>Immediate Kill Session#: 224, Serial#: 33323<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x124569e38 OS pid: 29928<br>
<br>
</pre><pre>Immediate Kill Session#: 225, Serial#: 49752<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127530d68 OS pid: 20147<br>
<br>
</pre><pre>Immediate Kill Session#: 227, Serial#: 34834<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1275338b0 OS pid: 9365<br>
<br>
</pre><pre>Immediate Kill Session#: 230, Serial#: 19879<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x124572010 OS pid: 15791<br>
<br>
</pre><pre>Immediate Kill Session#: 231, Serial#: 16554<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127538f40 </pre><pre> OS pid: 15490<br>
<br>
</pre><pre>Immediate Kill Session#: 233, Serial#: 25251<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12753ba88 OS pid: 6972<br>
<br>
</pre><pre>Immediate Kill Session#: 236, Serial#: 36970<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12457a1e8 OS pid: 12354<br>
<br>
</pre><pre>Immediate Kill Session#: 244, Serial#: 37284<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x124584f08 OS pid: 19290<br>
<br>
</pre><pre>Immediate Kill Session#: 245, Serial#: 55792<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12754be38 OS pid: 19288<br>
<br>
</pre><pre>Immediate Kill Session#: 246, Serial#: 25115<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x124587a50 OS pid: 3111<br>
<br>
</pre><pre>Immediate Kill Session#: 247, Serial#: 6416<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12754e980 OS pid: 19471<br>
<br>
</pre><pre>Immediate Kill Session#: 251, Serial#: 19899<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127554010 OS pid: 21486<br>
<br>
</pre><pre>Immediate Kill Session#: 252, Serial#: 34731<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12458fc28 OS pid: 30540<br>
<br>
</pre><pre>Immediate Kill Session#: 253, Serial#: 32638<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127556b58</pre><pre> OS pid: 5493<br>
<br>
</pre><pre>Immediate Kill Session#: 259, Serial#: 29155<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12755ed30 OS pid: 29463<br>
<br>
</pre><pre>Immediate Kill Session#: 261, Serial#: 14481<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127561878 OS pid: 31054<br>
<br>
</pre><pre>Immediate Kill Session#: 265, Serial#: 37618<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127566f08 OS pid: 868<br>
<br>
</pre><pre>Immediate Kill Session#: 267, Serial#: 42580<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127569a50 OS pid: 16839<br>
<br>
</pre><pre>Immediate Kill Session#: 268, Serial#: 50893<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245a5668 OS pid: 27778<br>
<br>
</pre><pre>Immediate Kill Session#: 274, Serial#: 34459<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245ad840 OS pid: 9808<br>
<br>
</pre><pre>Immediate Kill Session#: 278, Serial#: 59445<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245b2ed0 OS pid: 28434<br>
<br>
</pre><pre>Immediate Kill Session#: 281, Serial#: 50119<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12757c948 OS pid: 12606<br>
<br>
</pre><pre>Immediate Kill Session#: 282, Serial#: 30208<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245b8560</pre><pre> OS pid: 17944<br>
<br>
</pre><pre>Immediate Kill Session#: 285, Serial#: 53580<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127581fd8 OS pid: 16670<br>
<br>
</pre><pre>Immediate Kill Session#: 286, Serial#: 5929<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245bdbf0 OS pid: 20149<br>
<br>
</pre><pre>Immediate Kill Session#: 289, Serial#: 53725<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127587668 OS pid: 14697<br>
<br>
</pre><pre>Immediate Kill Session#: 290, Serial#: 30378<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245c3280 OS pid: 19757<br>
<br>
</pre><pre>Immediate Kill Session#: 293, Serial#: 53710<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x12758ccf8 OS pid: 11096<br>
<br>
</pre><pre>Immediate Kill Session#: 296, Serial#: 34022<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245cb458 OS pid: 10881<br>
<br>
</pre><pre>Immediate Kill Session#: 299, Serial#: 53951<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x127594ed0 OS pid: 1453<br>
<br>
</pre><pre>Immediate Kill Session#: 304, Serial#: 15149<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245d6178 OS pid: 22008<br>
<br>
</pre><pre>Immediate Kill Session#: 308, Serial#: 34245<br>
<br>
</pre><pre>Immediate Kill Session: sess:</pre><pre> 0x1245db808 OS pid: 19156<br>
<br>
</pre><pre>Immediate Kill Session#: 315, Serial#: 15240<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1275aa910 OS pid: 32148<br>
<br>
</pre><pre>Immediate Kill Session#: 317, Serial#: 41792<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1275ad458 OS pid: 15660<br>
<br>
</pre><pre>Immediate Kill Session#: 318, Serial#: 7839<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245e9070 OS pid: 24999<br>
<br>
</pre><pre>Immediate Kill Session#: 321, Serial#: 4422<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1275b2ae8 OS pid: 16028<br>
<br>
</pre><pre>Immediate Kill Session#: 324, Serial#: 6833<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245f1248 OS pid: 21909<br>
<br>
</pre><pre>Immediate Kill Session#: 332, Serial#: 18018<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245fbf68 OS pid: 15819<br>
<br>
</pre><pre>Immediate Kill Session#: 333, Serial#: 37534<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1275c2e98 OS pid: 16433<br>
<br>
</pre><pre>Immediate Kill Session#: 334, Serial#: 50463<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1245feab0 OS pid: 5660<br>
<br>
</pre><pre>Immediate Kill Session#: 335, Serial#: 11994<br>
<br>
</pre><pre>Immediate Kill Session: sess:</pre><pre> 0x1275c59e0 OS pid: 29575<br>
<br>
</pre><pre>Immediate Kill Session#: 336, Serial#: 26542<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1246015f8 OS pid: 31868<br>
<br>
</pre><pre>Immediate Kill Session#: 345, Serial#: 46583<br>
<br>
</pre><pre>Immediate Kill Session: sess: 0x1275d3248 OS pid: 25399<br>
<br>
</pre><pre>Sun Apr 05 15:05:43 2009<br>
<br>
</pre><pre>ARCH: Archival stopped, error occurred. Will continue retrying<br>
<br>
</pre><pre>ORACLE Instance ifxdb2 - Archival Error<br>
<br>
</pre><pre>ORA-16014: log 10 sequence# 1917 not archived, no available destinations<br>
<br>
</pre><pre>ORA-00312: online log 10 thread 2: '+REDO1/ifxdb/onlinelog/group_10.265.656605479'<br>
<br>
</pre><pre>Errors in file /u01/app/oracle/diag/rdbms/ifxdb/ifxdb2/trace/ifxdb2_arc2_15414.trc:<br>
<br>
</pre><pre>ORA-16014: log 10 sequence# 1917 not archived, no available destinations<br>
<br>
</pre><pre>ORA-00312: online log 10 thread 2: '+REDO1/ifxdb/onlinelog/group_10.265.656605479'<br>
<br>
</pre><pre>Sun Apr 05 15:10:52 2009<br>
<br>
</pre><pre>kcrrdmx: Successful archiving of previously failed ORL<br>
<br>
</pre><pre>Archiver process freed from errors. No longer stopped<br>
<br>
</pre><pre>Sun Apr 05 15:10:53</pre><pre> 2009<br>
<br>
</pre><pre>ALTER SYSTEM SET service_names='ifxdb.gointranet.com','ifxserv' SCOPE=MEMORY SID='ifxdb2';</pre>
<p class="MsoNormal" style="margin-bottom: 12pt;">These incidences are all
occurring during archiving (redo logs and database files are using ASM,
archiving and backups are on OCFS2). Even though it usually only lasts a few
minutes, it's very noticeable to the customers because of all the sessions that
are terminated. <br>
<br>
What should we be looking at to resolve this problem?<br>
Please let me know if you have any questions.<br>
<br>
Thanks,<br>
Diane Petersen<br>
ServerCare, Inc.</p>
</div>
</div>
<p class="MsoNormal"> </p>
</div>
</div></div></div><br>
</body></html>