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

Bob,
Here is how I would do it. I refresh test databases from production databases using this method.
It only works if you want or can live with the entire instance being copied. This requires the database to be in archivelogmode. This method copies the entire instance.
Actual downtime can be 0 minutes., Transfer time can be negligible if automated.

1. Create a backup controlfile to trace.
2. Put all of the tablespaces in hot backup.
3. Copy the files to the second server without taking production out of service..
4. Take all the tablespaces out of hot backup.
5. copy the archive files generated since the hot backup to the second server.
6. use the controlfile to trace and archive logs to recover the transfered database and recover until cancel.

And the key is, the database files can be moved a day or two ahead of time and archive logs applied up til
the time the transition is to occur.

hope it helps,
George.

Bobc wrote:

> 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.
Received on Thu Apr 06 2000 - 00:00:00 CDT