ORA-00368 & ORA-00353

Dari Milis ada temen yg databasenya bermasalah waktu startup.  Seperti ini kejadiannya

SQL> startup
ORACLE instance started.

Total System Global Area 1588157124 bytes
Fixed Size 457412 bytes
Variable Size 838860800 bytes
Database Buffers 738197504 bytes
Redo Buffers 10641408 bytes
Database mounted.
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 55170 change 8832580069569 time
06/24/2009
13:23:26

ORA-00312: online log 2 thread 1: ‘/u3/oracle/oradata/redo02.log’

Kedua kode error ini bisa sekaligus diselesaikan, begini caranya ;

Jika status redo2.lognya CURRENT atau ACTIVE dan tidak ada log member, makan INCOMPLETE RECOVERY bisa dilakukan (RECOVERY UNTIL CANCEL), begini caranya :

ketika oracle dalam status mount:

sql> recover database until cancel;
sql> alter database open resetlogs;

Tapi jika status redo2.lognya bukan CURRENT atau ACTIVE caranya begini :

1. shutdown immediate (jika database ON)

2. rename redo2.log (yg rusak) menjadi nama lagi misalnya redo2bak.log

3. copy redo3.log menjadi redo2.log (step 2 dan 3 dilakukan dari OS)

Command lihat status logile ;  select * from v$logfile;

Semoga berguna

~ by Ali Imran on June 27, 2009.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: