Skip to Main Content

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 number not changing

1013593Aug 25 2015 — edited Aug 25 2015

Hi All,

Db - 11.2.0.3

OS- OEL 6.5

In one of my database current_scn value is not changing it remains fixed to this value  from last 5 days(Development database)

SQL> select current_scn from v$database;

CURRENT_SCN

-----------

1.2205E+13

same is on datafile checkpoint headers,Database is not in backup mode.so what may be reason for  scn not  increasing .Db is in no archivelog mode.

There are no errors in alert log file but have lot of incremental checkpoints.

Thanks.

This post has been answered by Hemant K Chitale on Aug 25 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2015
Added on Aug 25 2015
4 comments
956 views