Re: Oracle Automated DB Restore

CS wrote:

> Hi,
>
> Is there anyone has thought about automated DB restoration?
> Automated backup I have heard a lot and have it scheduled and running
> every night but regarding the restoration, I just
> know about it is done by the manual way (copy/restore backup from
> production server, recover/apply log, bring up DB, etc...)
>
> If I want copy the production database backups from it's server to my dev
> server and have it done automatically, eg execute one script/command (in
> Windows 2000 environment), is there any good input on this, like using
> tools available in market ?
>
> DB size: 100GB
> Oracle EE 8i
> Backup with RMAN
>
> Thanks !

RMAN does both, and would suit your purposes. But a generic fully automated restore that covers all recovery situations can be a bit tricky (look up the definition of restore in the Backup Recovery manual and you'll understand why I say this.)

You might want to change your tactic a bit and investigate Oracle's Data Guard. That's designed to accomplish pretty well what you want.

/Hans Received on Sat Sep 25 2004 - 12:52:11 CDT