Oracle Backup

Hyper-V specific discussions

Oracle Backup

Veeam Logoby moderniste » Sat Feb 01, 2014 10:09 am

Hi,

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
Description :
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.

regards
moderniste
Influencer
 
Posts: 11
Liked: 4 times
Joined: Fri Jan 17, 2014 10:25 am
Full Name: jeremy

Re: Oracle Backup

Veeam Logoby Vitaliy S. » Sun Feb 02, 2014 1:46 pm

Hello Jeremy,

I'm not expert in Oracle, but I believe you you can use a post backup job script to delete the archive logs after a successful job run. Here is a similar topic for further reading > Questions regarding Backup/Recovery of Oracle database

Thank you!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Oracle Backup

Veeam Logoby moderniste » Tue Feb 04, 2014 8:47 am

Hi Vitaly,

Thanks you for the link, I ask to my sysdba for a script ;)
moderniste
Influencer
 
Posts: 11
Liked: 4 times
Joined: Fri Jan 17, 2014 10:25 am
Full Name: jeremy

Re: Oracle Backup

Veeam Logoby v.Eremin » Tue Feb 04, 2014 8:50 am

This article might give you some hints on how this process can be scripted. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Oracle Backup

Veeam Logoby moderniste » Tue Feb 04, 2014 10:47 am

Very interesting Vladimir

thank you !
moderniste
Influencer
 
Posts: 11
Liked: 4 times
Joined: Fri Jan 17, 2014 10:25 am
Full Name: jeremy

[MERGED] Oracle Archive log files backup (...and delete)

Veeam Logoby tasy » Tue Dec 30, 2014 12:07 pm

Hello all,
Does anyone know how to backup Oracle Archive logs?
I Do backup Oracle via VEEAM, and it works just fine.
I also see that all of my archive log files were backed up fine too, but I need to delete them after a successful backup.
SYMANTEC Net Backup has an USER-ARCHIVE policy and it deletes the archive right after a successful backup.
Does VEEAM have it too, or should I write a batch file to manage that?

Thanks,
tasy
Novice
 
Posts: 3
Liked: never
Joined: Thu Nov 20, 2014 6:59 am
Full Name: tasy

Re: Oracle Backup

Veeam Logoby Vitaliy S. » Tue Dec 30, 2014 12:50 pm

Hello,

Yes, you can use a batch file as a post-backup job script to handle this.

Thank you!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Oracle Backup

Veeam Logoby tasy » Tue Dec 30, 2014 1:04 pm

Thanks,
But ain't veeam supposed to take care of it?
tasy
Novice
 
Posts: 3
Liked: never
Joined: Thu Nov 20, 2014 6:59 am
Full Name: tasy

Re: Oracle Backup

Veeam Logoby tasy » Tue Dec 30, 2014 1:07 pm

I saw that VEEAM has a check box for the TRANS LOGs, and I thought they'll have one for the archive log files...
tasy
Novice
 
Posts: 3
Liked: never
Joined: Thu Nov 20, 2014 6:59 am
Full Name: tasy

Re: Oracle Backup

Veeam Logoby Vitaliy S. » Tue Dec 30, 2014 1:18 pm

No, this checkbox refers to SQL Server/Exchange server.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Oracle Backup

Veeam Logoby moderniste » Tue Dec 30, 2014 2:00 pm 1 person likes this post

Hi,
The only good way to delete Oracle Arhivelog is a postbackup script like this :

Code: Select all
crosscheck archivelog all;
crosscheck backup;
crosscheck copy;
delete noprompt archivelog until time 'SYSDATE';
exit;


On Windows from 2008 you can make a task triggered by event id with Windows tasks Scheduler : On each VSS success backup by Oravssw (called by Veeam job) a event is logged (I don't remember the event id)
moderniste
Influencer
 
Posts: 11
Liked: 4 times
Joined: Fri Jan 17, 2014 10:25 am
Full Name: jeremy


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 8 guests