I must add... Using "export" with Oracle WILL WORK. No doubt that's why you claim that this is what you do on live databases and get away with it. But it's horribly sub-optimal and will only work if your transactional volume is not high.
But if you are running say 20,000 continuous transactions per second, the instant you press "Enter" to start your "export" --- goodbye SLA. There are many far better ways of backing up a live Oracle database than "export" :O That's got to be the worst way to do it. On 8/2/07, Orlando Andico <[EMAIL PROTECTED]> wrote: > 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. > -- Orlando Andico Sales Consulting - Emerging Technologies ASEAN Oracle (Philippines) Corporation The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. _________________________________________________ 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
