Availability for the Always-On Enterprise
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 » 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

foggy
Veeam Software
Posts: 16662
Liked: 1338 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Oracle Server Backup - Application aware processing

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

marieelieg
Expert
Posts: 101
Liked: 4 times
Joined: Oct 20, 2016 7:15 am
Contact:

[MERGED] Multiple oracle instances backup

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

foggy
Veeam Software
Posts: 16662
Liked: 1338 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Multiple oracle instances backup

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

marieelieg
Expert
Posts: 101
Liked: 4 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: Multiple oracle instances backup

Post by marieelieg » 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?

foggy
Veeam Software
Posts: 16662
Liked: 1338 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Oracle Server Backup - Application aware processing

Post by foggy » May 24, 2017 11:54 am

Correct.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], david.tosoff, erohver and 16 guests