Re: Copying Oracle data files

2004-11-12 Thread Dan Pritts
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 > fil

Re: Copying Oracle data files

2004-11-11 Thread Paul Slootman
On Wed 10 Nov 2004, Guilhem Bichot wrote: > > What MySQL or Oracle can bear is if your copy is instant. On Linux > there is LVM for that: you create the LVM snapshot, rsync files, > discard the snapshot. It does work. Here's an intro to LVM: It's also advisable to put oracle into "backup mode" be

Re: Copying Oracle data files

2004-11-10 Thread Guilhem Bichot
Hello, On Wed, Nov 10, 2004 at 12:00:37PM +, [EMAIL PROTECTED] wrote: > Can I copy an Oracle database by just copying that Oracle Database > datafiles and moving them to another server with oracle? If > possible can one back up a database using this same method. If I try to continue Jason's

Re: Copying Oracle data files

2004-11-10 Thread Alessandro Ranellucci
On 10-11-2004 at 23:25, Jason Haar wrote: >With MySQL servers, I just do plain old "mysqldump" and rsync the >output file. Guaranteed consistent :-) Well, actually mysqlhotcopy provides more consistency and better performances. Raccomended to everybody. :-) - Alessandro -- To unsubscribe

Re: Copying Oracle data files

2004-11-10 Thread Jason Haar
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 possible can one back up a database using this same method. Why don't you try it and see? I don't think it'll work reliably. As you are running Ora