Re: How to get the Log seq # of a datafile?

From: Steve Adams <steve_adams_at_acslink.net.au>
Date: 1997/10/24
Message-ID: <344ff287.2171680960@newsserver.trl.oz.au>#1/1

Hi Andy,

The fileheader has the latest checkpoint scn and a non-infinite stop scn if it was offlined cleanly. If you are trying to find out which logs need to be applied to a datafile, the answer is everything between the checkpoint scn and the stop scn. However, to get actual log sequence numbers instead of scn numbers, you need to look in the controlfile's log history section.

Hope this helps,
Steve Adams
steve_adams_at_acslink.net.au (remove the underscore)

---

On Thu, 23 Oct 1997 10:52:55 -0400, Andy Marcelo <amarcelo_at_djttd.com> wrote:

>How can I get the log seq number of a datafile by looking at
>its file header?
>
>Any help will be appreciated.
>
>Please email.
>
>Thanks
>
>Andy
Received on Fri Oct 24 1997 - 00:00:00 CDT