Redo Log Seq# from datafile

From: Ian Johnson CMIM <icj_at_otto.bf.rmit.oz.au>
Date: 3 Apr 92 00:41:32 GMT
Message-ID: <icj.702261692_at_otto>


I am sending this request through a friend of mine as my machine is yet to be able to post this message to a newsgroup. You may reply either to the newsgroup or directly to me.

Q. Does anyone know of a way of reading the Redo Log Sequence # stamp on an

    Oracle datafile?

I need to know the number so that I can estimate the number of Offline Redo Logs (Archivelog) and time to apply without going into SQL*DBA.

 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |email: TJambu_at_cmutual.com.au
 ______  /                   |phone: +61-3-6076448
       \/                    |  fax: +61-3-6076198
Received on Fri Apr 03 1992 - 02:41:32 CEST

Original text of this message