hai, saya menemukan Note:179952.1 dari website lain, semoga berguna. cheers,
On 8/15/06, Ervin Listyawan <[EMAIL PROTECTED]> wrote: > > Adakah cara lain selain export-import, mengingat database sizenya > sudah di atas 100 GB? > > Terus e-mail sebelumnya, sola metalink 179952.1 itu soal apa, site di > metalink-nya di mana (tidak ketemu)? > > Thanks & rgds, > > Ervin L > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Tomi > Wijanto <[EMAIL PROTECTED]> > wrote: > > > > > Ini masalahnya, aku keburu drop tablespace undonya > > > (maksudku supaya > > > cepat up), beberapa kali gagal, terus gak tau kenapa > > > bisa didrop juga > > > (setelah diset manual, gak pakai undo tablespace, > > > terus create table > > > space baru). Nah anehnya di sini nih, setelah didrop > > > rollback segment > > > yang error itu masing nongol, ketika aku create > > > tablespace undo baru > > > dengan nama yang sama. Bahkan ganti table space undo > > > pakai nama lain > > > pun tetap aja nongol, problemnya lagi table space > > > satunya jadi gak > > > bisa didrop (sebelumnya sempat bisa), meski pakai > > > cara yang sama spt > > > sebelumnya. > > > > Pesan error tetap muncul karena Oracle mencatat bahwa > > ada transaksi yg mesti di-rollback ketika database > > crash, tetapa gak menemukan informasi rollback tsb di > > undo tbs. > > > > Ketika menggunakan param _OFFLINE_ROLLBACK_SEGMENTS, > > walaupun database bisa di-open, tetapa sebenarnya ada > > kemungkinan database secara logical corrupt (karena > > ada transaksi gagal yg belum di-rollback). > > > > > Kalau dinonaktifkan, sekarang jadi gak bisa naik > > > instancenya. > > > Bagaimana yach solusinya ... > > > > Utk amannya, segera EXPORT database Anda, buat > > database baru, kemudian IMPORT ke db baru. > > Ini adalah cara yg dianjurkan Oracle utk kasus Anda. > > > > > > regards, > > tomi > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > > > > -- (¨`·.·´¨) Always `·.¸(¨`·.·´¨ ) Keep (¨`·.·´¨)¸.·´Smiling! `·.¸.·´ ---------- (V9I) _OFFLINE_ROLLBACK_SEGMENTS ? _CORRUPTED_ROLLBACK_SEGMENTS (UNDO) =========================================================================== PURPOSE ------- ? ??? corrupted undo segments? ?? 9i ??????? recovery? ???? ??? ??? ????? ??. Problem Description ------------------- initSID.ora file? ??? ?? ????? ???? ??? ??. undo_management = AUTO undo_tablespace = UNDOTBS1 corrupt? undo segment? ??? ?????? ???? ?????, DBA_ROLLBACK_SEGS ??? _SYSSMUn$ ? NEEDS RECOVERY ??? ??? ??. RBS datafile? ??? ??, archive log file? available?? ??? ?? ???? ??? ???? ? ? ??? ????? ??. Workaround ---------- none Solution Description -------------------- 1. Set the following parameters in the initSID.ora UNDO_MANAGEMENT=MANUAL _OFFLINE_ROLLBACK_SEGMENTS=(_SYSSMU1$, _SYSSMU2$, _SYSSMU3$, ...etc) or _CORRUPTED_ROLLBACK_SEGMENTS=(_SYSSMU1$, _SYSSMU2$, _SYSSMU3$, ...etc) (??) ???? _OFFLINE_ROLLBACK_SEGMENTS=(_SYSSMU1$, _SYSSMU2$, _SYSSMU3$, ...etc) ????? ?? ???? ??. _CORRUPTED_ROLLBACK_SEGMENTS ?????? ?? DB? startup?? ?? DB? open ??? ???? ?????, ??? DB? ?? ???? ??. (??) ?? UNDO_MANAGEMENT=AUTO ?? ??? ??? UNDO tablespace? drop??? ? ? ??? ?? ??? ??? ??. SQL> drop tablespace undotbs1 including contents and datafiles; drop tablespace undotbs1 including contents and datafiles * ERROR at line 1: ORA-30013: undo tablespace 'UNDOTBS1' is currently in use (??) UNDO tablespace? ?? ?? ? ?? ?? UNDO tablespace? UNDO segment? ??? ?? ??? ? ?? ???? ???. ??, ??? UNDO segment ??? _SYSSMU1$ ?? _SYSSMU10$?? ??? ??? UNDO segment? ??? _SYSSMU11$?? generate??. 2. Open the database ??, RBS datafile? missing? ??? ???? ??????? open? ???. SQL> startup ORACLE instance started. Total System Global Area 118560016 bytes Fixed Size 451856 bytes Variable Size 100663296 bytes Database Buffers 16777216 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> select name, status, enabled, checkpoint_change# from v$datafile; NAME STATUS ENABLED CHECKPOINT_CHANGE# ---------------------------------- ------- ---------- ------------------ /oracle3/djeunot/DB1/system01.dbf SYSTEM READ WRITE 62315 /oracle3/djeunot/DB1/undotbs01.dbf RECOVER READ WRITE 62241 /oracle3/djeunot/DB1/users01.dbf ONLINE READ WRITE 62315 SQL> select SEGMENT_NAME, STATUS from DBA_ROLLBACK_SEGS; SEGMENT_NAME STATUS ------------ ---------------- SYSTEM ONLINE _SYSSMU2$ NEEDS RECOVERY _SYSSMU3$ NEEDS RECOVERY ... 3. The Undo Segments need to be individually dropped SQL> drop rollback segment "_SYSSMU1$"; Rollback segment dropped. SQL> drop rollback segment "_SYSSMU2$"; Rollback segment dropped. ..... 4. Once the Undo Segments are all dropped, drop the UNDO tablespace SQL> drop tablespace UNDOTBS1 including contents and datafiles; Tablespace dropped. 5. Recreate the undo tablespace SQL> create undo tablespace undotbs1 datafile '/DB1/undotbs01.dbf' size 500k reuse; Tablespace created. 6. Reset the following parameters in the initSID.ora UNDO_MANAGEMENT=AUTO #_OFFLINE_ROLLBACK_SEGMENTS=(_SYSSMU1$, _SYSSMU2$, _SYSSMU3$, ...etc) or #_CORRUPTED_ROLLBACK_SEGMENTS=(_SYSSMU1$, _SYSSMU2$, _SYSSMU3$, ...etc) 7. ?? _CORRUPTED_ROLLBACK_SEGMENTS parameter? ?? DB? open??? ??????? inconsistent ?????, DB? open ?? ??? full export? ??, ??????? ????? full import? ??? ?? ??. Reference Documents ------------------- <> [Non-text portions of this message have been removed] -- -----------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/
