Sunday, February 7, 2010

ALTER SYSTEM ARCHIVE LOG CURRENT and SCN


SQL> select max(next_change#) from v$archived_log;

MAX(NEXT_CHANGE#)
-----------------
2184453

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
2205026


Current changes are written to archived log triggered by "alter system archive log current".

SQL> alter system archive log current;

System altered.

SQL> select max(next_change#) from v$archived_log;

MAX(NEXT_CHANGE#)
-----------------
2205034

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
2205044