Skip to Main Content
  • Questions
  • Periodically Test Recovery Procedures


Question and Answer

Connor McDonald

Thanks for the question, Eliomar.

Asked: November 18, 2020 - 5:10 pm UTC

Last updated: November 23, 2020 - 6:29 am UTC

Version: 19c

Viewed 100+ times

You Asked

Hello Team,

I need to document our RMAN backup and restore best practices, and I'm struggling to answer the question:

How often (months, years, etc.) should we test our restore procedures? (max time between restores, at least "RESTORE... VALIDATE")


Here an old document:

and we said...

I'll propose a slightly different metric.

"Test" (and improve) your RMAN restore/recovery processes so that you can get a non-technical person to do it via running a single command at a terminal (because one day, that might be one you need to do).

If you can get your process so that it resembles:

Enter the last moment in time everything was fine (YYYY/MM/DD HH24:MI:SS)
(Default will be to try recover as up to date as possible)

Then now you have something you can test at *any* frequency you want, and in particular get anyone to test it for you, or even make it an automated test. Its a fantastic level to strive for.


  (1 rating)


... and you then fork these tests out to Finance/Controlling/Auditors Depts

Christian Klammer, November 27, 2020 - 7:32 am UTC

... and then you are able to fork out these tests out to Finance/Controlling/Auditor Depts.

Auditors love this stuff: they live for it ;-) ... and they will document everything they do very carefully, too.

Means you will have an other department doing your work off your budget ... :-)

More to Explore


Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.