Home -> Mailing Lists -> Oracle-L -> RE: Data Guard Issue

RE: Data Guard Issue

From: dimensional.dba <"dimensional.dba">
Date: Wed, 28 Aug 2024 12:14:12 -0700
Message-ID: <0f9f01daf97e$789b4c50$69d1e4f0$_at_comcast.net> 








ON STANDBY


Rman



Connect / as sysdba



list incarnation;

 



select FILE#,ERROR,RESETLOGS_CHANGE#,RESETLOGS_TIME from v$datafile_header;



select distinct RESETLOGS_CHANGE# from v$archived_log;

 

 

 



From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Scott Canaan ("srcdco")
Sent: Wednesday, August 28, 2024 12:01 PM
To: Andrew Kerber <andrew.kerber_at_gmail.com>
Cc: Oracle-L Freelists <oracle-l_at_freelists.org>
Subject: RE: Data Guard Issue

 



This looked like it was going to work, until the very end when it got an error:

 



starting media recovery



media recovery failed


RMAN-00571: ===========================================================





RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============



RMAN-00571: ===========================================================





RMAN-03002: failure of recover command at 08/28/2024 14:54:27



RMAN-03015: error occurred in stored script Memory Script



ORA-00283: recovery session canceled due to errors



RMAN-11003: failure during parse/execution of SQL statement: alter database recover



if needed standby start



ORA-00283: recovery session canceled due to errors



ORA-19909: datafile 1 belongs to an orphan incarnation



ORA-01110: data file 1: '/oracle/data/CLAWPRDA/sys01.dbf'

 

 



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.

 



From: Andrew Kerber <andrew.kerber_at_gmail.com <mailto:andrew.kerber_at_gmail.com> > 
Sent: Wednesday, August 28, 2024 1:16 PM
To: Scott Canaan <srcdco_at_rit.edu <mailto:srcdco_at_rit.edu> >
Cc: Oracle-L Freelists <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org> >
Subject: Re: Data Guard Issue

 



try this:  on the standby side:

 



dgmgrl> edit database CLAWPRDA set state='APPLY-OFF';

 



exit broker



on standby server:

 



rman target sys/password; -- for standby



rman> recover standby database from service <database link for primary>;

 

 

 



On Wed, Aug 28, 2024 at 9:20 AM Scott Canaan <dmarc-noreply_at_freelists.org <mailto:dmarc-noreply_at_freelists.org> > wrote:



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.

 




-- 

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'



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


Received on Wed Aug 28 2024 - 21:14:12 CEST












Original text of this message