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 <[email protected]> > 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 <[email protected]> > 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 <[email protected] > >wrote: > > > >> > >> > >> > >> Bisa dicoba lagi dgn setting parameter: > >> > >> UNDO_MANAGEMENT=MANUAL > >> > >> bw > >> > >> > >> --- In [email protected] <indo-oracle%40yahoogroups.com>, > Andes > >> Febrian <pejanta...@...> 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 ora...@... <ora...@...> > >> > >> > > >> > > > >> > > > >> > > 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] > 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]
