oracle12c 修改scn值6,Oracle 12c SCN推进方法汇总（一）之GDB

最新推荐文章于 2024-01-24 16:12:33 发布
最新推荐文章于 2024-01-24 16:12:33 发布
阅读量259 收藏 4
点赞数
文章标签： oracle12c 修改scn值6

在数据库异常恢复中，经常需要修改数据库的 SCN 值，在 12C 之前，我们常用的方法有如下几个：

1. oradebug poke 直接修改内存中的值；

2. event 10015 来增加 scn 的值；

3. _minimum_giga_scn 来增加 scn 的值；

4. gdb/dbx 来直接修改内存中的值；

5. 修改控制文件来修改 scn 的值；

6. 修改数据文件头来修改 scn 的值；

7. adjust_scn 来增加scn。

在这几种方法中，2、3、7方法在2012年中，Oracle 已经通过补丁更新，导致方法失效，就只有1，4，5，6方法。在这几种方法中，我们常常使用方法1来修改 scn 的值，但是此方法在 12C 中，Oracle 也已经屏蔽，还可以继续使用4，5，6 的方法来实现修改 SCN。在12.2 中，Oracle 多了一个新的 EVENT 21307096 也可以实现增加 SCN 的值。

接下来将介绍4，5，6以及event各种方式推进数据库SCN。

查看当前SCN：

SQL> alter system checkpoint;

System altered.

SQL> select current_scn from v$database;

CURRENT_SCN

-----------

3102150

SQL> oradebug setmypid

Statement processed.

SQL> oradebug dumpvar sga kcsgscn_

kcslf kcsgscn_ [0600113B8, 0600113E8) = 002F561D 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 60049740 00000000

查看进程号

[oracle@devin1 ~]$ ps -ef | grep -i local=yes

oracle 4223 4133 0 09:33 ? 00:00:00 oraclehkora (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 5124 5094 0 09:42 pts/2 00:00:00 grep --color=auto -i local=yes

GDB推进SCN

[oracle@devin1 ~]$ gdb $ORACLE_HOME/bin/oracle 4223

GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-120.el7

Copyright (C) 2013 Free Software Foundation, Inc.

License GPLv3+: GNU GPL version 3 or later

This is free software: you are free to change and redistribute it.

There is NO WARRANTY, to the extent permitted by law. Type "show copying"

and "show warranty" for details.

This GDB was configured as "x86_64-redhat-linux-gnu".

For bug reporting instructions, please see:

...

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/bin/oracle...(no debugging symbols found)...done.

Attaching to program: /u01/app/oracle/product/12.2/dbhome_1/bin/oracle, process 4223

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libodm12.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libodm12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libofs.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libofs.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libcell12.so...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libcell12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libskgxp12.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libskgxp12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libskjcx12.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libskjcx12.so

Reading symbols from /lib64/librt.so.1...(no debugging symbols found)...done.

Loaded symbols for /lib64/librt.so.1

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libmql1.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libmql1.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libipc1.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libipc1.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libclsra12.so...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libclsra12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libdbcfg12.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libdbcfg12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libhasgen12.so...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libhasgen12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libskgxn2.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libskgxn2.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libocr12.so...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libocr12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libocrb12.so...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libocrb12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libocrutl12.so...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libocrutl12.so

Reading symbols from /lib64/libaio.so.1...Reading symbols from /lib64/libaio.so.1...(no debugging symbols found)...done.

(no debugging symbols found)...done.

Loaded symbols for /lib64/libaio.so.1

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libons.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libons.so

Reading symbols from /lib64/libdl.so.2...(no debugging symbols found)...done.

Loaded symbols for /lib64/libdl.so.2

Reading symbols from /lib64/libm.so.6...(no debugging symbols found)...done.

Loaded symbols for /lib64/libm.so.6

Reading symbols from /lib64/libpthread.so.0...(no debugging symbols found)...done.

[Thread debugging using libthread_db enabled]

Using host libthread_db library "/lib64/libthread_db.so.1".

Loaded symbols for /lib64/libpthread.so.0

Reading symbols from /lib64/libnsl.so.1...(no debugging symbols found)...done.

Loaded symbols for /lib64/libnsl.so.1

Reading symbols from /lib64/libresolv.so.2...(no debugging symbols found)...done.

Loaded symbols for /lib64/libresolv.so.2

Reading symbols from /lib64/libc.so.6...(no debugging symbols found)...done.

Loaded symbols for /lib64/libc.so.6

Reading symbols from /lib64/libgcc_s.so.1...(no debugging symbols found)...done.

Loaded symbols for /lib64/libgcc_s.so.1

Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done.

Loaded symbols for /lib64/ld-linux-x86-64.so.2

Reading symbols from /usr/lib64/libnuma.so.1...Reading symbols from /usr/lib64/libnuma.so.1...(no debugging symbols found)...done.

(no debugging symbols found)...done.

Loaded symbols for /usr/lib64/libnuma.so.1

Reading symbols from /lib64/libnss_files.so.2...(no debugging symbols found)...done.

Loaded symbols for /lib64/libnss_files.so.2

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libnque12.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libnque12.so

Reading symbols from /u01/app/oracle/product/12.2/dbhome_1/lib/libshpkavx212.so...(no debugging symbols found)...done.

Loaded symbols for /u01/app/oracle/product/12.2/dbhome_1/lib/libshpkavx212.so

0x00007f9bbcff3740 in __read_nocancel () from /lib64/libpthread.so.0

Missing separate debuginfos, use: debuginfo-install glibc-2.17-317.0.1.el7.x86_64 libaio-0.3.109-13.el7.x86_64 libgcc-4.8.5-36.0.1.el7.x86_64 numactl-libs-2.0.9-7.el7.x86_64

(gdb) set *((int *) 0x0600113B8) = 0x102F561D --scn base

(gdb) set *((int *) 0x0600113BC) = 0x0001 --scn wrp

(gdb) quit

A debugging session is active.

Inferior 1 [process 4223] will be detached.

Quit anyway? (y or n) y

Detaching from program: /u01/app/oracle/product/12.2/dbhome_1/bin/oracle, process 4223

[Inferior 1 (process 4223) detached]

验证

SQL> select current_scn from v$database;

CURRENT_SCN

-----------

4566505132

SQL> select to_char(4566505132,'xxxxxxxxxxxxx') from dual;

TO_CHAR(456650

--------------

1102f56ac --wrp=1 base=102f56ac

能量中国
关注
推陈出新：12C 推进 SCN 新方法实践
Enmotech的博客
04-07 994
黄廷忠云和恩墨西区交付总监 简介：超过10年专职电信行业 Oracle 数据库管理和运维经验，熟悉电信行业的业务、数据库及硬件架构。擅长数据库各种迁移方法、优化、疑难故障排除、数据库异常恢复等。在数据库异常恢复中，经常需要修改数据库的 SCN 值，在 12C 之前，我们常用的方法有如下几个：oradebug poke 直接修改内存中的值；event 10015 来增加 scn 的值；_minimu
oracle 控制文件 scn,Oracle 12c SCN推进方法汇总（四）之修改控制文件
weixin_33610842的博客
04-03 274
1，查看当前SCNSQL>ALTERSYSTEMCHECKPOINT;Systemaltered.SQL>selectcurrent_scnfromv$database;CURRENT_SCN-----------20101799SQL>selectto_char(20101799,'xxxxxxxxx')fromdual;TO_CHAR(20------...
gdb调整scn
sqlora的专栏
05-21 251
linux下通过gdb调整scn更方便，适合oracle各种版本。 窗口一： [oracle@oem ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 21 15:30:29 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. .
oracle12c 修改scn值,通过控制文件修改scn，适合11g,12c版本
weixin_39560029的博客
04-08 323
SQL> set line 132SQL> set wrap offSQL> l11* select * from v$versionSQL> r1* select * from v$versionBANNERCON_I-----------------------------------------------------------------------------...
oracle数据库推进scn,oracle通过修改控制文件scn推进数据库scn
weixin_29670781的博客
04-13 386
数据库当前scn代码如下idle> select checkpoint_change# from v$database;CHECKPOINT_CHANGE#------------------271743118idle> shutdown abortORACLE 例程已经关闭。分析控制文件中scn这里我们可以看到加粗部分为数据库scn代码如下SQL>select to_num...
Oracle12c 实战ASM(12.1) 安装配置
最新发布
03-05
Oracle 12c ASM（12.1）安装配置 Oracle 12c ASM（12.1）是 Oracle 公司推出的自动存储管理（Automatic Storage Management）系统，用于管理数据库存储资源。以下是 Oracle 12c ASM（12.1）安装配置的详细过程。 ...
window oracle12c补丁Opatch
07-31
window oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c...
《Oracle 12c数据库基础教程》教学课件—03Oracle数据库管理工具.pdf
06-22
《Oracle 12c数据库基础教程》教学课件—03Oracle数据库管理工具.pdf《Oracle 12c数据库基础教程》教学课件—03Oracle数据库管理工具.pdf《Oracle 12c数据库基础教程》教学课件—03Oracle数据库管理工具.pdf《Oracle...
个人经验总结：Oracle数据库SCN号详解
01-06
Oracle数据库SCN号详解 系统检查点scn) 数据文件检查点（v$datafile） 数据文件终止scn) 数据文件中存放的检查点 启动scn
Oracle如何得到当前SCN
weixin_42161670的博客
10-27 555
方法一 conn sys / as sysdba; select * from v$database; 方法二 select dbms_flashback.get_system_change_number from dual;
数据库恢复的过程中调整scn的方法
crh198108021的博客
07-01 237
1.通过immediate trace name方式(在数据库Open状态下) 　　alter session set events 'IMMEDIATE trace name ADJUST_SCN level x'; 2.通...
调整oracle scn,ORACLE数据库中使用ADJUST_SCN增进SCN及案例模拟
weixin_36274355的博客
04-04 348
天萃荷净使用ADJUST_SCN增进SCN及案例模拟ORA-00600: internal error code, arguments: [2662], [0]在oracle数据库中我们可以利用oracle的内部事件调整SCN。增进SCN通常有两种常用方法:1.alter session set events 'IMMEDIATE trace name ADJUST_SCN level x';--...
隐含参数_minimum_giga_scn被Oracle废弃后如何调SCN
jarry_gao的专栏
06-11 2048
Posted: August 27, 2013 | Author: Cui Hua | Filed under: Oracle | Leave a comment » 隐含参数_minimum_giga_scn在Oracle 11.2.0.2打上相关的SCN的补丁以及后续的版本中已经被废弃： Connected to Oracle Database 12c Enterprise Ed
ORA-00600 [2662] , 怎么计算 adjust SCN level
cucanqi9387的博客
07-22 102
举个例子： ORA-00600: internal error code, arguments: [2662], [0], [2179133], [8656], [70114056], [33855201], [...
oracle 推进scn（poke、gdb、event、bbed）方法
汪灵骅的博客
01-24 1065
c代表：Arg [c] dependent SCN WRAPd代表：Arg [d] dependent SCN BASESCN组成：SCN占6字节，由SCN_WRAP和SCN_BASE组成SCN是一个6字节（6*8=48bit）的数字，其值最大为281,474,976,710,656（2^48），SCN分为2个部分：SCN_BASE是一个4字节（4 * 8=32bit）的数字SCN_WRAP是一个2字节（2 * 8=16bit）的数字。
Oracle数据文件scn不一致,使用ORACDEBUG 修改 数据库SCN
weixin_27032989的博客
04-06 647
作者：Lunar©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]1988年Oracle发布了Oracle V6，这一版本中Oracle引入了热备的操作，同时SCN使用48位存储的算法写死在代码中，一直沿用至12c以前(12c开始使用8个bytes存储SCN)。由于ORACLE的SCN是由48位来表示的，因此最大值不能超过2的48次方Oracle为了确保48位的SCN能够用...
oracle 10015 trace name adjust_scn level level_num
lb517290079的专栏
04-06 876
alter session set events '10015 trace name adjust_scn level level_num 当前日志文件损坏修复可能遇到的问题。1，将undo改变成手工管理的，2，然后设置隐含参数 _ALLOW_RESETLOGS_CORRUPTION = TRUE 和 _corrupted_rollback_segments ,因为redo损坏的时候，und...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值