Re: Moving db to linux
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 26 Feb 2004 15:18:58 -0500
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
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
----------------------------------------------------------------
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:
