Re: Questions re redo log files

Bill,

dbv is designed to verify datafiles only. It doesn't work against logfiles (online or archived) or controlfiles.

HTH,

• Anita
  • Bill Wagman <wjwagman_at_ucdavis.edu> wrote:
    > Hello,
    >
    > I have been playing around with the dbv utility and
    > have encountered
    > several questions.
    >
    > What are the ramifications of using the dbv utility
    > to look at redo logs?
    >
    > When I created the database I specified a database
    > block size of 8192 in
    > the init.ora file and used the following statement
    > to create the database...
    >
    > create database "isodtest"
    > controlfile reuse
    > maxinstances 1
    > maxlogfiles 16
    > maxdatafiles 30
    > character set "US7ASCII"
    > datafile
    > '$ORACLE_LOCAL/data/isodtest/system01.dbf' size
    > 100002K reuse logfile
    > '$ORACLE_LOCAL/data/isodtest/log01.dbf' size 10000K
    > reuse,
    > '$ORACLE_LOCAL/data/isodtest/log02.dbf' size 10000K
    > reuse,
    > '$ORACLE_LOCAL/data/isodtest/log03.dbf' size 10000K
    > reuse;
    >
    > yet when I run the dbv utility I must specify a
    > blocksize of 512 to look at
    > the redo logs.
    >
    > Why is the block size of the redo log files 512? Do
    > I need to worry about
    > the fact that the blocksize is different from the
    > rest of the files? Do I
    > have any control over this at database creation
    > time?
    >
    > When I do analyze the redo logs the utility returns
    > the following for each
    > page...
    >
    > DBVERIFY: Release 8.0.5.1.0 - Production on Fri May
    > 19 11:42:33 2000
    >
    > (c) Copyright 1998 Oracle Corporation. All rights
    > reserved.
    >
    >
    > DBVERIFY - Verification starting : FILE = log01.dbf
    > Page 1 is marked corrupt
    > ***
    > Corrupt block relative dba: 0x00000001 file=0.
    > blocknum=1.
    > Bad header found during dbv:
    > Data in bad block - type:0. format:0.
    > rdba:0x00000001
    > last change scn:0x0000.17b90186 seq:0x47 flg:0x65
    > consistancy value in tail 0x00000000
    > check value in block header: 0x800, calculated check
    > value: 0x0
    > spare1:0x2f, spare2:0x59, spare2:0x0
    >
    > Why does it return to me that there is an error on
    > each page? This does not
    > happen with any of the other files. Is this anything
    > I need to worry about?
    >
    > Thanks.
    >
    > Bill Wagman
    > Univ. of California at Davis
    > Information Resources
    > wjwagman_at_ucdavis.edu
    > (530) 754-6208
    >
    >
    

    ---

    
    > Why is it that when you're driving and looking for
    > an address, you turn
    > down the volume on the radio?
    >
    > --
    > Author: Bill Wagman
    > INET: wjwagman_at_ucdavis.edu
    >
    > 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).
    

    ---