03-23-2020 08:20 AM
Hello;
I have a question regarding a Vmware backup of a VM that has Oracle databases.
is there any harm of doing a backup of this VM? the snapshot won't "hurt" oracle's databases?
and if I want to backup those databases, do I have do install NetBackup client on that VM and do another Policy (type= Oracle Intelligent Policy) to backup those Oracle?
What are the best practices please?.
Thanks,
Solved! Go to Solution.
03-23-2020 12:30 PM
Hello,
on Windows Oracle servers, service called Oracle VSS Writer is installed with Oracle SW. When you are doing VMware snapshots, this writer is also called and puts Oracle into consistent state for the time of snapshot. When you search Oracle logs, you should find messages about this state in them, for the time of snapshot (ALTER DATAFILE XXX BEGIN/END BACKUP)
But the purpose of this is rather related to consistency during snapshots, I would not take it as Oracle data backup - NetBackup is not "Oracle aware" during VMware backups, thus it is not cataloguing any Oracle metadata.
Regards
Michal
03-24-2020 04:43 AM
From personal experience, I've had Oracle DBAs say it can affect the DB when taking a VM snapshot (cause it to crash or similar) so i have always just done an NBU Client backup to save any hassle.
03-24-2020 03:44 PM
Further to @Nick_Morris comment, I have also seen this happen on various database servers.
One way to avoid this occurring is to enable the "Perform snapshot without quiescing if quiesced snapshot fails" option in the Advanced options in the VMware tab for the policy.
In addition, I would also look to exclude the VMDK files that host the database files.
The above of course assumes you are doing agent based Oracle backups of the relevant databases.
03-23-2020 09:59 AM
To properly protect the database, you'd need to install the client and do an Oracle backup of the database.
03-23-2020 11:01 AM
Hi @Krutons , thank your for your reply,
I am aware of that actually, my main question is, is there any harm to oracle databases of doing a snapshot of that VM ?
I have actually two scenarios:
1st: let's say that I don't care about the oracle databases, I just want to backup that VM through VMware Backup, would the snapshot "disturb" oracle's databases?
2nd: let's say that I want to backup the oracle's databases and do a Vmware Backup, in this case I know that I have to configure 2 Policies :
- VMware Policy for the VM backup
- OIP for Oracle databases.
If my VMware policy is executed and the snapshot is in progress, In this case I can't run (or schedule) the OIP to start at this same time right? because the snapshot is still in progress and oracle's data are not in a consistent state?
03-23-2020 11:49 AM
I'm not 100% sure about Oracle on VM's, but I think the genreal rule of thumb is "don't snapshot database servers".
For my environment, we use the database agent where applicable and then for OS backups we use the "Inside the Matrix" approach and treat the client like it's a real physical server.
$0.02
03-23-2020 12:30 PM
Hello,
on Windows Oracle servers, service called Oracle VSS Writer is installed with Oracle SW. When you are doing VMware snapshots, this writer is also called and puts Oracle into consistent state for the time of snapshot. When you search Oracle logs, you should find messages about this state in them, for the time of snapshot (ALTER DATAFILE XXX BEGIN/END BACKUP)
But the purpose of this is rather related to consistency during snapshots, I would not take it as Oracle data backup - NetBackup is not "Oracle aware" during VMware backups, thus it is not cataloguing any Oracle metadata.
Regards
Michal
03-24-2020 04:43 AM
From personal experience, I've had Oracle DBAs say it can affect the DB when taking a VM snapshot (cause it to crash or similar) so i have always just done an NBU Client backup to save any hassle.
03-24-2020 03:44 PM
Further to @Nick_Morris comment, I have also seen this happen on various database servers.
One way to avoid this occurring is to enable the "Perform snapshot without quiescing if quiesced snapshot fails" option in the Advanced options in the VMware tab for the policy.
In addition, I would also look to exclude the VMDK files that host the database files.
The above of course assumes you are doing agent based Oracle backups of the relevant databases.
03-25-2020 05:11 AM
Hello Guys,
Thanks all for your replies.
So you confirmed what I had in mind " snapshot of a VM that has oracle databases is not a harmless action" even with the oracle VSS for windows VMs." there is always a risk..
Thanks again :)