| recovery [message #54956] |
Thu, 19 December 2002 13:54  |
SARU
Messages: 4
Registered: August 2002
|
Junior Member |
|
|
how to find data block corruption in a oracle database
how to recover data block corruption?
|
|
|
|
| Re: recovery [message #55016 is a reply to message #54956] |
Thu, 26 December 2002 16:56  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Whenever there is a problem with the DBA, Oracle will signal an Oracle error ORA-00600[[3339]][[arg1]][[arg2]] and possibly ORA-01578: Data block corrupted in file # block #. These errors provide information that point to where the corruption exists and can provide several potential causes.
If there is a possibility of memory problems on the system, you can enable further sanity block checking by placing the following event parameters in init.ora parameter file:
event = "10210 trace name context forever, level 10" event = "10211 trace name context forever, level 10" _db_block_cache_protect= true
(Note: restart your db after that)
To fix it, read When Block Media Recovery Should Be Used
Hope that helps,
clio_usa - OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
