Re: Apply redo logs?

From: William Lee <william.lee_at_cwolhk.com>
Date: 1995/08/18
Message-ID: <9508190454246838_at_cwolhk.com>#1/1


Hi,

>From: wgriedy_at_mailbox.syr.edu (William G. Riedy)
>Subject: Apply redo logs?
 

>I am the DBA of both an Oracle and a MS SQL Server system. I am fairly
>certain that what I am about to ask can not be done but I need to ask
>the question anyway.
 

>Is there a way in Oracle to apply the redo logs to a server if there has
>NOT been a disaster on your server (e.g. media failure)?
 

>Why am I asking this? Well my Oracle system is a mission critical OLTP
>system and I am looking for ways to minimize my down time in the event
>of a disaster. The scenario that I am cooking up in my head involves
>having 2 machines, one being the true production server and the other
>being a warm backup machine. Warm in the sense that it requires manual
>intervention to make it into the production system, and it may not have
>absolutely the most recent transactions, perhaps missing the last 15-30
>minutes of transactions.
 

>In MS SQL Server this is entirely feasible. With MS SQL server you can
>apply the transaction log dumps to another database (on the same or
>another machine).
 

>A reply via email would be greatly appreciated.
 

>Thanks in advance,
>William G. Riedy
>Niagara Mohawk Gas
>wgriedy_at_nmgas.com

>

William.
william.lee_at_cwolhk.com
___
* UniQWK #5138* Have you ever listen to Yukie Nishimura's music? Received on Fri Aug 18 1995 - 00:00:00 CEST

Original text of this message