hm.... sepertinya itu effect parameter _allow_resetlogs_corruption sehingga mestinya dibaca, ada corrupt tapi diabaikan/diskip
atau kutipan metalink ini ? A resetlogs creates new online redo logs so when you create a controlfile with resetlogs no check is made for the existence of current logs. They are going to be overwritten anyway! bisa dibuktikan mana yg sebenarnya terjadi pak bowo? 2010/4/9 yulius_wibowo <[email protected]> > > > 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>, > "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><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> > > > 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] > > > > > -- thanks and regards ujang | oracle dba | mysql dba jakarta - indonesia [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/
