The ACTIVATION# and ARCHIVAL_THREAD# columns are apparently used by Data
Guard "fetch archive log" (FAL) processes to manage any logfile transfer
gaps using the FAL_CLIENT and FAL_SERVER parameters on the primary and
standby databases. Metalink note #150214.1 ("Synchronization of primary and
standby database due to log transfer gap") mentions the values in these
columns, though not the column names themselves.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Sunday, March 02, 2003 9:48 AM
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
INET: Tim_at_SageLogix.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).
Received on Sun Mar 02 2003 - 15:43:39 CST
