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

Home -> Community -> Usenet -> c.d.o.misc -> Re: I need to move oracle database from one to another server

Re: I need to move oracle database from one to another server

From: marqzik <marqzik_at_wp.pl>
Date: Fri, 08 Oct 2004 08:17:21 GMT
Message-ID: <l2s9d.27238$k4.527961@news1.nokia.com>


> On the old server issue (prior to copying anything)
> alter database backup control file to trace
> This will result in a .trc file in your user_dump_dest directory
> now shutdown immediate the old database
> copy database files, redolog files and init.ora to new server.
> Now copy trace file to new server.
> Edit the file, adjusting filenames as necessary
> Remove the comments and follow instructions in the file.
>
> This procedure is called 'cloning a database' and it is published in
> the manuals, and in this group.

Ok. Tell me" why it wouldn't work with just moving? Received on Fri Oct 08 2004 - 03:17:21 CDT

Original text of this message

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