Home > 11g > duplicate entries in v$archived_log view.

duplicate entries in v$archived_log view.

March 2, 2014

Today while checking redo applying details i came across one strange point i.e. duplicate entries in v$archived_log view. i did further research and found that this is basically not duplicate, it is completely depend on log_archive_dest parameters. if we define 2 locations, we will see one edntrie for each location.

eg:- in my system(primary system).

==============================================================
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_dest_1 string location=/u01/app/archive/PRIM
valid_for=(all_logfiles,ALL_R
OLES) db_unique_name=PRIM

log_archive_dest_2 string service=stnd valid_for=(online
_logfiles,primary_role) db_uni
que_name=STND
==============================================================

when i check in v$archived_log view, i got the following details.

DEST_ID SEQUENCE# APPLIED S ARC DEL FAL
———- ———- ——— – — — —
1 36 NO A YES NO NO
2 37 YES A YES NO NO
1 37 NO A YES NO NO
2 38 YES A YES NO NO
1 38 NO A YES NO NO
2 39 YES A YES NO NO
1 39 NO A YES NO NO

Now i am going to add another location for archive log and let us c.

SQL> show parameter log_archive_dest_

NAME TYPE VALUE
———————————— ———– ——————————
log_archive_dest_1 string location=/u01/app/archive/PRIM
valid_for=(all_logfiles,ALL_R
OLES) db_unique_name=PRIM
log_archive_dest_2 string service=stnd valid_for=(online
_logfiles,primary_role) db_uni
que_name=STND
log_archive_dest_3 string location=/u01/app/archive/PRIM
3 valid_for=(all_logfiles,ALL_
ROLES) db_unique_name=PRIM

Now check the v$archived_log view details.
DEST_ID SEQUENCE# APPLIED S ARC DEL FAL
———- ———- ——— – — — —
1 44 NO A YES NO NO
3 44 NO A YES NO NO
2 45 YES A YES NO NO
1 45 NO A YES NO NO
3 45 NO A YES NO NO
2 46 YES A YES NO NO
1 46 NO A YES NO NO
3 46 NO A YES NO NO
1 47 NO A YES NO NO
3 47 NO A YES NO NO
2 47 YES A YES NO NO
2 48 YES A YES NO NO
1 48 NO A YES NO NO
3 48 NO A YES NO NO

=============================================================

Advertisements
Categories: 11g
%d bloggers like this: