RE: DG for nologging

From: Sheehan, Jeremy <JEREMY.SHEEHAN_at_fpl.com>
Date: Tue, 6 Mar 2018 14:15:01 +0000
Message-ID: <7cb9c23ea5d94baeb12c11a1137a8929_at_fpl.com>



+1 for SAN replication.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Purav Chovatia Sent: Tuesday, March 6, 2018 9:08 AM
To: nagaraj.chk_at_gmail.com
Cc: Norman Dunbar <oracle_at_dunbar-it.co.uk>; oracle-l_at_freelists.org 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_at_gmail.com<mailto:nagaraj.chk_at_gmail.com>> 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_at_dunbar-it.co.uk<mailto:oracle_at_dunbar-it.co.uk>> 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_at_gmail.com<mailto:nagaraj.chk_at_gmail.com>> 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.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 06 2018 - 15:15:01 CET

Original text of this message