Replicating a DB via archive logging ?
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Wed, 8 Jun 94 16:53:00 -0500
Message-ID: <12a.2528.905.0N3E20E5_at_compudata.com>
Date: Wed, 8 Jun 94 16:53:00 -0500
Message-ID: <12a.2528.905.0N3E20E5_at_compudata.com>
-> to a mirror database on a fairly frequent time interval.
->
-> Is anyone currently doing such a senerio in a production environment
-> ?
Yup. Constantly applying archived transaction logs on a remote database as they are archived. Wasn't easy, but is the BEST backup recovery scheme possible.
I have the remote copy of Oracle in recover mode, and use perl to sit on top of SQLDBA, feeding logs as they arrive. Received on Wed Jun 08 1994 - 23:53:00 CEST