通过控制文件修改scn，适合11g,12c版本
SQL> set line 132
SQL> set wrap off
SQL> l1
1* select * from v$version
SQL> r
1* select * from v$version
BANNER CON_I
-------------------------------------------------------------------------------- ---------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for 64-bit Windows: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
SQL> select CHECKPOINT_CHANGE# a from v$datafile_header;
A
----------------
8113679
8113679
8113679
8113679
8113679
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
8113679
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> oradebug setmypid
已处理的语句
SQL> oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [14BCC4270, 14BCC42A0) = 00000000 00000000 00000000 00000000 00000000 00000
00 00000000 00000000 00000000 4BCC3CF0 00000001
SQL> select to_char('8113800','xxxxxxxxx') from dual;
TO_CHAR('8
----------
7bce88
SQL> shutdown immediate
ORA-01109: 数据库未打开
已经卸载数据库。
--开始修改控制文件，先修改control01.ctl，将control02.ctl重命名为control02bak.ctl
等control01.ctl修改完成后拷贝一份为control02.ctl，然后启动数据库检查。
通过UE打开：先切换文字模式，查找数据库名字“ZXM”，然后切换为16进制，快速找到位置00004000h开始，将04CA0C右键替换为000000
将71CD7B右键替换为想要的值：88CE7B。
修改结果如下：
然后拷贝控制文件。
此时可以启动数据库。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 1677721600 bytes
Fixed Size 3046368 bytes
Variable Size 1006634016 bytes
Database Buffers 654311424 bytes
Redo Buffers 13729792 bytes
数据库装载完毕。
数据库已经打开。
SQL> oradebug setmypid
已处理的语句
SQL> oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [14BCC4270, 14BCC42A0) = 007BCF48 00000000 00000000 00000000 00000000 00000000 000000
00 00000000 00000000 00000000 4BCC3CF0 00000001
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
8113803
SQL> select CHECKPOINT_CHANGE# a from v$datafile_header;
A
----------------
8113803
8113803
8113803
8113803
8113803
SQL> oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [14BCC4270, 14BCC42A0) = 007BD15E 00000000 00000000 00000000 00000000 00000000 000000
00 00000000 00000000 00000000 4BCC3CF0 00000001
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
8113803
SQL> select to_char('8113803','xxxxxxxxx') from dual;
TO_CHAR('8
----------
7bce8b
其它可参考文档：
以正常库控制文件操作的，只改了一处。
[oracle@localhost.localdomain:/home/oracle]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 29 18:39:22 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> select CHECKPOINT_CHANGE# a from v$datafile_header;
A
----------
972173
972173
972173
972173
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
972173
使用ue工具打开控制文件，
[root@localhost ecard]# mv control01.ctl control01.ctl.bak
[root@localhost ecard]# rz -E
rz waiting to receive.
[root@localhost ecard]# ls -l
total 1530516
-rw-r--r-- 1 root root 9748480 Sep 29 18:37 control01.ctl
-rw-r-----. 1 oracle oinstall 9748480 Sep 29 18:05 control01.ctl.bak
-rw-r-----. 1 oracle oinstall 52429312 Sep 29 06:46 redo01.log
-rw-r-----. 1 oracle oinstall 52429312 Sep 29 18:05 redo02.log
-rw-r-----. 1 oracle oinstall 52429312 Sep 29 06:46 redo03.log
-rw-r-----. 1 oracle oinstall 534781952 Sep 29 18:05 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 775954432 Sep 29 18:05 system01.dbf
-rw-r-----. 1 oracle oinstall 30416896 Sep 27 19:42 temp01.dbf
-rw-r-----. 1 oracle oinstall 73408512 Sep 29 18:05 undotbs01.dbf
-rw-r-----. 1 oracle oinstall 5251072 Sep 29 18:05 users01.dbf
[root@localhost ecard]# chown oracle.oinstall control01.ctl
[root@localhost ecard]# cd /u01/app/oracle/fast_recovery_area/
[root@localhost fast_recovery_area]# cd ecard/
[root@localhost ecard]# ls
control02.ctl
[root@localhost ecard]# mv control02.ctl control02.ctl.bak
[root@localhost ecard]# cp /u01/app/oracle/oradata/ecard/control01.ctl ./control02.ctl
[root@localhost ecard]# ls -l
total 19040
-rw-r--r-- 1 root root 9748480 Sep 29 18:38 control02.ctl
-rw-r-----. 1 oracle oinstall 9748480 Sep 29 18:05 control02.ctl.bak
[root@localhost ecard]# chown oracle.oinstall control02.ctl
[root@localhost ecard]# su - oracle
Last login: Tue Sep 29 18:05:21 PDT 2020 on pts/1
[oracle@localhost.localdomain:/home/oracle]$ slqplus / as sysdba
bash: slqplus: command not found...
[oracle@localhost.localdomain:/home/oracle]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 29 18:39:22 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 4259082240 bytes
Fixed Size 2260040 bytes
Variable Size 872416184 bytes
Database Buffers 3372220416 bytes
Redo Buffers 12185600 bytes
Database mounted.
Database opened.
