From oracle-l-bounce@freelists.org Thu Oct 13 14:49:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9DJnDQu007972 for ; Thu, 13 Oct 2005 14:49:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9DJn8vX007946 for ; Thu, 13 Oct 2005 14:49:09 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 08E281FE067; Thu, 13 Oct 2005 14:49:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21628-07; Thu, 13 Oct 2005 14:48:59 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6DF451FE063; Thu, 13 Oct 2005 14:48:59 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5D02E.C4D284DB" Subject: dev db issues Date: Thu, 13 Oct 2005 15:46:13 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: dev db issues thread-index: AcXQLsSVnwLw+mDQQgCpfY5r3fl/YQ== From: "O'Donnell, Kevin" To: X-archive-position: 26945 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Kevin.ODonnell@neighborcare.com Precedence: normal Reply-To: Kevin.ODonnell@neighborcare.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00,HTML_70_80, HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5D02E.C4D284DB Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello all, I have a dev db that uses iscsi. The box lost power today and is now complaining about being out of sync with the redo logs =20 ORA-00283: recovery session canceled due to errors ORA-00314: log 2 of thread 1, expected sequence# 9134 doesn't match 9136 ORA-00312: online log 2 thread 1: '/ora_base/oradata/dirx/redo02a.log' =20 SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /ora_base/app/oracle/product/10.1/db/dbs/arch Oldest online log sequence 9133 Current log sequence 9134 =20 I have never seen this in a db. Any suggestions? Could it of been from the power loss? =20 Kevin O'Donnell Sr. Database Administrator Neighborcare Technology Center =20 Cell: 443-257-3323 Office: 410-534-1959 e-mail: kevin.odonnell@neighborcare.com=20 =20 ------_=_NextPart_001_01C5D02E.C4D284DB Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello all, I have a dev db that uses iscsi. The box = lost power today and is now complaining about being out of sync with the redo = logs

 

ORA-00283: recovery session canceled due to = errors

ORA-00314: log 2 of thread 1, expected sequence# = 9134 doesn't match 9136

ORA-00312: online log 2 thread 1: '/ora_base/oradata/dirx/redo02a.log'

 

SQL> archive log = list;

Database log = mode           &nb= sp;  No Archive Mode

Automatic = archival           = ;  Disabled

Archive = destination          &n= bsp; /ora_base/app/oracle/product/10.1/db/dbs/arch

Oldest online log sequence     = 9133

Current log = sequence           = 9134

 

I have never seen this in a db. Any suggestions? = Could it of been from the power loss?

 

Kevin O’Donnell

Sr. Database = Administrator

Neighborcare<= /st1:PlaceName> Technology Center

 

Cell: 443-257-3323

Office: 410-534-1959

e-mail: kevin.odonnell@neighborcare.com =

 

------_=_NextPart_001_01C5D02E.C4D284DB-- -- http://www.freelists.org/webpage/oracle-l