Discussions specific to the VMware vSphere hypervisor
Post Reply
LaurentS
Influencer
Posts: 15
Liked: 2 times
Joined: Mar 18, 2016 11:26 am
Full Name: Laurent SERES
Contact:

Good way to Backup/Replicate Oracle VM without truncate log

Post by LaurentS » 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

veremin
Product Manager
Posts: 17005
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin » Oct 07, 2016 9:36 am

First option should be enough. Thanks.

LaurentS
Influencer
Posts: 15
Liked: 2 times
Joined: Mar 18, 2016 11:26 am
Full Name: Laurent SERES
Contact:

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

Post by LaurentS » 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.

veremin
Product Manager
Posts: 17005
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin » 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.

LaurentS
Influencer
Posts: 15
Liked: 2 times
Joined: Mar 18, 2016 11:26 am
Full Name: Laurent SERES
Contact:

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

Post by LaurentS » 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.

veremin
Product Manager
Posts: 17005
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin » 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.

LaurentS
Influencer
Posts: 15
Liked: 2 times
Joined: Mar 18, 2016 11:26 am
Full Name: Laurent SERES
Contact:

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

Post by LaurentS » Oct 11, 2016 1:15 pm

Waoh ok !!
Everything is clear now.

Thank you very much :)

veremin
Product Manager
Posts: 17005
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin » 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.

LaurentS
Influencer
Posts: 15
Liked: 2 times
Joined: Mar 18, 2016 11:26 am
Full Name: Laurent SERES
Contact:

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

Post by LaurentS » 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.

veremin
Product Manager
Posts: 17005
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin » 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.

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 8 guests