How to find SEQUENCE#

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Mon, 19 Mar 2001 13:27:27 -0800
Message-ID: <F001.002D0E1B.20010319121041@fatcity.com>

        Hi, DBAs,

        Can anybody give me a guess, how to find out next log SEQUENCE#, required for recovery, without issuing RECOVER command? I believe, this is not possible to find it out of Oracle dictionary, can anybody confirm this or, otherwise, name appropriate fixed table? I'm particularly concerned with standby database recovery, I want to know in advance SEQUENCE#, required to roll forward, and don't want to rely on alertXXX.log tail.

        Another question, in "normal" database I can find correspondence between CHANGE# and log SEQUENCE# from v$archived_log or v$log. Where to look this correspondence in standby database.

        Thanks for Your Help
        Vadim Gorbounov
        Oracle DBA

        

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vadim Gorbounov
  INET: vgorbounov_at_simplyengineering.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). Received on Mon Mar 19 2001 - 15:27:27 CST