SAP Oracle Upgrade issue

[JAMpe]

Hello,

Im going through an oracle upgrade from 10.2.0.4 to 11.2.0.3, I have already done the pre-upgrade tasks with no problems, however, I'm having a dump which says that I have a data block corrupted, should I try to go through dbua or it will give me an error in upgrade or post upgrade task?  I'd like to open an OSS message however as my database is still in 10G I'd probably not get too much support.

Regards,

JAM

OS: AIX 7.1

[Reagan · Accepted solution]

Hello

I would suggest you to fix the block corruption first before you upgrade the database.

Check these SPA notes

Note 23345 - Consistency check of ORACLE database

1559652  - How to deal with block corruptions on Oracle

Note 365481 - Block corruptions

Regards

RB

[JAMpe]

Thank you all for your advice, I fixed the problem first and then went through the upgrade. Everything is ok now.

Regards,

JAM

[ACE-SAP]

Hi

If think you will get an answer from support, even if only version 10.2.0.5 is supported.

You first need to fix that corruption issue before proceeding with the upgrade.

Are your running, as SAP recommend a DB verification ?

I'm surprised that so many systems are running without having that basic security.

For the future read that note and at least setup the DB verify & DB analyze.

     23345 - Consistency check of ORACLE database

The purpose now is to be able to identify what is inside the corrupted block...

That block could either:

1) be empty

2) be unused (belonging to a segment but under the high water mark)

3) belong to an index (then you just need to recreate the index)

4) belong to a table... and then only you are in real trouble.

You shoud run a DBverify action through transaction DB13 that will provide you the list of block(s) that are corrupted.

You can also run the action directly with that command line

brbackup -u / -c force -w only_dbv -p init<SID>.sap -m ALL

Then check the DBV log to find the corrupted blocks

DBVERIFY - Verification starting : FILE = /oracle/PRD/sapdata1/prd_10/prd.data10

Page 796765 is influx - most likely media corrupt

Corrupt block relative dba: 0x034c285d (file 13, block 796765)

Fractured block found during dbv:

Data in bad block:

You can then use this query to find which object is using that block

select OWNER, SEGMENT_NAME, SEGMENT_TYPE from DBA_EXTENTS where file_id = 13 and 796765 between block_id and (block_id + blocks - 1);

[former_member207464]

Hi JAM,

You can use RMAN check instead.

It will give you a very much easier output using brconnect afterwards.

Note 23345 has details about that.

Regards,

Adriano

[former_member188883]

Hi JAM,

In case you have a corrupted block, it has to be rectified first before performing an oracle upgrade.

else it will create problems with upgrade.

Hope this helps.

Regards,

Deepak Kori