Re: OCI Dataguard - Can not open standby snapshot

Hi Ethan,

I’m not quite sure I fully understood your post but here goes..

1. You should be able to clone from a standby via Rman.
2. The convert may be hanging due to network issues. I’ve found that even when we have a missing tnsnames.ora entry at the oci the sqlplus connection attempt just hangs. It doesn’t come back with a tns error!!

Cheers,
Leng

> On 20 Sep 2023, at 11:40 pm, Ethan Post <post.ethan_at_gmail.com> wrote:
>
> 
> I have a data guard database which the command hangs when I try to convert the database to snapshot standby in DGMGRL. I have tried taking a snapshot and activating the database, also hangs. I have tried ALTER DATABASE CONVERT TO SNAPSHOT STANDBY; which also hangs.
>
> I checked alert log and .trc and didn't see anything stick out. What are some things I could do to try to diagnose this?
>
> I have a ticket open with Oracle but we are in the first 24 hour/no help what-so-ever stage of that ticket.
>
> The goal, by the way, is to get data from this STBY to another database in another VCN. I would prefer to clone it but you can't clone a DG STBY. Not sure if you can clone it if it is a snapshot standby. Network connectivity is not available between the two, at least not easily, we will be swinging disk for any media that moves over. Going with full dp export/import for now which is not my preference by a long shot. Don't ask what is being tested. Customer driven and no basis in reality whatsoever.
>
> Regards,
> Ethan

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