dev db issues

From: O'Donnell, Kevin <Kevin.ODonnell_at_neighborcare.com>
Date: Thu, 13 Oct 2005 15:46:13 -0400
Message-ID: <C1F59AE7E3A0594F8446A79C0DF0195D01D3CAE7@npexc01.corp.neighborcare.com>

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 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

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 Technology Center

Cell: 443-257-3323

Office: 410-534-1959

e-mail: kevin.odonnell_at_neighborcare.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 13 2005 - 14:49:13 CDT