Re: Recover database

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 20 Nov 2002 22:37:36 +1000
Message-ID: <cgKC9.80500$g9.226975@newsfeeds.bigpond.com>

"xueyang" <xueyangy_at_singnet.com.sg> wrote in message news:arfn05$6os$1_at_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.

To simplify method 1, 'alter database backup controlfile to trace' first and use the trace file as a template.

Cheers

Richard

>
> 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 - 06:37:36 CST