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
No comments:
Post a Comment