Re: Oracle: how to demonstrate successful restore?

Dominica wrote:

>Of course, if you run hot-standby, you don't have that recovery problem.

Yes, you have _other_ recovery problems. You need to test standby also, some people who have been burned switch it into readable mode every day (or hour). Beyond that, it needs to be fully tested periodically with a full app switchover.

I found one place that was faithfully moving changed code to the standby - but not changed shell scripts!

Another place I discovered was using a combination of backup software and tape compression that would backup within the window, at the cost of making it wayyyyy too slow to restore, the software would make the tape hunt all over for each [I don't know what, smaller than a file], making the restore go on for days, rather than just blasting it all back onto the DR machine. Which is why to this day I'm kinda weird about wanting the occasional cold dumb backup.

Mladen, we hate you _because_ we love you! :-) (You ought to take that write-up, generalize it, and add it to a faq or the dizwell wiki).  Good point making the distinction between doing a DR plan right and learning recovery techniques. I have fallen into the "trying to answer their question and oversimplifying the answer until it is wrong" trap in this thread.

jg

--
@home.com is bogus.
"People are always going to find a way around us."
http://www.signonsandiego.com/uniontrib/20060127/news_1n27tunnel.html