Re: Editing LogFiles (Was: Hot vs Archive backups in V7 on unix)

In article <1994Jan4.164616.2125_at_exlog.com> lparsons_at_exlog.com (Lee Parsons) writes:
>In article <shatzmanCJ38F6.H9K_at_netcom.com> shatzman_at_netcom.com (Barry Shatzman) writes:
>>
>>the main difference would be how fast you could recover. depending on how
>>much activity there is on your db, a weeks worth of redo logs might take
>>a lot longer than a day's worth
>>
>There is also the problem of extending your liability. Your possible
>points of failure go from N Logfiles to N*7. If any one of them is
>hosed, you have real problems.
>
>
>As a side bar to this, if you have N archive logs to apply and one
>of them is missing, is it possible to make a copy of a good one and
>edit it's header.
>
>Granted this would be a problem for data consistency, But if the
>alternative is rolling back a week...

Ok, you can edit the header and it is happily processed but you get ORA-600 internal errors when you apply the next logfile.

I presume that this is because you are missing the data dictionary info from the lost log file and applying the next log file tries access a row/extents that was never allocated.

Is there an event that you can set to salvage SOME of the data in the logs after this point? Somebody out there must have run into this before. What's the answer?

Is repling to your own posts a form of schizophrenia? Yes (NO) Yes (NO)

-- 
Regards, 

Lee E. Parsons                  		Baker Hughes Inteq, Inc
Oracle Database Administrator 			lparsons_at_exlog.com