Re: [Q] archive log list from tables

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
Almut:

I believe most of this information can be found from the v$log table an example of the v$log table from one of our instances is shown below.

 select * from v$log;

GROUP# THREAD# SEQ# SIZE  MMBRS ARC STATUS CHANGE#     TIME 
------ ------  ---- ----- ----- --- ------ -------     ----
1      1       5697 10M   2     NO  CURRENT 2541549238 03/21/97 08:51:04
2      1       5695 10M   2     YES INACTVE 2541547000 03/21/97 04:03:51
3      1       5696 10M   2     YES INACTVE 2541548308 03/21/97 06:39:52

Here is the archive log list for the same instance:

>connect internal

 Connected.
>archive log list

 Database log mode              ARCHIVELOG  
 Automatic archival             ENABLED
 Archive destination            
/db62/ORACLE/backup/archived_redo_logs/devl/de
 Oldest online log sequence     5695
 Next log sequence to archive   5697  
 Current log sequence           5697

Hope this helps,

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