Home » RDBMS Server » Backup & Recovery » scn is 0
scn is 0 [message #578567] Fri, 01 March 2013 05:24 Go to next message
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 1461 times)
Re: scn is 0 [message #578570 is a reply to message #578567] Fri, 01 March 2013 05:31 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous messageGo to next message
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

Re: scn is 0 [message #578573 is a reply to message #578571] Fri, 01 March 2013 05:48 Go to previous messageGo to next message
ramashankar
Messages: 22
Registered: November 2011
Junior Member
is there any error in my database

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

Report message to a moderator

Re: scn is 0 [message #578574 is a reply to message #578571] Fri, 01 March 2013 05:49 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
v$instance.database_status is not relevant to this issue. Look up the view definition and you will see.
Re: scn is 0 [message #578578 is a reply to message #578574] Fri, 01 March 2013 05:55 Go to previous message
ramashankar
Messages: 22
Registered: November 2011
Junior Member
Thank you verymuch John.

Kind Regards,
Ram
Previous Topic: archive
Next Topic: Command for restoring from Incremental Backup..!
Goto Forum:
  


Current Time: Thu Mar 28 10:45:44 CDT 2024