| ORA-01578 ERROR [message #61129] |
Tue, 30 March 2004 19:00  |
siritham
Messages: 2
Registered: March 2004
|
Junior Member |
|
|
I got ORA-01578 error
ORA-01578: ORACLE data block corrupted (file #5,block#715866)
ORA-01110: ORACLE data file 5 :'/usr/c2000_data/2000/data/usres01.dbf'
#segment_name : met_value
#segment_type : table
#index_name :metvalue_rtunb_mpnb_ui
I want to know repair the data block corrupted. Please help me
|
|
|
|
| Re: ORA-01578 ERROR [message #61131 is a reply to message #61129] |
Tue, 30 March 2004 19:35  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
If you run Oracle9i or above; and your have a full RMAN backup of your database (incremental backups are not good enough), you could try the following:
RMAN> BLOCKRECOVER DATAFILE 5 BLOCK 715866;
Alternatively, if the blocks you want to recover is in v$backup_corruption, you can just do an "RMAN> blockrecover corruption list;".
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
