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, After updating to the AMD 13.1 drivers, on my 5770, Firefox will not launch; it does, however, show in the task manager. I should note that it will start in Windows safe mode; when I had it open in safe mode, I used that time to disable all plugi [More]
I have a macbook 13-inch, Early 2009 and installed Lion 10.7.5 How can I recover or resset my admin. password?, because I put that I remember but is incorrect.The only way to reformat (erase) and restore to factory settings is by booting from the ins [More]
I can select the entire library to highlight it, but when I point on it with my mouse and try to drag it over, it's not working for me. I sometimes get the blockout symbol, but that's about it. HELP PLEASE! Much thanks.Forgive what may be a dumb ques [More]
Hello, just minutes ago, when I woke up my G4 800 QS, OS 10.4.9, after about one hour sleep mode, there was a beeping sound from the speaker, that did beep...beep....beep in a frequenz of about 60 to 90 beeps/minute. I could operate the Mac, but ther [More]
Dear All, I have an electric organ from Yamaha, and it has 3 keyboards, upper keyboard, lower keyboard, and pedal keyboard. They are all running in different midi channels: i.e. upper keyboard: midi channel 1 lower keyboard: midi channel 2 pedal keyb [More]
Hi, Can some guide how to configure budget check for purchase order based on supply schedule. This could be that you have raised a Purchase order for 12 Quantity and the delivery of the same is at 1 per month for 12 months.Budget should  be checked f [More]
Hi Experts, Is it possible to integration SAP cloud for customer with Gmail ? Please share your valuable thoughts on this post. Many Thanks MithunHi Mithun, There is no Add-In for Gmail as we have for Outlook and Lotus Notes in the current release of [More]
I am trying to open up my iTunes from my iMac. It says "You can't open the application iTunes because it is not supported on this type of Mac." What do I do? I've already force closed all other apps.Well, obviously the problem isn't with the oth [More]
It's been almost more than a month since nokia released it,,, and it was supposed to be a worlwide release on oct 24th,,,, i don't feel like waiting for christmas nokia,,,,, we want the symbian belle preferably before the end of november at least..aS [More]
Hi, i am developing a piece of software where i need to be able to edit the contents of an SWT table and then save any changes, i have been able to edit the cell contents, but am stuck saving the changes. I found how to edit the table cells using a s [More]