Re: Dataguard logs

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Dataguard-logs-tp1478p8648.html

Hi Erman,

the logs are being shipped to standby but I do not see applied.

standby DB:
     37537 NO        08/18/20 18:55:04
     37538 NO        08/18/20 18:56:16
     42713 NO        08/18/20 19:02:17
     42714 NO        08/18/20 19:02:49
     37539 NO        08/18/20 19:02:50
     42715 NO        08/18/20 19:02:53
     37540 NO        08/18/20 19:08:44
     37541 NO        08/18/20 19:09:59
     42716 NO        08/18/20 19:17:22

 SEQUENCE# APPLIED   FIRST
---------- --------- -----------------
     37542 NO        08/18/20 19:36:32
     37543 NO        08/18/20 19:39:29
     37544 NO        08/18/20 19:41:14
     42717 NO        08/18/20 19:41:16
     42718 NO        08/18/20 19:50:19
     37545 NO        08/18/20 19:51:11
     37546 NO        08/18/20 19:54:32
     37547 NO        08/18/20 19:55:32
     42719 NO        08/18/20 19:55:35
     42720 NO        08/18/20 20:04:02
     37548 NO        08/18/20 20:08:14

 SEQUENCE# APPLIED   FIRST
---------- --------- -----------------
     37549 NO        08/18/20 20:09:59
     37550 NO        08/18/20 20:29:24
     42721 NO        08/18/20 20:29:26
     42722 NO        08/18/20 20:39:15
     37552 NO        08/18/20 20:39:33

28000 rows selected.

PRIMARY DB:

 SEQUENCE# APPLIED   FIRST
---------- --------- -----------------
     42718 NO        08/18/20 19:50:19
     42718 NO        08/18/20 19:50:19
     37545 NO        08/18/20 19:51:11
     37545 NO        08/18/20 19:51:11
     37546 NO        08/18/20 19:54:32
     37546 NO        08/18/20 19:54:32
     37547 NO        08/18/20 19:55:32
     37547 NO        08/18/20 19:55:32
     42719 NO        08/18/20 19:55:35
     42719 NO        08/18/20 19:55:35
     42720 NO        08/18/20 20:04:02

 SEQUENCE# APPLIED   FIRST
---------- --------- -----------------
     42720 NO        08/18/20 20:04:02
     37548 NO        08/18/20 20:08:14
     37548 NO        08/18/20 20:08:14
     37549 NO        08/18/20 20:09:59
     37549 NO        08/18/20 20:09:59
     37550 NO        08/18/20 20:29:24
     37550 NO        08/18/20 20:29:24
     42721 NO        08/18/20 20:29:26
     42721 NO        08/18/20 20:29:26
     37551 NO        08/18/20 20:37:06
     37551 NO        08/18/20 20:37:06

 SEQUENCE# APPLIED   FIRST
---------- --------- -----------------
     42722 NO        08/18/20 20:39:15
     42722 NO        08/18/20 20:39:15
     37552 NO        08/18/20 20:39:33
     37552 NO        08/18/20 20:39:33
     37553 NO        08/18/20 20:39:51

28000 rows selected.

Also, I checked v$archive_gap and i see no records. Why are archivelogs not applied?