mas bowo, sebener nya udah bisa create controlfile dan memang ada inconsistent system.dbf tp sudah saya kasi hidden parameter seperti mas bowo bilang, tapi ketika database open muncul error, internal error :p parah banget deh, ada aja :( berikut error nya :
Completed: ALTER DATABASE MOUNT Thu Apr 8 13:55:39 2010 alter database open resetlogs RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 64250703 Thu Apr 8 13:55:45 2010 Setting recovery target incarnation to 2 Thu Apr 8 13:55:45 2010 Assigning activation ID 2174505551 (0x819c524f) Thread 1 opened at log sequence 1 Current log# 3 seq# 1 mem# 0: /u01/app/oracle/product/10.2/oradata/prod/redo0 3.log Current log# 3 seq# 1 mem# 1: /u01/app/oracle/product/10.2/oradata/prod/redo0 3a.log Successful open of redo thread 1 Thu Apr 8 13:55:45 2010 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu Apr 8 13:55:45 2010 SMON: enabling cache recovery Thu Apr 8 13:55:46 2010 Errors in file /u02/app/oracle/product/10.2/db_1/admin/prod/udump/prod_ora_117 06.trc: ORA-00600: internal error code, arguments: [4000], [8], [], [], [], [], [], [] Thu Apr 8 13:55:46 2010 Errors in file /u02/app/oracle/product/10.2/db_1/admin/prod/udump/prod_ora_117 06.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [4000], [8], [], [], [], [], [], [] Thu Apr 8 13:55:46 2010 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 11706 ORA-1092 signalled during: alter database open resetlogs many thanks atas bantuan nya. 2010/4/8 yulius_wibowo <[email protected]> > > > Coba hapus baris kosong di bawah baris "-- STANDBY LOGFILE" (sebelum > DATAFILE)(dan spt-nya itu bug dari Oracle pada saat generate controlfile > script). > > Bowo > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Andes > Febrian <pejanta...@...> wrote: > > > > sori mas bw, saya salah jalanin. tp tetep saya coba jalanin lagi error > lain > > muncul, thanks. > > > > CREATE CONTROLFILE REUSE DATABASE "prod" RESETLOGS NOARCHIVELOG > > MAXLOGFILES 16 > > MAXLOGMEMBERS 3 > > MAXDATAFILES 100 > > MAXINSTANCES 8 > > MAXLOGHISTORY 292 > > LOGFILE > > GROUP 1 ( > > '/u01/app/oracle/product/10.2/oradata/prod/redo01.log', > > '/u01/app/oracle/product/10.2/oradata/prod/redo01a.log' > > ) SIZE 50M, > > GROUP 2 ( > > '/u01/app/oracle/product/10.2/oradata/prod/redo02.log', > > '/u01/app/oracle/product/10.2/oradata/prod/redo02a.log' > > ) SIZE 50M, > > GROUP 3 ( > > '/u01/app/oracle/product/10.2/oradata/prod/redo03.log', > > '/u01/app/oracle/product/10.2/oradata/prod/redo03a.log' > > ) SIZE 50M > > -- STANDBY LOGFILE > > > > DATAFILE ( > > '/u02/app/oracle/product/10.2/oradata/prod/system01.dbf', > > '/u02/app/oracle/product/10.2/oradata/prod/undotbs01.dbf', > > '/u02/app/oracle/product/10.2/oradata/prod/sysaux01.dbf', > > '/u02/app/oracle/product/10.2/oradata/prod/users01.dbf', > > '/u02/app/oracle/product/10.2/oradata/prod/example01.dbf') > > CHARACTER SET WE8ISO8859P1 > > ; > > > > *saya coba copy ke sqlplus plus terminal, hasil nya error berikut, salah > > dimana ya,* > > > > SQL> CREATE CONTROLFILE REUSE DATABASE "prod" RESETLOGS NOARCHIVELOG > > 2 MAXLOGFILES 16 > > 3 MAXLOGMEMBERS 3 > > 4 MAXDATAFILES 100 > > 5 MAXINSTANCES 8 > > 6 MAXLOGHISTORY 292 > > 7 LOGFILE > > 8 GROUP 1 ( > > 9 '/u01/app/oracle/product/10.2/oradata/prod/redo01.log', > > 10 '/u01/app/oracle/product/10.2/oradata/prod/redo01a.log' > > 11 ) SIZE 50M, > > 12 GROUP 2 ( > > 13 '/u01/app/oracle/product/10.2/oradata/prod/redo02.log', > > 14 '/u01/app/oracle/product/10.2/oradata/prod/redo02a.log' > > 15 ) SIZE 50M, > > 16 GROUP 3 ( > > 17 '/u01/app/oracle/product/10.2/oradata/prod/redo03.log', > > 18 '/u01/app/oracle/product/10.2/oradata/prod/redo03a.log' > > 19 ) SIZE 50M > > 20 -- STANDBY LOGFILE > > 21 > > SQL> DATAFILE ( > > SP2-0042: unknown command "DATAFILE (" - rest of line ignored. > > SQL> '/u02/app/oracle/product/10.2/oradata/prod/system01.dbf', > > SP2-0734: unknown command beginning "'/u02/app/..." - rest of line > ignored. > > SQL> '/u02/app/oracle/product/10.2/oradata/prod/undotbs01.dbf', > > SP2-0734: unknown command beginning "'/u02/app/..." - rest of line > ignored. > > SQL> '/u02/app/oracle/product/10.2/oradata/prod/sysaux01.dbf', > > SP2-0734: unknown command beginning "'/u02/app/..." - rest of line > ignored. > > SP2-0044: For a list of known commands enter HELP > > and to leave enter EXIT. > > SQL> '/u02/app/oracle/product/10.2/oradata/prod/users01.dbf', > > SP2-0734: unknown command beginning "'/u02/app/..." - rest of line > ignored. > > SQL> '/u02/app/oracle/product/10.2/oradata/prod/example01.dbf') > > SP2-0734: unknown command beginning "'/u02/app/..." - rest of line > ignored. > > SQL> CHARACTER SET WE8ISO8859P1 > > SP2-0734: unknown command beginning "CHARACTER ..." - rest of line > ignored. > > SQL> ; > > > > > > 2010/4/8 yulius_wibowo <yulius_wib...@...> > > > > > > > > > > > > Lho kok cuma sampai LOGFILE saja, DATAFILE-nya mana? > > > > > > Seharusnya: > > > CREATE CONTROLFILE REUSE DATABASE ... > > > ... > > > LOGFILE > > > ... > > > ... > > > DATAFILE > > > ... > > > ... > > > CHARACTER SET ...; > > > > > > > > > --- In [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, Andes > > > Febrian <pejantan4u@> wrote: > > > > > > > > thanks mas bw, > > > > berikut script nya > > > > > > > > SQL> CREATE CONTROLFILE REUSE SET DATABASE "prod" NORESETLOGS > > > NOARCHIVELOG > > > > 2 MAXLOGFILES 16 > > > > 3 MAXLOGMEMBERS 3 > > > > 4 MAXDATAFILES 100 > > > > 5 MAXINSTANCES 8 > > > > 6 MAXLOGHISTORY 292 > > > > 7 LOGFILE > > > > 8 GROUP 1 ( > > > > 9 '/u01/app/oracle/product/10.2/oradata/prod/redo01.log', > > > > 10 '/u01/app/oracle/product/10.2/oradata/prod/redo01a.log' > > > > 11 ) SIZE 50M, > > > > 12 GROUP 2 ( > > > > 13 '/u01/app/oracle/product/10.2/oradata/prod/redo02.log', > > > > 14 '/u01/app/oracle/product/10.2/oradata/prod/redo02a.log' > > > > 15 ) SIZE 50M, > > > > 16 GROUP 3 ( > > > > 17 '/u01/app/oracle/product/10.2/oradata/prod/redo03.log', > > > > 18 '/u01/app/oracle/product/10.2/oradata/prod/redo03a.log' > > > > 19 ) SIZE 50M > > > > 20 ; > > > > CREATE CONTROLFILE REUSE SET DATABASE "prod" RESETLOGS NOARCHIVELOG > > > > * > > > > ERROR at line 1: > > > > ORA-01503: CREATE CONTROLFILE failed > > > > ORA-01565: error in identifying file '?/dbs/dbs1@' > > > > > > > ORA-27037: unable to obtain file status > > > > Linux Error: 2: No such file or directory > > > > Additional information: 3 > > > > > > > > > > > > 2010/4/7 yulius_wibowo <yulius_wibowo@> > > > > > > > > > > > > > > > > > > > > > > Bisa dikirim isi file utk create controlfile-nya? > > > > > > > > > > > > > > > bw > > > > > > > > > > --- In [email protected] > > > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com><indo-oracle% > > > > 40yahoogroups.com>, Andes > > > > > Febrian <pejantan4u@> wrote: > > > > > > > > > > > > pak bw, maaf nih nanya lagi, ketika saya jalankan create > controlfile > > > nya > > > > > > ajah di sqlplus (copy paste) keluar error berikut : > > > > > > > > > > > > CREATE CONTROLFILE REUSE DATABASE "TAKAH" NORESETLOGS > NOARCHIVELOG > > > > > > * > > > > > > ERROR at line 1: > > > > > > ORA-01503: CREATE CONTROLFILE failed > > > > > > ORA-01565: error in identifying file '?/dbs/dbs1@' > > > > > > > > > > > ORA-27037: unable to obtain file status > > > > > > Linux Error: 2: No such file or directory > > > > > > Additional information: 3 > > > > > > > > > > > > many thanks atas bantuannya. > > > > > > > > > > > > 2010/4/7 yulius_wibowo <yulius_wibowo@> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > A1. Bisa pada bagian noresetlogs atau resetlogs. > > > > > > > Karena yg diambil cuma pada bagian > > > > > > > CREATE CONTROLFILE .... > > > > > > > ...s/d...; (titik koma) > > > > > > > > > > > > > > Baris2 selebihnya tidak dipakai/bisa dihapus. > > > > > > > Lalu jalankan perintah: > > > > > > > > > > > > > > - recover database until sequence <seq#max> using backup > > > controlfile > > > > > > > - alter database open resetlogs > > > > > > > - alter database add tempfile ..... > > > > > > > > > > > > > > A2. Bisa dgn > > > > > > > - SQL> @nama_script_ctlfile_nya (yg telah diedit) > > > > > > > atau dengan > > > > > > > - copy-paste perintah CREATE CONTROLFILE .... ke dalam SQL*Plus > > > > > session. > > > > > > > > > > > > > > cmiiw, > > > > > > > bw > > > > > > > > > > > > > > > > > > > > > --- In > > > > > > > [email protected]<indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com><indo-oracle% > > > 40yahoogroups.com><indo-oracle% > > > > > > > > 40yahoogroups.com>, Andes > > > > > > > Febrian <pejantan4u@> wrote: > > > > > > > > > > > > > > > > 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 <pejantan4u@> > > > > > > > > > > > > > > > > > > > > > > > > Ok mas bw, terima kasih sangat. saya coba dulu. > > > > > > > > > > > > > > > > > > 2010/4/1 yulius_wibowo <yulius_wibowo@> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >> > > > > > > > > >> > > > > > > > > >> 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> > <indo-oracle%40yahoogroups.com> > > > <indo-oracle%40yahoogroups.com><indo-oracle% > > > > > 40yahoogroups.com><indo-oracle% > > > > > > > > > > > > 40yahoogroups.com>, Andes > > > > > > > > > > > > > > > >> Febrian <pejantan4u@> 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 <andzsr@> > > > > > > > > >> > > > > > > > > >> > > > > > > > > > >> > > > > > > > > > > >> > > > > > > > > > > >> > > Mungkin bisa dicoba workaround yang ada disini > > > > > > > > >> > > > > > http://rohmad.net/2008/05/05/startup-inconsistent-database/ > > > > > > > > >> > > > > > > > > > > >> > > 2010/3/31 Rindra Iin <canda_iin@ <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 <pejantan4u@ > > > > > <pejantan4u% > > > > > > > > >> 40gmail.com> > > > > > > > > >> > > <pejantan4u%40gmail.com>> > > > > > > > > >> > > > menulis: > > > > > > > > >> > > > > > > > > > > > >> > > > Dari: Andes Febrian <pejantan4u@ <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> > > > > > <indo-oracle%40yahoogroups.com><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] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > Best Regards, > > > > > > Andes > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Best Regards, > > > > Andes > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > -- > > Best Regards, > > Andes > > > > > > [Non-text portions of this message have been removed] > > > > > -- 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/
