EVENT ADJUST_SCN 说明 [30681.1]

最新推荐文章于 2021-04-06 09:47:51 发布

最新推荐文章于 2021-04-06 09:47:51 发布 · 59 阅读

文章标签：

#数据库

在一篇文章中引用了ID 为[30681.1] 的文档，刚才去MOS 上查，居然没有了，原来MOS 有时也靠不住。在google 上展转了一下，找到了这篇文章。贴过来，备用。

DocID: Note:30681.1

Subject: EVENT: ADJUST_SCN - Quick Reference

Type: REFERENCE

Status: PUBLISHED

Content Type:TEXT/PLAIN

CreationDate: 20-OCT-1997

LastRevision Date: 04-AUG-2000

Language: USAENG

ADJUST_SCNEvent

~~~~~~~~~~~~~~~~

***WARNING ***

This event should only ever be used underthe guidance

of an experienced Oracle analyst.

If an SCN is ahead of the current databaseSCN, this indicates

some form of database corruption. Thedatabase should be rebuilt

after bumping the SCN.

****************

The ADJUST_SCN event is useful in somerecovery situations where the

current SCN needs to be incremented by alarge value to ensure it

isahead of the highest SCN in the database. This is typically

required if either:

a. An ORA-600 [2662] error is signalledagainst database blocks

b. ORA-1555 errors keep occuring afterforcing the database open

or ORA-604 / ORA-1555 errors occurduring database open.

(Note: If startup reports ORA-704& ORA-1555 errors together

then the ADJUST_SCN eventcannot be used to bump the

SCN as the error is occuringduring bootstrap.

Repeated startup/shutdown attemptsmay help if the SCN

mismatch is small)

c. If a database has been forced openused _ALLOW_RESETLOGS_CORRUPTION

(See<Parameter:Allow_Resetlogs_Corruption> )

The ADJUST_SCN event acts as describedbelow.

**NOTE: You can check that the ADJUST_SCNevent has fired as it

should write a message to the alert log inthe form

"Debugging event used to advance scn to %s".

If this message is NOT present in the alert log the event

has probably not fired.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If the database will NOT open:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Take a backup.

You can use event 10015 to trigger anADJUST_SCN on database open:

startup mount;

alter session set events '10015 tracename adjust_scn level 1';

(NB: You can only use IMMEDIATE here onan OPEN database. If the

database is only mounted use the 10015 trigger to adjust SCN,

otherwise you get ORA 600 [2251], [65535], [4294967295] )

alter database open;

If you get an ORA 600:2256 shutdown, usea higher level and reopen.

Do *NOT* set this event in init.ora or theinstance will crash as soon

as SMON or PMON try to do any clean up.Always use it with the

"alter session" command.

~~~~~~~~~~~~~~~~~~~~~~~~~~

If the database *IS* OPEN:

~~~~~~~~~~~~~~~~~~~~~~~~~~

You can increase the SCN thus:

alter session set events 'IMMEDIATEtrace name ADJUST_SCN level 1';

LEVEL:Level 1 is usually sufficient - it raises the SCN to 1 billion

(1024*1024*1024)

Level 2 raises it to 2 billion etc...

If you try to raise the SCN to a level LESS THAN or EQUAL to its

current setting you will get <OERI:2256> - See below.

Ie: The event steps the SCN to known levels. You cannot use

the same level twice.

Calculating a Level from 600 errors:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To get a LEVEL for ADJUST_SCN:

a) Determine the TARGET scn:

ora-600 [2662] See <OERI:2662> Use TARGET >= blocks SCN

ora-600 [2256] See<OERI:2256> Use TARGET >=Current SCN

b)Multiply the TARGET wrap number by 4. This will give you the level

to use in the adjust_scn to get the correct wrap number.

c) Next, add the following value to thelevel to get the desired base

value as well :

Add to Level Base

~~~~~~~~~~~~ ~~~~~~~~~~~~

0 0

1 1073741824

2 2147483648

3 3221225472

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

Blog： http://blog.youkuaiyun.com/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群：62697716(满); DBA2 群：62697977(满)DBA3 群：62697850(满)

DBA 超级群：63306533(满); DBA4 群： 83829929 DBA5群： 142216823

DBA6 群：158654907 聊天群：40132017 聊天2群：69087192