Re: Recover database

From: xueyang <xueyangy_at_singnet.com.sg>
Date: Wed, 20 Nov 2002 18:14:54 +0800
Message-ID: <arfn05$6os$1@mawar.singnet.com.sg>

try this:
method 1:
copy all the files needed to the new directory. recreate the controlfile using the new dir in the statement.

method 2:
copy all the files needed to the new directory. mount the database and use alter database rename file .. to update the controlfile

"Charles" <ngcl_at_sf-express.com> wrote in message news:2b68fda7.0211200126.26f1c22b_at_posting.google.com...
> Hi,
>
> I am using Oracle 9i and I have performed an online backup by using
> "ALTER TABLESPACE *** BEGIN BACKUP". I have also backup all the
> controlfiles, archivelogs. And now, I have created a new database
> server and the directory structure is different. How can I restore the
> database to this new server??
>
> THANKS A LOT~!
Received on Wed Nov 20 2002 - 04:14:54 CST