I’m new using veeam, and our company just decided to use veeam as our backup solution. The 3rd party that setup the backup, is using application oracle agent, so it’s a managed mode as agent was deployed from the VBR.
Backup job is running fine, and I saw that it’s using RMAN to backup the database. However, I don’t see a way to modify the RMAN script veeam is using.
I have couple of questions:
If I want to use recovery catalog, how can I put it in the backup script for the job with veeam managed mode.
How to enable GFS, if I have to retain data for longer term (our requirement is for ex 7 years to retain data)
Is it actually possible to restore from the specific veeam backup files (.vab,.vsm) from RMAN command? I tried to test this to restore specific control file not from the autobackup, as backup information has been deleted from the current control file, but it doesnot able to find it.
I’m new using veeam, and our company just decided to use veeam as our backup solution. The 3rd party that setup the backup, is using application oracle agent, so it’s a managed mode as agent was deployed from the VBR.
Backup job is running fine, and I saw that it’s using RMAN to backup the database. However, I don’t see a way to modify the RMAN script veeam is using.
I have couple of questions:
If I want to use recovery catalog, how can I put it in the backup script for the job with veeam managed mode.
How to enable GFS, if I have to retain data for longer term (our requirement is for ex 7 years to retain data)
Is it actually possible to restore from the specific veeam backup files (.vab,.vsm) from RMAN command? I tried to test this to restore specific control file not from the autobackup, as backup information has been deleted from the current control file, but it doesnot able to find it.
thank you.
Hi @santi welcome in our community.
You can consider a different point of view when use Veeam to protect Oracle databases. Think about backup and restore are managed by a backup administrator and not by a DBA.
In managed mode, from VBR server, is not needed to modify rman scripts and the restores are managed from the console. I try to reply to your doubt:
At the moment is not possible to use a different catalog, on another server for example, where sore restore point.
when you create a backup job is possible to create a copy job to apply your GFS policy (see here)
Consider Veeam create a PITR (Point in time restore). When you start a restore you can choice from different solution as image below
You can generete a New DBID if you want to restore on a different server or database.
During restore task you can see how controlfile, SPFile and all DB files will be restored.
If you want to learn more….
For Managed mode you can see my article:
For unmanaged mode you can check this other one:
@Andanet Hi Antonio, very rich content, I was reading those two additional information that you mentioned. great content. thank you
Thank you @Andanet , I have read the document before. I have tested the restore before with the managed mode, but the one bothers me is I will not know which oldest data that Veaam can restore. Yes, I can choose the date, but it didn’t allow me to see the oldest restore point.
Therefore, if I want to restore database when the backup information has been deleted in the control file, how can I do that with manage mode?
For point no 2: To achieve GFS, the solution is to do backup copy of the backup to other location and apply GFS for that archive? Other way I can think of is to create a VM backup with oracle awareness as that one I can apply for GFS.
easiest was to backup is to use VM backup with application aware processing or for physical servers Veeam agents. You can apply GFS on primary job and on copy job as well. - point 2
Very easy to use, but you cannot use different catalog for restore. - point 1
Extracting data from backup files from point 3 is not possible. But you can open support case and they have internal tool to extract data to continue with recovery from rman to the specific point.
