Re: Export/Import oracle 10g db to another machine

Godzilla wrote:
> Hello,
>
> I have been doing some research these few days and have kind of find
> what I need to do, that is export and import oracle db to another
> machine by using exp/imp/oradim functions. But using the oradim
> function to create the service, you do not have the web interface that
> is generated when using Database Configuration Assistant to create the
> database.
>
> Having been working with MySQL, MSSQL, Sybase and to lesser extend DB2,
> you can easily transport the database over to another machine, with
> minimal configuration required. What I have done, by copying the other
> db export/import technique, is create the oracle db instance using
> Database Configuration Assistant, then shut down the service via
> services.msc, copy over all the log files, control files and data files
> to the new instance data directory
> (C:\oracle\product\10.2.0\oradata\<instance>\) on the new machine.
> Then, restart the service and woala, the transport worked! Doing this
> you also get the web interface too.
>
> Has anyone done what I just described above? Is this method safe? I
> cannot find any tips and tricks anywhere which recommends you to do
> what I did in Oracle.
>
> Also, why is everything in Oracle seems to be 10x harder?
>
> Thank you.

You don't need an rman clone. Clone can be painful. It is much easier to restore by moving the rman files if device is disk. I like cloning when going directly from tape, but it's overkill if you can take the database down. There are issues regarding where the controlfile or catalog expects rman backup sets to be. This could be annoying if you can't use the same drive letters for disk channels.

I think your original trick using dbca works just fine. The windows services are easy enough to create by hand but why bother. There is nothing wrong with your method as long as you are moving and not cloning. If you need to keep the original running and also need to back up via rman catalog or connect to grid, you'll need to reset the dbid. Again, overkill if I've read your situation correctly.

Either way, if you got it done and the database open, you should be fine.

If you think 10g is harder, wait to you see 11g... :) Received on Tue Nov 28 2006 - 00:15:30 CST