Each instance will have an associated thread and the
combination of the thread# and the sequence#
distinguishes a log file and an archive file.
v$log:
log file information from control file.
Name Null? Type DESCRIPTION
- -------- ----
GROUP# NUMBER LOG GROUP NUMBER
THREAD# NUMBER LOG THREAD NUMBER
SEQUENCE# NUMBER LOG SEQUENCE NUMBER
BYTES NUMBER SIZE OF THE LOG
MEMBERS NUMBER NUMBER OF MEMBERS
ARCHIVED VARCHAR2(3) ARCHIVE STATUS:
T/F
STATUS VARCHAR2(16) STATUS OF THE
REDO LOGS
FIRST_CHANGE# NUMBER LOWEST SCN IN THE
LOG
FIRST_TIME DATE TIME OF THE
FIRST SCN IN THE LOG
- ddorr.cs_at_clearstream.com wrote: > Each instance
mounting a database has its own redo
> thread.
> When you run an OPS with multiple instances, you
> will have one redo thread
> per instance with the redo blocks generated by this
> instance.
>
> > ----------
> > From: Dash, Saroj
> (CAP,CEF)[SMTP:Saroj.Dash_at_gecapital.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Friday, November 10, 2000 04:50
> > To: Multiple recipients of list ORACLE-L
> > Subject: Redo Threads
> >
> > Hello All,
> >
> > Is any body will tell me what is mean by Redo
> threads.
> >
> > Regards,
> > Saroj.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Dash, Saroj (CAP,CEF)
> > INET: Saroj.Dash_at_gecapital.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > 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.com
> --
> Author:
> INET: ddorr.cs_at_clearstream.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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 Mon Nov 13 2000 - 10:25:32 CST