- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Block corrupted
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2006 06:25 PM
тАО08-17-2006 06:25 PM
Block corrupted
I got the following error message:
ORA-01578: ORACLE data block corrupted (file # 42, block # 16373) ORA-01110: data file 42: '/Oracle9i/OraHome/oradata_nas/ERIDBCQ/CQ_LTBDB2.ora'
Could you please someone help me to how to fix these corrupted block?
I tried to run the rman utility without success {blockrecover datafile 42 block 16373;} and now i'm going to user the DBMS_REPAIR..
I have Oralce9i on Solaris 9.
Thanks in advance
Fabio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2006 06:53 PM
тАО08-17-2006 06:53 PM
Re: Block corrupted
I am sure you have used a web search to get some information, but just in case:
http://www.quest-pipelines.com/newsletter-v4/0103_C.htm
http://www.fortunecity.com/skyscraper/oracle/699/orahtml/oramag/16tech.html
http://www.fors.com/orasupp/rdbms/dba/28814_1.HTM
Also lots of metalink entries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2006 07:19 PM
тАО08-17-2006 07:19 PM
Re: Block corrupted
You don't really fix a corrupted block. The database tries to move/reconstruct the data elsewhere. If that fails you either have to restore the missing data or perhaps the entire database.
We've seen it happen and figured out what records were corrupt and wrote a sqlplus script to put them back from a backup.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2006 09:17 PM
тАО08-17-2006 09:17 PM
Re: Block corrupted
So i followed the instruction you sent and after i run the DBMS_REPAIR.CHECK_OBJECT and verified the corrupted block I run the FIX_CORRUPT_BLOCKS. Then I run the finding the orphan index and the result was 28.
After having found the index name trying to rebuild it i got the following error:
"ALTER INDEX SYS_IL0000036518C00039$$ REBUILD online;
ALTER INDEX SYS_IL0000036518C00039$$ REBUILD online
*
ERROR at line 1:
ORA-01418: specified index does not exist"
But it exists!!!
Any idea..? thanks so much..
The main problem is that i don't have any backup of the damage datafile, but just an early one because we had a blackout and no chance to made it.
Thanks!!!!
Fabio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2006 09:21 PM
тАО08-17-2006 09:21 PM
Re: Block corrupted
if it is the index that is faulty, can't you just recreate the index with drop/create?
This would not be possible with table data fault, unless you have a backup.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2006 10:53 PM
тАО08-17-2006 10:53 PM
Re: Block corrupted
Based on the assumption that you identified the "faulty" object to be an idex, i would recommend the following:
1. alter index
2. Stop using the tablespace for any new objects
3. create another tablespace and move all the objects from the old tablespace to the new.
Then, try to see if there are any error messages relating to I/O or disk at the OS level.
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-17-2006 11:12 PM
тАО08-17-2006 11:12 PM
Re: Block corrupted
So after i marked the corrupted block as true with DBMS.REPAIR I used the DBMS_REPAIR.DUMPORPHAN_KEYS and the result is:
orphan key count: 28.
So now i wonder if exists something to mark and fix these orphan key.
Thanks in advance.
Regards,
Fabio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 02:21 AM
тАО08-18-2006 02:21 AM
Re: Block corrupted
dd if=/dev/rdsk/EachDISK of=/dev/null bs=256k
(replace EachDISK with the c0t0d0 name of your disks.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2006 01:38 AM
тАО08-24-2006 01:38 AM
Re: Block corrupted
Thanks to everyone for your support and help.
Regards,
Fabio