How to restore Oracle Logfiles?

Availability for the Always-On Enterprise

How to restore Oracle Logfiles?

Veeam Logoby SvenConrad » Wed Jul 12, 2017 6:59 am

Hello,

a few weeks ago I started to include the Oracle database of one of our SAP developement systems in the Veeam bacup. So far we backed up the Oracle Database and its logfiles using brbackup (SAP).
I configured a daily Incremental, weekly full and Log backup every 15 minutes. Logs older than 24h are deleted after the Full/inc backup:

Image

Everything is going well so far. VSS is working flawlessly, the backup is fast and relyable. Haven't tested a restore yet, but will soon.

My only Problem so far: How the hell can I get the logs back? I can see that .vlb files are created regulary:

Image

I guess I would be able to restore the database to any point covered by the logs using Veeam in case of trouble. But what if I needed a log for another purpose, like a database recovery? Is there any way to get the logs back as a file? This would really put my mind at rest...
SvenConrad
Novice
 
Posts: 3
Liked: never
Joined: Mon Feb 20, 2017 9:38 am
Full Name: Sven Conrad

Re: How to restore Oracle Logfiles?

Veeam Logoby DGrinev » Wed Jul 12, 2017 12:07 pm

Hi Sven,

You should use File-Level Restore to obtain a log as a file from the VM backup. Thanks!
DGrinev
Veeam Software
 
Posts: 532
Liked: 63 times
Joined: Thu Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev

Re: How to restore Oracle Logfiles?

Veeam Logoby SvenConrad » Wed Jul 12, 2017 1:37 pm

Alright, thank you. I already feared that this would be the answer. Guess I'll activate Guest file indexing and maybe I'll keep the logs a bit longer than 24h on the Server and this might suffice.
Maybe I'll deactivate the Redo Log backup in Veeam instead and return to BRbackup for the Logs. But that would mean a bit of manual Oracle-aftermath if restoring a complete database to the last available point...

You can see this as a feature request: A dialog that lists all log files that have been collected by a Redo Log Backup job and gives you the possibility to restore them as a file.
SvenConrad
Novice
 
Posts: 3
Liked: never
Joined: Mon Feb 20, 2017 9:38 am
Full Name: Sven Conrad

Re: How to restore Oracle Logfiles?

Veeam Logoby DGrinev » Wed Jul 12, 2017 4:56 pm

Sven,

Please keep in mind FLR allows you to get log files from the daily restore points, not from the truncated every 15 minutes transaction logs.
So, if you want to restore logs as files from the 15 minutes transaction logs, it's not possible. Thanks!
DGrinev
Veeam Software
 
Posts: 532
Liked: 63 times
Joined: Thu Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google [Bot], nmdange, Yahoo [Bot] and 70 guests