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], "ora...@..." <ora...@...> 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 <pejanta...@...> > > > 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 <pejanta...@...> > > 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_wib...@... > > >wrote: > > > > > >> > > >> > > >> > > >> Bisa dicoba lagi dgn setting parameter: > > >> > > >> UNDO_MANAGEMENT=MANUAL > > >> > > >> bw > > >> > > >> > > >> --- In [email protected] <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] > > 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] >
