Re: Data Guard Issue
Date: Wed, 28 Aug 2024 12:15:59 -0500
Message-ID: <CAJvnOJbM6LiLchuXdTiM6Eou4RzrL8Ts_19ETeHP72Hr0G-k-g_at_mail.gmail.com>
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> 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.
>
>
>
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 28 2024 - 19:15:59 CEST