abhijat

[khan]

Hello Erman,

We are trying to create a new standby database from rac primary to single instance.We already created and configured.But Mrp process working very slowly.I couldnt find that why? server has 95 gb ram so sga > 40g pga > 10g

[ErmanArslansOracleBlog]

Find out the wait events by enabling the MRP tracing.. Oradebug MRP process and see its waits.

Enabling trace for MRP is given in this document -> MRP Slow or apply lag on Active Data Guard (ADG) (Doc ID 2347080.1)

Find the cause/wait , then we'll talk..

[khan]

WAIT #0: nam='class slave wait' ela= 999727 slave id=0 p2=0 p3=0 obj#=-1 tim=1529647852904373
WAIT #0: nam='parallel recovery control message reply' ela= 100034 p1=0 p2=0 p3=0 obj#=-1 tim=1529647853004546

[ErmanArslansOracleBlog]

1)How do you start this recovery?
Are you recovering paralllel? What is the exact command that you use for starting the MRP?

2)What is your DB version?

3)Any errors in alert log or in MRP trace?

[khan]

1) recover managed standby database disconnect from session;

2)11.2.0.4

3) ı am not gettin error since yesterday but when i restart standby db , iam getting this error while starting db:

ORA-00313: open failed for members of log group 19 of thread 2
ORA-00312: online log 19 thread 2: '+DATA/test/onlinelog/group_19.822.936532709'
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/onlinelog/group_19.822.936532709
ORA-15173: entry 'group_19.822.936532709' does not exist in directory 'onlinelog'
ORA-00312: online log 19 thread 2: '+DATA/test/onlinelog/group_19.820.936532705'
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/onlinelog/group_19.820.936532705
ORA-15173: entry 'group_19.820.936532705' does not exist in directory 'onlinelog'
Errors in file /u01/app/oracle/diag/rdbms/test/test/trace/test_arc6_25

[ErmanArslansOracleBlog]

1)Is your redologs located in +DATA/test/onlinelog/ ? Is that failing redolog there?
what is the value of your LOG_FILE_NAME_CONVERT parameter?

2)Send me the oradebug trace of MRP.. So I can take a look.