Re: Data Guard Issue

Hello,

What output for commands?
show database 'CLAWPRDA' 'StatusReport';

Execute too:
show database 'CLAWPRDA' 'InconsistentProperties'; show database 'CLAWPRDA' 'LogXptStatus';

Att.

*Juliano Ribeiro*
http://linkedin.com/in/supernoi <http://br.linkedin.com/in/supernoi>

Em qua., 28 de ago. de 2024 às 13:08, Scott Canaan < dmarc-noreply_at_freelists.org> escreveu:

> It shows it as a physical standby:
>
>
>
> DGMGRL> show configuration verbose;
>
>
>
> Configuration - CLAWPRDA
>
>
>
> Protection Mode: MaxPerformance
>
> Members:
>
> CLAWPRDB - Primary database
>
> CLAWPRDA - Physical standby database
>
> Error: ORA-16810: multiple errors or warnings detected for the member
>
>
>
> Properties:
>
> FastStartFailoverThreshold = '30'
>
> OperationTimeout = '30'
>
> TraceLevel = 'USER'
>
> FastStartFailoverLagLimit = '30'
>
> CommunicationTimeout = '180'
>
> ObserverReconnect = '0'
>
> FastStartFailoverLagGraceTime = '0'
>
> FastStartFailoverAutoReinstate = 'TRUE'
>
> FastStartFailoverPmyShutdown = 'TRUE'
>
> BystandersFollowRoleChange = 'ALL'
>
> ObserverOverride = 'FALSE'
>
> ExternalDestination1 = ''
>
> ExternalDestination2 = ''
>
> PrimaryLostWriteAction = 'CONTINUE'
>
> ConfigurationWideServiceName = 'CLAWPRDA_CFG'
>
> FastStartFailoverLagType = 'APPLY'
>
>
>
> Fast-Start Failover: Disabled
>
>
>
> Configuration Status:
>
> ERROR
>
>
>
> The problem is when I try to do a recover, it wants log 1. I put in the
> oldest log we have available and it says it isn’t old enough. It wants
> logs from 2 months ago, based on the SCN it wants to start with, and those
> are not available anywhere.
>
>
>
> *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 <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:* dimensional.dba_at_comcast.net <dimensional.dba_at_comcast.net>
> *Sent:* Wednesday, August 28, 2024 11:56 AM
> *To:* Scott Canaan <srcdco_at_rit.edu>; 'Jon Crisler' <joncrisler_at_gmail.com>
> *Cc:* 'Oracle-L Freelists' <oracle-l_at_freelists.org>
> *Subject:* RE: Data Guard Issue
>
>
>
> When you execute dgmgrl show configuration, does the database show as a
> snapshot database or a regular standby database?
>
> I have had to remove the dg broker config completely including wiping out
> dg broker files to get some of the previous configs removed properly.
>
>
>
>
> What error do you get if you run
>
> DBMS_DG.CONVERT_TO_PHYSICAL (
>
> db_name IN VARCHAR2,
>
> severity OUT BINARY_INTEGER)
>
> RETURN BINARY_INTEGER;
>
>
>
> On the primary? Since you don’t have a real snapshot db anymore that
> command should error.
>
>
>
>
>
> As to
>
> SQL> recover standby database;
>
> ORA-01153: an incompatible media recovery is active
>
>
>
> To just get things rolling forward, you get this error all the time if you
> don’t
>
> Alter database recover managed database cancel;
>
> Then do your
>
> recover standby database until cancel;
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Scott Canaan ("srcdco")
> *Sent:* Wednesday, August 28, 2024 7:51 AM
> *To:* Jon Crisler <joncrisler_at_gmail.com>
> *Cc:* Oracle-L Freelists <oracle-l_at_freelists.org>
> *Subject:* RE: Data Guard Issue
>
>
>
> I’ve done the cancel / restart at least 3 times. I did do an RMAN backup,
> copy, “restore” along with the control file which was created just after
> the RMAN backup.
>
>
>
> *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 <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:* Jon Crisler <joncrisler_at_gmail.com>
> *Sent:* Wednesday, August 28, 2024 10:42 AM
> *To:* Scott Canaan <srcdco_at_rit.edu>
> *Cc:* Oracle-L Freelists <oracle-l_at_freelists.org>
> *Subject:* Re: Data Guard Issue
>
>
>
> In this case you need to cancel mrp before you try to restart it .
> Double check the incarnations once you get media recovery running (rman or
> dg mrp) . Worst case you will need a full rman copy to restore the standby
> , and use a control file from “after” the rman backup , otherwise you have
> to manually catalog your rman backups.
>
> Sent from my Atari 2600
>
>
>
> On Aug 28, 2024, at 10:20 AM, Scott Canaan <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 <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