Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Have ORA-01172 and ORA-01151 on a regular basis

Have ORA-01172 and ORA-01151 on a regular basis

From: Michael Jenc <jenc_at_cas_software.de>
Date: 1997/07/30
Message-ID: <33DF2B8D.1CDB@cas_software.de>#1/1

Hi all,

I have an instance of Oracle 7.3 running on an NT machine. The database files are located on a RAID 5 system.

After creating the database I import tables, so I created datafiles with an initial size of 160MB which should be enough. The import works fine and after that I can even work with the data.
But from time to time I can't connect anymore (via ODBC) to that database instance. When I start instance manager I can see, that the Oracle service is started but the instance has stopped. I then also stop the service and start it again. In svrmgr23 I try to startup the database. The following errors are reported after a while:
ORA-01172
ORA-01151
When I execute the RECOVER DATAFILE 'name_of_datafile_reported' I get the following error messages:
ORA-00283
ORA-00600
If the media would have been corrupted, I think RAID 5 should have reported that or at least further messages should appear in the event viewer.

How can I avoid always restoring data once a week?

Ciao
Michael

-- 
*********************************************************
                    Michael Jenc
                 CAS Software GmbH
                 Karlsruhe, Germany

Replace the '_' with '-' in E-mail address to contact me
Received on Wed Jul 30 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US