SCN and Checkpoint in Oracle
SCN and Checkpoint in Oracle What is SCN and why it is used? What happens if the SCN in datafile header is not matching with the Control file? The system change number (SCN) is Oracle's clock, every time we commit the clock increments. The SCN just marks a consistent point in time in the database. The checkpoint SCN in datafile headers are updated after checkpoint. The SCN is incremented whenever a transaction commits. Suppose i do update in one table which is stored in two different datafiles it will update all datafiles header & write information in control file after commit. Before opening the database SMON will check the control file & datafile headers for the same SCN. If the SCN in datafile header is not matching with the Control file that means datafile need recovery. How to find Current SCN? SQL> select dbms_flashback.get_system_change_number from dual; VER. Oracle 9i SQL> select to_char(current_scn) from v$database; ...