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!

SCN is showing 0 in fail over server

Swetha RapoluAug 25 2018 — edited Aug 27 2018

Hi All,

I have build a fail over instance using the latest PROD backup which is completed without any issues but the SCN number is showing as 0. Can someone please help me on this.

SQL> SELECT to_char(CURRENT_SCN) FROM V$DATABASE;

TO_CHAR(CURRENT_SCN)

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

SQL> select distinct(status) from v$datafile;

STATUS

-------

ONLINE

SYSTEM

SQL> SELECT to_char(archivelog_change#-1) FROM V$DATABASE;

TO_CHAR(ARCHIVELOG_CHANGE#-1)

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

60424564844

SQL> select to_char(checkpoint_change#) from v$database;

TO_CHAR(CHECKPOINT_CHANGE#)

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

60792116586

SQL> SELECT MAX(SEQUENCE#) FROM V$LOG_HISTORY;

MAX(SEQUENCE#)

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

295018

Thanks,

Swetha

This post has been answered by JohnWatson2 on Aug 25 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2018

Added on Aug 25 2018

#general-database-discussions

7 comments

1,681 views