tp setelah di alter database open resetlogs, database langsung terminated SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced klo error di atas liat di alert log, error nya internal code error tadi.
dan hidden parameter _allow_resetlogs_corruption sudah TRUE SQL> show parameter corruption NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _allow_resetlogs_corruption boolean TRUE Thanks, 2010/4/8 yulius_wibowo <[email protected]> > > > Setelah di ALTER DATABASE OPEN RESETLOGS, harusnya databasenya OPEN > (dgn asumsi menggunakan hidden parameter _allow_resetlogs_corruption=TRUE) > > > SQL> ALTER DATABASE OPEN RESETLOGS > SQL> SELECT status FROM V$INSTANCE; > > kalau sudah open nggak perlu di open dgn resetlogs lagi. > > Note: > Undo datafile : OK.nggak corrupt. > > bowo > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Andes > Febrian <pejanta...@...> wrote: > > > > dear gurus, > > ternyata setelah saya coba recover lagi muncul error, yg pertama > berhasil, > > berikut error nya : > > > > RMAN> recover database until sequence 1719; > > > > Starting recover at 08-APR-10 > > using target database control file instead of recovery catalog > > allocated channel: ORA_DISK_1 > > channel ORA_DISK_1: sid=155 devtype=DISK > > > > starting media recovery > > > > unable to find archive log > > archive log thread=1 sequence=1 > > Oracle Error: > > 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: > > '/u02/app/oracle/product/10.2/oradata/prod/system01.dbf' > > > > RMAN-00571: =========================================================== > > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > > RMAN-00571: =========================================================== > > RMAN-03002: failure of recover command at 04/08/2010 15:34:12 > > RMAN-06054: media recovery requesting unknown log: thread 1 seq 1 lowscn > > 64250709 > > > > > > On Thu, Apr 8, 2010 at 3:33 PM, Andes Febrian <pejanta...@...> wrote: > > > > > saya coba jalan kan dbv, berikut hasil nya : > > > > > > [ora...@prod dbs]$ dbv > > > file=/u02/app/oracle/product/10.2/oradata/prod/undotbs01.dbf > > > > > > DBVERIFY: Release 10.2.0.1.0 - Production on Thu Apr 8 15:26:31 2010 > > > > > > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > > > > > DBVERIFY - Verification starting : FILE = > > > /u02/app/oracle/product/10.2/oradata/prod/undotbs01.dbf > > > > > > > > > DBVERIFY - Verification complete > > > > > > Total Pages Examined : 16640 > > > Total Pages Processed (Data) : 0 > > > Total Pages Failing (Data) : 0 > > > Total Pages Processed (Index): 0 > > > Total Pages Failing (Index): 0 > > > Total Pages Processed (Other): 16640 > > > Total Pages Processed (Seg) : 0 > > > Total Pages Failing (Seg) : 0 > > > Total Pages Empty : 0 > > > Total Pages Marked Corrupt : 0 > > > Total Pages Influx : 0 > > > Highest block SCN : 64267185 (0.64267185) > > > > > > Thanks, > > > > > > 2010/4/8 yulius_wibowo <yulius_wib...@...> > > > > > > > > > >> > > >> ora-00704 ==> bootstrap$ bermasalah (mungkin karena locking...) > > >> > > >> ora-00600 [4000] ==> berkaitan dgn undo segment > > >> > > >> hhhmmm.... gimana cara melepas lock-nya tanpa menggunakan undo data > ... > > >> Mungkin juga karena undo tablespace datafile-nya corrupt? > > >> > > >> Coba check pakai dbv: > > >> > > >> dbv file=/u02/app/oracle/product/10.2/oradata/prod/undotbs01.dbf > > >> > > >> > > >> --- In [email protected] > > >> <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, > > > >> "yulius_wibowo" <yulius_wibowo@> wrote: > > >> > > > >> > ora-00704 ==> bootstrap$ bermasalah (mungkin karena locking...) > > >> > > > >> > ora-00600 [4000] ==> berkaitan dgn undo segment > > >> > > > >> > hhhmmm.... gimana cara melepas lock-nya tanpa menggunakan undo data > ... > > >> > > > >> > > > >> > > > >> > --- In [email protected] > > >> > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, > > > >> "oracle@" <oracle@> wrote: > > >> > > > > >> > > sewaktu recover until change ada masalah? atau sampe "media > recovered" > > >> tanpa > > >> > > embel2 lainnya? > > >> > > karena redolog current corrupt, mestinya gak kebaca dan system.dbf > gak > > >> > > mundur as of UNTIL keyword... > > >> > > > > >> > > > > >> > > > > >> > > 2010/4/8 Andes Febrian <pejantan4u@> > > >> > > > > >> > > > 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 <yulius_wibowo@> > > >> > > > > > >> > > > > > > >> > > > > > > >> > > > > 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> > <indo-oracle%40yahoogroups.com><indo-oracle% > > > >> 40yahoogroups.com>, > > >> > > > Andes > > >> > > > > Febrian <pejantan4u@> 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_wibowo@> > > >> > > > > > > >> > > > > > > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > 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><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><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><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><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><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]<indo-oracle-unsubscribe%40yahoogroups.com> > <indo-oracle-unsubscribe%40yahoogroups.com> > > > >> > > > 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 > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > >> > > > > >> > > -- > > >> > > thanks and regards > > >> > > ujang | oracle dba | mysql dba > > >> > > jakarta - indonesia > > >> > > > > >> > > > > >> > > [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] ------------------------------------ -- -----------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/
