暂无图片
Oracle 12c SCN推进方法汇总（四）之修改控制文件
最近更新：2022-03-11 14:21:05

查看当前SCN

SQL> ALTER SYSTEM CHECKPOINT ;

System altered.

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
   20101799

SQL> select to_char(20101799,'xxxxxxxxx')from dual;

TO_CHAR(20
----------
   132baa5

copy 控制文件

[oracle@devin-enmo controlfile]$ sz control01.ctl 
rz
Starting zmodem transfer.  Press Ctrl+C to cancel.
......