RE:Wondering ... Lite: Redo sequence poll

Hi,

I'm just wondering how you guys know so many undocumented Oracle parameters and what to do with them and things like that.

Please don't answer "because we're smart" ... that would be stating the obvious.

Cheers,

Sujatha
PS: "undocumented Oracle parameters" makes it OnT rather than a philosophical musing.

-----Original Message-----
Sent: Wednesday, 13 March 2002 2:23 PM
To: Multiple recipients of list ORACLE-L

John,

alter session set events 'immediate trace name ADJUST_SCN level 1' bumps the current SCN By one billion. I have used this event once while recovering a Tera Byte database where LGWR crashed and all the data files were inconsistent.

And also there is an undocumented paramter something like _Max_Giga_SCN which starts (!!) the SCN at higher values. Have anyone used that?

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

-----Original Message-----
Kanagaraj
Sent: Tuesday, March 12, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L

> I think you can **artificially** force a database to reach the SCN to
> 0xfffffff.ffff by using the event ADJUST_SCN.
> This bumps the SCN to one billion if set at level 1. So
> running them in a
> loop will bump the SCN to the max value.
> THis event generally used to bump the SCNs if there is a
> mismatch between
> file headers which is signaled by
> ORA-00600 [2662].
>
> Any volunteers?

Gopal - how do you set or access this event?

Volunteers: Just a word of warning - if you want to implement this on a Dev/Test database, make sure that it is not connected as a source or target to ANY other database via DBLinks. Otherwise you will find that these high SCNs migrate across to all others as if it were a cold virus. Such a database has to be absolutely quarantined...

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!

• The opinions and statements above are entirely my own and not those of my employer or clients **

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sujatha Madan
  INET: Sujatha.Madan_at_cmc.cwo.net.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).