Aku tidak tahu apakah sudah coba mengikuti prosedur yg ada di metalink note 179952.1.
Apakah command ini bisa dilakukan ketika database open: drop rollback segment "_SYSSMU13$"; Biasanya sebelum tablespace undo di-drop, semua rollback segments yg tercatat di param _offline_rollback_segments harus di-drop dulu. Kemudian baru drop tbs undo yg lama: drop tablespace undotbs including contents and datafiles; Lalu recreate tbs undo baru. Kemudian non-aktifkan parameter _offline_rollback_segments, lalu restart database. regards, tomi --- Ervin Listyawan <[EMAIL PROTECTED]> wrote: > 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 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------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/
