URGENT:
DEAR ALL
I HAVE A QUERY?
I HAVE A DATABASE WITH 3 REDOLOG GROUPS
NOW IN THE CURRENT SEQUENCE NUMBERS ARE 416 , 417 , 418
416 AND 417 ARE ARCHIVED AND PRESENTLY INACTIVE.
418 IS CURRENT.
WHEN I QUERY THE ARCHIVED_CHANGE# FROM V$DATABASE IT SHOWS THE FIRST_CHANGE# VALUE OF 416 AND NOT 417 . BUT BOTH R ARCHIVED THEN WHY THE DATABSE VIEW IS SHOWING THE NUMBER CORRESPONDING TO 416?
KINDLY RESPOND?
REGARDS
AMIT TANDON