Re: Is Automated Recovery Possible?

Rich,

    I have successfully automated refreshes from 'COLD' backups -- BUT -- as you have experienced -=- from a 'HOT' is unpredictable as you can not control logging during the "HOT'. You might want to reevaluate the rationale of a daily refreshed test environment. In our environment, on the other hand, our developers have convinced management that 10 copies of production are required for them to 'do their thing'. Consequently, I take a 'COLD' backup on Sundays and then propagate as required or requested. I automate this (mostly) although there are some exceptions where different objects etc. are required for some development environments. Might consider some variation of managed standby database - although you would still need a 'COLD' to create the initial standby.

    Best of luck. I would be interested to hear if you achieve your goal. I will continue to experiment myself and publish the results.

Regards,

Chris Royce

"Jesse, Rich" wrote:

> Hi,
>
> We've got a test database (O8.0.5 on HP/UX 10.20) that is created nightly
> from a Production hotbackup. As you might guess, recovery is necessary to
> rebuild control files and redo logs. The problem is how to do the recovery
> automatically and consistently.
>
> The procedure I've created (and am using) recovers a single archived log
> ("RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL") and opens the
> instance. While this works fine most of the time, it's not working more
> often these days. The test database isn't opened, and our early-AM users
> (who get into work hours before us DBAs do) complain.
>
> I've thought about doing a point-in-time recovery, but a few tests haven't
> been successful. I've attempted to recover the database to about one hour
> after the hot backup was completed, but I keep getting an error like
> "recovery was successful, but datafile # needs more recovery to be
> consistent". Of course, I can't find the ORA- numbers to go with the
> errors, and it's been a few days since I've been able to attempt the
> recovery manually.
>
> Has anyone done an automated recovery like this? How?
>
> Rich Jesse System/Database Administrator
> rjesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
>
> -----------------------------------------------------------------------
>
> This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 07 2000 - 13:54:28 CDT