+1 for SAN replication.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Purav Chovatia
Sent: Tuesday, March 6, 2018 9:08 AM
To: nagaraj.chk@xxxxxxxxx
Cc: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>; oracle-l@xxxxxxxxxxxxx
Subject: Re: DG for nologging
CAUTION - EXTERNAL EMAIL
3 other solutions that I can think of, apart from SAN replication, are: 1.
exp/imp on a regular basis. 2. Write custom scripts to pull the data out and
put it in the DB on standby side. 3. Change the app such that it writes on both
sides (this looks challenging but can be done and depends on scope to a good
extent; we did it to one of our apps).
On 6 Mar 2018 7:23 pm, "Nagaraj chk"
<nagaraj.chk@xxxxxxxxx<mailto:nagaraj.chk@xxxxxxxxx>> wrote:
We will not be able to make database force logging (due to various reason), in
that case do we have any other solution apart from DG or OGG.
-Naga
On Tue, Mar 6, 2018 at 5:41 PM, Norman Dunbar
<oracle@xxxxxxxxxxxxxxx<mailto:oracle@xxxxxxxxxxxxxxx>> wrote:
Hi Naga,
Unless I misunderstand, then simply run this:
Alter database force logging;
You can do this at any time.
It is one of the pre-requisites for setting up DG/Standby databases anyway.
Once done, you can proceed to build the standby in the normal manner. Rman is
good for that.
HTH
Cheers.
Norm.
On 6 March 2018 11:20:00 GMT+00:00, Nagaraj chk
<nagaraj.chk@xxxxxxxxx<mailto:nagaraj.chk@xxxxxxxxx>> wrote:
hi Gurus,
We have a database which is in TB of size with no logging option enabled , we
have requirement to setup DR to ensure the data is protected on any disaster ,
Since the database in nologging mode we will not be able to setup DataGuard or
OGG. In this situation please guide on any feasible solutions
-Naga
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
