手动递增SCN号的几种方法
除去下面几种，还有一种方法直接修改 实例的Global Lamport SCN，在SGA中由kcsgscn变量存储，对于一个实例来说这是唯一的源SCN，所有其他的SCN均由这个source scn所驱动。 这种递增方式是直接用oradebug 修改该Global Lamport SCN kcsgscn
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]
SQL> oradebug setmypid
Statement processed.
SQL> select to_char(current_scn,’XXXXXXXXXXXX’) from v$database;
TO_CHAR(CURRE
————-
D3E1E
SQL>
SQL> oradebug DUMPvar SGA kcsgscn
kcslf kcsgscn_ [060012658, 060012688) = 000D3E1E 00000000 00000000 00000000 0000162D 00000000 00000000 00000000 00000000 00000000 60012338 00000000
ORADEBUG POKE 0x060012658 4 0xfffff
poke 命令的语法
<address> <length> <value>” allows you to modify a given region of memory (length of memory is limited to size of scalar C types)
SQL> select current_scn from v$database;
CURRENT_SCN
———–
1048583
SQL> select to_char(current_scn,’XXXXXXXXXXXX’) from v$database;
TO_CHAR(CURRE
————-
10000B
SQL> oradebug DUMPvar SGA kcsgscn
kcslf kcsgscn_ [060012658, 060012688) = 00100010 00000000 00000000 00000000 0000004E 00000000 00000000 00000000 00000000 00000000 60012338 00000000
How to jump SCN by manual , this could be a problem:
1. We can bump up the SCN by using the procedure from Note: 386830.1
Bump the system SCN on the primary database to fix any metadata index corruptions for both primary and physical standby databases. Set the following parameters in the init.ora and restart the database in restricted mode to bump the system SCN of the primary database. For Real Application Clusters, perform the steps on only one node of the cluster. Init.ora syntax: *._allow_error_simulation = TRUE *._smu_debug_mode = 268435456 If using an spfile, Oracle recommends creating a temporary init.ora using the CREATE PFILE SQL command. SQL> create pfile='/tmp/initTMP.ora' from spfile=''; Then add the parameters to this temporary file. To use the temporary init.ora file when starting the instance, include the 'PFILE' clause with the STARTUP SQL command i.e. SQL> startup restrict pfile= WARNING: These parameters should only be used for this fix and must be removed immediately afterwards in step 2. If the above parameters are used through multiple database restarts, a complete database rebuild will be required. To know the system SCN has been bumped, monitor the instance's alert.log for the following message: advance SCN to wrap base xxxx Where xxx represents the new wrap SCN.
2.EVENT: ADJUST_SCN – Quick Reference (Doc ID 30681.1)
WORKAROUND: ----------- Searched in webiv (ora-1555, ora-604 see note:1063408.6 ) suggests workaround is to adjust serial number using event Will try : (30681.1) alter session set events 'IMMEDIATE trace name ADJUST_SCN level 1'; ora-600 [2256][0][1073741824][1][293672646] ERROR: ORA-600 [2256][a][b][c][d][e] VERSIONS: versions 7.3.X, 8.0.X, 8.1.X DESCRIPTION: This exception indicates that you attempted to ADJUST_SCN but the level supplied would be less that the current SCN. ARGUMENTS: a. Requested SCN WRAP b. Requested SCN BASE c. Current SCN WRAP d. Current SCN BASE = [293672646] *4 = 1174690584 will try level 2 ora-600 2256[0][2147483648][1][293672646] level 3 ora-600 2256[0][3221225472][1][293672646] Now, we increase the SCN on DST7 by using the ADJUST_SCN event - (Note: do not use this event outside of your test environment) set the following hidden parameter in init.ora on DST7 database and bounce the database. _allow_error_simulation=true Now, the SCN is increased by doing - alter system set events 'immediate trace name adjust_scn level '; where translates to (n*0x40000000) as the target SCN value. ie. n = 1 will set the SCN as 0x0000.40000000. For the testcase pick a value that is larger than the current SCN on both databases by atleast 100000 SCNs (our earlier SCN adjust threshold value). alter system set events 'immediate trace name adjust_scn level 2'; select to_char(current_scn, 'xxxxxxxxxxxx') from v$database;
3.Note 552438.1 How To Adjust the SCN using parameter _MINIMUM_GIGA_SCN
Parameter: MINIMUM_GIGA_SCN
~~~~~~~~~~~~~~~~~~~~~~~~~~~
@Oracle8i: HIDDEN
@Identifier: kcmmsn
@Versions: See <IVERS.MINIMUM_GIGA_SCN>
Values:
Related:
Description: Minimum SCN to start with in 2^30 units
~~~~~~~~~~~~
Articles:
<Event:ADJUST_SCN>
Overview of Init.Ora Parameter Reference notes
终极方案：
使用bbed修改datafile header实现修改scn
主要是修改system01.dbf datafile header kcvfh.kcvfhckp.kcvcpscn
[email protected] [email protected] SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Linux: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production 1* select name,CHECKPOINT_CHANGE# from v$datafile SQL> / /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system_9f2flf09_.dbf 3905523 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_undotbs1_9f2flf52_.dbf 3905523 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_sysaux_9f2flf2v_.dbf 3905523 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_users_9f2flf5g_.dbf 3905523 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_example_9f2fmfto_.dbf 3905523 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_youchuan_9f2fqwr4_.dbf 3905523 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_guobao_9f2fwkkt_.dbf 3905523 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_tsoa_d_bjx6j57v_.dbf 3905523 SQL> select to_char(3905523,'XXXXXXXXXXXXX') from dual; TO_CHAR(390552 -------------- 3B97F3 SQL> oradebug tracefile_name /s01/oracle/product/10.2.0/db_1/admin/MACLEAN1/udump/maclean1_ora_9468.trc [oracle@vrh8 ~]$ cp /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system_9f2flf09_.dbf /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system_9f2flf09_.dbf.bak [oracle@vrh8 ~]$ bbed filename=/s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system_9f2flf09_.dbf password=blockedit BBED: Release 2.0.0.0.0 - Limited Production on Tue Mar 24 16:50:39 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** BBED> set mode edit MODE Edit BBED> set blocksize 8192 BLOCKSIZE 8192 BBED> set block 1 BLOCK# 1 BBED> map File: /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system (0) Block: 1 Dba:0x00000000 ------------------------------------------------------------ Data File Header struct kcvfh, 676 bytes @0 ub4 tailchk @8188 BBED> p kcvfh struct kcvfh, 676 bytes @0 struct kcvfhbfh, 20 bytes @0 ub1 type_kcbh @0 0x0b ub1 frmt_kcbh @1 0xa2 ub1 spare1_kcbh @2 0x00 ub1 spare2_kcbh @3 0x00 ub4 rdba_kcbh @4 0x00400001 ub4 bas_kcbh @8 0x00000000 ub2 wrp_kcbh @12 0x0000 ub1 seq_kcbh @14 0x01 ub1 flg_kcbh @15 0x04 (KCBHFCKV) ub2 chkval_kcbh @16 0x4fc6 ub2 spare3_kcbh @18 0x0000 struct kcvfhhdr, 76 bytes @20 ub4 kccfhswv @20 0x00000000 ub4 kccfhcvn @24 0x0a200100 ub4 kccfhdbi @28 0x157f2927 text kccfhdbn[0] @32 M text kccfhdbn[1] @33 A text kccfhdbn[2] @34 C text kccfhdbn[3] @35 L text kccfhdbn[4] @36 E text kccfhdbn[5] @37 A text kccfhdbn[6] @38 N text kccfhdbn[7] @39 1 ub4 kccfhcsq @40 0x00000675 ub4 kccfhfsz @44 0x00010900 s_blkz kccfhbsz @48 0x00 ub2 kccfhfno @52 0x0001 ub2 kccfhtyp @54 0x0003 ub4 kccfhacid @56 0x00000000 ub4 kccfhcks @60 0x00000000 text kccfhtag[0] @64 text kccfhtag[1] @65 text kccfhtag[2] @66 text kccfhtag[3] @67 text kccfhtag[4] @68 text kccfhtag[5] @69 text kccfhtag[6] @70 text kccfhtag[7] @71 text kccfhtag[8] @72 text kccfhtag[9] @73 text kccfhtag[10] @74 text kccfhtag[11] @75 text kccfhtag[12] @76 text kccfhtag[13] @77 text kccfhtag[14] @78 text kccfhtag[15] @79 text kccfhtag[16] @80 text kccfhtag[17] @81 text kccfhtag[18] @82 text kccfhtag[19] @83 text kccfhtag[20] @84 text kccfhtag[21] @85 text kccfhtag[22] @86 text kccfhtag[23] @87 text kccfhtag[24] @88 text kccfhtag[25] @89 text kccfhtag[26] @90 text kccfhtag[27] @91 text kccfhtag[28] @92 text kccfhtag[29] @93 text kccfhtag[30] @94 text kccfhtag[31] @95 ub4 kcvfhrdb @96 0x00400179 struct kcvfhcrs, 8 bytes @100 ub4 kscnbas @100 0x00000008 ub2 kscnwrp @104 0x0000 ub4 kcvfhcrt @108 0x221e01bf ub4 kcvfhrlc @112 0x31dd7868 struct kcvfhrls, 8 bytes @116 ub4 kscnbas @116 0x00080634 ub2 kscnwrp @120 0x0000 ub4 kcvfhbti @124 0x00000000 struct kcvfhbsc, 8 bytes @128 ub4 kscnbas @128 0x00000000 ub2 kscnwrp @132 0x0000 ub2 kcvfhbth @136 0x0000 ub2 kcvfhsta @138 0x2000 (NONE) struct kcvfhckp, 36 bytes @484 struct kcvcpscn, 8 bytes @484 ub4 kscnbas @484 0x003b97f3 ub2 kscnwrp @488 0x0000 ub4 kcvcptim @492 0x342a9561 ub2 kcvcpthr @496 0x0001 union u, 12 bytes @500 struct kcvcprba, 12 bytes @500 ub4 kcrbaseq @500 0x00000052 ub4 kcrbabno @504 0x00013fc0 ub2 kcrbabof @508 0x0010 ub1 kcvcpetb[0] @512 0x02 ub1 kcvcpetb[1] @513 0x00 ub1 kcvcpetb[2] @514 0x00 ub1 kcvcpetb[3] @515 0x00 ub1 kcvcpetb[4] @516 0x00 ub1 kcvcpetb[5] @517 0x00 ub1 kcvcpetb[6] @518 0x00 ub1 kcvcpetb[7] @519 0x00 ub4 kcvfhcpc @140 0x00000087 ub4 kcvfhrts @144 0x3427f1a8 ub4 kcvfhccc @148 0x00000086 struct kcvfhbcp, 36 bytes @152 struct kcvcpscn, 8 bytes @152 ub4 kscnbas @152 0x00000000 ub2 kscnwrp @156 0x0000 ub4 kcvcptim @160 0x00000000 ub2 kcvcpthr @164 0x0000 union u, 12 bytes @168 struct kcvcprba, 12 bytes @168 ub4 kcrbaseq @168 0x00000000 ub4 kcrbabno @172 0x00000000 ub2 kcrbabof @176 0x0000 ub1 kcvcpetb[0] @180 0x00 ub1 kcvcpetb[1] @181 0x00 ub1 kcvcpetb[2] @182 0x00 ub1 kcvcpetb[3] @183 0x00 ub1 kcvcpetb[4] @184 0x00 ub1 kcvcpetb[5] @185 0x00 ub1 kcvcpetb[6] @186 0x00 ub1 kcvcpetb[7] @187 0x00 ub4 kcvfhbhz @312 0x00000000 struct kcvfhxcd, 16 bytes @316 ub4 space_kcvmxcd[0] @316 0x00000000 ub4 space_kcvmxcd[1] @320 0x00000000 ub4 space_kcvmxcd[2] @324 0x00000000 ub4 space_kcvmxcd[3] @328 0x00000000 word kcvfhtsn @332 0 ub2 kcvfhtln @336 0x0006 text kcvfhtnm[0] @338 S text kcvfhtnm[1] @339 Y text kcvfhtnm[2] @340 S text kcvfhtnm[3] @341 T text kcvfhtnm[4] @342 E text kcvfhtnm[5] @343 M text kcvfhtnm[6] @344 text kcvfhtnm[7] @345 text kcvfhtnm[8] @346 text kcvfhtnm[9] @347 text kcvfhtnm[10] @348 text kcvfhtnm[11] @349 text kcvfhtnm[12] @350 text kcvfhtnm[13] @351 text kcvfhtnm[14] @352 text kcvfhtnm[15] @353 text kcvfhtnm[16] @354 text kcvfhtnm[17] @355 text kcvfhtnm[18] @356 text kcvfhtnm[19] @357 text kcvfhtnm[20] @358 text kcvfhtnm[21] @359 text kcvfhtnm[22] @360 text kcvfhtnm[23] @361 text kcvfhtnm[24] @362 text kcvfhtnm[25] @363 text kcvfhtnm[26] @364 text kcvfhtnm[27] @365 text kcvfhtnm[28] @366 text kcvfhtnm[29] @367 ub4 kcvfhrfn @368 0x00000001 struct kcvfhrfs, 8 bytes @372 ub4 kscnbas @372 0x00000000 ub2 kscnwrp @376 0x0000 ub4 kcvfhrft @380 0x00000000 struct kcvfhafs, 8 bytes @384 ub4 kscnbas @384 0x00000000 ub2 kscnwrp @388 0x0000 ub4 kcvfhbbc @392 0x00000000 ub4 kcvfhncb @396 0x00000000 ub4 kcvfhmcb @400 0x00000000 ub4 kcvfhlcb @404 0x00000000 ub4 kcvfhbcs @408 0x00000000 ub2 kcvfhofb @412 0x000a ub2 kcvfhnfb @414 0x000a ub4 kcvfhprc @416 0x221e01a8 struct kcvfhprs, 8 bytes @420 ub4 kscnbas @420 0x00000001 ub2 kscnwrp @424 0x0000 struct kcvfhprfs, 8 bytes @428 ub4 kscnbas @428 0x00000000 ub2 kscnwrp @432 0x0000 ub4 kcvfhtrt @444 0x00000000 BBED> p kcvfhckp struct kcvfhckp, 36 bytes @484 struct kcvcpscn, 8 bytes @484 ub4 kscnbas @484 0x003b97f3 ub2 kscnwrp @488 0x0000 ub4 kcvcptim @492 0x342a9561 ub2 kcvcpthr @496 0x0001 union u, 12 bytes @500 struct kcvcprba, 12 bytes @500 ub4 kcrbaseq @500 0x00000052 ub4 kcrbabno @504 0x00013fc0 ub2 kcrbabof @508 0x0010 ub1 kcvcpetb[0] @512 0x02 ub1 kcvcpetb[1] @513 0x00 ub1 kcvcpetb[2] @514 0x00 ub1 kcvcpetb[3] @515 0x00 ub1 kcvcpetb[4] @516 0x00 ub1 kcvcpetb[5] @517 0x00 ub1 kcvcpetb[6] @518 0x00 ub1 kcvcpetb[7] @519 0x00 BBED> set offset 484 OFFSET 484 BBED> modify /x 0xF397 File: /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system (0) Block: 1 Offsets: 484 to 995 Dba:0x00000000 ------------------------------------------------------------------------ f397f4f3 00000000 61952a34 01000000 52000000 c03f0100 1000a865 02000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0d000d00 0d000100 00000000 00000000 00000000 02004000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 <32 bytes per line> BBED> set offset 486 OFFSET 486 BBED> modify /x 0x4B00 File: /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system (0) Block: 1 Offsets: 486 to 997 Dba:0x00000000 ------------------------------------------------------------------------ 4b000000 00006195 2a340100 00005200 0000c03f 01001000 a8650200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000d00 0d000d00 01000000 00000000 00000000 00000200 40000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 <32 bytes per line> BBED> p kcvfhckp struct kcvfhckp, 36 bytes @484 struct kcvcpscn, 8 bytes @484 ub4 kscnbas @484 0x004b97f3 ub2 kscnwrp @488 0x0000 ub4 kcvcptim @492 0x342a9561 ub2 kcvcpthr @496 0x0001 union u, 12 bytes @500 struct kcvcprba, 12 bytes @500 ub4 kcrbaseq @500 0x00000052 ub4 kcrbabno @504 0x00013fc0 ub2 kcrbabof @508 0x0010 ub1 kcvcpetb[0] @512 0x02 ub1 kcvcpetb[1] @513 0x00 ub1 kcvcpetb[2] @514 0x00 ub1 kcvcpetb[3] @515 0x00 ub1 kcvcpetb[4] @516 0x00 ub1 kcvcpetb[5] @517 0x00 ub1 kcvcpetb[6] @518 0x00 ub1 kcvcpetb[7] @519 0x00 BBED> sum Check value for File 0, Block 1: current = 0x4fc6, required = 0x4fb6 BBED> sum apply Check value for File 0, Block 1: current = 0x4fb6, required = 0x4fb6 BBED> verify DBVERIFY - Verification starting FILE = /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system_9f2flf09_.dbf BLOCK = 1 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 0 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 SQL> select file#,name,checkpoint_change# from v$datafile; 1 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_system_9f2flf09_.dbf 3905523 2 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_undotbs1_9f2flf52_.dbf 3905523 3 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_sysaux_9f2flf2v_.dbf 3905523 4 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_users_9f2flf5g_.dbf 3905523 5 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_example_9f2fmfto_.dbf 3905523 6 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_youchuan_9f2fqwr4_.dbf 3905523 7 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_guobao_9f2fwkkt_.dbf 3905523 8 /s01/oracle/product/10.2.0/db_1/oradata/MACLEAN1/datafile/o1_mf_tsoa_d_bjx6j57v_.dbf 3905523 8 rows selected. SQL> select file#,FUZZY,CHECKPOINT_CHANGE# from v$datafile_header; 1 NO 4954099 2 NO 3905523 3 NO 3905523 4 NO 3905523 5 NO 3905523 6 NO 3905523 7 NO 3905523 8 NO 3905523 8 rows selected. SQL> alter database open; Database altered. SQL> select file#,FUZZY,CHECKPOINT_CHANGE# from v$datafile_header; 1 YES 4954100 2 YES 4954100 3 YES 4954100 4 YES 4954100 5 YES 4954100 6 YES 4954100 7 YES 4954100 8 YES 4954100 8 rows selected. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 591396864 bytes Fixed Size 2022536 bytes Variable Size 180355960 bytes Database Buffers 402653184 bytes Redo Buffers 6365184 bytes Database mounted. Database opened.
Leave a Reply