Dear gurus, Error ini muncul di alert log pada database saya, adakan cara untuk memperbaik block corrupt seperti ini bila database saya "NO ARCHIVE LOG" dan otomatis tidak punya backup RMAN. untuk lebih detail dari error, saya copy dari alert log dibawah ini, Thanks.
Tue Apr 21 22:00:11 2009 GATHER_STATS_JOB encountered errors. Check the trace file. Tue Apr 21 22:00:12 2009 Errors in file /u01/app/oracle/admin/TESTDB/bdump/testdb_j001_7240.trc: ORA-01578: ORACLE data block corrupted (file # 3, block # 27493) ORA-01110: data file 3: '/u02/oradata/TESTDB/sysaux01.dbf' Tue Apr 21 22:00:33 2009 Thread 1 advanced to log sequence 1575 Current log# 2 seq# 1575 mem# 0: /u02/oradata/TESTDB/redo02.log Tue Apr 21 22:02:21 2009 Thread 1 advanced to log sequence 1576 Current log# 3 seq# 1576 mem# 0: /u02/oradata/TESTDB/redo03.log -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
