Discussions specific to the VMware vSphere hypervisor
Post Reply
benny2020
Lurker
Posts: 2
Liked: never
Joined: Jan 31, 2020 8:25 am
Full Name: Benny Strömberg
Contact:

Oracle - Application-aware processing

Post by benny2020 »

Hello,

We are backing up a virtual Windows Server that is running Oracle DB. Oracle is handling the backup of the database locally and truncating the transaction logs. We are then using Veeam to backup the complete server. In "Guest processing" for the server, we have ticked the box "Perform copy only (lets another application use logs)" but we don´t know if we should enable "Application-aware processing" or not. If we enable it we get the following error:

Unable to perform application-aware processing of Oracle database (SID: XXX) : Oracle error has occurred. ORA-01017: invalid username/password; logon denied

And if we disable it, the backup shows that all is ok.

So the questions are:

1. If we keep "Application-aware processing" enabled and add the username and password for the DB, what does Veeam do with the DB?
2. If we disable "Application-aware processing", will we get a crash consistent backup of the DB?

Regards,
Benny

Andreas Neufert
VP, Product Management
Posts: 5473
Liked: 1119 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: Oracle - Application-aware processing

Post by Andreas Neufert »

1. We bring the database in consistent state before image level backup => "Alter Database begin/end backup"
2. correct

benny2020
Lurker
Posts: 2
Liked: never
Joined: Jan 31, 2020 8:25 am
Full Name: Benny Strömberg
Contact:

Re: Oracle - Application-aware processing

Post by benny2020 »

So there is no benefit in going with option 1 compared to option 2?

Andreas Neufert
VP, Product Management
Posts: 5473
Liked: 1119 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: Oracle - Application-aware processing

Post by Andreas Neufert »

Sure there is a benefit ... you have the Oracle DB in a cosistent state at image level backup. If you need DR and restore the server you have the DB in a good working state.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Majestic-12 [Bot] and 17 guests