Stop complaining.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Monday, December 08, 2003 7:59 PM
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: tanel.poder.003_at_mail.ee
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 - 12:24:25 CST
