Linda,
This information is covered in the Backup and Recovery
Internals course offered by Oracle.
In addition to the info provided by Riyaj, here are
some more details:
flg values:
0x01 log has been archived
0x02 no more space available in log
0x04 the next log to be used
0x08 the current log
0x10 log is being cleared
hws: header write sequence
I'm not sure what this is used for, but I imagine
it's another cross check mechanism to ensure that the
correct version of the block is being accessed.
Lest you get the idea to manually hack the file
headers, a checksum is stored in the file header.
HTH,
- Anita
- Riyaj_Shamsudeen_at_i2.com wrote:
> Hi Linda
> Welcome to Oracle! I am aware that db2 has
> wealth of documentation
> and manuals, but you would n't find these
> information any where in the
> Oracle documentation..
> Anyway , here is the info that you are looking for:
> Again, this is from my
> memory so use caution..
>
> siz: Indicates the size of the log file in log block
> size. So your log
> file size would be 20480 * 512 =10M
> seq: Log sequence # in hex
> hws: heck, I don't remember this:-( Been a while
> looking at this..
> bsz:log block size. same as 'select lebsz from
> x$kccle'
> nab:next available block.
> flg:Status of the log, like current etc. If I
> remember correctly, this is
> a bitmap to indicate various statuses.
> dup: # of members in the group.
>
> Thanks
> Riyaj "Re-yas" Shamsudeen
> Certified Oracle DBA
> i2 technologies www.i2.com
>
>
>
>
> "Hagedorn, Linda" <lindah_at_epocrates.com>
> Sent by: root_at_fatcity.com
> 05/30/01 03:38 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: alter session set events
> 'immediate trace name redohdr level 10'
>
>
> Hello,
> I'm looking for documentation to name and label the
> output from the dump
> of redo headers and logs. For example,
> siz: 0x5000 seq: 0x00001087 hws: 0x2 bsz: 512 nab:
> 0x5001 flg: 0x0 dup: 2
> The size parameter is what, the header size in hex?
> x5000 = decimal
> 20480?
> In the DB2 world, this kind of information is
> readily available and
> provided to licensed customers in the DB2 Diagnosis
> Manual. I would think
> the Oracle diagnosis info should be as available as
> IBM's. Yes? A search
> in MetaLink for this list returned zero hits: siz
> seq hws bsz nab flg dup
>
>
> Any information or referral to documentation is
> appreciated. Thanks,
> Linda. Oracle DBA, former IBM DB2 L2.
>
>
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.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 Thu May 31 2001 - 07:27:29 CDT
