Re: Shadowing ORACLE7
Date: 1995/10/27
Message-ID: <46qph5$cpo_at_lyra.csx.cam.ac.uk>#1/1
svachon_at_mais.hydro.qc.ca (Stephane Vachon) wrote:
>Hi,
>
>Just wondering if there is a way to have a shadow
>database of Oracle version 7.1 under Novell 4.1
>or Solaris 2.3.
One way is to use archive logs.
Run the production database in archivelog mode. Create the shadow database from an online backup of the production database. Have the shadow database continuousy executing the RECOVER DATABASE UNTIL CANCEL command. Feed it archive logs as the production database produces them. (See ALTER DATABASE RECOVER LOGFILE filename).
When the production database fails, cancel the recovery of the shadow. It will be as up-to-date as anything which could have been made by recovering a backup, but available much more quickly.
Charles Jardine, University of CAmbridge Computing Service Received on Fri Oct 27 1995 - 00:00:00 CET