Re: Is Automated Recovery Possible?

PS

The other problem you are encountering re: 'point in time recovery' ??? to the best of my knowledge you cannot recover - point-in-time - if the time period is within the time frame of the hot backup - It is necessary to apply all generated redo which was generated while a tablespace was in backup mode.

OK BYE 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:59:03 CDT