Re: Move whole database

I do agree with Pete. We do this on regular basis to install test database from a copy of prod database. The steps described as Pete did indeed work, provided source and target computers have the same O/S. The only thing I could add is the path of the control files should be revised within the init parameter file to reflect the new location of these files (control files I mean).

Michel Gauthier
Donohue Inc.

Pete Sharman <psharman_at_us.oracle.com> wrote in message news:385FEE6B.D9275A4E_at_us.oracle.com...
> No, this is definitely not going to work. There are no datafile path
> parameters in the init.ora file.
>
> Provided the servers are binary compatible, and you already have the
> services running and the software installed, you'll need to:
>
> 1. Binary copy the files to their new locations using ftp or similar
> 2. Startup mount the database.
> 3. Alter database rename old_file1, old_file2 ... to new_file1,
> new_file2, ...
> 4. Shutdown
> 5. Backup.
>
> HTH.
>
> Pete
>
> "P. van der Ven" wrote:
>
> > >Hello
> > >
> > >I must transfer a whole database from one to another NTserver with
> > >different Directorys.
> > >How can i do it ?
> >
> > Copy the datafiles and update the paths in init.ora.
> >
> > >Thanks
> > >Immo
> >
> > (I am quite new to DBA-stuff, so please tell me when I am wrong!)
> >
> > Regards,
> > P. van der Ven
> > ---
> > http://contactpven.da.ru/
>
Received on Wed Dec 22 1999 - 00:00:00 CET