adjust scn by poke kcsgscn_
11g以后手工修改scn的手段：adjust_scn，_minimum_giga_scn都失效了
但是可以修改内存变量来修改scn
SYS@bbb>select current_scn from v$database;
CURRENT_SCN
--------------------
146028890382
SYS@bbb>oradebug setmypid
Statement processed.
SYS@bbb>oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [06001AE70, 06001AEA0) = 000008CB 00000022 00000000 00000000 00000585 00000000 00000000 00000000 00000000 00000000 6001AB50 00000000
SYS@bbb>oradebug poke 0x06001AE70 8 0x00000330000008CB
BEFORE: [06001AE70, 06001AE78) = 00000910 00000022
AFTER: [06001AE70, 06001AE78) = 000008CB 00000330
其中0x00000330是wrap, 0x0000008CB是base
SYS@bbb>select current_scn from v$database;
CURRENT_SCN
--------------------
3504693315791
SYS@bbb>oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [06001AE70, 06001AEA0) = 000008D3 00000330 00000000 00000000 000005D0 00000000 00000000 00000000 00000000 00000000 6001AB50 00000000
注意poke的时候地址必须是起始地址:0x06001AE70
即使修改wrap
但是可以修改内存变量来修改scn
SYS@bbb>select current_scn from v$database;
CURRENT_SCN
--------------------
146028890382
SYS@bbb>oradebug setmypid
Statement processed.
SYS@bbb>oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [06001AE70, 06001AEA0) = 000008CB 00000022 00000000 00000000 00000585 00000000 00000000 00000000 00000000 00000000 6001AB50 00000000
SYS@bbb>oradebug poke 0x06001AE70 8 0x00000330000008CB
BEFORE: [06001AE70, 06001AE78) = 00000910 00000022
AFTER: [06001AE70, 06001AE78) = 000008CB 00000330
其中0x00000330是wrap, 0x0000008CB是base
SYS@bbb>select current_scn from v$database;
CURRENT_SCN
--------------------
3504693315791
SYS@bbb>oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [06001AE70, 06001AEA0) = 000008D3 00000330 00000000 00000000 000005D0 00000000 00000000 00000000 00000000 00000000 6001AB50 00000000
注意poke的时候地址必须是起始地址:0x06001AE70
即使修改wrap
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/37279/viewspace-2134307/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
