Oh gitu ya Pak, saya terlanjur masukin archive log versi sebelumnya ( 56092 ) Trus saya harus gimana pak. ada kah cara untuk nyalmentinya pak ?
terima kasih .. -------Original Message------- From: [email protected] Date: 09/09/08 09:26:20 To: [email protected] Subject: Re: [indo-oracle] ORA-01589: must use RESETLOGS or NORESETLOGS option for database open pak agung, dia minta archive yg tidak ada? mungkin bisa di cancel... ini bisa menyebabkan lost data .... atau cari sequence 56093 dari redolog yang bisa saja belum ter archive. -- thanks and regards ujang | oracle dba jakarta | http://ora62.wordpress.com On Tue, Sep 9, 2008 at 8:43 AM, Agung Purwanto <[EMAIL PROTECTED]> wrote: > Dear Senior Oracle. > Saya sedang ngalami masalah serius dengan oracle server saya, > > yaitu database tidak bisa open setelah mounting database > ( tidak bisa di alter database open dengan pesan > ORA-01589: must use RESETLOGS or NORESETLOGS option for database open ) > kemudian saya lakukan reset log > > SVRMGR> alter database open resetlogs; > alter database open resetlogs > * > ORA-01113: file 1 needs media recovery > ORA-01110: data file 1: '/data1/oradata/SKKERIS/system01.dbf' > > lalu saya lakukan recover database from backup control file > > SVRMGR> recover database until cancel using backup controlfile; > ORA-00279: change 10155239765 generated at 09/08/2008 16:50:35 needed for > thread > 1 > ORA-00289: suggestion : /exp_backup/SKKERIS/arch/arch_1_56093.arc > ORA-00280: change 10155239765 for thread 1 is in sequence #56093 > Specify log: {<RET>=suggested | filename | AUTO | CANCEL} > > saya tidak punya archive sesui yang direcomendasikan > saya punya archive dngan sequence 56092 > > pada waktu saya masukan 56092 > > /exp_backup/SKKERIS/arch/arch_1_56092.arc > ORA-00310: archived log contains sequence 56092; sequence 56093 required > ORA-00334: archived log: '/exp_backup/SKKERIS/arch/arch_1_56092.arc' > ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error > below > ORA-01194: file 1 needs more recovery to be consistent > ORA-01110: data file 1: '/data1/oradata/SKKERIS/system01.dbf' > > saya tidak tahu harus bagaimana > > adakah rekan2 senior oracle yang bisa bantu , > terima kasih atas perhantiannya sebelumnya > > salam, > > agung > > Oh ya oracle = 8.1.7 , OS Tru Unix 64 [Non-text portions of this message have been removed]
