I post here to make a feedback on my experience with Veeam 7 on 2008 R2 and Oracle 11g; discuss about best practices ...
* First, I had to configure Oracle Vss writer :
Activate : oravssw %db% /i
Oracle VSS writer service need sysdba privileges.
I tried to change account service with a member of ora_dba Windows group but doesn't work... so I used authentication option in sqlnet.ora SQLNET.AUTHENTICATION_SERVICES = (NONE,NTS) Add NTS and ORacle vss ervice will have SYSDBA privilege.
With command : vssadmin list writers check Oracle vss writer
* Database must be in archive log mode and veeam backup in application-aware mode. When backup is successfull you can see in Windows event log a message from VSS which show :
- Code: Select all
Nom du journal :Application
Source : Oracle.VSSWriter.databasename
Date : 30/01/2014 21:55:41
ID de l'événement :4107
Catégorie de la tâche :(255)
Niveau : Information
Mots clés : Classique
Utilisateur : N/A
Ordinateur : server
VSS-04107: successfully backed up component Oracle Database (FULL)
Now some questions...
How to delete archive log files after a successfull backup ? Before Veeam, I worked with backup exec and rman to backup Oracle, Backupexec can delete archive log after a good backup.