Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: I need to move oracle database from one to another server
> 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