Tolong caranya ya, saya menemukan kejadian aneh di server Oracle sbb: 1. Krn kelupaan di monitor, ada 2 disk logical yang full. Satu berisi archive, satunya lagi berisi undo tablespace dan temp.
2. Akibat no (1), server gak bisa create archive (mandek), ketahuan pas hang dilihat archive log full di disk tsb, terpaksa archive log dihapus semua sementara 3. Tanpa disadari, disk satunya yang berisi temp dan undo tablespace juga penuh sehingga mandek kembali. Pas dicek (kirain archive lagi), eh ternyata nggak. Pas disk dikosongkan, server tidak bisa restart krn minta recover --> kondisi hot backup (di-offline-kan tablespacenya) 4. Dicoba recover, krn archive log keburu dihapus, gak bisa complete recovery, jadilah incomplete pakai backup controlfile dan direset. 5. Temp berhasil recover, tapi undo table space nggak bisa. Akhirnya sementara diset manual, kemudian diset offline, create undo tablespace baru, terus drop yang lama. Sama sini masih OK. 6. Pas restart error, ternyata ada 1 rollback segment yang corrupt, yang letaknya ada di undotablespace yg pertama. Terpaksa dijalankan pakai init paramater: _offline_rollback_segments=<segment yang rusak> 7. Jalan sih jalan,terus coba create undo tbs2, ganti init.ora undotbs ke sini, terus restart, jalan sih. 8. Tapi problemnya sekarang di alert log selalu muncul sbb setiap 5 menit: Sat Aug 12 10:12:46 2006 SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Aug 12 10:12:46 2006 Completed: alter tablespace undotbs1 online Sat Aug 12 10:17:53 2006 SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Aug 12 10:22:51 2006 SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Aug 12 10:27:58 2006 SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Aug 12 10:33:05 2006 SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Tentu efeknya jadi lambat. Mau coba drop undo tablespace pertama gak bisa, keluar internal error ORA-00600: internal error code, arguments: [ktssdrp1], [1], [2], [97], [], [], [], [] Objective/Tanya: 1. Bagaimana supaya di alert.log tidak keluar pesan recover undo segment 13 (yg corrupt) 2. Undo Tablespace 1 bagaimana supaya bisa didrop (kalau didrop selalu keluar error ORA-00600: internal error code, arguments: [ktssdrp1], [1], [2], [97], [], [], [], [] 3. Bagaimana supaya bisa start tanpa dipancing init ora-nya pakai _offline_rollback_segments 4. Solusi seharusnya dan antisipasinya? Terima kasih atas bantuannya ... Rgds, Ervin L ygnginapdikantorgaragaracorrupt -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
