Cannot backup a W2k8 R2 VM running Oracle 11g DB

#1 VM Backup : Modern Data Protection for VMware vSphere and Microsoft Hyper-V

Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby frispete » Wed Apr 24, 2013 7:26 pm

[#00200628}

Hi,

I would like to kindly ask here, if other veeam users ever tried to backup a VM with an Oracle 11g instance running inside?

DB installed on C:
DB table data running on D:
Both are vmdks of vSphere 5.1.

I just harvest a:
Failed to prepare guest for hot backup. Error: VSSControl: -2147212300 Backup job failed.
Cannot create a shadow copy of the volumes containing writer's data.
A VSS critical writer has failed. Writer name: [Oracle VSS Writer - SOLOPLAN].
Writer's state: [VSS_WS_FAILED_AT_PREPARE_BACKUP]. Error code: [0x800423f4].

What's strange here, this writer isn't listed in "vssadmin list writers" at all, nor in "vssadmin list providers".

I do ask myself, if Oracle is the bad guy here, or the company, that installed Oracle for their industry solution (Soloplan).

Any idea anybody?

Thanks in advance
frispete
Novice
 
Posts: 7
Liked: never
Joined: Wed Apr 24, 2013 12:44 pm
Full Name: Hans-Peter Jansen

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby Vitaliy S. » Wed Apr 24, 2013 10:21 pm

Hi Hans-Peter,

You definitely need to check that with Soloplan, as it looks like this VSS driver wasn't installed properly and right now is casing these issues. Btw, do you have any related messages in the Windows Event log?

Thanks!
Vitaliy S.
Product Manager
 
Posts: 11853
Liked: 421 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby frispete » Thu Apr 25, 2013 7:03 am

Dear Vitaliy,

thanks for responding. I checked the event logs amply on this VM, but didn't find any related notice. Strange.
Since I kept the default of retrying 3 times, I can can see the the logins of B&R, but no follow ups. Hmm.

Will raise the pressure on Soloplan now..

Thanks,
Pete
frispete
Novice
 
Posts: 7
Liked: never
Joined: Wed Apr 24, 2013 12:44 pm
Full Name: Hans-Peter Jansen

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby frispete » Thu Apr 25, 2013 2:13 pm

Hi,

after Soloplan resolved the issue, it ran into another issue:

25.04.2013 14:56:12 :: Failed to prepare guest for hot backup. Error: RPC function call failed. Function name: [IsSnapshotInProgress]. Target machine: [172.16.24.17].
RPC error:Zugriff verweigert
Code: 5

Might be related to traffic on this machine, but I was under the impression, that a backup of a lightly busy system should be possible anyway.
Am I wrong?
frispete
Novice
 
Posts: 7
Liked: never
Joined: Wed Apr 24, 2013 12:44 pm
Full Name: Hans-Peter Jansen

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby foggy » Thu Apr 25, 2013 3:30 pm

Make sure you've specified account with local admin privileges on the target VM to perform application-aware image processing. Looks like you do not have enough permissions for that.
foggy
Veeam Software
 
Posts: 6318
Liked: 342 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby frispete » Fri Apr 26, 2013 2:03 pm

The latter issue was due to using a user@domain identification, instead of DOMAIN\user..

I was able to solve the topic issue with support of Soloplan.

Thank you for the fine support,
Pete
frispete
Novice
 
Posts: 7
Liked: never
Joined: Wed Apr 24, 2013 12:44 pm
Full Name: Hans-Peter Jansen

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby m.novelli » Fri Apr 26, 2013 2:19 pm

frispete wrote:The latter issue was due to using a user@domain identification, instead of DOMAIN\user..

I was able to solve the topic issue with support of Soloplan.

Thank you for the fine support,
Pete


Hi, how did you solve the issue with VSS writer? I have a customer with Oracle and the same VSS error, but the Oracle DBA don't know how to handle Microsoft VSS (me too I don't know what to do... I'm a SQL Server guy :) )

Marco
m.novelli
Veeam ProPartner
 
Posts: 209
Liked: 18 times
Joined: Tue Dec 29, 2009 12:48 pm
Location: Asti - Italy
Full Name: Marco Novelli

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby frispete » Fri Apr 26, 2013 2:54 pm

Hi Marco,

Hi, how did you solve the issue with VSS writer?


Yes, partly by chance. I noticed, that the Oracle VSS service was started manually, and that resulted in above failures. After changing it to run automatically, it still failed here.
After stopping the service and keep it on starting automatic, it succeeded..

Try and call back ;-)

