oracle vm backup

[jnsvano]

Hello,

Any ideas, how can I backup Linux vm with Oracle db inside through vdp (or with any other solution) ? Main problem is db is often broken after restore.

[daphnissov]

That's because you're probably not using the correct scripts to prepare Oracle for backup. Backup applications like Veeam (and others) can correctly protect Oracle and ensure application consistency upon recovery. If you wish to roll your own, there are pre-freeze and post-thaw scripts out there to integrate with VMware Tools which can prepare the DB correctly.

[jnsvano]

Thanks for reply. I googled those pre-freeze and post-thaw scripts, and it seems that all are using alter database backup statement, thus meaning database must in archivelog mode ?

[daphnissov]

Correct