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.
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 ?