recover datafile

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Tue, 17 Oct 2000 11:19:27 -0700 (PDT)
Message-Id: <10652.119532@fatcity.com>

--0-8936987-971806767=:11159
Content-Type: text/plain; charset=us-ascii

I've got a datafile that was offlined automatically about 3 months ago and I never knew about it until the other day. I don't have the archived logs going back far enough to recover the datafile. Does anyone know of a way to get it back online apart from paying Oracle a $10,000 ransom to come on site and run their utility? The data in the tablespace hasn't been updated and if I can somehow extract it, I can recreate and reload the one table that's in the affected tablespace.

I've tried creating a clone database with just the system tablespace and the one in question to no avail. When I run "recover database until cancel" and cancel it immediately, it says that the recovery was succesful but that an "alter database open resetlogs" would produce an error on the system tablespace, which of course it does. The error is that the system datafile requires further recovery.

Any ideas?

---

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. --0-8936987-971806767=:11159
Content-Type: text/html; charset=us-ascii

<P>I've got a datafile that was offlined automatically about 3 months ago and I never knew about it until the other day. I don't have the archived logs going back far enough to recover the datafile. Does anyone know of a way to get it back online apart from paying Oracle a $10,000 ransom to come on site and run their utility? The data in the tablespace hasn't been updated and if I can somehow extract it, I can recreate and reload the one table that's in the affected tablespace.</P>
<P>I've tried creating a clone database with just the system tablespace and the one in question to no avail. When I run "recover database until cancel" and cancel it immediately, it says that the recovery was succesful but that an "alter database open resetlogs" would produce an error on the system tablespace, which of course it does. The error is that the system datafile requires further recovery.</P>
<P>Any ideas?</P><BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://im.yahoo.com/">Yahoo! Messenger</a> - Talk while you surf! It's FREE.
--0-8936987-971806767=:11159-- Received on Tue Oct 17 2000 - 13:19:27 CDT