![]() |
Oracle Databases? |
Post Reply
|
| Author | |
Amber Computers
Ultra Buddy
Joined: 24/June/2011 Location: United Kingdom Status: Offline Points: 73 |
Post Options
Thanks(0)
Quote Reply
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 |
|
![]() |
|
John
Admin Group
Head of development Joined: 02/May/2006 Location: United Kingdom Status: Offline Points: 203 |
Post Options
Thanks(0)
Quote Reply
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 |
|
![]() |
|
Amber Computers
Ultra Buddy
Joined: 24/June/2011 Location: United Kingdom Status: Offline Points: 73 |
Post Options
Thanks(0)
Quote Reply
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 |
|
![]() |
|
John
Admin Group
Head of development Joined: 02/May/2006 Location: United Kingdom Status: Offline Points: 203 |
Post Options
Thanks(0)
Quote Reply
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 |
|
![]() |
|
Post Reply
|
|
|
|
| Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |