Re: [Q] archive log list from tables

From: Naren Chintala <naren_at_mink.att.com>
Date: 1997/03/21
Message-ID: <33330E44.3590@mink.att.com>#1/1

Almut Herzog wrote:
>
> HI,
>
> Using 'archive log list' from SQLDBA results in lines like
>
> Database log mode ARCHIVELOG
> Automatic archival ENABLED
> Archive destination /tmp/xxx
> Oldest online log sequence 59
> Next log sequence to archive 61
> Current log sequence 61
>
> How do I query 'Oldest online log sequence' and 'Current log sequence'
> from a table? From which table?
>
> Please reply by e-mail, too. It's faster and more reliable.
> TIA
>
> --
> Almut Herzog
> SECTRA-Imtec AB e-mail: al-her_at_sectra.se
> Teknikringen 2 voice: ++46 13 235221
> 583 30 Linkoping fax: ++46 13 212185
> SWEDEN
select min(SEQUENCE#) "Oldest online log sequence" , MAX(SEQUENCE#) "Current log sequence" from v$log;

Cheers

-- 
Naren

Received on Fri Mar 21 1997 - 00:00:00 CST