Hello to the board !
I'm writing this because I'm a bit unsure about the backup options one has for Oracle with Veeam B&R especially for the Standard Edition.
Maybe someone can clarify a little bit.
The scenario I'm thinking about:
VMware will be used for hosting the VMs
Amongst these will be a Windows DB Server running Oracle (10, 11, 12) where ArchiveLog mode is disabled
I want to take a single daily (nightly) backup.
Goal is to have the ability of a full restore of the entire VM, which covers it's state at backup time and runs "out-of-the-box" after restore.
As far as I've seen even on Standard Edition I can set credentials for Oracle.
But what effect will this have ?
Will this on Standard Edition give me a consistent backup at all ?
Will this give me a consistent backup in any case ?
The last question is, because I often read Oracle needs to have ArchiveLog enabled to do a consistent backup with Veeam.
In case the answer to my above questions is "no":
Will it be sufficent to stop the Oracle Service(s) for the database instance(s) by script during the backup, to have a consistent one, which I can restore "out-of-the-box" ?
Or do I have to stop all other Oracle services too (e.g. Listener, MTSRecoveryService) ?
I'm looking forward to your answers
Best Regards CT