Cheers,
Pete
frispete
Novice
 
Posts: 7
Liked: never
Joined: Wed Apr 24, 2013 12:44 pm
Full Name: Hans-Peter Jansen

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby m.novelli » Fri Apr 26, 2013 3:07 pm

I've checked and the service is already set with automatic start with local service :-(

Marco
m.novelli
Veeam ProPartner
 
Posts: 209
Liked: 18 times
Joined: Tue Dec 29, 2009 12:48 pm
Location: Asti - Italy
Full Name: Marco Novelli

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby frispete » Fri Apr 26, 2013 4:26 pm

Hm, too bad, but here's something else to check:

I have two other services related to VSS, one is called "Volume shadow copy" and the other "Microsoft shadow copy provider" (translated from german) both with start type: manually.

Try a few times, it took a few trials before it succeeded. Otherwise, provide the exact error as a starter ;-)

Cheers,
Pete
frispete
Novice
 
Posts: 7
Liked: never
Joined: Wed Apr 24, 2013 12:44 pm
Full Name: Hans-Peter Jansen

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby m.novelli » Fri Apr 26, 2013 4:29 pm

Yes the other VSS services are set correctly
My error is the same as your:

Failed to prepare guest for hot backup. Error: VSSControl: -2147212300 Backup job failed. Cannot create a shadow copy of the volumes containing writer's data. A VSS critical writer has failed. Writer name: [Oracle VSS Writer - PRDH2O]. Class ID: [{26d02976-b909-43ad-af7e-62a4f625e372}]. Instance ID: [{3b95b4fe-28e0-4340-b754-5cdd19602093}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_BACKUP]. Error code: [0x800423f4].
Error: VSSControl: -2147212300 Backup job failed. Cannot create a shadow copy of the volumes containing writer's data. A VSS critical writer has failed. Writer name: [Oracle VSS Writer - PRDH2O]. Class ID: [{26d02976-b909-43ad-af7e-62a4f625e372}]. Instance ID: [{3b95b4fe-28e0-4340-b754-5cdd19602093}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_BACKUP]. Error code: [0x800423f4].
m.novelli
Veeam ProPartner
 
Posts: 209
Liked: 18 times
Joined: Tue Dec 29, 2009 12:48 pm
Location: Asti - Italy
Full Name: Marco Novelli

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby foggy » Fri Apr 26, 2013 4:45 pm

Marco, as in case with OP, you also need to check with the VSS writer vendor (H2O, i guess) regarding this issue.
foggy
Veeam Software
 
Posts: 6318
Liked: 342 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby frispete » Fri Apr 26, 2013 8:23 pm

Well, the support didn't helped much. Playing with the services did..

We're using Oracle 11g (11.2.0).

Might be that your database is just too liquid to be backed up correctly.. :wink:
frispete
Novice
 
Posts: 7
Liked: never
Joined: Wed Apr 24, 2013 12:44 pm
Full Name: Hans-Peter Jansen

[MERGED] : Oracle VSS Writer Issue

Veeam Logoby EvoTom » Tue May 07, 2013 9:36 am

We are having some issues with the Veeam and the Oracle VSS Writer. The job fails after preparing guest for hot backup. The error is "Unable to release guest. Error: Unfreeze error: Cannot create a shadow copy of the volumes containing writers data"

On the target server there is an error for VSS in the Event Log saying :

Volume Shadow Copy Service error: Unexpected error calling routine XML document is too long. hr = 0x80070018, The program issued a command but the command length is incorrect.
.

Operation:
Writer Modifying Modifying Backup Document

Context:
Execution Context: Requestor
Writer Instance ID: {D959B881-F426-4DA4-8266-495EABB8DBAB}

When you run vssadmin list writers for the 'Oracle VSS Writer - <ORACLE_SID>' the state is "[11] Failed" and the Last Error is "Retryable error".

In the alert log for Oracle you can see that the writer is putting the database into backup mode. Just trying to work out why the writer is failing.
EvoTom
Member
 
Posts: 21
Liked: never
Joined: Wed Jul 11, 2012 10:18 am

Re: Cannot backup a W2k8 R2 VM running Oracle 11g DB

Veeam Logoby v.Eremin » Tue May 07, 2013 10:21 am

It seems that you have an error that is similar to ones described in this topic. Try proposed solutions and see whether it helps.

Thanks.
v.Eremin
Veeam Software
 
Posts: 5154
Liked: 354 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Exabot [Bot], robg, Yahoo [Bot] and 14 guests