Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Redo Log Seq# from datafile

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@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 Thu Apr 02 1992 - 18:41:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US