Sitemap

Amicuk Programming Answers

Database Block Corruption

-0001-11-30   Views:1

Advertisement

Dear Experts, In our BW system, from the alert log we have found that one oracle block was corrupted. > ORA-01578: ORACLE data block corrupted (file # 137, block # > 516877)#ORA-01110: data file 137: > '/oracle/PBP/sapdata1/sr3_121/sr3.data121'#O

Dear Experts,
In our BW system, from the alert log we have found that one oracle block was corrupted.
> ORA-01578: ORACLE data block corrupted (file # 137, block #
> 516877)#ORA-01110: data file 137:
> '/oracle/PBP/sapdata1/sr3_121/sr3.data121'#ORA-26040: Data
> block was loaded using the NOLOGGING option
Database error 1578
Database error 1578 at FET
> ORA-01578: ORACLE data block corrupted (file # 137, block #
> 516877)#ORA-01110: data file 137:
> '/oracle/PBP/sapdata1/sr3_121/sr3.data121'#ORA-26040: Data
> block was loaded using the NOLOGGING option
Database error 1578
From the SAP Market place we have found one KBA (1812719 - Avoid NOLOGGING during the index creation) which says that it was not really a corruption and it can be cleared by rebuilding the index.
Can any one please help us how to find the index present in that block. I have tried with below command which returns no rows.
SQL> select segment_name, partition_name, segment_type, block_id, blocks from dba_extents where (516877 between block_id and (block_id + blocks - 1)) and file_id = 137 and rownum < 2;
no rows selected
SQL>
Please suggest how to find the index for rebuilding the same for clearing the corruption.
Thanks
Suresh

The replay answer
Advertisement
Hi Suresh,
Kindly check SAP Notes  365481 - Block corruptions
1559652 - How to deal with block corruptions on Oracle
923919 - Advanced Oracle block checking features
Regards,
Gaurav

Go to See the other 5 answers

OAF Update of Custom Table causing ORA-600 with database block corruption?

Category:DefaultRelease time:2015-10-11Views:130

Using OA Framework 12.1.3, running under EBusiness Suite 12.1.3 Created Custom Web page operating against Custom Tables ISSUE On about 2% of new records, when OAF is UPDATING a record in a certain table, it  is failing with java.sql.SQLException: ORA[More]

Database Block Corruption

Category:DefaultRelease time:-0001-11-30Views:130

Dear Experts, In our BW system, from the alert log we have found that one oracle block was corrupted. > ORA-01578: ORACLE data block corrupted (file # 137, block # > 516877)#ORA-01110: data file 137: > '/oracle/PBP/sapdata1/sr3_121/sr3.data121'#O[More]

DB block corruption by using OEM

Category:DefaultRelease time:-0001-11-30Views:130

1. OEM can discover database block corruption, but I wasn't sure if whether db_block_checking and db_block_checksum need to be set in order for OEM to discover corruption or we don't have to set this parameter. 2. If we set db_block_checksum and db_b[More]

DB block corruption

Category:DefaultRelease time:-0001-11-30Views:130

Hi All Is there any specific reason or what have possible to cause on the data block corruption in the oracle database.Block corruption is while the data is being written to the data blocks, if the write to the block fails abruptly, I mean that there[More]

System datafile block corruption - no backups and database in NOARCHIVELOG mode

Category:DefaultRelease time:2015-10-11Views:130

Dear All, Database version - oracle 11.1 Enterprise OS - RHELinux 5.8 What are the options of recovering from physical block corruption when there are no backup available to perform block media recovery? V$DATABASE_BLOCK_CORRUPTION reports two segmen[More]

Block corruption on Standby database

Category:DefaultRelease time:-0001-11-30Views:130

Oracle 10g R2 64bit on Solaris 10 installed on two database server, Sun M5000 and Sun V890 Primary and physical Standby database is configured with Max performance Async mode, log shipping is ok, archive logs are also applying.. I opened the standby[More]

Data block corrupted on standby database (logical corruption)

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, we are getting the below error on our DRSITE,it is MANUAL PHYSCIAL STANDBY DATABSE... The following error has occurred: ORA-01578: ORACLE data block corrupted (file # 3, block # 3236947) ORA-01110: data file 3: '/bkp/oradata/orcl_raw_cadata01[More]

Oracle 11g: Block Corruption in SYSAUX File

Category:DefaultRelease time:2015-10-11Views:130

Hello All, I am facing Data corruption issue in the SYSAUX file. We are using Oracle 11G (Microsoft 32 bit) and our system is running in noarchivelog mode. Following are the errors in the alert log. e:\sc\sc15.2\databases\oracleconfig\diag\rdbms\enms[More]

Need advice on ORA-01578: ORACLE data block corrupted

Category:DefaultRelease time:2015-10-11Views:130

We have a development database server version- 10.2.0.3 with materialized views refresh as complete every morning. Yesterday we had a power failure and the server went down and database was shutdown unexpectedly. When we restarted the database after[More]

Oracle 11g - How to repair block corruption(on free space) in datafile

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a tablesopace with 3 datafiles, out of which one datafile has corrupted block. But no objects or data is affected as the corrupted block os in free space. This was shown in the alert logs. Please see below the details: Wed Apr 06 15:30:04[More]

Data Block Corruption

Category:DefaultRelease time:2015-10-11Views:130

I'm on 9i R2 Patch 7 on a Microsoft Windows Server 2003. How do you fix data block corruption in a Table? Is the some way to retrieve the data from the Table drop it then recreate and reimport the data? or do you have to succumb with restoring the Da[More]

Hot
Hi all I am sending an IDoc type ORDERS05 from XI to SAP R/3. Everything seems to be alright when looking at SXMB_MONI. Nevertheless, there is no IDoc created in SAP R/3, and I cannot find a hint anywhere (queues, etc.) what the problem could be. Doe [More]
I need to parse some log files extracting only the numerical parts of interest.  Example line: x264 [info]: SSIM Mean Y:0.9689320 (15.077db) Two goals here: 1) Capture the number after the "Y:" --> 0.9689320 2) Capture the number in () withou [More]
Hi All, Can we enhance the Sender SOAP Adapter with our own modules on the Module Tab Page in the Module Processor? I believe the answer is no. However, whatever may be the answer, I would like to know that is there any specific reason for that. Plea [More]
My young kids have ipads and since I updated the software, but they have their own icloud account, predictive text within their messages shows all my contacts from my iphone but the contacts are not listed as their contacts, how do I stop this?I have [More]
Is anyone familiar with "The Standby Wizard for Oracle " by Relational Database Consultants, Inc? It is a GUI app that supposedly simplifies and automates the creation, maintenance, and switchback functions necessary to implement Oracle's standb [More]
Installer file damaged.  I have installed and re-installed Adobe Air at least 10 times.  How do I correct the error?http://helpx.adobe.com/air/kb/troubleshoot-air-installation-windows.htmlRead other 2 answers [More]
Does any one have complete example of creating async web service???Can you be a bit more specific on your requirement.In JDeveloper there is no wizard driven tooling support to create POJO based async services, but you can expose methods of an Applic [More]
I have tons of albums that I wish to convert into my iTunes library. Please help.Define hardcopy music album. If you have music on CD, DVD, vinyl record, you must first import the music into iTunes on a computer using the appropriate player and then [More]
I have recently installed elements 9 on my MAC running OS 10.7 (Lion). Elements runs fine but when I attempt to print on on my Canon IP6700D, blank paper comes out. I have the latest drivers installed and all other programs on the MAC print ok. It se [More]
??? I want to publish my site to the web. HELP!!!Well, how have you been publishing your site before now without a MobileMe account? You need to go and purchase a domain name and hosting space with a company such as http://www.godaddy.com or http://w [More]