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:
Error: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
after5: 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
taking it offline, but couldn't due to a lock. Iended
up bouncing the database an recovering this file.I'm
wondering whether I should have tired to recoverthis
file first without bouncing the database. Ifanyone
has any experience with that issue, could you letme
know whether what I did was wrong or not (andwhy). Is
there a document that I can read on this?http://www.orafaq.net
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.fatcity.com-- Author: Gene Gurevich INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
San Diego, California -- Mailing list andweb hosting services
---------------------------------------------------------------------To REMOVE yourself from this mailing list, send anE-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of'ListGuru') and in
the message BODY, include a line containing: UNSUBORACLE-L
(or the name of mailing list you want to beremoved 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).
