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

Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import oracle 10g db to another machine

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

From: Godzilla <godzillaismad_at_gmail.com>
Date: 27 Nov 2006 23:03:01 -0800
Message-ID: <1164697381.865725.323060@14g2000cws.googlegroups.com>

EscVector wrote:
> Godzilla wrote:
> > EscVector wrote:
> > > Godzilla wrote:
> > > > EscVector wrote:
> > > > > Godzilla wrote:
> > > > > > Hello,
> > > > > >
> > > > > > That's just one pointer for database copying I've found over the
> > > > > > internet...
> > > > > >
> > > > > > http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/double-migration-90998#
> > > > > >
> > > > > >
> > > > > > I've come across RMAN but, correct me if i'm wrong, that requires the
> > > > > > db to be in archivelog mode. I have limited experience with Oracle in a
> > > > > > very short timeframe, and am curious of whether there's an easy way...
> > > > > >
> > > > > > Would you be able to point me to an area where I can learn more about
> > > > > > RMAN?
> > > > > >
> > > > > > Thanks again.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > DA Morgan wrote:
> > > > > > > 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.
> > > > > > >
> > > > > > > Perhaps because you are using the wrong tool. Why would you choose
> > > > > > > EXPORT/IMPORT if the point is to clone the database? And why on earth
> > > > > > > ORADIM? What pointed you in that direction?
> > > > > > >
> > > > > > > Oracle is Oracle. It is not a generic clone of some other product
> > > > > > > and it has capabilities not shared by the others therefore it is
> > > > > > > different. I'd suggest you look at RMAN for starters. And if you
> > > > > > > provide additional information we can no doubt help you with anything
> > > > > > > RMAN can't do that you require.
> > > > > > > --
> > > > > > > Daniel A. Morgan
> > > > > > > University of Washington
> > > > > > > damorgan_at_x.washington.edu
> > > > > > > (replace x with u to respond)
> > > > > > > Puget Sound Oracle Users Group
> > > > > > > www.psoug.org
> > > > >
> > > > > You don't have to be in ArchiveLog mode. If not in Archivelog mode,
> > > > > the database must only be MOUNTED. RMAN is fine this way.
> > > >
> > > > Hi EscVector,
> > > >
> > > > I tried that, it splits out an error... 'close connection' error
> > > > message in the clone database page. Any idea?
> > >
> > > Yes, Revenge of the Clones..... Don't use the clone. it's overkill.
> > > For learning good, getting something done right now, bad. Could be a
> > > number of issues, but patch level jumps to mind. Make sure you don't
> > > have target and destination reversed...
> > >
> > > Get yourself the 9i rman book. Yes, 9i, but it works just fine for
> > > 10g.
> > > http://www.bookpool.com/sm/0072226625
> > > The TTS convert stuff is missing but that is online in oracle docs.
> > > The convert feature is great, I frequently move tablespaces containing
> > > performance data from bitendian 64bit aix to littleendian 32bit winxp
> > > for analysis. Rman is really good for this.
> >
> > Thanks EscVector for your help... I will look deep into it... At this
> > moment, I'm fed up with the rman, cloning... I need to get this thing
> > working by tomorrow and I have done a schema rebuild on the new machine
> > and just import the data from the exported data from the old oracle
> > server... :(
> >
> > Also, sorry for the double posting...

>

> I missed that you are imp/exp the stuff. You could simple copy the
> datafiles and rename them if you can take original database down or
> have previous backup. This would avoid any logical data errors. It's
> very simple. Depending on disk speed, very quick too.

Hello EscVector,

I've found a problem with my method, i.e. straight copy and paste to the new machine, is that the connect string is still set to the old machine name. It's not a problem if the old and new machines are having the same name, it's not the case here... so I have to do it the right way... I am using export data method now...

Is it ok for you to tell me how you would transport a db from one machine to another? Want the db + data as well... Is it something very hard to do in Oracle? Received on Tue Nov 28 2006 - 01:03:01 CST

Original text of this message

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