Oracle Backup - Howto handle crash recovery ?

Availability for the Always-On Enterprise

Oracle Backup - Howto handle crash recovery ?

Veeam Logoby cxwsrei » Wed Jun 28, 2017 12:24 pm

Hi all

I´m testing oracle backup - works.
But what about crash recovery ?
Example:
Made a backup at 11:00.
Database got lost at 15:00, needs a full recovery (restore).
Log files that has been generated after 11:00 until 15:00 are still available.
Restore works (tested) but logs after 11:00 has been deleted !?!
But I like to recover the database until the point in time it got lost (15:00).
How to handle this ?
cxwsrei
Influencer
 
Posts: 15
Liked: 1 time
Joined: Mon May 22, 2017 1:18 pm

Re: Oracle Backup - Howto handle crash recovery ?

Veeam Logoby v.Eremin » Wed Jun 28, 2017 3:04 pm

If the logs are still available, you can replay them on VM restored from image level backup, using Oracle native tools.

If logs have been captured by VB&R (oracle logs backup job), feel free to replay them, leveraging Veeam Explorer for Oracle.

Thanks.
v.Eremin
Veeam Software
 
Posts: 13428
Liked: 987 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Oracle Backup - Howto handle crash recovery ?

Veeam Logoby cxwsrei » Wed Jul 05, 2017 7:59 am

I see. I can replay all logs THAT ARE UNDER CONTROL by veeam.
Consequently it depends on the frequency to backup database log files setup in the backup job which logs can be used for recovery.
"Only" log files that are already on the OS level but still has not been backed up by veeam cannot be replayed (when for a restore veeam is used).
In this case I consider my question as answered.
Thank you for the feedback.
cxwsrei
Influencer
 
Posts: 15
Liked: 1 time
Joined: Mon May 22, 2017 1:18 pm

Re: Oracle Backup - Howto handle crash recovery ?

Veeam Logoby v.Eremin » Wed Jul 05, 2017 11:31 am

Correct, logs that have been backed up by backup server can be replayed by backup server. Anything happened outside of backup server is out of its control. Thanks.
v.Eremin
Veeam Software
 
Posts: 13428
Liked: 987 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 62 guests