Re: Help recover database without redo logs

From: Martin Rapier <m.rapier_at_sheffield.ac.uk>
Date: 2000/05/18
Message-ID: <01bfc0d4$c0ba5560$f811a78f@ad1mer.shef.ac.uk>#1/1

Robert Hovestadt <sherlockhoNOshSPAM_at_yahoo.com.invalid> wrote in article <0f1aefdf.84c7009a_at_usw-ex0106-045.remarq.com>...
> Is anyone out there aware of a way to recover a database when
> the redo logs are not available?

Without the archived redo logs, your only hope is to restore your last cold backup and get the users to type the data in again. Maybe you've got a fairly recent export file??

If you lost the online redo logs, you just need to roll it forward as far as you can and then reset the online redo logs - you will lose a bit of data which the archiver may not have had time to write out, but not huge amounts (depending how big your online logs are!).

There may be some sort of solution by hacking the datafiles directly to reset the system change numbers, but I wouldn't recommend it.

Good luck.
Martin. Received on Thu May 18 2000 - 00:00:00 CDT