Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Testing Backup
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