Oracle Server Backup - Application aware processing

Availability for the Always-On Enterprise

Oracle Server Backup - Application aware processing

Veeam Logoby vahsankhan » Wed Mar 08, 2017 12:36 pm

I currently working with a customer who has a linux/windows oracle server with 3 different instances and different account with sysdba privileges.
so when replicating this VM and enabling Application aware processing how can we backup the archived logs if the account is not common between the 3 oracle instances running on the server.

Need help and suggestions
Thankyou
vahsankhan
Novice
 
Posts: 6
Liked: never
Joined: Wed Mar 08, 2017 12:27 pm
Location: PAKISTAN
Full Name: Khan Ahsan Masroor

Re: Oracle Server Backup - Application aware processing

Veeam Logoby foggy » Thu Mar 09, 2017 10:53 am

You need an account with privileges on all instances to be able to collect logs from all of them.
foggy
Veeam Software
 
Posts: 14482
Liked: 1057 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED] Multiple oracle instances backup

Veeam Logoby marieelieg » Wed May 24, 2017 7:23 am

Hello everyone,

While configuring a backup job for oracle, in the guest processing page, we enable App-Aware and we press the "Applications" button to configure more settings (truncate logs, etc.). At this step, in the "Oracle" tab we specify an account with sysdba privileges for Oracle. So far so good.

My problem is, I have, on the same oracle server, 2 oracle instances each having a different sysdba account. My question is: How do I configure a backup for this oracle server? I mean how do I specify both sysdba accounts for this server? Is that even possible?

Really appreciate your help.

Thanks everybody in advance :D
marieelieg
Enthusiast
 
Posts: 45
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: Multiple oracle instances backup

Veeam Logoby foggy » Wed May 24, 2017 11:29 am

The only option I see here is selecting 'Use guest credentials' in the list of user accounts, where the account specified at the Guest Processing step of the wizard has access to both instances.
foggy
Veeam Software
 
Posts: 14482
Liked: 1057 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Multiple oracle instances backup

Veeam Logoby marieelieg » Wed May 24, 2017 11:33 am

That's the problem. There isn't 1 account that has sysdba privileges to both instances. There are 2 accounts, one is sysdba to instance1 and the other is sysdba to instance2.

I take it we should have a single account that should have sysdba privileges to all instances on a single oracle server?
marieelieg
Enthusiast
 
Posts: 45
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: Oracle Server Backup - Application aware processing

Veeam Logoby foggy » Wed May 24, 2017 11:54 am

Correct.
foggy
Veeam Software
 
Posts: 14482
Liked: 1057 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: baber, Edwin, Google [Bot], uri and 22 guests