Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

lists the archive log apply records of standby database alert log

JhilJul 26 2016 — edited Jul 31 2016

Good morning to all ,

>> at Standby database

shell command lists the archive log apply records of standby database alert log

What i have noticed , some sequence# are not displayed from above output ( seq# ===> 1669, 1670, 1671, 1672, 1679, 1680, 1682, 1685, 1687, ...1

Why those sequences are missing from following output ?

$ tail -10000 /u01/app/oracle/diag/rdbms/stbycrms/stbycrms/trace/alert_stbycrms.log |awk -v x="" '

{if (index($0,"Media Recovery Log ")!=0) print $0" "x; else if($1=="Mon"||$1=="Tue"||$1=="Wed"||$1=="Thu"||$1=="Fri"||$1=="Sat"||$1=="Sun") x=$0}'

...

......

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_25/o1_mf_1_1668_csd4cy3g_.arc Mon Jul 25 23:27:07 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1673_csddt0vh_.arc Tue Jul 26 02:34:40 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1674_csdhvskb_.arc Tue Jul 26 02:34:40 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1678_csg3klso_.arc Tue Jul 26 17:16:06 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1681_csg51nmq_.arc Tue Jul 26 17:41:41 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1683_csg51y0q_.arc Tue Jul 26 17:41:55 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1684_csg51yd4_.arc Tue Jul 26 17:41:55 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1686_csg53cb1_.arc Tue Jul 26 17:42:35 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1688_csg53kom_.arc Tue Jul 26 17:42:41 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1689_csg53ld8_.arc Tue Jul 26 17:42:41 2016

Media Recovery Log /u01/app/oracle/flash_recovery_area/STBYCRMS/archivelog/2016_07_26/o1_mf_1_1691_csg53qgc_.arc Tue Jul 26 17:42:47 2016

>> Following query shows applied status for all sequence at Standby database

SQL> select sequence#, first_time, next_time, applied from v$archived_log order by sequence#;

SEQUENCE# FIRST_TIME NEXT_TIME APPLIED

---------- -------------------- -------------------- ---------

1668 25-JUL-2016 23:17:39 25-JUL-2016 23:17:44 YES

1669 25-JUL-2016 23:17:44 25-JUL-2016 23:32:17 YES

1670 25-JUL-2016 23:32:17 26-JUL-2016 01:09:04 YES

1671 26-JUL-2016 01:09:04 26-JUL-2016 01:10:05 YES

1672 26-JUL-2016 01:10:05 26-JUL-2016 01:10:24 YES

1673 26-JUL-2016 01:10:24 26-JUL-2016 01:41:51 YES

1674 26-JUL-2016 01:41:51 26-JUL-2016 02:34:00 YES

SEQUENCE# FIRST_TIME NEXT_TIME APPLIED

---------- -------------------- -------------------- ---------

1675 26-JUL-2016 02:34:00 26-JUL-2016 17:15:51 YES

1676 26-JUL-2016 17:15:51 26-JUL-2016 17:15:52 YES

1677 26-JUL-2016 17:15:52 26-JUL-2016 17:15:57 YES

1678 26-JUL-2016 17:15:57 26-JUL-2016 17:15:57 YES

1679 26-JUL-2016 17:15:57 26-JUL-2016 17:17:34 YES

1680 26-JUL-2016 17:17:34 26-JUL-2016 17:41:35 YES

1681 26-JUL-2016 17:41:35 26-JUL-2016 17:41:37 YES

1682 26-JUL-2016 17:41:37 26-JUL-2016 17:41:45 YES

1683 26-JUL-2016 17:41:45 26-JUL-2016 17:41:46 YES

1684 26-JUL-2016 17:41:46 26-JUL-2016 17:41:50 YES

1685 26-JUL-2016 17:41:50 26-JUL-2016 17:42:32 YES

SEQUENCE# FIRST_TIME NEXT_TIME APPLIED

---------- -------------------- -------------------- ---------

1686 26-JUL-2016 17:42:32 26-JUL-2016 17:42:33 YES

1687 26-JUL-2016 17:42:33 26-JUL-2016 17:42:36 YES

1688 26-JUL-2016 17:42:36 26-JUL-2016 17:42:38 YES

1689 26-JUL-2016 17:42:38 26-JUL-2016 17:42:40 YES

1690 26-JUL-2016 17:42:40 26-JUL-2016 17:42:43 YES

1691 26-JUL-2016 17:42:43 26-JUL-2016 17:42:44 YES

1692 26-JUL-2016 17:42:44 26-JUL-2016 23:07:09 YES

1693 26-JUL-2016 23:07:09 26-JUL-2016 23:14:50 YES

1694 26-JUL-2016 23:14:50 27-JUL-2016 00:00:29 YES

1695 27-JUL-2016 00:00:29 27-JUL-2016 00:00:31 YES

1696 27-JUL-2016 00:00:31 27-JUL-2016 00:00:41 YES

SEQUENCE# FIRST_TIME NEXT_TIME APPLIED

---------- -------------------- -------------------- ---------

1697 27-JUL-2016 00:00:41 27-JUL-2016 04:19:35 YES

Thanks.

DB version : 11.2.0.1

This post has been answered by JuanM on Jul 29 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2016

Added on Jul 26 2016

#data-guard, #performance-availability

6 comments

924 views