Re: DBVERIFY on system ts

Mark Marsden wrote:
>
> Hi all
>
> If I run dbverify on the system ts (or rbs ts AND on different dbs) I get
> the following:
>
> DBVERIFY - Verification starting : FILE = /dpp/test01/HOUR/HOURsystem01.dbf
> Block Checking: DBA = 67108867, Block Type = Undo data block
> ERROR: Undo Block Corrupted. Error Code = 2005
> ktu4ubck: Undo Record addr did not aligned to boundary
> record number=1, addr=080d6392, aligned addr=080d6394
> UNDO BLK HEADER:
> xid: 0x0000.02f.00000166 seq: 0x1c5 cnt: 0x24 irb: 0x24 icl: 0x0 flg:
> 0x0000
>

see Note:118008.1 on Metalink.
DBV Report UNDO Corruption after Migrating V7.X to V8.X using Mig Utility

the solution is to shrink the rollback segs, run u0703040.sql and force DML to touch RBS's.

Paul

> Looks serious but the summary looks ok and the dbs seems ok.
> I tried it on a newly created db and don't get it and the dbverify docs say
> nothing.
> Should I be worried about this?
>
> DBVERIFY - Verification complete
>
> Total Pages Examined : 51200
> Total Pages Processed (Data) : 20271
> Total Pages Failing (Data) : 0
> Total Pages Processed (Index): 7773
> Total Pages Failing (Index): 0
> Total Pages Processed (Other): 4951
> Total Pages Empty : 18205
> Total Pages Marked Corrupt : 0
> Total Pages Influx : 0
>
> Cheers for any feedback
>
> Mark Marsden.
>
>
>********************************************************************************************************************************
> Hyde Housing Association - Email Disclaimer
>
> The information in this email is strictly confidential and may be legally privileged.
>
> It is intended solely for the addressee only. Access to this email by anyone else is
>unauthorised.
> If you are not the intended recipient and you have recieved this email in error you
>must take no action
> on its contents, nor must you copy or show them to anyone, or make use of the
>information therein.
> Please reply to the email immediately, or forward to helpdesk_at_hyde-housing.co.uk,
>highlighting
> the error and confirming that it has been deleted from your system.
>
> SECURITY WARNING: Please note that this email has been created with the
>knowledge that the Internet
> is not a 100% secure communications medium. We advise that you understand and observe
> this lack of security when e-mailing us.
> VIRUSES: Although we have taken steps to ensure that this email and attachments
>are free
> from any virus, we advise that in keeping with good computing practise the recipient
>should ensure
> that they are actually virus free.
>
>********************************************************************************************************************************
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Marsden
> INET: mark.marsden_at_hyde-housing.co.uk
>
> 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: Paul Drake
  INET: paled_at_home.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).