BuddyBackup Forum Homepage
Forum Home Forum Home » BuddyBackup Forum » General
  New Posts New Posts RSS Feed - Oracle Databases?
  FAQ FAQ  Forum Search   Register Register  Login Login

Oracle Databases?

 Post Reply Post Reply
Author
Message
Amber Computers View Drop Down
Ultra Buddy
Ultra Buddy


Joined: 24/June/2011
Location: United Kingdom
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote Amber Computers Quote  Post ReplyReply Direct Link To This Post Topic: Oracle Databases?
    Posted: 05/April/2012 at 7:52pm
Hello,

I have a customer who would like to backup Oracle Databases. Has anyone tried this? Is this recommended?

Regards
Paul
Back to Top
John View Drop Down
Admin Group
Admin Group
Avatar
Head of development

Joined: 02/May/2006
Location: United Kingdom
Status: Offline
Points: 203
Post Options Post Options   Thanks (0) Thanks(0)   Quote John Quote  Post ReplyReply Direct Link To This Post Posted: 15/April/2012 at 3:30pm
It might be possible.

What you probably *don't* want to do is simply backup the Oracle data directory (wherever that is).

Best case is that the files will just be locked and BuddyBackup won't be able to backup. Worst case is that BuddyBackup backs up midway through DB transactions.

Backing up databases is tricky: almost always you need to actually engage with the software to tell it that a backup is about to happen (so it can finish transactions and flush data to disk etc).

The best way to do this is to use the software that comes with your database to regularly create a backup as a file which you save to a folder, e.g. every night. Then, backup that folder with BuddyBackup.

We do exactly this with our MySQL database: we setup a scheduled backup with the MySQL admin UI which runs nightly and saves the backup to a folder. This folder is backed up by BuddyBackup as normal.

You don't get "live" backup of the database, but then that wouldn't be practical with BuddyBackup.

John
Back to Top
Amber Computers View Drop Down
Ultra Buddy
Ultra Buddy


Joined: 24/June/2011
Location: United Kingdom
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote Amber Computers Quote  Post ReplyReply Direct Link To This Post Posted: 27/April/2012 at 8:09pm
Hello,

Thank you for your advice. I have contacted my customer and advised them to backup the database first using the software provided.

Unless Oracle can add to an existing backup file, I am not sure if there is a practical solution because BB will have to upload the newly created backup file each time and the file size will probably be too big.

I have not really envisaged using BB to backup Oracle databases, but will update the post when I can.

Regards
Paul
Back to Top
John View Drop Down
Admin Group
Admin Group
Avatar
Head of development

Joined: 02/May/2006
Location: United Kingdom
Status: Offline
Points: 203
Post Options Post Options   Thanks (0) Thanks(0)   Quote John Quote  Post ReplyReply Direct Link To This Post Posted: 27/April/2012 at 10:40pm
Actually what you could do is make sure that the backup gets saved to the same filename every time. e.g. "C:\oracle\backup.bak".

That way, BuddyBackup can do incremental binary backups (backing up only the changes within each version of the file. Your mileage may vary, but it could well get quite small backups each time.

John
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.01
Copyright ©2001-2011 Web Wiz Ltd.