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 <[email protected]>
>
>
> 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 <pejanta...@...> 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/d...@...'
>
> > ORA-27037: unable to obtain file status
> > Linux Error: 2: No such file or directory
> > Additional information: 3
> >
> >
> > 2010/4/7 yulius_wibowo <yulius_wib...@...>
>
> >
> > >
> > >
> > > 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]
------------------------------------
--
-----------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/
