Re: V$ARCHIVED_LOG question

Murali,

I can offer some insight into the activation# column because I was interested in that too earlier. When a database starts, a new "database instantiation id" is given to that instance, presumably for the RMAN backups. This id can be seen from v$database under column activation#. So when you create another incarnation of the database using RMAN cloning, the archived logs are either used or not depending on the value of this activation# associated with them.

Hope someone else can shed some light into the other columns - particularly archival_thread# and why it's different from the thread#.

Arup Nanda

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, March 02, 2003 9:58 AM

> Oracle 9i has quite a few new columns added to the V$ARCHIVED_LOG
dictionary
> view,however there is no documentation.
>
> For example, END_OF_REDO, ARCHIVAL_THREAD#,ACTIVATION#
>
> Any clues on what these columns mean.
>
> Thanks
>
> Murali
>
> DEST_ID THREAD# SEQUENCE# END BACKUP_COUNT ARCHIVAL_THREAD#
> ACTIVATION#
> ---------- ---------- ---------- --- ------------ ----------------
> -----------
> 1 2 48 NO 1 2
> 3612293975
> 1 1 116 NO 1 1
> 3612293975
> 1 2 49 NO 1 2
> 3612293975
> 1 1 117 NO 0 1
> 3612293975
> 1 2 50 NO 0 2
> 3612293975
> 1 1 118 NO 0 2
> 3612293975
> 1 2 51 NO 0 2
> 3612293975
> 1 1 119 NO 0 2
> 3612293975
> 1 2 52 NO 0 2
> 3612293975
>
>
>
>
> Murali Vallath
>
>
>
>
>
>
> _________________________________________________________________
> Add photos to your messages with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Murali Vallath
> INET: murali_vallath_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).