hi,
If tester needs only few tables from production
then I would just write import/export script.
Which truncates tables every night in test and
relaods them from prod.
Why go through recovery every morning !!
..Ashish
- "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> 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 - 14:16:33 CDT
