RE: Disaster Recovery solutions for Oracle...
From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Mon, 23 May 2011 11:25:32 +0300
Message-ID: <OFA9F053B2.F9953048-ONC2257899.002C9898-C2257899.002E489A_at_seb.lt>
>Jorgensen, Finn
>You can do what everybody did before DG was available (i.e Oracle 7 & 8) :
write your own set of scripts that ships archivelogs to the standby server where you have a database in mount mode and another script that looks for archived logs to arrive and then performs recovery.
Date: Mon, 23 May 2011 11:25:32 +0300
Message-ID: <OFA9F053B2.F9953048-ONC2257899.002C9898-C2257899.002E489A_at_seb.lt>
>Jorgensen, Finn
>You can do what everybody did before DG was available (i.e Oracle 7 & 8) :
write your own set of scripts that ships archivelogs to the standby server where you have a database in mount mode and another script that looks for archived logs to arrive and then performs recovery.
Talking about "no transactions lost" solution what about online redo logs? With DG you can have a real time (synchronous) redo shipping mode (Oracle's talk Maximum Availability or Protection)
In principle, redo logs can be replicated(mirrored) at file system level. But it costs a license too. If you buy that then the whole database can be implemented as active-passive cluster too. DG is not even necessary then. Does there exist some pure man's file system metro-mirroring solutions?
Brgds, Laimis
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 23 2011 - 03:25:32 CDT