Dear all,
I am working one instance called awacs, i faced following error,
ORA-01578: ORACLE data block corrupted (file # 21, block # 2862997)
ORA-01110: data file 21: 'D:\APP\ADMINISTRATOR\ORADATA\AWACS\USERS07.DBF'
I will explain actually what is the current situation,
Scenario -1
March 25 2015 19:30, data block corrupted error occur.
When i try to connect this awacs instance on Mar 26 2015 and the table called 'Distributer_file' there is error thrown like database block corrupted. like below,
ORA-01578: ORACLE data block corrupted (file # 21, block # 2862997)
ORA-01110: data file 21: 'D:\APP\ADMINISTRATOR\ORADATA\AWACS\USERS07.DBF'
I checked instance by issuing following command,
SELECT * FROM V$DATABASE_BLOCK_CORRUPTION;
o/p- corrupted block details came.
so, we have flash image copy backup (third party tool) upto Mar 25 17:30, so i had restored it and get rid out from the error.
after that i checked instance by using same query
SELECT * FROM V$DATABASE_BLOCK_CORRUPTION;
o/p- No rows returned.
so my instance is safer side.
Scenario - 2
when i checked alert log file on Mar 27 2015, the same error is coming like below,
Fri Mar 27 11:41:45 2015
Process 0x0x000000031734AA38 appears to be hung in Auto SQL Tuning task
Current time = 1427436705, process death time = 1427436666
Attempting to kill process 0x0x000000031734AA38 with OS pid = 1908
Errors in file d:\app\administrator\diag\rdbms\awacs\awacs\trace\awacs_ora_3076.trc (incident=63397):
ORA-01578: ORACLE data block corrupted (file # 21, block # 2862997)
ORA-01110: data file 21: 'D:\APP\ADMINISTRATOR\ORADATA\AWACS\USERS07.DBF'
Errors in file d:\app\administrator\diag\rdbms\awacs\awacs\trace\awacs_ora_3964.trc (incident=63541):
ORA-01578: ORACLE data block corrupted (file # 21, block # 2862997)
ORA-01110: data file 21: 'D:\APP\ADMINISTRATOR\ORADATA\AWACS\USERS07.DBF'
Incident details in: d:\app\administrator\diag\rdbms\awacs\awacs\incident\incdir_63541\awacs_ora_3964_i63541.trc
Incident details in: d:\app\administrator\diag\rdbms\awacs\awacs\incident\incdir_63397\awacs_ora_3076_i63397.trc
but, i can able to work in the database normally, i can use that table it is working fine. and importantly when i issue the query like below
SELECT * FROM V$DATABASE_BLOCK_CORRUPTION;
o/p- No rows returned.
It is showing there is no block has been corrupted, but why this corrupted log entry register in alert log.
How to get resolve this problem permanently.
Here with i have attached alert log file and trace file for mentioned days.
I didn't configured RMAN. Can anyone help me get rid out from the error.