Skip to main content

oracle 11g release 2 backup

Thread needs solution

Since Oracle 11g now supports Microsoft VSS, is it still necessary to suspend the database at the start of backup operations to get a consistent backup?

Thanks in Advance,

Gary

0 Users found this helpful

Hello Gary!

Thank you for finding time to open the thread regarding this question! I understand your concern and will be glad to shed the light to the situation.

In case Oracle supports Microsoft VSS you can enable the backup with VSS support in the backup options instead of using batch files. But the Database will be anyway freezed during the process of the snapshot creation (2-3 seconds).

VSS is a service that is responsible for many things, but we're interested in the part where we communicate with MS VSS. VSS provides our product with the proper access to the database, so now the freezing command will be sent not via batch files, but through native Windows tools.

Unfortunately there's no way to avoid suspending of the database during the full backup of OS.

Should you need anything else or have any further questions - feel free to contact us at your earliest convenience, we will be happy to help you!

Thank you!

Yana,
Thank You for your reply. It is my understanding from your email that in either through VSS or Batch file the database will be suspended to facilitate a consistent backup. Unfortunately from our experience so far we have not be able to get a consistent Oracle 11g database backup using the VSS option. Each time we restore the image (at the disk level) the Oracle database is asking to be recovered. During the backup we have used the VSS enable function as well as the multi-volume snapshot function. Our database is configured just that that datafiles are on drive C: and the archive log files are on drive F:. If the VSS and multi-volume snapshot function we working as I expected, then the database would not request recovery after restoring the image.

Is there any other insight you can provide to help understand what is going on with the VSS backup?

Dear Gary,

Thank you for your comment and for the details of the problem.

According to your description everything should be working fine. Unfortunately due to the lack of diagnostic data it's hard to say what caused the problem: there can be dozens of issues. So we will need to investigate the issue to find the glitch. Could you please kindly gather the following information? 

  1. Acronis Info from the problem machine
  2. Exact sequence of steps performed

After that please kindly submit a support request with the information attached and specify us the case number.

Should you need anything else or have any further questions - feel free to contact us at your earliest convenience, we will be happy to help you!

Thank you!