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], 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>, 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>, 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>, 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>, 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> > > > > > > > >> > > > > > > > > > >> > > > 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] >
