Oracle Database Discussions

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!

duplicate sequence no in v$archived_log

user7316227Aug 22 2015 — edited Aug 22 2015

Hi,

i am able to see duplicate sequence no in v$archived_log and with different completion date and register are arch and rman

SQL> select sequence#, registrar, recid, standby_dest, dest_id, to_char(completion_time,'DD-MON-YYYY HH24:MI:SS') completion_time from v$archived_log where sequence# ='443878';

SEQUENCE# REGISTR RECID STA DEST_ID COMPLETION_TIME

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

443878 ARCH 206378 NO 1 07-AUG-2015 12:03:44

443878 RMAN 206435 NO 1 07-AUG-2015 19:12:39

in which scenario we will see this situation

appreciated for any inputs

PGR

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2015

Added on Aug 22 2015

#general-database-discussions

5 comments

1,204 views