RE: Raid Arrays and Power Loss

Thanks. I'll keep this in mind, if it happens again.

-----Original Message-----
Sent: Tuesday, September 16, 2003 1:55 PM To: Multiple recipients of list ORACLE-L

My Veritas-trained co-worker says they ran into the same situation in the class and fsck was able to find the missing inodes and repair the damage. We were thinking that it could be Solaris not flushing the writes that could be your problem. I was warned about that for HP/UX's syncer during training and am told there's a similar function on Solaris.

I'm just the messenger...

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: MacGregor, Ian A. [mailto:ian_at_SLAC.Stanford.EDU]
> Sent: Tuesday, September 16, 2003 2:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Raid Arrays and Power Loss
>
>
> The Raid Array is a Sun A1000. I'm not sure the vintage,
> but the disks are 18 GB. The Raid array did not lose its
> configuration. The storage is still there. Neither affected
> file system was every empty, but a couple of files were lost.
> One on each file system.
>
> The box is located at one of our interaction regions (IR's).
> some additional information [results truncated]
>
> oracle_at_bbr-oracle $ last reboot
>
> reboot system boot Fri Sep 12 15:32
> reboot system boot Mon Aug 25 14:24
>
> When the
>
> Fri Sep 12 13:32:01 2003
> ORA-00204: error in reading (block 1, # blocks 1) of controlfile
> ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
> ORA-27091: skgfqio: unable to queue I/O
> SVR4 Error: 6: No such device or address
> Additional information: 1
>
> Error occurred the raid box was off. I had thought that the
> unix box had already been rebooted but that turns out to be false.
>
> After the box was rebooted with the raid array on
>
> Fri Sep 12 15:33:08 2003
> > ORA-00202: controlfile: '/u1/oradata/BBRO/BBROcntrl01.ctl'
> > ORA-27037: unable to obtain file status
> > SVR4 Error: 2: No such file or directory
> > Additional information: 3
> > Fri Sep 12 15:33:11 2003
>
> The other files on /u1 were fine. Also concerning
>
> The other error
>
> Fri Sep 12 16:18:58 2003
> > Thread recovery: start rolling forward thread 1
> > Fri Sep 12 16:18:58 2003
> > Errors in file /opt/oracle/admin/BBRO/udump/bbro_ora_1804.trc:
> > ORA-00313: open failed for members of log group 3 of thread 1
> > ORA-00312: online log 3 thread 1: '/u2/oradata/BBRO/redo0301.log'
> > ORA-27037: unable to obtain file status
> > SVR4 Error: 2: No such file or directory
> > Additional information: 3
>
> The other files are /u2 were fine. The files in question
> just disappeared. I know this is not normal and raid boxes
> do not normally lose files, but it's hard to argue against
> the empirical evidence here that they can. It may be that
> either I or the folks down an IR-2 induced the problems. But
> files were indeed lost on two different LUN's.
>
> My current thinking is that the two files were being written
> when the power was turned off on the raid array or there was
> not enough to keep the disks spinning because the UPS had
> been drained. The battery for the cache was reporting low,
> but based on the number of hours it operation. Should it not
> have maintained the cache?
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_SLAC.Stanford.edu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

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