Re: lost redo logs, but have consitent offline backup

From: Chuck Hamilton <chuckh_at_safeaccess.net>
Date: Thu, 12 Nov 1998 15:11:55 GMT
Message-ID: <364af6b9.3758457@news2.axs2000.net>

On Thu, 12 Nov 1998 08:11:57 +0100, Torsten Borchert <T.Borchert_at_DeutschePost.de> wrote:

>Hi,
>
>in a offline backup you must include also all Online-Redologs, so that
>you do not have a backup now. You can now only recreate the database and
>an export file import in it.
>
>Torsten

While it's true that an offline backup should include data files, control files, and redo log files, it's *not* true that you can't recover the database. It can be recovered quite easily.

. Restore the data files and control files.
. Bring the database up to the mount stage with STARTUP MOUNT
. Drop and recreate each logfile group with:
	ALTER DATABASE DROP LOGFILE GROUP x
	ALTER DATABASE ADD LOGFILE GROUP x

. When you get to the current log which is the one it won't let you drop, do ALTER DATABASE CLEAR LOGFILE GROUP. . Open the database with ALTER DATABASE OPEN; --
Chuck Hamilton
chuckh_at_safeaccess.net

But the angel said to them, "Do not be afraid; for I bring you tidings of great joy which shall be for all the people; for today in the city of David there has been born for you a Saviour, who is Christ the Lord." (NASB Luke 2:10-11) Received on Thu Nov 12 1998 - 09:11:55 CST