Maaf kalau salah ya .. Kayakanya aku dulu pernah ngalamin hal yang sama utk kasus 'need media recovery'.
Coba untuk 'shutdown immediate' dulu .. baru tar di 'startup normal' lagi ... semoga bisa naldy sableng <[EMAIL PROTECTED]> wrote: Rekans milis yang baik, Database Oracle saya tidak mau startup, setelah saya mencoba ganti control file dari ketiga control file oracle (control01.dbf,control02.dbf,control03.dbf) maka file control03.dbf bisa dipake untuk startup dan mount database. Tapi ketika saya coba startup database, SQL> startup ORACLE instance started. Total System Global Area 129673244 bytes Fixed Size 75804 bytes Variable Size 57856000 bytes Database Buffers 71663616 bytes Redo Buffers 77824 bytes Database mounted. malah muncul error : ORA-01113: file 5 needs media recovery ORA-01110: data file 5: 'D:\SERVER\ORACLE\ORADATA\CAKEP\TOOLS01.DBF' Saya coba recover file tersebut, SQL> recover datafile 'D:\SERVER\ORACLE\ORADATA\CAKEP\TOOLS01.DBF'; malah muncul error : ORA-00283: recovery session canceled due to errors ORA-00341: log 3 of thread 1, wrong log # 1 in header ORA-00312: online log 3 thread 1: 'D:\SERVER\ORACLE\ORADATA\CAKEP\REDO01.LOG' saya coba command dibawah ini : SQL> alter database noarchivelog; Database altered. SQL> recover datafile 'D:\SERVER\ORACLE\ORADATA\CAKEP\TOOLS01.DBF'; Tapi tetap muncul error yang sama : ORA-00283: recovery session canceled due to errors ORA-00341: log 3 of thread 1, wrong log # 1 in header ORA-00312: online log 3 thread 1: 'D:\SERVER\ORACLE\ORADATA\CAKEP\REDO01.LOG' Oracle yang saya gunakan adalah Oracle 8i Mohon bantuannya ... Terima kasih sebelumnya.. Wasalam, Naldy __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com [Non-text portions of this message have been removed] Thanks, Tora Fahrudin --------------------------------- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed]
