Re: I/O error offlines a datafile

Gene, i thought you'd been around a while and know how Mladen works, geez.

joe

Gene Gurevich wrote:

>Mladen,
>
>Thank you very much for your suggestion. I tried
>exactly that - offline the tablespace and restore the
>datafile and - guess what? - it failed because of the
>lock being held against the datafile. That is what
>lead me (and the Oracle support guy) to bounce the
>database. Now I may be less than "half way competent
>member of damanagement" (whatever it means), but
>based on your advice you may be not much better. In
>the future if you can't refrain from isults, please do
>not reply to my posts. I'm asking for help and
>advice, not an insult.
>
>Gene
>
>--- Mladen Gogala <mladen_at_wangtrading.com> wrote:
>
>
>>It's review time, so everything you do is wrong, as
>>a cost
>>saving measure. Any half way competent member of
>>damagement
>>can tell you that.In this particular case though,
>>you could have
>>recovered the datafile online. You should have
>>offlined the
>>tablespace, restored the datafile and recovered the
>>datafile.
>>Restarting the database was not not necessary. Also,
>>one of my
>>religious rituals is to perform a checkpoint after
>>the tablespace
>>has been successfully brought online. The reason is
>>to record the
>>new timestamp to the control file and make sure that
>>all files
>>have the same timestamp (checkpoint process updates
>>file headers
>>during checkpoint).
>>
>>On 12/08/2003 10:39:32 AM, Gene Gurevich wrote:
>>
>>
>>>Hi I got the following error in an alert.log file.
>>>Aparently it was a result of some UNIX issues on a
>>>hdisk, which have been resolved some time later ..
>>>
>>>"Fri Dec 5 18:28:10 2003
>>>KCF: write/open error block=0x3571 online=1
>>> file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf
>>> error=27063 txt: 'IBM AIX RISC System/6000
>>>
>>>
>>Error:
>>
>>
>>>5: I/O error
>>>Additional information: -1
>>>Additional information: 16384'
>>>Automatic datafile offline due to write error on
>>>file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf"
>>>
>>>The file in question had status = 'RECOVER" in the
>>>v$datafile and status = 'AVAIALBLE' in
>>>dba_Data_files. I attempted to restore the file
>>>
>>>
>>after
>>
>>
>>>taking it offline, but couldn't due to a lock. I
>>>
>>>
>>ended
>>
>>
>>>up bouncing the database an recovering this file.
>>>
>>>
>>I'm
>>
>>
>>>wondering whether I should have tired to recover
>>>
>>>
>>this
>>
>>
>>>file first without bouncing the database. If
>>>
>>>
>>anyone
>>
>>
>>>has any experience with that issue, could you let
>>>
>>>
>>me
>>
>>
>>>know whether what I did was wrong or not (and
>>>
>>>
>>why). Is
>>
>>
>>>there a document that I can read on this?
>>>
>>>thanks
>>>
>>>Gene
>>>
>>>
>>>__________________________________
>>>Do you Yahoo!?
>>>Free Pop-Up Blocker - Get it now
>>>http://companion.yahoo.com/
>>>--
>>>Please see the official ORACLE-L FAQ:
>>>
>>>
>>http://www.orafaq.net
>>
>>
>>>--
>>>Author: Gene Gurevich
>>> INET: gurelei_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).
>>
>>
>>Mladen Gogala
>>Oracle DBA
>>
>>
>>
>>Note:
>>This message is for the named person's use only. It
>>may contain confidential, proprietary or legally
>>privileged information. No confidentiality or
>>privilege is waived or lost by any mistransmission.
>>If you receive this message in error, please
>>immediately delete it and all copies of it from your
>>system, destroy any hard copies of it and notify the
>>sender. You must not, directly or indirectly, use,
>>disclose, distribute, print, or copy any part of
>>this message if you are not the intended recipient.
>>Wang Trading LLC and any of its subsidiaries each
>>reserve the right to monitor all e-mail
>>communications through its networks.
>>Any views expressed in this message are those of the
>>individual sender, except where the message states
>>otherwise and the sender is authorized to state them
>>to be the views of any such entity.
>>
>>--
>>Please see the official ORACLE-L FAQ:
>>http://www.orafaq.net
>>--
>>Author: Mladen Gogala
>> INET: mladen_at_wangtrading.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).
>>
>>
>
>
>__________________________________
>Do you Yahoo!?
>Free Pop-Up Blocker - Get it now
>http://companion.yahoo.com/
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: oracle-l_at_oracle-dba.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).