Comprehensive data protection for all workloads
Post Reply
Posts: 1
Liked: never
Joined: Aug 03, 2012 9:20 am
Full Name: david adam

Oracle DB snapshot pb

Post by davidadam » Oct 04, 2012 1:26 pm

Hello all,

We're trying to backup/restore an Oracle DB with Veeam and encounter issues. While Veeam asks WMware to do a snapshot, it freezes the DB (seems like Oracle doesn't like the facts that some files are locked during the snapshot)

As Oracle versions prior to 11G are not VSS compliant, we tried to use quiescence to be able to start scripts before snapshot (including "alter database begin backup" command) and after snapshot (including "alter database end backup" command).
Freeze script is correctly executed befor snapshot and Thaw scripts after snapshot.
However, during snapshot the database fails because of I/O problems :

Code: Select all

ORA-00206: error in writing (block 3, # blocks 1) of controlfile 
ORA-00202: controlfile: 'F:\ORACLE\ORADATA\WMDN33LG\CONTROL03.CTL' 
ORA-27070: skgfdisp: async read/write failed 
OSD-04016: Error queuing an asynchronous I/O request. 
We followed one best practice to do it without success :

If you take pre/post scripts approach to Oracle backups, you need to make sure "Enable VMware Tools quiescence" is checked because this is what will enable pre/post scripts to work. This will also enable SYNC driver, but the driver will not cause any problem in this case, as your applications will be quiesced.

Anyone having an idea to solve this ?

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 29 guests