From vgorbounov@simplyengineering.com Tue, 20 Mar 2001 06:32:03 -0800 From: Vadim Gorbounov Date: Tue, 20 Mar 2001 06:32:03 -0800 Subject: RE: How to find SEQUENCE# Message-ID: MIME-Version: 1.0 Content-Type: text/plain Thank you Christian, That's almost what I was looking for. One issue - it doesnt work when I replace unrecoverable file with fresh hot copy. Vadim -----Original Message----- Sent: Tuesday, March 20, 2001 2:55 AM To: Multiple recipients of list ORACLE-L So rely on v$log_history. Regards. > -----Mensaje original----- > De: Vadim Gorbounov [SMTP:vgorbounov@simplyengineering.com] > Enviado el: lunes 19 de marzo de 2001 21:11 > Para: Multiple recipients of list ORACLE-L > Asunto: How to find SEQUENCE# > > 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@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@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: Trassens, Christian INET: CTrassens@uni2.es 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@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: Vadim Gorbounov INET: vgorbounov@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@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).