Re: Oracle: how to demonstrate successful restore?

Tiffany:

You definitely need to have a test environment set up separate from your production environment. (Even then I've seen people screw up and get fired because the front ends can look so similar).

If you have metalink access, type in "recovery scenarios" in the knowledge browser. Plenty of ideas scattered about there, especially if you run across the scenarios they use in the classes (and note: 62385.1 is a pretty decent list of basic things to try). Recovery is _the_ most significant dba skill, and you are right to recognize that you don't have valid backup procedures unless they've been tested. You need to know it cold for when you need it for real.

jg

-- 
@home.com is bogus.
http://www.rathergood.com/independent_woman/