mas bw, mau tanya, - edit control file script, dengan menghapus nama file dari log file yg corrupt atau dengan memindahkan ke lokasi baru yg di edit bagian pertama yang noresetlogs atau bagian ke dua resetlogs ?
- jalankan control file script sampai dengan create controfile saja. yg ini jalankan dari sqlplus kah ? seperti berikut, SQL> @$ORACLE_HOME/dbs/myctl.txt Thanks, 2010/4/1 Andes Febrian <[email protected]> > Ok mas bw, terima kasih sangat. saya coba dulu. > > 2010/4/1 yulius_wibowo <[email protected]> > > >> >> >> kondisi awal: >> - current logfile corrupt >> - duplexing - tapi dikarenakan disk rusak, kedua2nya tidak bisa dibaca >> - tidak ada backup >> - tidak menggunakan archivelog mode >> >> solusi: >> - shutdown database >> - startup mount >> - check sequence number terakhir (select max(sequence#) from v$log) >> - create control file script (alter database backup controlfile to trace >> as 'myctl.txt') >> - edit control file script, dengan menghapus nama file dari log file yg >> corrupt atau dengan memindahkan ke lokasi baru >> - copy logfile yg bagus ke lokasi baru dari log file yg bermasalah, >> kemudian ganti namanya >> - shutdown database >> - startup nomount >> - jalankan control file script sampai dengan create controfile saja. >> - recover database until sequence <seq#max> using backup controlfile >> - alter database open resetlogs >> - alter database add tempfile ..... >> >> Kalau masih nggak bisa juga dikarenakan tidak konsistenya system.dbf >> datafile, >> tambahkan hidden parameter _allow_resetlogs_corruption=TRUE >> >> cmiiw, >> >> Bowo >> >> --- In [email protected] <indo-oracle%40yahoogroups.com>, Andes >> Febrian <pejanta...@...> wrote: >> > >> > ga bisa di buka pak, error di browser nya >> > Bandwidth Limit Exceeded The server is temporarily unable to service >> your >> > request due to the site owner reaching his/her bandwidth limit. Please >> try >> > again later. >> > >> > 2010/3/31 Andhi Rahman <and...@...> >> >> > >> > > >> > > >> > > Mungkin bisa dicoba workaround yang ada disini >> > > http://rohmad.net/2008/05/05/startup-inconsistent-database/ >> > > >> > > 2010/3/31 Rindra Iin <canda_...@... <canda_iin%40yahoo.com>> >> >> > > >> > > >> > > > >> > > > >> > > > mungkin karena Redo log file tersebut telah corrupt, munkin juga >> dapat >> > > > corrupt ada disk penuh atau kegagalan hardware. >> > > > >> > > > SQL> alter system checkpoint; >> > > > SQL>SHUTDOWN ABORT; >> > > > SQL>STARTUP MOUNT; >> > > > RMAN>RESTORE DATABASE; >> > > > SQL>RECOVER DATABASE UNTIL CANCEL; >> > > > SQL>ALTER DATABASE OPEN RESETLOGS; >> > > > >> > > > semoga bisa startup kembali.. >> > > > >> > > > --- Pada Sel, 30/3/10, Andes Febrian <pejanta...@...<pejantan4u% >> 40gmail.com> >> > > <pejantan4u%40gmail.com>> >> > > > menulis: >> > > > >> > > > Dari: Andes Febrian <pejanta...@... <pejantan4u%40gmail.com >> ><pejantan4u% >> >> > > 40gmail.com>> >> > > >> > > > Judul: [indo-oracle] ORA-00368 checksum error in redo log block >> > > > Kepada: [email protected] >> > > > <indo-oracle%40yahoogroups.com><indo-oracle% >> 40yahoogroups.com><indo-oracle% >> >> > > 40yahoogroups.com> >> > > >> > > > Tanggal: Selasa, 30 Maret, 2010, 5:41 AM >> > > > >> > > > >> > > > >> > > > >> > > > Dear gurus, >> > > > >> > > > Database gak bisa di startup, muncul error berikut : >> > > > >> > > > ORA-00368 checksum error in redo log block >> > > > >> > > > ORA-00353 log corruption near block 44330 change >> > > > >> > > > ORA-00312 online log 2 thread 1 >> > > > >> > > > sebelum nya Database jalan dengan no archivelog dan tidak punya >> backup >> > > > >> > > > database. >> > > > >> > > > Please ada saran dari guru untuk membuat database ini up ? >> > > > >> > > > -- >> > > > >> > > > Best Regards, >> > > > >> > > > Andes >> > > > >> > > > [Non-text portions of this message have been removed] >> > > > >> > > > Akses email lebih cepat. Yahoo! menyarankan Anda meng-upgrade >> browser ke >> > > > Internet Explorer 8 baru yang dioptimalkan untuk Yahoo! Dapatkan di >> sini! >> > > > http://downloads.yahoo.com/id/internetexplorer >> > > > >> > > > >> > > > [Non-text portions of this message have been removed] >> > > > >> > > > >> > > > >> > > >> > > -- >> > > (**) >> > > >> > > >> > > [Non-text portions of this message have been removed] >> > > >> > > >> > > >> > >> > >> > >> > -- >> > Best Regards, >> > Andes >> > >> > >> > [Non-text portions of this message have been removed] >> > >> >> >> > > > > -- > Best Regards, > Andes > -- Best Regards, Andes [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
