Re: Restore whole from Tape

David McGeorge wrote:
> If you restore All Oracle Folders ( Data, Binary, defaults, etc. )
> from Tape backup in Win 2000 env is it going to work ??

Probably not. There's the small matter of the registry to worry about.

In the event of disaster, I'd almost certainly re-install Oracle, rather than attempt to recover it off tape.

Your database, of course, is a different matter. And the only sensible answer to the "is it going to work" question then becomes "only if your tape backup software knows how to perform Oracle (hot) backups properly, and only if you have kept all redo generated since the time of your last backup".

Basic tape backup software, in short, will not understand Oracle properly, and so hot copies of the database they take so easily will be unusable. Pay enough money, however, and you can buy tape backup software with 'Oracle agents', and they will backup properly.

Or you could learn how to use RMAN, which is free.

> I mean is
> Oracle going to work?
>
> What about app 11i if restore from tape?
 >
> What extra steps neeed to be done if any?
>
> Thanks billions

That's about what I'm tempted to charge! You can't seriously ask such an open-ended question. Fair enough if you provide a few more details, such as the sort of hardware and tape backup software you're using. But even then, the basic answer is: does your software understand Oracle, or is it generic tape backup software?

And as for the extra steps needed to be done: think lots and lots of them, such as testing whatever backup strategy you finally adopt. It's no good, in other words, anyone here saying "yes, that should work" or "no, I don't think that will work properly". Only you can answer that generic a question by finding out for yourself by setting up a test environment, and blowing it up in a multitude of different ways and satisfying yourself that there are no circumstances where you couldn't recover properly.

If you supply a few more details, and ask a few more focussed questions, then this group can certainly lessen the learning curve. But you're ultimately going to have to understand Oracle's recovery mechanisms, and put them to the test with whatever advice you get here.

Regards
HJR Received on Sun Nov 28 2004 - 12:12:40 CST