Fast backup/recovery solution

[former_member598597]

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

[michael_schlosser]

Hi Ross,

from my prospective it is only possible to do it on the Storage Software Layer. NetApp is doing this for years with our Storage Systems. Providing excellent RPO and RTO through Snapshot / Cloning / Replication Technology and enhance SAP Operations.

Might be interesting for you: https://www.youtube.com/watch?v=ZH84RMeXWL8

Kind Regards

Michael

[former_member598597]

Michael

I've come back to looking at this requirement again for a fast backup and recovery. I've started looking at the NetApp SnapCenter Plug-in for Oracle.

In order to take a snapshot backup of Oracle, does NetApp/SnapCenter need to 'quiesce' the database at Oracle level?

Thanks
Ross

[janos_mucsi-besze]

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"

[former_member598597]

Thanks Janos, will take a look at that.

Regards
Ross