This statement is naive. Using "export" will hold a ton of locks on Oracle and the performance will drop like a rock.
I think I understand/second Andre's point. A lot of the "solutions" being bandied around here are band-aids, not best practices. If your Oracle backup strategy consisted of making dumps and then diff'ing them.. you'd certainly get fired. On 8/2/07, ian sison (mailing list) <[EMAIL PROTECTED]> wrote: .. > > Have said this few days ago, rsync/rsnapshot or tar won't help you > > with backups especially with open files. Good luck backing up Live > > Oracle with rsync or tar. > > Yes it will. All you need is an external script to dump the oracle > database (or portions of it) > into a file, maybe compare it to a previous copy, make a diff, even > compress it, and then let rsync backup the file. Rsnapshot has the > facility to run external scripts before doing a file copy. This is > what I do for backup up live databases. _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
