Re: Testing Backup

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Thu, 5 Nov 1998 07:31:35 -0800
Message-ID: <Pine.OSF.3.95.981105071952.7942C-100000@gonzo.wolfenet.com>

On Thu, 5 Nov 1998, Konstantin Kivi wrote:
>
> We are implementing new backup strategy for our database.
> Unfortunately our test computer died recently, and we
> cannot test restoration procedure. I wonder, if it
> possible to restore from the backup on the same machine
> under different db_name/sid without affecting original
> database. Thanks in advance.

You can restore the database datafiles to an alternative file location, re-create the controlfile with the new file paths and a new database name, and then you can perform recovery.

For details on re-creating the controlfile and renaming the database, you can look at any of a bunch of old postings on the topic:

http://x11.dejanews.com/getdoc.xp?AN=400647497&CONTEXT=910279781.889848034&hitnum=12

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Thu Nov 05 1998 - 09:31:35 CST