Oracle pushes database SCN by modifying control file SCN

Database Current SCN

Code to copy code as follows
Idle> select checkpoint_change# from V$database;

checkpoint_change#
------------------
271743118

idle> Shutdown Abort

The ORACLE routine has been closed.
Analysis of SCN in control file

Here we can see the bold part for the database SCN

Code to copy code as follows
Sql>select to_number (' 10327a59 ', ' xxxxxxxxx ') from dual;

To_number (' 10327a59 ', ' xxxxxxxxx ')
---------------------------------
271743577

There is a small difference between the SCN value here and the value queried in the database, because there is a time difference between the point of the query and the fact that I completely shut down the database, which has a SCN change. Thin red box section to control file validation information for a block

Modifying control file SCN and validation information
Verification information modified to all 0,SCN information you can modify according to your needs, here the database of the SCN modified to 57253932971026, according to the principle of the database, the SCN should be slightly larger than the SCN value.

Code to copy code as follows
Sql>select to_number (' 341278563412 ', ' xxxxxxxxxxxxxxxxx ') from dual;

To_number (' 341278563412 ', ' xxxxxxxxxxxxxxxxx ') (www.111cn.net)
---------------------------------------------
57253932971026

Start the database
Idle> Startup Mount
The ORACLE routine has been started.

Code to copy code as follows
Total System Global area 400846848 bytes
Fixed Size 2440024 bytes
Variable Size 289408168 bytes
Database buffers 100663296 bytes
Redo buffers 8335360 bytes

The database is loaded.

Code to copy code as follows
idle> Recover database;
Complete media recovery.
idle> ALTER DATABASE open;

The database has changed.

Idle> select checkpoint_change# from V$database;

checkpoint_change#
------------------
57253932991028

After database startup, the query SCN is 57253932991028 (database current SCN) is slightly greater than 57253932971026 (Modify the control file SCN), prove that we by modifying the control file SCN, the implementation of database SCN push nearly complete OK. No experimental risk is greater, Do not test in the production environment, the load consequences at your own risk
From:http://www.111cn.net/database/oracle/60235.htm

Oracle pushes database SCN by modifying control file SCN