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