Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.6K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
WAIT_FOR_GAP
Oracle DB 12.1.0.2
Hello Team,
i recently configured a DG from RAC to standalone. archivelogs are being shipped from RAC to the standby DB. Standby DB is receiving archivelogs from primary.
The issue is I noticed the MRP0 process is stuck.
select process, thread#, sequence#, status from v$managed_standby where process='MRP0';
PROCESS THREAD# SEQUENCE# STATUS
--------- ---------- ---------- ------------
MRP0 1 4 WAIT_FOR_GAP
How can I solve this?
Regards,
Joe
Best Answers
-
Hi, you need to configure the parameters DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT initially in standby, but it is good to configure also in the primary in case you need to do a failover or switchover, the parameter is not dynamic, it is necessary to restart the database.
-
Agree
Answers
-
Hi Joe,
obviously some archivelogs got deleted at primary before they could be shipped to the standby. You should check the standby's alert.log to see which archivelogs (sequence#, thread#) are missing and try to restore those from backup to make them available again. Then try to stop/start managed recovery in case it does not resume on it's on.
In case the archivelogs in question cannot easily be restored, you can roll forward your physical standby with an incremental backup and then start the managaed recovery again.
https://support.oracle.com/epmos/faces/DocContentDisplay?id=1987763.1
Cheers,
Marco
-
Hi Marc,
after restore, should I rename logfiles from +DATA to /data (ASM to filesystem)? or just recover the db and start replication.
I am getting error when drop logfiles:
ORA-00261: log 11 of thread 1 is being archived or modified
ORA-00312: online log
-
Did you see any error in alert log files?
Also do check v$dataguard_status view to check any messages.
On Tue, Aug 18, 2020, 11:38 PM community-admin <
-
The source is a RAC of 2 nodes on ASM and target is standalone DB
How can I convert the +DATA to /data ?
1 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_1_hmsylp8r_.log NO 0
2 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_2_hmsylt1p_.log NO 0
3 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_3_hmsylyg2_.log NO 0
4 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_4_hmsym2l8_.log NO 0
16 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_16_hmsym69c_.log NO 0
17 ONLINE +DATA/DWARE1/ONLINELOG/group_17.543.1018688819 NO 0
18 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_18_hmsymb0w_.log NO 0
19 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_19_hmsymfqo_.log NO 0
21 STANDBY /data/DATA/dware1/log/stby_redo21.log NO 0
22 STANDBY /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_22_hmsx395b_.log NO 0
23 STANDBY /data/DATA/dware1/log/stby_redo23.log NO 0
24 STANDBY /data/DATA/dware1/log/stby_redo24.log NO 0
25 STANDBY /data/DATA/dware1/log/stby_redo25.log NO 0
26 STANDBY /data/DATA/dware1/log/stby_redo26.log NO 0
27 STANDBY /data/DATA/dware1/log/stby_redo27.log NO 0
28 STANDBY /data/DATA/dware1/log/stby_redo28.log NO 0
29 STANDBY /data/DATA/dware1/log/stby_redo29.log NO 0
30 STANDBY /data/DATA/dware1/log/stby_redo30.log NO 0
31 STANDBY /data/DATA/dware1/log/stby_redo31.log NO 0
32 STANDBY /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_32_hmsx4bhm_.log NO 0
33 STANDBY /data/DATA/dware1/log/stby_redo33.log NO 0
34 STANDBY /data/DATA/dware1/log/stby_redo34.log NO 0
35 STANDBY /data/DATA/dware1/log/stby_redo35.log NO 0
36 STANDBY /data/DATA/dware1/log/stby_redo36.log NO 0
37 STANDBY /data/DATA/dware1/log/stby_redo37.log NO 0
38 STANDBY /data/DATA/dware1/log/stby_redo38.log NO 0
39 STANDBY /data/DATA/dware1/log/stby_redo39.log NO 0
40 STANDBY /data/DATA/dware1/log/stby_redo40.log NO 0
41 STANDBY /data/DATA/dware1/log/stby_redo41.log NO 0
42 STANDBY /data/DATA/dware1/log/stby_redo42.log NO 0
5 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_5_hmsymk89_.log NO 0
6 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_6_hmsymo9b_.log NO 0
7 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_7_hmsyms2h_.log NO 0
8 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_8_hmsymwng_.log NO 0
9 ONLINE +DATA/DWARE1/ONLINELOG/group_9.535.1018688171 NO 0
10 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_10_hmsyn0f2_.log NO 0
11 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_11_hmsyn4vm_.log NO 0
12 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_12_hmsync3o_.log NO 0
13 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_13_hmsynhv8_.log NO 0
14 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_14_hmsynmt4_.log NO 0
15 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_15_hmsynqyt_.log NO 0
20 ONLINE /data/DATA/dware1/log/DWAREDR/onlinelog/o1_mf_20_hmsynvwx_.log NO 0
-
I cannot drop the above files since they are current.
-
Errors in file /u01/app/ora12c/diag/rdbms/dwaredr/dware1/trace/dware1_m000_7560.trc:
ORA-00313: open failed for members of log group 17 of thread 2
ORA-00312: online log 17 thread 2: '+DATA/DWARE1/ONLINELOG/group_17.543.1018688819'
ORA-17503: ksfdopn:2 Failed to open file +DATA/DWARE1/ONLINELOG/group_17.543.1018688819
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15064: communication failure with ASM instance
WARNING: Clusterware is not configured.
WARNING: Clusterware is not configured.
Completed: alter database recover managed standby database disconnect from session
-
seems good now after recreating the redolog files.
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 37643
ARCH CONNECTED 0
ARCH CLOSING 42821
ARCH CLOSING 37622
RFS IDLE 0
RFS RECEIVING 37575
RFS RECEIVING 42741
RFS IDLE 42824
RFS RECEIVING 42742
RFS RECEIVING 42740
RFS IDLE 0
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
RFS IDLE 37644
MRP0 WAIT_FOR_LOG 42740 <---- MRP0 started.
-
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 37644
ARCH CONNECTED 0
ARCH CLOSING 42824
ARCH CLOSING 37622
RFS RECEIVING 37646
RFS IDLE 0
RFS RECEIVING 42747
RFS RECEIVING 42825
RFS RECEIVING 42745
RFS RECEIVING 42746
RFS IDLE 0
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
RFS RECEIVING 37645
MRP0 APPLYING_LOG 42744
-
Hi, you need to configure the parameters DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT initially in standby, but it is good to configure also in the primary in case you need to do a failover or switchover, the parameter is not dynamic, it is necessary to restart the database.
-
Agree