Discussions specific to the VMware vSphere hypervisor
Post Reply
hsm
Lurker
Posts: 2
Liked: never
Joined: Feb 06, 2015 11:55 am
Contact:

Oracle 12c Database Backup with VSS

Post by hsm » Feb 06, 2015 12:07 pm

Hallo!

In an testing environment I tried to backup and restore an oracle 12c databse with VSS. It works like a charm, but everytime I recover the whole machine, the database is running, but all schemas are in backup mode and I have to put them back to online mode.

My question is now - Is this behaviour "normal" and do I get a consistence backup of all data at time of the snapshot? - If not, are there any further steps I have to take after recovery?

Thanks in advance!
Steeve

dellock6
Veeam Software
Posts: 5734
Liked: 1626 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: Oracle 12c Database Backup with VSS

Post by dellock6 » Feb 06, 2015 12:50 pm 1 person likes this post

Hi,
for what I know this is expected behaviour. conistency is guaranteed by VSS that puts the databasefiles in hot backup mode and stop writing to online redo logs. During restore, you are epxected to bring the database back in original position and afterwards execute e reset logs operations. If you also backup archive logs and then have them available, yo can do point in time restore, otherwise oracle will just replay the redo logs to the last point stored in them.
You can find additional info here:
http://docs.oracle.com/cd/B28359_01/win ... 10/vss.htm
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2019
Veeam VMCE #1

hsm
Lurker
Posts: 2
Liked: never
Joined: Feb 06, 2015 11:55 am
Contact:

Re: Oracle 12c Database Backup with VSS

Post by hsm » Feb 10, 2015 2:57 pm

Hello Luca,

thank you very much for you reply! - It's good to know that my setup is working correctly and as expected.

Steeve

killingworth
Lurker
Posts: 1
Liked: never
Joined: Mar 31, 2015 7:13 am
Full Name: Kevin Illingworth
Contact:

[MERGED] Backup Oracle VM

Post by killingworth » Mar 31, 2015 11:04 am

Hi

Please can someone help me I have a VM (VMWare) that I need to backup using VEEAM it is hosting an Oracle database which can not be taken offline as it runs our production within the factory is they a way in which you can do this ?

Shestakov
Veeam Software
Posts: 6974
Liked: 715 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Oracle 12c Database Backup with VSS

Post by Shestakov » Mar 31, 2015 11:48 am

Hi Kevin,
It is possible without shutting the application down. What version of Oracle Database are you using?
Thanks.

Post Reply

Who is online

Users browsing this forum: Baidu [Spider] and 16 guests