Re: DR test Ideas

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