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
Hello, i am really despaired right now, because I can't convince the current Version of Adobe Reader to work on my Computer. I hope you can help me... I've installed the current version of Adobe Flash Player and Adobe Reader on my Windows 7 x64 and w [More]
We were going to leave Verizon to do Sprints Unlimited for life, so we called to see how much out ETF would cost. The rep said to keep us with verizon she would offer us the verizon max plan even though we didn't have unlimited data. So we decided ye [More]
I have a new install of Exchange 2013 (SP1, CU6) and I am receiving errors every 30 minutes. They appear to be happening when Exchange tries to test the scan engine update.  Here are the errors: Any suggestions would be appreciated! Chris Log Name:   [More]
Hi, I´m currently setting a LAB in order to test NEAT feature. The Supplicant switch (sSW) is able to authenticate toward the Authenticator Switch (aSW). sSW#sh cisp summary CISP is running on the following interface(s):   Fa0/8 (supplicant) When I c [More]
Hi friends, how can i access 9i's OEM from remote computer. ThanksI suppose to access to "Oracle Enterprise Manager" you will need an "Oracle Enterprise Manager Console" (also named "DBA Studio" in old times). When you start [More]
I have gotten my Ipod to go to the Itunes connect screen for recovery. However when I donwloaded the update it did not work. So my Ipod is still not being recognized by my computer.If you cannot operate the device nor get it to connect to iTunes, mak [More]
I am trying to deploy Adobe Reader X (10.1.2) MUI to Windows 7 64 systems VIA SCCM and the user's are seeing a Language Prompt upon first run.  They can click cancel it will open fine and not prompt again.  I have used Adobe Customization Wizard X an [More]
I can't get AA to take my serial number to download AA1.5 into a new computer. Not interested in AA3.0Nothing we can deal with - contact support.Read other 2 answers [More]
I experienced some problems with the on-board Intel PRO/1000 PL Ethernet adapter. The adapter in most cases works fine: it connects normally in 100 or 1000Mbps - full duplex - speed, depends on wich internetworking devices attached, and the link does [More]
Whilst using the wizard to construct a report using multiple query groups the final report seems to ingnore the field order I set. Is this yet another bug in reports? Does anyone have a work round? I'm I missing something?It has been resolved! thanks [More]