Hello,
First time I have to manage backup with Oracle server.
I see there are 3 solutions in the Veeam documentation :
-Agent
-Backup job
-Oracle plugin
Both first are if I want IT to manage backup and last one if I want DBA manage it.
I would like to have some feedback about all these method.
Today my customer only perform dump on his server and then backup the VM (including this dump).
I'm thinking about using Backup job and enable backup log each X min but for this I see DB need to be with archivelog.
Does this mean I need Oracle plugin to be sure I can "regulary" backup my DB ?
I know how it works with SQL but don't know anything about oracle.
Thanks for your help.
-
- Veeam Legend
- Posts: 824
- Liked: 128 times
- Joined: May 11, 2018 8:42 am
- Contact:
-
- Veeam Software
- Posts: 3692
- Liked: 620 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: Oracle backup
Hello,
You don't need to back up logs if ARCHIVELOG mode is turned off (btw it's not recommended as it does not provide proper disaster recovery). If the database works in ARCHIVELOG mode, it definitely makes sense to enable archived redo logs backup. At a very high level, it works in the same way as SQL does: you create consistent backups of the whole server with a specific schedule and you process archived logs every X minutes.
You need to use the plug-in only if the image-level backup does not fit your backup strategy: for example, you back up individual databases using RMAN scripts and have different scripts for every database, you want to process an individual tablespace or a data file, etc.
Thanks!
You don't need to back up logs if ARCHIVELOG mode is turned off (btw it's not recommended as it does not provide proper disaster recovery). If the database works in ARCHIVELOG mode, it definitely makes sense to enable archived redo logs backup. At a very high level, it works in the same way as SQL does: you create consistent backups of the whole server with a specific schedule and you process archived logs every X minutes.
You need to use the plug-in only if the image-level backup does not fit your backup strategy: for example, you back up individual databases using RMAN scripts and have different scripts for every database, you want to process an individual tablespace or a data file, etc.
Thanks!
-
- Veeam Legend
- Posts: 824
- Liked: 128 times
- Joined: May 11, 2018 8:42 am
- Contact:
Re: Oracle backup
Hello,
Thanks for your answer.
If I understand correctly :
Does process transaction logs apply to Oracle DB ?
If ARCHIVELOG is "OFF" => I just need to backup the VM with VBR with AAIP enabled right ? (and I choose to perform copy only for log instead of truncate ? )
if ARCHIVELOG is "ON" => I need to choose process transaction log ? Then on Oracle Tab I have to choose Backup log every X min and Remove older logs based on Hours / Size.
OK, if there is custom backup needed on DB, I have to use the plugin !
Do I understand correctly ?
Thanks for your answer.
If I understand correctly :
Does process transaction logs apply to Oracle DB ?
If ARCHIVELOG is "OFF" => I just need to backup the VM with VBR with AAIP enabled right ? (and I choose to perform copy only for log instead of truncate ? )
if ARCHIVELOG is "ON" => I need to choose process transaction log ? Then on Oracle Tab I have to choose Backup log every X min and Remove older logs based on Hours / Size.
OK, if there is custom backup needed on DB, I have to use the plugin !
Do I understand correctly ?
-
- Veeam Software
- Posts: 3692
- Liked: 620 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: Oracle backup
Hello,
Yes, the "process transaction logs with this job" option also applies to Oracle.
If ARCHIVELOG is "OFF" => Copy-only processing applies to SQL only (this is how we create VSS snapshot which is not the case with Oracle), for Oracle processing it's to enough make sure that the first radio button is selected.
If ARCHIVELOG is "ON" => Yes, you choose process transaction log and define archived logs backup period and deletion policy.
If a "custom" backup is required, the plug-in is a way to go.
Thanks!
Yes, the "process transaction logs with this job" option also applies to Oracle.
If ARCHIVELOG is "OFF" => Copy-only processing applies to SQL only (this is how we create VSS snapshot which is not the case with Oracle), for Oracle processing it's to enough make sure that the first radio button is selected.
If ARCHIVELOG is "ON" => Yes, you choose process transaction log and define archived logs backup period and deletion policy.
If a "custom" backup is required, the plug-in is a way to go.
Thanks!
-
- Veeam Legend
- Posts: 824
- Liked: 128 times
- Joined: May 11, 2018 8:42 am
- Contact:
Re: Oracle backup
Thanks a lot for your feedback 

Who is online
Users browsing this forum: ybarrap2003 and 60 guests