Comprehensive data protection for all workloads
Post Reply
vahsankhan
Novice
Posts: 6
Liked: never
Joined: Mar 08, 2017 12:27 pm
Full Name: Khan Ahsan Masroor
Location: PAKISTAN
Contact:

Oracle Server Backup - Application aware processing

Post by vahsankhan »

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
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Oracle Server Backup - Application aware processing

Post by foggy »

You need an account with privileges on all instances to be able to collect logs from all of them.
marieelieg
Expert
Posts: 147
Liked: 8 times
Joined: Oct 20, 2016 7:15 am
Contact:

[MERGED] Multiple oracle instances backup

Post by marieelieg »

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
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Multiple oracle instances backup

Post by foggy »

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.
marieelieg
Expert
Posts: 147
Liked: 8 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: Multiple oracle instances backup

Post by marieelieg »

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?
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Oracle Server Backup - Application aware processing

Post by foggy »

Correct.
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 99 guests