Stop complaining. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > >>> > > >>>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > >> > > >>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
