Re: DR test Ideas

I can second that - we do this frequently without any issues as well - just use the old-school commands with the dg broker.

Niklas Iveslatt
Senior Partner

Arisant LLC ~ http://www.arisant.com
44 Inverness Dr. E Bldg. C Suite 2 ~ Englewood, CO 80112 mobile: 303.882.4461 ~ main: 303.330.4065 ~ fax: 888.889.0155

  Need to send me something securely? *Click here* <https://arisant.sendsafely.com/u/niklas.iveslatt>

On Thu, Oct 26, 2023 at 6:52 AM Ludovico Caldara <ludovico.caldara_at_gmail.com> wrote:

> The control plane does not have yet support for snapshot standby or
> multiple standby databases.
> But... there should be no problem with temporarily converting the standby
> database to a snapshot standby MANUALLY.
> You will just get warnings in the control plane (database "Yellow" or
> "Red") because the status is not the one expected.
>
> You can also still have multiple standby databases by configuring Data
> Guard manually. In that case, you probably want to skip the automatic Data
> Guard association and configure Data Guard manually from scratch.
> I know it's not fully automated, but it seems more reasonable than the
> steps you are actually doing :-)
>
> Il giorno mer 25 ott 2023 alle ore 07:53 Ethan Post <post.ethan_at_gmail.com>
> ha scritto:
>
>> This is database as a service not ATP so I think it is different then the
>> link. Oracle support stated in support ticket the snapshot standby not
>> supported. We found a solution. Clone PRD in ASH. create DG standby for the
>> clone in PHO, activate the new standby, clone the activated standby in PHO
>> into the new VCN. The entire DR is a poor design in my opinion but we got
>> it working and it was fairly easy, all can be done via OCI control panel.
>>
>> On Tue, Oct 24, 2023 at 10:00 PM Al B. <albert.y.balbekov_at_gmail.com>
>> wrote:
>>
>>>
>>> ATO and ADW have Autonomous Data Guard, which lists converting to
>>> snapshot standby for up to 24hrs as possibility for cross-region standby.
>>>
>>> Does this not work ?
>>>
>>>
>>> https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-data-guard.html#GUID-2AFA2C06-BBD9-496E-94B9-B3C54EC567D1
>>>
>>> Thanks,
>>> Albert
>>>
>>> On Tue, Oct 24, 2023 at 9:47 AM Jon Crisler <joncrisler_at_gmail.com>
>>> wrote:
>>>
>>>> Is this a OCI limitation ? I would think they fully support Snapshot
>>>> databases.
>>>>
>>>> On Mon, Oct 2, 2023 at 10:42 AM Ethan Post <post.ethan_at_gmail.com>
>>>> wrote:
>>>>
>>>>> Here is the problem. Customer wants to test DR in PHO datacenter on
>>>>> Oracle OCI. They have Have primary and Oracle configured data guard
>>>>> standby. Primary in ASH and standby in PHO. Oracle does not support opening
>>>>> the standby in snapshot mode and as far as I can tell it doesn't work
>>>>> anyway, at least on the instance I am working on.
>>>>>
>>>>> What are some possible ways to get a copy of the standby database into
>>>>> an isolated VCN and open it up or make that data available for testing?
>>>>>
>>>>> ALso Oracle only allows one standby from within the OCI control panel
>>>>> per database.
>>>>>
>>>>

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