Skip to Content

Fast backup/recovery solution

Hi all

Just wondering what backup solutions people are using for large Oracle systems that enable a fast recovery?

As far as I can see, only flash copy type solutions are able to offer 'rapid' recovery. We looked at Oracle's Zero Downtime Recovery Appliance, but ultimately that's still doing a full database restore which, even over a 16GB fibre channel link, will still take a fair amount of time. Is there any backup product out there that only recovers changed blocks? We thought Actifio did something like that but essentially that's a 'intermediate' solution and although you can mount it up and run from it almost immediately, you've still got to recover your database to the original disk area in the background.

Other options we've looked at are standby/delayed standby/Oracle Flashback etc to be able to switch to quickly and also provide 'rollback' in the event of data corruption / accidental data deletion etc.

Any other solutions out there we've not thought about?

Essentially need fast recovery (minimal RPO and RTO times) and the ability to recover to a PIT before corruption/data deletion.

Thanks
Ross

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 28, 2018 at 01:21 PM

    Hi Ross,

    As of Oracle 12c (I believe 12.2) RMAN provides a command to restore and recovery datafile(s) from a Standby database. This is called

    "RMAN Network Restore". It enables a really fást restore/recover compared to the regular solutions.

    Have a look at the documentation here:

    https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV684

    Just follow Section "Restoring and Recovering Files Over the Network"


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.