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 Fri, 08 Oct 2004 07:07:27 GMT, "marqzik" <marqzik_at_wp.pl> wrote:
>Hello. Please take into consideratio a scenarrio...
>on left and hardware the same server on right
>
>SUN server SUN server
>Solaris
>Oracle database
>
>And now.
>Left server is working.
>But I stopped whole server one month ago and did _full_ backup of all
>filesystems.
>After that server and database were operating back for one month.
>Now.
>I have second SUN identical server on the right. I did full restore on this
>server (of all filesystems). But of course database is not up to date.
>I can stop oracle on left and move some files to right server.
>My idea is to do:
>On the right (new server) remove all (old) dbf files, controll files,
>redologs.
>Copy files from the original server (on left) that are has been in "work"
>for recent month to the second server:
>dbf files
>control files
>and redo logs.
>
>Then start new server on right?
>Is it all I have to do? Or I will meet any problems?
>Regards
>
>
No
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.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Oct 08 2004 - 02:43:48 CDT