ORA:01194 Corrupt datafile error
Date: Tue, 25 Jun 2002 07:54:28 -0400
Message-ID: <3d185887_3_at_corp-goliath.newsgroups.com>
I was doing an upgrade of our database, and suddenly we lost connectivity
with the db and I got an error saying ORA-01034 ORACLE not started, and it
definelty was.
I have no physical backup... This is on our todo list...
Is there a way to recover the database? I have tried a few suggestions but none seem to completely work for me...
I have tried recovering from date, and now get this error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\ORA806\DATABASE\SYS1ORCL.ORA'
It was trying to find an archived log before this that it could not find (and neither could I manually)
What can I do?
Thanks.
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Jun 25 2002 - 13:54:28 CEST