Pak agung, waktu bapak mau jalankan command recover database until cancel kan di minta archive nya, nah jika bapak tidak ada itu archive nya, bapak cuma ada 1 pilihan yaitu : bapak ketik CANCEL, dengan konsekuensi lose data dari waktu archive tersebut terbentuk sampai database bapak corrupt. baru setelah itu bapak bisa open database nya dengan resetlogs
semoga membantu Best Regards, Hendra --- On Tue, 9/9/08, Agung Purwanto <[EMAIL PROTECTED]> wrote: From: Agung Purwanto <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] ORA-01589: must use RESETLOGS or NORESETLOGS option for database open To: [email protected] Date: Tuesday, 9 September, 2008, 10:09 AM 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: indo-oracle@ yahoogroups. com Date: 09/09/08 09:26:20 To: indo-oracle@ yahoogroups. com 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] co.id> 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] Get your preferred Email name! Now you can @ymail.com and @rocketmail.com http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
