Database Software

Hi Gurus,

Need urgent help .....My Primary and Secondary database logs are out of sync. I am new to this Dataguard and want help in fixing this issue. I went through some blogs and found people suggesting a restart of DR system .Not sure is it correct or not . Have posted below my Primary and DR databae current state :-

PRIMARY DB
=================
Thread Last Sequence Generated
---------- -----------------------
1 52293
1 52293

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:\oracle\P01\oraarch\P01arch
Oldest online log sequence 52291
Next log sequence to archive 52294
Current log sequence 52294


SQL> show parameter DG_BROKER_START

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start boolean FALSE


+++++++++++++++++
SECONDARY
+++++++++++++++++
After sequence 52223 next log is missing ,after that all log recieved but not applied


SEQUENCE# APP FIRST_TIM NEXT_TIME
---------- --- --------- ---------
52215 YES 06-NOV-12 06-NOV-12
52216 YES 06-NOV-12 06-NOV-12
52217 YES 06-NOV-12 06-NOV-12
52218 YES 06-NOV-12 06-NOV-12
52219 YES 06-NOV-12 06-NOV-12
52220 YES 06-NOV-12 06-NOV-12
52221 YES 06-NOV-12 06-NOV-12
52222 YES 06-NOV-12 06-NOV-12
52223 YES 06-NOV-12 06-NOV-12
52225 NO 06-NOV-12 07-NOV-12
52226 NO 07-NOV-12 07-NOV-12

SEQUENCE# APP FIRST_TIM NEXT_TIME
---------- --- --------- ---------
52227 NO 07-NOV-12 07-NOV-12
52228 NO 07-NOV-12 07-NOV-12
52229 NO 07-NOV-12 07-NOV-12
52230 NO 07-NOV-12 07-NOV-12
52231 NO 07-NOV-12 07-NOV-12
52232 NO 07-NOV-12 07-NOV-12
52233 NO 07-NOV-12 07-NOV-12
52234 NO 07-NOV-12 07-NOV-12
52235 NO 07-NOV-12 07-NOV-12
52236 NO 07-NOV-12 07-NOV-12
52237 NO 07-NOV-12 07-NOV-12

SEQUENCE# APP FIRST_TIM NEXT_TIME
---------- --- --------- ---------
52238 NO 07-NOV-12 07-NOV-12
52239 NO 07-NOV-12 07-NOV-12
52240 NO 07-NOV-12 07-NOV-12
52241 NO 07-NOV-12 07-NOV-12
52242 NO 07-NOV-12 07-NOV-12
52243 NO 07-NOV-12 07-NOV-12
52244 NO 07-NOV-12 07-NOV-12
52245 NO 07-NOV-12 07-NOV-12
52246 NO 07-NOV-12 07-NOV-12
52247 NO 07-NOV-12 07-NOV-12
52248 NO 07-NOV-12 07-NOV-12

SEQUENCE# APP FIRST_TIM NEXT_TIME
---------- --- --------- ---------
52249 NO 07-NOV-12 07-NOV-12
52250 NO 07-NOV-12 07-NOV-12
52251 NO 07-NOV-12 07-NOV-12
52252 NO 07-NOV-12 07-NOV-12
52253 NO 07-NOV-12 07-NOV-12
52254 NO 07-NOV-12 07-NOV-12
52255 NO 07-NOV-12 07-NOV-12
52256 NO 07-NOV-12 07-NOV-12
52257 NO 07-NOV-12 07-NOV-12
52258 NO 07-NOV-12 07-NOV-12
52259 NO 07-NOV-12 07-NOV-12

SEQUENCE# APP FIRST_TIM NEXT_TIME
---------- --- --------- ---------
52260 NO 07-NOV-12 08-NOV-12
52261 NO 08-NOV-12 08-NOV-12
52262 NO 08-NOV-12 08-NOV-12
52263 NO 08-NOV-12 08-NOV-12
52264 NO 08-NOV-12 08-NOV-12
52265 NO 08-NOV-12 08-NOV-12
52266 NO 08-NOV-12 08-NOV-12
52267 NO 08-NOV-12 08-NOV-12
52268 NO 08-NOV-12 08-NOV-12
52269 NO 08-NOV-12 08-NOV-12
52270 NO 08-NOV-12 08-NOV-12

SEQUENCE# APP FIRST_TIM NEXT_TIME
---------- --- --------- ---------
52271 NO 08-NOV-12 08-NOV-12
52272 NO 08-NOV-12 08-NOV-12
52273 NO 08-NOV-12 08-NOV-12
52274 NO 08-NOV-12 08-NOV-12
52275 NO 08-NOV-12 08-NOV-12
52276 NO 08-NOV-12 08-NOV-12
52277 NO 08-NOV-12 08-NOV-12
52278 NO 08-NOV-12 08-NOV-12
52279 NO 08-NOV-12 08-NOV-12
52280 NO 08-NOV-12 08-NOV-12
52281 NO 08-NOV-12 08-NOV-12

SEQUENCE# APP FIRST_TIM NEXT_TIME
---------- --- --------- ---------
52282 NO 08-NOV-12 08-NOV-12
52283 NO 08-NOV-12 08-NOV-12
52284 NO 08-NOV-12 08-NOV-12
52285 NO 08-NOV-12 08-NOV-12
52286 NO 08-NOV-12 08-NOV-12
52287 NO 08-NOV-12 08-NOV-12
52288 NO 08-NOV-12 08-NOV-12
52289 NO 08-NOV-12 08-NOV-12
52290 NO 08-NOV-12 08-NOV-12
52291 NO 08-NOV-12 08-NOV-12
52292 NO 08-NOV-12 08-NOV-12

SEQUENCE# APP FIRST_TIM NEXT_TIME
---------- --- --------- ---------
52293 NO 08-NOV-12 08-NOV-12




Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
1 52293 52223 70


SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:\oracle\P01\oraarch\P01arch
Oldest online log sequence 52291
Next log sequence to archive 0
Current log sequence 52294
SQL> select process,status,sequence# from v$managed_standby;

PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 52292
ARCH CLOSING 52293
ARCH CLOSING 52289
ARCH CLOSING 52290
ARCH CLOSING 52291
MRP0 WAIT_FOR_LOG 52224
RFS IDLE 52294
RFS IDLE 0
RFS IDLE 0
RFS IDLE 52224



The MRP0 process is in WAIT_FOR_LOG. I think its hanged .Please let me know what i need to do in order to bring both primary ad secondary in sync.

Please let me know how to do it manually and what other options are available for me.

Thanks
Meena