ok mas bowo, terima kasih banyak sekali lagi atas bantuannya. 2010/4/9 yulius_wibowo <[email protected]>
> > > Alternatifnya sbb: > > - buat undo tablespace yg baru. > - set UNDO_TABLESPACE=new_undo_tbs > - set UNDO_MANAGEMENT=AUTO > - drop undo tablespace yg lama > > bowo > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Andes > Febrian <pejanta...@...> wrote: > > > > ok mas bowo, export, create db baru kemudian import. > > tapi apakah undo tablespace gak perlu di re-create lagi, kan seperti nya > > undo tbs corrupt tuh ? ini seandainya kita jalan dengan database yg udah > > rusak tersebut. > > > > terima kasih banyak atas pencerahan yg sangat jelas mas bowo :) > > > > 2010/4/9 yulius_wibowo <yulius_wib...@...> > > > > > > > > > > > > Mas Ujang, > > > Spt-nya buat Oracle sama saja, mau logical corrupt atau physical > corrupt. > > > > > > Mas Andes, > > > UNDO_MANAGEMENT-nya bisa di balikin kesemula (AUTO). > > > > > > hhhmmm,... > > > Sebetulnya bisa saja database yg sudah direcover tsb dipakai. > > > Tapi mungkin kurang sreg/enak dihati, spt pakai mobil bekas tabrakan, > > > walaupun luarnya bagus (karena di dempul), tapi namanya bekas tabrakan > kok > > > rasanya risih utk mengendarainya... > > > Ada baiknya, export dulu data-nya, buat database yg baru, lalu import > > > datanya. > > > > > > Bowo > > > > > > > > > --- In [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, > > > > "oracle@" <oracle@> wrote: > > > > > > > > pak, raden kanjeng mas bowo :) > > > > > > > > sepertinya redolog tsb cuma logical filesystem corrupt saja ya? > > > > mestinya sewaktu roll forward sewaktu recover db/instance crash > recovery > > > > kalo memang physical corrupt bakal dapet error ? > > > > > > > > atau ada something else? > > > > > > > > > > > > 2010/4/9 Andes Febrian <pejantan4u@> > > > > > > > > > > > > Mas bowo, > > > > > sudah berhasil deng, saya sudah bisa export data yg di perlukan. > terima > > > > > kasih banyak atas bantuan nya. > > > > > > > > > > oh ya nanya lagi, bila saya running dengan database yg baru aja di > > > start > > > > > ini dengan kondisi database yg bermasalah tersebut (tp skrg sudah > up) > > > > > gimana mas bowo ? lebih baik saya install ulang database kemudian > > > export > > > > > hasil dmp atau running dengan database yg ada aja ? > > > > > > > > > > dan undo management harus di balikkan kembali ke parameter auto > atau > > > tidak > > > > > usah ? karena sepertinya undo tbs bermasalah/corrupt ? atau saya > harus > > > > > create tablespace undo lagi ?? > > > > > > > > > > > > > > > many thanks for your help. > > > > > > > > > > On Fri, Apr 9, 2010 at 11:29 AM, Andes Febrian <pejantan4u@> > > > > > > > > wrote: > > > > > > > > > > > mas bowo, seting parameter UNDO_MANAGEMENT=MANUAL sudah bisa nih. > > > > > kemudian > > > > > > klo udah open, create tempfile, klo di step mas bowo kasih ada > alter > > > > > > database add tempfile, maksud nya saya create dengan perintah > create > > > > > > tempfile <nama tablespace temp baru> atau add tempfile di > tablespace > > > temp > > > > > yg > > > > > > lama ?? > > > > > > > > > > > > Thanks, > > > > > > > > > > > > > > > > > > On Fri, Apr 9, 2010 at 6:40 AM, yulius_wibowo <yulius_wibowo@ > > > > > > > > >wrote: > > > > > > > > > > > >> > > > > > >> > > > > > >> > > > > > >> Bisa dicoba lagi dgn setting parameter: > > > > > >> > > > > > >> UNDO_MANAGEMENT=MANUAL > > > > > >> > > > > > >> bw > > > > > >> > > > > > >> > > > > > >> --- In > > > > > >> [email protected]<indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com><indo-oracle% > > > > 40yahoogroups.com>, > > > > > Andes > > > > > >> Febrian <pejantan4u@> wrote: > > > > > >> > > > > > > >> > output dari statement berikut, > > > > > >> > $ strings system01.dbf | head -100 > > > > > >> > $ strings undo01.dbf | head -100 > > > > > >> > > > > > > >> > [ora...@prod prod]$ strings system01.dbf | head -100 > > > > > >> > }|{z > > > > > >> > L!2|prod > > > > > >> > SYSTEM > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU4$ > > > > > >> > _SYSSMU3$ > > > > > >> > _SYSSMU2$ > > > > > >> > _SYSSMU1$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU10$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU9$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU8$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU7$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU6$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU5$ > > > > > >> > _SYSSMU4$ > > > > > >> > [ora...@prod prod]$ strings undotbs01.dbf |head -100 > > > > > >> > }|{z > > > > > >> > L!2|prod > > > > > >> > UNDOTBS1 > > > > > >> > KZdyKZdyKZdyK > > > > > >> > wTKtwTKtwTK > > > > > >> > JR_GG > > > > > >> > KNxn > > > > > >> > 4...@co > > > > > >> > 4...@xn > > > > > >> > xlxn > > > > > >> > 4...@ic > > > > > >> > _JOxn > > > > > >> > If9xn > > > > > >> > 4...@xn > > > > > >> > 4...@ic > > > > > >> > 4@"T > > > > > >> > "TAxn > > > > > >> > 4@"T > > > > > >> > xnxn > > > > > >> > 4...@-6 > > > > > >> > Spxn > > > > > >> > 4...@22 > > > > > >> > nt xn > > > > > >> > T_Sxn > > > > > >> > 4...@xn > > > > > >> > '5xn > > > > > >> > [email protected] > > > > > >> > 4...@ma > > > > > >> > 8.4xn > > > > > >> > GO.xn > > > > > >> > _MAxn > > > > > >> > 4...@33 > > > > > >> > _SYxn > > > > > >> > ERTxn > > > > > >> > VENxn > > > > > >> > 4...@n > > > > > >> > ysixn > > > > > >> > 4@', > > > > > >> > a...@xn > > > > > >> > 4...@22 > > > > > >> > nt xn > > > > > >> > D_Mxn > > > > > >> > 4...@ah > > > > > >> > 4...@_m > > > > > >> > 4...@o. > > > > > >> > D_Mxn > > > > > >> > D_Mxn > > > > > >> > _Sexn > > > > > >> > vicxn > > > > > >> > 4...@va > > > > > >> > KAHxn > > > > > >> > n1xn > > > > > >> > 4...@tu > > > > > >> > &xn > > > > > >> > 4...@cc > > > > > >> > 1.6xn > > > > > >> > E.Exn > > > > > >> > menxn > > > > > >> > 4...@an > > > > > >> > BKNxn > > > > > >> > 4...@cc > > > > > >> > xnxn > > > > > >> > ( M r > > > > > >> > @YPA > > > > > >> > %':= > > > > > >> > <+>" > > > > > >> > CA5W > > > > > >> > %O=[N > > > > > >> > @YPA > > > > > >> > %':= > > > > > >> > <+>" > > > > > >> > CA5W > > > > > >> > %O=[N > > > > > >> > @YPA > > > > > >> > %':= > > > > > >> > <+>" > > > > > >> > CA5W > > > > > >> > %O=[N > > > > > >> > $^Z( > > > > > >> > @YPA > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > %':= > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > <+>" > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > CA5W > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > $^Z( > > > > > >> > > > > > > >> > Thanks, > > > > > >> > > > > > > >> > 2010/4/8 oracle@ <oracle@> > > > > > >> > > > > > >> > > > > > > >> > > > > > > > >> > > > > > > > >> > > bisa keluarin output ini? > > > > > >> > > > > > > > >> > > $ strings system01.dbf | head -100 > > > > > >> > > $ strings undo01.dbf | head -100 > > > > > >> > > > > > > > >> > > SQL> oradebug setmypid > > > > > >> > > SQL> oradebug dump file_hdrs 1 > > > > > >> > > SQL> oradebug dump file_hdrs <no_datafile_undo> > > > > > >> > > > > > > > >> > > > > > > > >> > -- > > > > > >> > Best Regards, > > > > > >> > Andes > > > > > >> > > > > > > >> > > > > > > >> > [Non-text portions of this message have been removed] > > > > > >> > > > > > > >> > > > > > >> > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > Best Regards, > > > > > > Andes > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Best Regards, > > > > > Andes > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > ------------------------------------ > > > > > > > > > > -- > > > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > > > Keluar: > > > > > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > <indo-oracle-unsubscribe%40yahoogroups.com> > > > > > > Website: http://indooracle.wordpress.com > > > > > http://www.facebook.com/group.php?gid=51973053515 > > > > > ----------------------------------------------- > > > > > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > thanks and regards > > > > ujang | oracle dba | mysql dba > > > > jakarta - indonesia > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > -- > > Best Regards, > > Andes > > > > > > [Non-text portions of this message have been removed] > > > > > -- Best Regards, Andes [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
