Server 2008 VM w Oracle: backup question
-
Hypervisor is Win Server 2008 R2.
LOB app: o/s is Server 2008. This app has an Oracle db.If the VM is backed using Veeam or Altaro, is that good enough in the event that a restore is needed?
-
Depends on how you want to restore. I assume that Veeam has an Oracle agent, but I'd double check. Ideally, you'll want something that talks directly to Oracle and restores Oracle, not the whole system.
-
Looks like I need to read up: https://www.veeam.com/blog/how-to-backup-oracle-database-best-practices.html
-
@FATeknollogee said in Server 2008 VM w Oracle: backup question:
Looks like I need to read up: https://www.veeam.com/blog/how-to-backup-oracle-database-best-practices.html
A better answer is do you care if Veeam is application aware on this piece?
I generally do not care if Veeam does anything stable with a database on a system that it is backing up.
Because I use the native database tools to handle that locally. Then when Veeam backs up the VM, the database backups are simply taken along.
I do not have any Oracle systems out there, but in the SQL Server world, I simply setup maintenance plans that backup the database at the interval required by the business continuity / DR planning research.
Granular DB recovery for corrupted database: hourly, because it is easy to use SQL Server Management studio to handle rollbakcs.
Smoked server acceptable recovery: daily. So this means I have SQL server create .bak files a couple times a day and then an hour later twice a day I have veeam run a backup.
-
@JaredBusch said in Server 2008 VM w Oracle: backup question:
A better answer is do you care if Veeam is application aware on this piece?
I would only care if there is an advantage or benefit to it being app aware
I generally do not care if Veeam does anything stable with a database on a system that it is backing up.
Because I use the native database tools to handle that locally. Then when Veeam backs up the VM, the database backups are simply taken along.
It sounds like these db backups are stored in the same vm?
-
@FATeknollogee said in Server 2008 VM w Oracle: backup question:
@JaredBusch said in Server 2008 VM w Oracle: backup question:
A better answer is do you care if Veeam is application aware on this piece?
I would only care if there is an advantage or benefit to it being app aware
I generally do not care if Veeam does anything stable with a database on a system that it is backing up.
Because I use the native database tools to handle that locally. Then when Veeam backs up the VM, the database backups are simply taken along.
It sounds like these db backups are stored in the same vm?
Yes, your point? The best, fastest, backup target is always local. This is just the application backup though. do not confuse things or leave out pieces of the puzzle. I gave an entire solution.
-
@JaredBusch said in Server 2008 VM w Oracle: backup question:
Granular DB recovery for corrupted database: hourly, because it is easy to use SQL Server Management studio to handle rollbakcs.
Smoked server acceptable recovery: daily. So this means I have SQL server create .bak files a couple times a day and then an hour later twice a day I have veeam run a backup.
I assume this is setup on a schedule using Mgmt Studio?
-
@FATeknollogee said in Server 2008 VM w Oracle: backup question:
@JaredBusch said in Server 2008 VM w Oracle: backup question:
Granular DB recovery for corrupted database: hourly, because it is easy to use SQL Server Management studio to handle rollbakcs.
Smoked server acceptable recovery: daily. So this means I have SQL server create .bak files a couple times a day and then an hour later twice a day I have veeam run a backup.
I assume this is setup on a schedule using Mgmt Studio?
Yes.
-
I prefer just using Veeam rather than having a separate maintenance plan to backup the database outside of Veeam. Mainly, I guess, because of laziness, though partly because I prefer Veeam to log successful/unsuccessful backups. If I didn't use Veeam, I'd have to have another process for checking successful database backups. This is for SQL Server, but the same would apply for Oracle.
-
@JaredBusch said in Server 2008 VM w Oracle: backup question:
Yes, your point? The best, fastest, backup target is always local. This is just the application backup though. do not confuse things or leave out pieces of the puzzle. I gave an entire solution.
I understand you gave an entire solution, I was trying to ask the question in detail, hence the multi-part reply.
Also wasn't sure if it was advisable to store the app backups in the same vm, but you say that's ok
-
@FATeknollogee said in Server 2008 VM w Oracle: backup question:
@JaredBusch said in Server 2008 VM w Oracle: backup question:
Yes, your point? The best, fastest, backup target is always local. This is just the application backup though. do not confuse things or leave out pieces of the puzzle. I gave an entire solution.
I understand you gave an entire solution, I was trying to ask the question in detail, hence the multi-part reply.
Also wasn't sure if it was advisable to store the app backups in the same vm, but you say that's ok
Turn that around.
Why do you think it would not be ok? -
@Carnival-Boy said in Server 2008 VM w Oracle: backup question:
I prefer just using Veeam rather than having a separate maintenance plan to backup the database outside of Veeam. Mainly, I guess, because of laziness, though partly because I prefer Veeam to log successful/unsuccessful backups. If I didn't use Veeam, I'd have to have another process for checking successful database backups. This is for SQL Server, but the same would apply for Oracle.
You should have various other maintenance tasks setup for SQL Server anyway. Adding a backup task is simplistic. Those other tasks should be alerting on fail, and so should the backup. so really, not an issue here.
-
@JaredBusch said in Server 2008 VM w Oracle: backup question:
Turn that around.
Why do you think it would not be ok?I guess it is ok....if you lost the vm, you would have a backup of the vm, which contains the app db data
-
@FATeknollogee said in Server 2008 VM w Oracle: backup question:
@JaredBusch said in Server 2008 VM w Oracle: backup question:
Turn that around.
Why do you think it would not be ok?I guess it is ok....if you lost the vm, you would have a backup of the vm, which contains the app db data
Correct.
-
@JaredBusch said in Server 2008 VM w Oracle: backup question:
Granular DB recovery for corrupted database: hourly, because it is easy to use SQL Server Management studio to handle rollbakcs.
Smoked server acceptable recovery: daily. So this means I have SQL server create .bak files a couple times a day and then an hour later twice a day I have veeam run a backup.
Granular db (hourly) + Smoked (daily) + Veeam (twice a day) = Full protection with lots of restore point options.
Correct?
-
@FATeknollogee said in Server 2008 VM w Oracle: backup question:
@JaredBusch said in Server 2008 VM w Oracle: backup question:
Granular DB recovery for corrupted database: hourly, because it is easy to use SQL Server Management studio to handle rollbakcs.
Smoked server acceptable recovery: daily. So this means I have SQL server create .bak files a couple times a day and then an hour later twice a day I have veeam run a backup.
Granular db (hourly) + Smoked (daily) + Veeam (twice a day) = Full protection with lots of restore point options.
Correct?
Smoked is twice a day with veeam directly after because I prefer not to have to risk a full 24 hours. generally people think daily means this morning like it was, but we know that is not true.
but yes, correct.
-
Very true. You can use a traditional tool, store a backup locally then take any sort of backup of the local system that way.
