Re: DG for nologging

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 6 Mar 2018 07:56:42 -0600
Message-ID: <CAJvnOJY9qbEAWcsqR_7xLGgreWBYTf4tEH1d-azmqJvR5hJz6g_at_mail.gmail.com>



Are you saying its not in force logging? Or do you mean that its not in archivelog mode. If its not in archivelog mode there is nothing you can do. You cant even recover the database to a point in time.

On Tue, Mar 6, 2018 at 6:11 AM, 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.
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 06 2018 - 14:56:42 CET

Original text of this message