Re: Moving db to linux
- From: mkb <mkb125@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 26 Feb 2004 13:14:48 -0800 (PST)
Ahh...that's it, and just to make sure, run as root
right ;)
--- Mladen Gogala <mladen@xxxxxxxxxxxxxxx> wrote:
> What you need is a magic wand. On Solaris, it's
> called "rsh".
> The spell goes like this:
> System A, prior to the operation:
> mknod expdat.dmp p
> System B, prior to the operation:
> mknod exp_remote.dmp p
>
> System A, engaging the enemy:
> exp parfile=myexp.par 2>/dev/null &
> dd if=expdat.dmp|rsh dd of=exp_remote.dmp
>
> imp parfile=myimp.par file=exp_remote.dmp
> log=/vmunix
>
>
>
>
> On 02/26/2004 03:01:13 PM, mkb wrote:
> > As an aisde, can you not exp to a pipe on one
> machine
> > and exp from the pipe on the other machine.
> >
> > I remember doing something like this using a
> > combination of pipes, rsh and dd from Sun-to-Sun.
> >
> > Any ideas out there?
> >
> > mohammed
> >
> > --- "Nelson, Allan" <anelson@xxxxxxxx> wrote:
> > > Thanks for the response. There was a key fact
> > > missing from what I told you, sorry. The HP
> > > database is in a computer room connected by a
> pair
> > > of T1's to our computer room. With an aggregate
> > > throughput orf 3.08 Mb / sec. I had thought
> that
> > > any sort of sql copy or ctas type solution would
> be
> > > out because of the bandwidth requirements.
> > >
> > > Sorry again,
> > > Allan
> > >
> > > -----Original Message-----
> > > From: oracle-l-bounce@xxxxxxxxxxxxx
> > > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
> Of
> > > Tanel P?der
> > > Sent: Thursday, February 26, 2004 1:39 AM
> > > To: oracle-l@xxxxxxxxxxxxx
> > > Subject: Re: Moving db to linux
> > >
> > >
> > > Sorry, I didn't see the HP-UX part in beginning
> of
> > > your mail.
> > > Yep, you have to go with exp-imp for changing
> > > platforms.
> > >
> > > I'd go with exp-imp with rows=n indexes=n
> > > constraints=n and transfer all data over dblink.
> > > After which I'd run modified create index
> statements
> > > on tables followed by imp constraints=y.
> > >
> > > Here's a simple query for generating insert
> > > commands over database link (you might want to
> > > remove parallel hint and use several serial
> inserts
> > > instead):
> > >
> > >
> > > set linesize 300
> > >
> > > set pagesize 0
> > >
> > > set feedback off
> > >
> > > set trimspool on
> > >
> > >
> > >
> > > spool /tmp/apps_insert.sql
> > >
> > >
> > >
> > > prompt alter session enable parallel dml;;
> > >
> > >
> > >
> > > select 'insert /*+ APPEND PARALLEL(' ||
> table_name
> > > || ',4) NOLOGGING */ into '
> > >
> > > || owner || '.' || table_name
> > >
> > > || ' select * from ' || owner || '.' ||
> > > table_name || '@dblink;'
> > >
> > > from dba_tables
> > >
> > > where owner in ('AP', 'APPLSYS', 'APPS', 'AR',
> > > 'GL', 'JE')
> > >
> > > order by owner;
> > >
> > >
> > >
> > > spool off
> > >
> > > exit
> > >
> > >
> > > Tanel.
> > >
> > >
> > > ----- Original Message -----
> > > From: Tanel P?der
> <mailto:tanel.poder.003@xxxxxxx>
> > >
> > > To: oracle-l@xxxxxxxxxxxxx
> > > Sent: Thursday, February 26, 2004 9:28 AM
> > > Subject: Re: Moving db to linux
> > >
> > > Hi
> > >
> > > Who told you you have to use exp-imp for that?
> > > Since the platform remains the same, you can
> use
> > > regular migration path to go from 8i to 9i.
> > >
> > > Tanel.
> > >
> > >
> > > ----- Original Message -----
> > > From: Nelson, Allan <mailto:anelson@xxxxxxxx>
>
> > > To: oracle-l@xxxxxxxxxxxxx
> > > Sent: Wednesday, February 25, 2004 7:22 PM
> > > Subject: Moving db to linux
> > >
> > >
> > > Im, going to be moving a 220 GB 8.1.7.4
> database
> > > from HP-UX to Red Hat AS 3.0 running 9.2.0.4.0.
> I'm
> > > told that we have to use export/import to get
> that
> > > job done. I plan to work through pipes and use
> > > split to keep the file sizes to 2 GB or less to
> > > aviod large file issues between the platforms.
> Does
> > > anyone know of other issues that may trip me up?
>
> > >
> > > Thanks In Advance
> > >
> > > Allan L. Nelson
> > > Oracle DBA
> > > M-I L.L.C.
> > > (832) 295-2238 office
> > > (832) 351-4180 fax
> > > anelson@xxxxxxxx <mailto:anelson@xxxxxxxx
> > > <mailto:anelson@xxxxxxxx> >
> > >
> > >
> > >
> > >
> > >
> >
>
______________________________________________________________________________
> > > This email is intended solely for the person
> or
> > > entity to which it is addressed and may contain
> > > confidential and/or privileged information.
> Copying,
> > > forwarding or distributing this message by
> persons
> > > or entities other than the addressee is
> prohibited.
> > > If you have received this email in error, please
> > > contact the sender immediately and delete the
> > > material from any computer. This email may have
> been
> > > monitored for policy compliance. [021216]
> > >
> > >
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Get better spam protection with Yahoo! Mail.
> > http://antispam.yahoo.com/tools
> >
>
----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
----------------------------------------------------------------
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
