Re: Apply redo logs?
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