Host-based backup of Microsoft Hyper-V VMs.
Post Reply
moderniste
Influencer
Posts: 14
Liked: 4 times
Joined: Jan 17, 2014 10:25 am
Full Name: jeremy
Contact:

Oracle Backup

Post by moderniste »

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
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Oracle Backup

Post by Vitaliy S. »

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!
moderniste
Influencer
Posts: 14
Liked: 4 times
Joined: Jan 17, 2014 10:25 am
Full Name: jeremy
Contact:

Re: Oracle Backup

Post by moderniste »

Hi Vitaly,

Thanks you for the link, I ask to my sysdba for a script ;)
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Oracle Backup

Post by veremin »

This article might give you some hints on how this process can be scripted. Thanks.
moderniste
Influencer
Posts: 14
Liked: 4 times
Joined: Jan 17, 2014 10:25 am
Full Name: jeremy
Contact:

Re: Oracle Backup

Post by moderniste »

Very interesting Vladimir

thank you !
tasy
Novice
Posts: 3
Liked: never
Joined: Nov 20, 2014 6:59 am
Full Name: tasy
Contact:

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

Post by tasy »

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,
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Oracle Backup

Post by Vitaliy S. »

Hello,

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

Thank you!
tasy
Novice
Posts: 3
Liked: never
Joined: Nov 20, 2014 6:59 am
Full Name: tasy
Contact:

Re: Oracle Backup

Post by tasy »

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

Re: Oracle Backup

Post by tasy »

I saw that VEEAM has a check box for the TRANS LOGs, and I thought they'll have one for the archive log files...
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Oracle Backup

Post by Vitaliy S. »

No, this checkbox refers to SQL Server/Exchange server.
moderniste
Influencer
Posts: 14
Liked: 4 times
Joined: Jan 17, 2014 10:25 am
Full Name: jeremy
Contact:

Re: Oracle Backup

Post by moderniste » 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)
Post Reply

Who is online

Users browsing this forum: No registered users and 18 guests