On Fri, 14 Mar 2003, Hagibis Fan wrote: .. > Admittedly i've never implemented raw partitions > but I've heard a lot of stuff from our > office to scare me: > > 1 - replicating a database from one Unix box to > Another by *copying files*---both are open and > LIVE with the database daemons on both running.
NEVER DO THAT!!!! geez. just because you can see the files doesn't mean you can copy them with the database running. the correct way to do a replicate (at least in Oracle) if you don't have hot replication, is to use exp and imp and use a pipe to connect them together (and avoid having a huge temporary dump file). .. > 2 - "Just mount the database by NFS and share the > database from there".... that's a no-no too :P file-locking over NFS is extremely iffy. just because you can see the files doesn't mean you can scr*w around with them. however i was thinking of the instance where the database falls down and can't get up. in which case you can copy the data files to another instance safely, and try to extract the data there. --- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
