Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving database

Re: Moving database

From: Phillip Tien <tienp_at_wholefoods.com>
Date: Mon, 05 Apr 2004 16:13:57 -0500
Message-ID: <4071CC15.E6702B23@wholefoods.com>


or if you had executed a 'alter database backup controlfile to trace;', you could change the locations of your datafiles by editing this script and recreating your controlfile. And yeah, make sure the database version is the same and relink the pfile in the $ORACLE_HOME/dbs directory (if needed).

DJ wrote:

> "szalas" <gszalach_at_hotmail.com> wrote in message
> news:c4s5b2$d7s$1_at_julia.coi.pw.edu.pl...
> > Hi,
> > I had to reinstall Oracle server. I have all files from old database
> > (including parameter file). What should I do next to restore my database ?
> > Thank in advance
> > Szalas
> >
> >
>
> install Oracle and start it up - makign sure directory structures of the
> database are the same as before

--
Phillip Tien
Database Administrator
Whole Foods Market
Received on Mon Apr 05 2004 - 16:13:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US