Tag Archives: archive number from SCN number

Find archive from SCN number in Oracle Database

Find archive from SCN number in Oracle Database

1. Check the current SCN number from the Oracle database.

Select CURRENT_SCN from v$database;
SCN
----------
3208910

2. Check the archived log from SCN number.
Run the query will ask for put scn number in bind variable.

Select sequence#,FIRST_CHANGE#,NEXT_CHANGE# from v$archived_log where &scn between FIRST_CHANGE# and NEXT_CHANGE#;

SEQUENCE# FIRST_CHANGE# NEXT_CHANGE#
--------- ------------- ------------
       23       3207813      3208973


Note: If no row found then you can switch the logfile with “alter system switch logfile;”