anyone seen this? (possible controlfile corruption)

Hi.

 

tar already opened - awaiting feedback.

 

W2K Adv Svr Sp4

Oracle 9i R2 Std Ed 9.2.0.4

NTFS 5.0 filesystem

Dell 2650, PERC3/Di controller, writeback caching enabled

qa database, not a huge deal at the moment.

I have a backup controlfile, but would rather not open resetlogs, as there is a remote standby database for this - but then again, that gets refreshed over the weekend anyways.

 

I only found one similar posting on the Oracle Metalink Forums, so this seems to be uncommon.

just wondering if anyone has experienced this.

glad that I haven't seen it yet in production.

so it seems that the battery in the PERC just decided to charge itself in an unscheduled fashion.

 

I'd recommend that if you have any Dell Servers that you periodically re-charge the battery explicitly, rather than wait for it to do it itself, at some inopportune time.

 

Paul

 

 

********************* ATTENTION: ********************
 The controlfile header block returned by the OS
 has a sequence number that is too old.
 The controlfile might be corrupted.
 PLEASE DO NOT ATTEMPT TO START UP THE INSTANCE
 without following the steps below.
 RE-STARTING THE INSTANCE CAN CAUSE SERIOUS DAMAGE
 TO THE DATABASE, if the controlfile is truly corrupted.
 In order to re-start the instance safely,
 please do the following:
 (1) Save all copies of the controlfile for later
     analysis and contact your OS vendor and Oracle support.
 (2) Mount the instance and issue:
     ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
 (3) Unmount the instance.
 (4) Use the script in the trace file to
     RE-CREATE THE CONTROLFILE and open the database.
*****************************************************
kccchb_6: Controlfile sequence number mismatch !
SGA Seq: 198992 lseqno: 198991 lfileno: 0 hseqno: 198991
hfileno : 0

 

 

Event Type: Error
Event Source: afamgt
Event Category: None
Event ID: 1
Date:  12/4/2003
Time:  6:37:14 PM
User:  N/A
Computer: NY-ORCL-001
Description:
\Device\AFA0 : Battery is Charging 
Data:
0000: 00 00 00 00 02 00 4e 00   ......N.
0008: 00 00 00 00 01 00 07 e0   .......à
0010: 00 00 00 00 00 00 00 00   ........
0018: 00 00 00 00 00 00 00 00   ........
0020: 00 00 00 00 00 00 00 00   ........

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).