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<mailto: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.