Pak, Bisa coba dicoba dengan solusi ini : http://www.indo-oracletech.com/forum/viewtopic.php?f=7&t=286&st=0&sk=t&sd=a&start=10#p1421
Semoga membantu cheers, Andrew ----- Original Message ---- From: Agung Purwanto <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, 9 September 2008 09:43:34 Subject: [indo-oracle] ORA-01589: must use RESETLOGS or NORESETLOGS option for database open 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 new Email address! Grab the Email name you've always wanted before someone else does! http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
