Re: recovery question...

try restoring your last cold backup then recovering to point in time with the archive logs just before you had the table updates

john b

At 01:38 PM 8/11/00 -0800, Roy Ferguson wrote:
>
>running 8.0.5.2.1 on solaris 2.6...
>
>an individual updated 29 thousand rows in a table then comitted and closed
>out...this should not have happened...we have a cold backup done every
>wednesday
>evening...and are in archivelog mode...I'm think about exporting this table
>after creating a test instance from the cold backup on wednesday...droping
the
>table in production..and importing into production...losing just over a days
>work...
>
>any other recovery solutions that comes to mind will be much appreciated...
>
>roy
>
>--
>Author: Roy Ferguson
> INET: rferguso_at_level1.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 Fri Aug 11 2000 - 18:04:57 CDT