Re: DG for nologging

We have NetApp as well. You can use SnapManger for Oracle or their new production SnapCenter to take a snapshot backup of your database and then SnapMirror can automatically mirror that to your DR SAN. Now your DR database will only be as good as your last snapshot so if you want to minimize data loss you might want to think about shipping your archive logs files to DR or using SnapMirror for your archive log volume as well. This is what we do for our Standard Edition database where we can't using Data Guard. For Enterprise databases we use Data Guard instead and not SnapMirror. This is assuming you are in archive log mode. If not well then your snapshots will require database down time.

Jeff

On Tue, Mar 6, 2018 at 9:32 AM, Harel Safra <harel.safra_at_gmail.com> wrote:

> NetApp have a licenseable feature call SnapMirror that will replicate
> volumes between NetApp Filers - both synchronously and a-synchronously.
>
> Harel
>
> On Tue, Mar 6, 2018 at 7:20 PM, Nagaraj chk <nagaraj.chk_at_gmail.com> wrote:
>
>> Yea, thanks for sharing the link. We use Netapp as storage device, So any
>> solution feasible in Netapp storage level replication ?
>>
>> On Tue, Mar 6, 2018 at 7:26 PM, Stefan Knecht <knecht.stefan_at_gmail.com>
>> wrote:
>>
>>> You can do replication at the SAN level. Many solutions are out there,
>>> for example:
>>>
>>> https://www.emc.com/collateral/white-papers/h12079-vnx-repli
>>> cation-technologies-overview-wp.pdf
>>>
>>>
>>>
>>> On Tue, Mar 6, 2018 at 8:52 PM, Nagaraj chk <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>
>>>> 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>
>>>>> 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.
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> //
>>> zztat - The Next-Gen Oracle Performance Monitoring and Reaction
>>> Framework!
>>> Visit us at zztat.net | Support our Indiegogo campaign at
>>> igg.me/at/zztat | _at_zztat_oracle
>>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l