Copying Oracle data files

Dan Pritts danno at
Fri Nov 12 21:16:09 GMT 2004

On Wed, Nov 10, 2004 at 11:25:49PM +1300, Jason Haar wrote:
> Tauya Mhangami wrote:
> >Can I copy an Oracle database by just copying that Oracle Database
> >datafiles and moving them to another server with oracle? If

> With MySQL servers, I just do plain old "mysqldump" and rsync the output 
> file. Guaranteed consistent  :-)

I have done something similar with oracle in the past.  I'm not
a DBA, i had the DBA show me the equivalent of mysqldump under oracle.

It worked quite well.  the dump file was quite large (tens of megabytes)
but i was able to sync a day's worth of changes in a couple minutes over
a 33.6 modem connection.

dan pritts - systems administrator - internet2
734/352-4953 office        734/834-7224 mobile

More information about the rsync mailing list