Re: Moving large amounts of data from one Oracle Server to another

We are doing such thing every night. We shutdown database and then just copy all data files to second server. Then start both databases. Both servers are Sun machines. Main server is Ultra Enterprise 4500 and second one is
Ultra Enterprise 450. You just need to have filesystems with same names as on main server and sufficient space on them to hold data files.

Nightwalker

In article <f8vI4.31524
$Y4.923529_at_news1.rdc1.il.home.com>,
  "MyTwoBits" <nighr_at_hotmail.com> wrote:
> You might want to consider upgrading to Oracle
 8i (8.1.5) soon. There is a
> feature called portable tablespaces. It might
 be faster just to move the
> tablespaces from one server to another.
> My25/c.
>
> "Bobc" <bobchaytor_at_hotmail.com> wrote in message
> news:9vaH4.143011

 $Hq3.3361229_at_news2.rdc1.on.home.com...
> > Here is the situation:
> > There is 10 gb of data on a production server
 (Oracle 7.3.?.?) that I need
> > to move to a second server on a quarterly
 basis (Same version of Oracle).
> > Currently this data is bundled up in a full
 oracle export, sent to the
> > second Unix box, an import is performed and
 then the quarterly processing
> > takes place on the second box. The whole
 process from the start of the
> > export to the end of the import is taking 8-
 10 hours!!! This is way to
> > long. The export processing is taking place
 on a large parallel siemens
 box
> > the import is being done on a smaller siemens
 machine.
> >
> > Does anyone out there have an suggestions on
 a different approach to
 moving
> > this data to the second machine? I am open
 to any and all ideas. I can
> > only assume, since I have not had a chance to
 look at the database tuning
> > issues that both databases are well tuned, if
 you know of any tuning issue
> > specific to import/export I would really like
 to hear about them.
> >
> > One requirement of any suggestion is that it
 can not heavily impact
> > performance on the main production server.
> >
> > If it is not to much trouble, could you email
 me directly.
> >
> > Thanks in advance,
> > Bob.
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 13 2000 - 00:00:00 CDT