OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » scn is 0

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

scn is 0 [message #578567]

Fri, 01 March 2013 05:24

ramashankar
Messages: 22
Registered: November 2011

Junior Member

Hi all,

My current scn is showing 0.can scn be 0?

Regards,
Ram

Attachment: Capture.JPG
(Size: 12.96KB, Downloaded 1996 times)

Report message to a moderator

Re: scn is 0 [message #578570 is a reply to message #578567]

Fri, 01 March 2013 05:31

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I have not looked at your jpg. In future, please follow the forum guidelines and use/copy paste, with code tags, from SQL*Plus when youi want to show something.

However, I assume that your datbase is not open:

orcl>
orcl> select current_scn from v$database;

CURRENT_SCN
-----------
    5519895

orcl> alter database close;

Database altered.

orcl> select current_scn from v$database;

CURRENT_SCN
-----------
          0

orcl>

--
update: corrected my code tags!

[Updated on: Fri, 01 March 2013 05:32]

Report message to a moderator

Re: scn is 0 [message #578571 is a reply to message #578567]

Fri, 01 March 2013 05:45

ramashankar
Messages: 22
Registered: November 2011

Junior Member

My database is active John also its showing 0.

[oracle@primary ~]$ sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 2 00:43:44 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL> select database_status from v$instance;

DATABASE_STATUS
-----------------
ACTIVE

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
          0


Regards,
Ram

Report message to a moderator