OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » SCN no.

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

SCN no. [message #286263]

Fri, 07 December 2007 01:08

pankajkmeena
Messages: 46
Registered: September 2007

Member

===================
winddows-XP oracle9i
====================
what is difference between SCN number obtained

from query====
select dbid,name,resetlogs_change#,resetlogs_time from v$database;

and using package ========

select dbms_flashback.get_system_change_number from dual;

both give diifferent output

Report message to a moderator

Re: SCN no. [message #286276 is a reply to message #286263]

Fri, 07 December 2007 01:35

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

dbms_flashback.get_system_change_number is the current SCN.
resetlogs_change# is the SCN at the last "open reset log".
Check current_scn column instead.

Regards
Michel

Report message to a moderator

Re: SCN no. [message #286280 is a reply to message #286276]

Fri, 07 December 2007 01:44

pankajkmeena
Messages: 46
Registered: September 2007

Member

can u plz tell me from which column/table we get same value as in dbms_flashback.get_system_change_number

Report message to a moderator

Re: SCN no. [message #286299 is a reply to message #286280]

Fri, 07 December 2007 02:25

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read my last line.

Regards
Michel

Report message to a moderator

Re: SCN no. [message #286306 is a reply to message #286280]

Fri, 07 December 2007 02:31

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select current_scn, dbms_flashback.get_system_change_number from v$database;
CURRENT_SCN GET_SYSTEM_CHANGE_NUMBER
----------- ------------------------
    2766311                  2766311

1 row selected.

Regards
Michel

Report message to a moderator

Re: SCN no. [message #286384 is a reply to message #286306]

Fri, 07 December 2007 04:20

pankajkmeena
Messages: 46
Registered: September 2007

Member

Yes
but my v$database does not have this column (oracle 9i)


 Namedesc v$database;                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                               NUMBER
 NAME                                               VARCHAR2(9)
 CREATED                                            DATE
 RESETLOGS_CHANGE#                                  NUMBER
 RESETLOGS_TIME                                     DATE
 PRIOR_RESETLOGS_CHANGE#                            NUMBER
 PRIOR_RESETLOGS_TIME                               DATE
 LOG_MODE                                           VARCHAR2(12)
 CHECKPOINT_CHANGE#                                 NUMBER
 ARCHIVE_CHANGE#                                    NUMBER
 CONTROLFILE_TYPE                                   VARCHAR2(7)
 CONTROLFILE_CREATED                                DATE
 CONTROLFILE_SEQUENCE#                              NUMBER
 CONTROLFILE_CHANGE#                                NUMBER
 CONTROLFILE_TIME                                   DATE
 OPEN_RESETLOGS                                     VARCHAR2(11)
 VERSION_TIME                                       DATE
 OPEN_MODE                                          VARCHAR2(10)
 PROTECTION_MODE                                    VARCHAR2(20)
 PROTECTION_LEVEL                                   VARCHAR2(20)
 REMOTE_ARCHIVE                                     VARCHAR2(8)
 ACTIVATION#                                        NUMBER
 DATABASE_ROLE                                      VARCHAR2(16)
 ARCHIVELOG_CHANGE#                                 NUMBER
 SWITCHOVER_STATUS                                  VARCHAR2(18)
 DATAGUARD_BROKER                                   VARCHAR2(8)
 GUARD_STATUS                                       VARCHAR2(7)
 SUPPLEMENTAL_LOG_DATA_MIN                          VARCHAR2(3)
 SUPPLEMENTAL_LOG_DATA_PK                           VARCHAR2(3)
 SUPPLEMENTAL_LOG_DATA_UI                           VARCHAR2(3)
 FORCE_LOGGING                                      VARCHAR2(3)

[Updated on: Fri, 07 December 2007 04:22]

Report message to a moderator

Re: SCN no. [message #286385 is a reply to message #286384]

Fri, 07 December 2007 04:21

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, in 9i, the only way is dbms_flashback package.

Regards
Michel

Report message to a moderator

Previous Topic:	RMAN Recovery
Next Topic:	FILE LOCK

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 21:14:09 CST 2024