Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!mcdchg!laidbak!rahil
From: rahil@i88.isc.com (Rahil M. Nizamuddin)
Newsgroups: comp.databases
Subject: Hosed Raw Partition in Oracle.
Message-ID: <1990Mar3.014154.5215@i88.isc.com>
Date: 3 Mar 90 01:41:54 GMT
Sender: usenet@i88.isc.com (Usenet News)
Distribution: usa
Organization: INTERACTIVE Systems Corporation, Naperville, IL
Lines: 28

Context : Pyramid 9815 running Oracle V 5.1.
		  
Problem : A particular disk partition had been allocated as 
		  raw partition for Oracle.
		  A novice system admin tried to create a filesystem 
		  on  a partition that overlapped the above one. 
		  The system crashed when a user tried to create a 
		  file on this new "filesystem";
		  The dbase has been in production for a week since the 
		  above event, with no visible damage. 
		  However, a " select count(*) operation on large 
		  tables yields the following error : 

		  Error at line 1: ORA-0327 diolcb : block/rba pid
		  incorrect after read.

Questions : 
			1. How can we determine what data has been damaged?
			2. What are the recovery procedures ? ( besides 
			   using AIJ files and old backup tapes ) 

Any response will be appreciated. 
Thanks.
--
Rahil M Nizamuddin (800)-LAI-UNIX x253
Interactive Systems Corporation
1901 North Naper Boulevard
Naperville IL 60563.