| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Block Corruption from SQL
Hum logical or physical? My guess from looking at the trace file is that it
is a logical corruption door to the actual (likely) crash of the oracle
executable. I am going to suggest to the guys running this one that they
relink to begin with, saw that one in metalink. Also going to plead that we
go ahead and upgrade to 8.1.7.x, so far we haven't had time or been able to
due to Peoplesoft support issues. We are taking weekly cold backups and
nightly exports on this database. It is just one of the databases being
used for a conversion so not a production level database. I think we are
going to have to open an iTar on this one. Just want to see if anyone knew
of anything obvious on this before I do anything else.
Thanks,
Ethan
-----Original Message-----
Sent: Wednesday, March 13, 2002 9:04 PM
To: Multiple recipients of list ORACLE-L
Okay, is it a logical or a physical corruption problem? Any disk errors this time? Do you have a backup from before the corruption occurred?
Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu
-----Original Message-----
Sent: Wednesday, March 13, 2002 2:25 PM
To: Multiple recipients of list ORACLE-L
Anyone seen this one...
I have a user running SQL against a database, she keeps getting disconnected. After the 3'rd time we get a block corruption error. I was actually getting disconnected from a database yesterday while re-running catproc.sql. The db was hosed and so was soem disk so we decided to rebuild since it was not previously under our control, I ignored it for the time being. This is a completey different database and server (8.1.6 on Sun). I think she was running SQL*Plus on her client.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: Ethan.Post_at_ps.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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 Thu Mar 14 2002 - 00:48:21 CST
 |
 |