联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
Patch_SCN工具目前有For win和for linux版本,主要用于修改Oracle SCN(特别是在oracle数据库非常规恢复中实现一键修改SCN功能,实现快速open数据库.主要解决典型问题:
ORA-600 2662
ORA-600 kclchkblk_4
ORA-600 kcbzib_kcrsds_1
最近有点空对Patch_SCN软件的for linux版本进行了完善,主要完善功能:
1. 整个代码全部通过C代码实现
2. 完善了注册机制
3. 无需输入内存地址,程序一般情况下可以直接获取地址并修改
上传软件到linux环境并授权
确保执行用户有x权限
[root@iZbp11c0qyuuo1gr7j98upZ tmp]# ls -ltr /tmp/Patch_SCN -rw-r--r-- 1 root root 13984 Oct 13 2025 /tmp/Patch_SCN[root@iZbp11c0qyuuo1gr7j98upZ tmp]# chmod +x /tmp/Patch_SCN [root@iZbp11c0qyuuo1gr7j98upZ tmp]# ls -ltr /tmp/Patch_SCN -rwxr-xr-x 1 root root 13984 Oct 13 2025 /tmp/Patch_SCN |
使用软件之前需要进行注册
第一次使用要求输入注册码
[root@iZbp11c0qyuuo1gr7j98upZ tmp]# ./Patch_SCN This software is not registered.======================================== Software Registration ========================================Your Hardware ID: XXXXXXXPlease send your Hardware ID to XiFenFei to register.Website: https://www.xifenfei.com Tel/WX: +86-17813235971 Enter Registration Code: 6F2EEF38-693AEA80Registration successful!Usage: Automatic address mode: ./Patch_SCN <pid> <new_value> Manual address mode: ./Patch_SCN <pid> <address> <new_value> Where: <pid> - Oracle process ID (must be entered manually) <address> - Memory address (entered in manual mode, hexadecimal) <new_value> - SCN value to modify (must be entered manually, supports decimal or hexadecimal) |
授权成功之后,后续使用软件无需注册
[root@iZbp11c0qyuuo1gr7j98upZ tmp]# ./Patch_SCN Usage: Automatic address mode: ./Patch_SCN <pid> <new_value> Manual address mode: ./Patch_SCN <pid> <address> <new_value> Where: <pid> - Oracle process ID (must be entered manually) <address> - Memory address (entered in manual mode, hexadecimal) <new_value> - SCN value to modify (must be entered manually, supports decimal or hexadecimal) |
Patch_SCN使用演示
软件支持自动发现内存地址和手工输入内存地址两种模式(当某些情况无法软件自动发现地址时,可以考虑人工输入地址方式进行)
###############自动识别内存地址方式修改#############################--修改scn之前SQL> SELECT CURRENT_SCN FROM V$DATABASE;CURRENT_SCN----------- 5691132517---进行scn修改[oracle@iZbp11c0qyuuo1gr7j98upZ tmp]$ ./Patch_SCN 18884 5691232517Successfully obtained address automatically: 0x6001ae70Original Oracle SCN at Address 0x6001ae70: 0x15337ca8aAre you sure you want to modify Oracle SCN? (yes/no): yesNew SCN at Address 0x6001ae70: 0x153395105Oracle SCN successfully modified.--修改scn之后SQL> SELECT CURRENT_SCN FROM V$DATABASE;CURRENT_SCN----------- 5691232520 --->由于scn会自动增加,所以比修改值稍大一点###############手工输入内存地址方式修改########################---当程序提示无法获取到内存地址时,采用人工输入内存地址方式进行修改[root@iZbp11c0qyuuo1gr7j98upZ tmp]# ./Patch_SCN 18884 5691232517Could not find valid SCN ddressFailed to get SCN address automaticallyPlease use manual address mode instead---使用get_addr程序获取内存地址,如果无法获取联系:xifenfei[oracle@iZbp11c0qyuuo1gr7j98upZ tmp]$ ./get_addrRetrieving Oracle SCN address...Successfully retrieved SCN address: 0x6001ae70---修改scn值[root@iZbp11c0qyuuo1gr7j98upZ tmp]# ./Patch_SCN 18884 0x6001ae70 6691232517Using manually provided address: 0x6001ae70Original Oracle SCN at Address 0x6001ae70: 0x15339517fAre you sure you want to modify Oracle SCN? (yes/no): yesNew SCN at Address 0x6001ae70: 0x18ed41b05Oracle SCN successfully modified.---验证修改之后scn值SQL> SELECT CURRENT_SCN FROM V$DATABASE;CURRENT_SCN----------- 6691232521 --->由于scn会自动增加,所以比修改值稍大一点 |
Patch_SCN下载:Patch_SCN下载
Patch_SCN使用说明:Patch_SCN使用说明
浙公网安备 33010602011771号