Terima kasih mas Bowo untuk informasinya :)
________________________________ Dari: Yulius Wibowo <[email protected]> Kepada: [email protected] Terkirim: Kamis, 25 Juni, 2009 09:36:51 Judul: Re: Bls: [indo-oracle] Urgent Help : redo error ORA-00368: checksum error in redo log block Mas Sulistyo, Kalau misalnya redo02.log-nya corrupt tapi statusnya bukan CURRENT atau ACTIVE -DAN- besarnya file sama dgn redo03.log, cara yg Mas Tyo sampaikan bisa jadi solusinya. Tapi kalau status redo02.log-nya CURRENT atau ACTIVE -DAN- tidak ada logfile member yg lainnya, maka INCOMPLETE recovery (recovery until CANCEL) yg diambil. cmiiw, bw --- In indo-oracle@ yahoogroups. com, Sulistyo <bookonlineworm@ ...> wrote: > > Dear mas Rafif, > Dulu pernah alami di windows juga step yg saya lakukan sbb: > > 1. shutdown immediate > 2. Rename '/u3/oracle/ fintstdata/ redo02.log' menjadi '/u3/oracle/ > fintstdata/ redo02.log.bak' > 3. cp '/u3/oracle/ fintstdata/ redo03.log' menjadi '/u3/oracle/ fintstdata/ > redo02.log' > 4. startup database. > Database berjalan normal, hanya mungkin transaksi yang ada di redo02 yg > corrupt tidak bisa dikembalikan. > > CMIIW > > Tyo > > > > > > ____________ _________ _________ __ > Dari: rafif milis <rafif.milis@ ...> > Kepada: indo-oracle@ yahoogroups. com > Terkirim: Rabu, 24 Juni, 2009 16:01:05 > Judul: [indo-oracle] Urgent Help : redo error ORA-00368: checksum error in > redo log block > > > > > > dear all, mohon bantuan, > gimana cara betulin error > > 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/ fintstdata/ redo02.log' > > oracle DB 9.2, sun OS > > terima kasih sebelumnya > > [Non-text portions of this message have been removed] > > > > > > Terhubung langsung dengan banyak teman di blog dan situs pribadi Anda? > Buat Pingbox terbaru Anda sekarang! http://id.messenger .yahoo.com/ pingbox/ > > [Non-text portions of this message have been removed] > ____________________________________________________________________ Kunjungi halaman depan Yahoo! Indonesia yang baru! http://id.yahoo.com/ [Non-text portions of this message have been removed]
