Since you're on different OSs, you don't have many options.

If you have EMC, try doing an SRDF copy.
It's fast and not much work for the DBAs. :)

~Ruth

-----Original Message-----
From: Wayne McCance
[mailto:oracledba-ezmlmshield-x46202625.[Email address protected]
Sent: Friday, September 28, 2007 5:23 PM
To: LazyDBA Discussion
Subject: RE: 500 GIG database refresh?

I'm afraid the only way would be to compress and tar each file system
with
the db files then use rcp to the target file system.

Be sure to remember to take a backup controlfile from the source to edit
on
the target.


Wayne

-----Original Message-----
From: will landstrom
[mailto:oracledba-ezmlmshield-x59213598.[Email address protected]
Sent: 28 September 2007 21:49
To: LazyDBA Discussion
Subject: 500 GIG database refresh?



Hello DBAS. I need to take a 500 GIG 10.2.2 database from server A and
copy
it to server B. 2 ways I am considering (neither are very good)
A) just take a bib export file and import the whole thing (will take a
long
long time to run)
B) use a hotback of the database and recover (very quick but not
plausible
because server B has a file system (AIX) not compatible with server A
(Solaris).

By any chance does anyone have any other suggestions how to do this
efficiently?

Thanks, Will




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page