Actually, I haven't read too much of his posts. Based
on the one he sent to me, I didn't miss much.
Gene
--- Joe Testa <oracle-l_at_oracle-dba.com> wrote:
> 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).
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).
Received on Mon Dec 08 2003 - 11:59:25 CST
