Re: Moving Oracle database from one server to another ...

Abu M Rahman <arahman_at_nko.com> wrote in article <349ACFCA.5E3CF126_at_nko.com>...
> That's the only way...
>
>
> Vjacheslav Saiko wrote:
>
> > Hi All !
> >
> > Is it possible to move existing oracle database from one server to
> > another ?
> > I have development and production servers (some platform - NT) and
> > need to move current database
> > from development to production. I've tried to backup database on
> > first server
> > and restore on second - didn't work ; i've tried to copy all
> > database files -
> > didn't vork; i've tried to create new instance on second server
 with
> > all parameters
> > and files like in source instance and after that replace all files
> > from source database -
> > didn't work.
> > The only way i can do this - export database on first server
 and
> >
> > import on second .
> > May be there is another way ?
> >
> > Thank you !
>
>
>
> --
> -------------------------------------------------------------------
> Abu M Rahman | PHONE: (904) 737-3181 ext. 237
> Database Administrator | FAX : (904) 739-1984
> NKO, Inc. | Email: arahman_at_nko.com
> -------------------------------------------------------------------
>
>
>

If the first server is NT and the second server is NT as well you must be able to create a set of services on the second server (oradim73) and copy the pfile (init.ora), the controlfile, the database files and the redo log files. Make sure that the path mentioned in the init.ora to the controlfile(s) is correct, and make sure the datafiles and redo log files are on the same spot on both servers (or tell Oracle you've moved them with 'alter database rename file x to y'.

Good luck,

gvr. Received on Fri Dec 19 1997 - 00:00:00 CST