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. danno -- dan pritts - systems administrator - internet2 734/352-4953 office 734/834-7224 mobile -- To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html
