kalo gak salah ALTER SYSTEM ARCHIVE LOG CURRENT; database musti dalam keadaan open. karena state db masih mount, langsung saja umpankan redolog tsb sewaktu recover.
-- thanks and regards ujang | oracle dba jakarta | http://ora62.wordpress.com 2008/9/9 mohammad arief pradipto <[EMAIL PROTECTED]>: > iya ya, > > jangan-jangan masih ada redo log yang belum ter-archive. > > jadi redo lognya di buat archive dulu bukan kang ujang? > > ALTER SYSTEM ARCHIVE LOG CURRENT; > > baru jalankan hal2 tersebut di atas > > On 9/9/08, Ujang Jaenudin <[EMAIL PROTECTED]> wrote: >> 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 >> > > -- > adipt > [EMAIL PROTECTED] > 021 68 535 141 > http://adipt.net/
