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

From: Lee Parsons <lparsons_at_exlog.com>
Date: Tue, 4 Jan 94 16:46:16 GMT
Message-ID: <1994Jan4.164616.2125_at_exlog.com>


In article <1994Jan4.163935.27327_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...

-- 
Regards, 

Lee E. Parsons                  		Baker Hughes Inteq, Inc
Oracle Database Administrator 			lparsons_at_exlog.com 
Received on Tue Jan 04 1994 - 17:46:16 CET

Original text of this message