maaf juga kalo salah coba SQL>alter database datafile 5 offline; SQL>alter system switch logfile; <-- lakukan 5 kali SQL>recover datafile 5; ---masukan file archive yang dibutuhkan manually--------------- kalo error coba di retry terus klo sukses SQL>alter database datafile 5 online;
mudah2an bermanfaat Trims Eko 2008/2/6 tora fahrudin <[EMAIL PROTECTED]>: > > > > > > > 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] > > -- i love being baud wanderer
