Good way to Backup/Replicate Oracle VM without truncate log

VMware specific discussions

Good way to Backup/Replicate Oracle VM without truncate log

Veeam Logoby LaurentS » Fri Oct 07, 2016 8:19 am

Hello,

Could you please tell me what is the good way to backup/replicate Oracle VM without truncate logs ?

1) Activate AAIP
Select "Perform Copy Only"

2) Activate AAIP
select "Process transaction logs with this job"
Use a SYSDBA account (if really need ?)
Select "Do not delete archived logs"

Thank you very much.
Laurent.S
LaurentS
Novice
 
Posts: 8
Liked: never
Joined: Fri Mar 18, 2016 11:26 am
Full Name: Laurent SERES

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby v.Eremin » Fri Oct 07, 2016 9:36 am

First option should be enough. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby LaurentS » Fri Oct 07, 2016 3:23 pm

Thank you Vladimir,

When selecting the first option, i got some error message :

"Unable to perform application-aware processing of Oracle database (SID: MYDB) : Oracle error has occurred. ORA-01031: insufficient privileges --tr:Failed to create oracle session. --tr:Failed to create oracle session holder. SID: MYDB."

If we just want to backup/replicate Oracle DB (consistant with Oracle VSS Writer) but don't want truncate Log with Veeam,
when i choose "perform copy only", the account used for AAIP need SYSDBA privilege ?

Regards.
LaurentS
Novice
 
Posts: 8
Liked: never
Joined: Fri Mar 18, 2016 11:26 am
Full Name: Laurent SERES

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby v.Eremin » Mon Oct 10, 2016 11:28 am

I've clarified your question internally and below is the summary I got.

If non-default settings are specified in AAIP Oracle tab, you will need to:

- Oracle Tab: Select account with SYSDBA privileges
- Oracle Tab: Select "do not delete archive logs"
- General Tab: Select Copy Only option

Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby LaurentS » Tue Oct 11, 2016 9:44 am

Hello Vladimir,

Could you please just clarify one thing, i have to select one of the three options, if non-default settings are specified in AAIP Oracle Tab :

- Oracle Tab: Select account with SYSDBA privileges
"OR" Oracle Tab: Select "do not delete archive logs"
"OR" General Tab: Select Copy Only option

Is that right ?
Because when i select "Perform Copy Only" option, Oracle Tab just disapppear.

Thank you.
LaurentS
Novice
 
Posts: 8
Liked: never
Joined: Fri Mar 18, 2016 11:26 am
Full Name: Laurent SERES

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby v.Eremin » Tue Oct 11, 2016 12:36 pm 1 person likes this post

If non-default settings are specified in Oracle Tab, you will need to specify all three options (1-2 - first and then the 3 one), even though it's true that as soon as you set the third option the first two will disappear. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby LaurentS » Tue Oct 11, 2016 1:15 pm

Waoh ok !!
Everything is clear now.

Thank you very much :)
LaurentS
Novice
 
Posts: 8
Liked: never
Joined: Fri Mar 18, 2016 11:26 am
Full Name: Laurent SERES

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby v.Eremin » Tue Oct 11, 2016 1:20 pm

You're welcome. Kindly, let us know whether the proposed options set works for you. There is a room for potential improvements, so, your feedback will be quite valuable. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby LaurentS » Fri Oct 21, 2016 4:30 pm

Hi Vlad,

Finally my customer wasn't aware of a sysdba account (he have a dba team who take care of all Oracle DB stuff).

Actually, the dba team Backup Oracle DB with RMAN;
So we just add the registry key "DisableOracleProcessing" = 1 on Oracle VM, in order to make proper AAIP Backup but without Oracle processing.
https://www.veeam.com/kb2114

Thanks again for your help.
Regards.
LaurentS
Novice
 
Posts: 8
Liked: never
Joined: Fri Mar 18, 2016 11:26 am
Full Name: Laurent SERES

Re: Good way to Backup/Replicate Oracle VM without truncate

Veeam Logoby v.Eremin » Fri Oct 21, 2016 4:42 pm

The said key must have slipped from my mind. Glad to hear, though, that you've been able to find and successfully implement it. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 14 guests