| ORA-01578 corrupt block [message #57174] |
Sun, 25 May 2003 11:04  |
kowalsky
Messages: 37
Registered: May 2003
|
Member |
|
|
Hi all,
I am getting a ORA-01578 message lately that is more and more frequent.
I consulted some documentation and I tried to fix the corrupt block using DBMS_REPAIR but it did not work.
My configuration is as follows:
Red Hat 7.3, Oracle Server 9.2
one tablespace on 4 data files each up to 2G
one table with about 32 million rows.
Most of the time the corrupt block apears on the same datafile and I'd say the corrupt block is in the same range (file # 13 block # 17459).
Any ideas how to fix this?
kowalsky
|
|
|
|
| Re: ORA-01578 corrupt block [message #57206 is a reply to message #57174] |
Wed, 28 May 2003 07:53  |
Naveen
Messages: 75
Registered: June 2001
|
Member |
|
|
since the error is occured at same datafile you perform the following steps if database
is mounted or open.
1)OFFLINE the affected data file
eg: ALTER DATABASE DATAFILE 'name_of_file' OFFLINE;
2)Copy it to a safe location (in case the backup is bad).
3)Restore the latest backup of the file onto a GOOD disk
4)Check the restored file for obvious corruptions with DBVERIFY
5)if the restored file is OK then rename the datafile.
ALTER DATABASE RENAME FILE 'old_name' TO 'new_name';
6)recover the datafile
RECOVER DATAFILE 'name_of_file';
7)make the datafile online.
ALTER DATABASE DATAFILE 'name_of_file' ONLINE;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
