EVENT ADJUST_SCN 说明 [30681.1]

 

       在一篇文章中引用了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

    or

      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)

    or

      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

 

 

 

 

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

QQ:492913789

Email:ahdba@qq.com

Blog:  http://www.cndba.cn/dave

Weibo:   http://weibo.com/tianlesoftware

Twitter:  http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

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

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

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

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请