restart the standby and check the status in dgmgrl. If that doesnt do it,
issue the convert command from within dgmgrl and see what it does.
On Fri, Nov 18, 2022 at 1:19 PM Scott Canaan <srcdco@xxxxxxx> wrote:
We have a production database set up with data guard. This morning, I ran
a script to refresh a test version using the standby. To do this, we
change the standby to a snapshot standby, copy the data, then change it
back to a physical standby. At the end of the script, it didn’t change
back to a physical standby.
I manually changed it back using the “alter database convert to physical
standby” command, followed by “alter database recover managed standby
database disconnect from session”. Both appeared to work and it looks like
logs are being shipped and applied. But cloud control and dgmgrl both say
it isn’t good. Cloud control says that it is a physical standby, but when
I dig into it, it gives an ORA-16816: incorrect database role and
ORA-16782: instance not open for read and write access.
This is what dgmgrl says:
DGMGRL> show configuration
Configuration - CLAWPRDA
Protection Mode: MaxPerformance
Members:
CLAWPRDB - Primary database
CLAWPRDA - Snapshot standby database
Error: ORA-16810: multiple errors or warnings detected for the member
Fast-Start Failover: Disabled
Configuration Status:
ERROR (status updated 51 seconds ago)
This is what the database itself says:
SQL> select status,instance_name,database_role,open_mode from
v$database,v$Instance;
STATUS INSTANCE_NAME DATABASE_ROLE OPEN_MODE
------------ ---------------- ---------------- --------------------
MOUNTED CLAWPRDA PHYSICAL STANDBY MOUNTED
So which is correct? How do I get them all to agree?
This is Oracle 19c (19.16) on Red Hat 7.
*Scott Canaan ‘88*
*Sr Database Administrator *Information & Technology Services
Finance & Administration
*Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
*srcdco@xxxxxxx <srcdco@xxxxxxx>* | c: (585) 339-8659
*CONFIDENTIALITY NOTE*: The information transmitted, including
attachments, is intended only for the person(s) or entity to which it is
addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any
action in reliance upon this information by persons or entities other than
the intended recipient is prohibited. If you received this in error, please
contact the sender and destroy any copies of this information.
