Data Guard Issue
Date: Wed, 28 Aug 2024 14:12:40 +0000
Message-ID: <CH3PR16MB589789EF9AED84553B417E18C5952_at_CH3PR16MB5897.namprd16.prod.outlook.com>
We are running Oracle 19.23. We have a data guard configuration that isn't working. About 2 months ago, someone changed the secondary to a snapshot standby instead of a physical standby. That was just discovered and it's too late to recover all the now missing archive logs (backups are only kept for 30 days). I tried to restore the database from the primary via an RMAN backup/recovery. That appears to have worked. Now the archive logs are being brought over, but not applied. The secondary says it's a physical standby, but cloud control says it's still a snapshot standby. When I tried to recover it, I get an ORA-01153. I also noticed that the MRP0 is waiting for log 1, which doesn't exist. I've been searching online and nothing is working. Of course this is a critical production database.
How do I get this data guard mess straightened out?
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
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING 1 140772 411648 298 DGRD ALLOCATED 0 0 0 0 DGRD ALLOCATED 0 0 0 0 ARCH CLOSING 1 140773 411648 1219 ARCH CONNECTED 0 0 0 0 ARCH CONNECTED 0 0 0 0 RFS IDLE 1 0 0 0 RFS RECEIVING 1 140774 258804 2 MRP0 WAIT_FOR_LOG 1 1 0 0
9 rows selected.
SQL> select sequence#, archived, applied from v$archived_log order by sequence#;
SEQUENCE# ARC APPLIED
---------- --- ---------
140768 YES NO
140769 YES NO
140770 YES NO
140771 YES NO
140772 YES NO
140773 YES NO
6 rows selected.
SQL> recover standby database;
ORA-01153: an incompatible media recovery is active
Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | 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.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 28 2024 - 16:12:40 CEST