Dear Wiyoto
kalau melihat sekilas sepertinya control07.ctl corrupt.
ada dua alternatif cara :
1. hapus/remark control07.ctl yang ada di init.ora, berarti tinggal satu
controlfile.
coba startup db nya lagi. kalau berhasil aman, shutdown lagi db, copy file
controlfile yang tidak di remark menjadi control07.ctl (mis. cp control06.ctl
control07.ctl)
coba start ulang db
2. ini cara yang lumayan ribet.
recreate ulang controlfile db, tapi kita musti tahu mana saja datafile yang
benar2 dipakai oleh database.
untuk memastikan lihat tanggal terakhir datafile, jika ada
datafile/redologfile/undo/temp yang sebelum tanggal datafile yang terakhir
tadi, berarti, file tersebut ga pernah diakses.
kalau sudah ketemu baru recreate controlfile
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "SID" NORESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 400
MAXINSTANCES 8
MAXLOGHISTORY 2920
LOGFILE
GROUP 1 (
'/redo1.log',
'/redo1a.log'
) SIZE 300M,
GROUP 2 (
'/redo2a.log',
'/redo2b.log'
) SIZE 300M,
DATAFILE
'/system01.dbf',
'/index_03.dbf',
'/sysaux01.dbf'
CHARACTER SET WE8ISO8859P1
;
ALTER TABLESPACE TEMP ADD TEMPFILE 'temp_06.dbf'
SIZE 2000M REUSE AUTOEXTEND ON NEXT 52428800 MAXSIZE 2000M
semoga berhasil
From: [email protected] [[email protected]] On Behalf Of
Christian Rohanda Wiyoto yahoo [[email protected]]
Sent: Friday, August 28, 2009 9:44 AM
To: [email protected]
Subject: External Email : --> [indo-oracle] start oracle
GAGAL!!!!--oracle-ORA-27047: unable to read the header block of file
halo rekan2 DBA,
Salam hormat,
Saya menemui error problem di bawah ini,
waktu startup oracle database.
ORA-00205: error in identifying control file, check alert log for more info
di file alert bdump:
/3G/bscs_db4/admin/pbscs_lm/bdump->db:BSCSR2>tail -200 alert_BSCSR2.log
ORA-00202: control file: '/3G/bscs_db4/oradata01/pbscs_lm/control07.ctl'
ORA-27047: unable to read the header block of file
Init.ora sudah menunjuk benar 2 control file.
Please bagaimana cara menanggulangi error ini supaya oracle db bisa
distartup lagi?;
SQL> startup
ORACLE instance started.
Total System Global Area 2852126720 bytes
Fixed Size 2048128 bytes
Variable Size 1258295168 bytes
Database Buffers 1577058304 bytes
Redo Buffers 14725120 bytes
ORA-00205: error in identifying control file, check alert log for more info
ALTER DATABASE MOUNT
Thu Aug 27 21:33:15 2009
ORA-00202: control file: '/3G/bscs_db4/oradata01/pbscs_lm/control07.ctl'
ORA-27047: unable to read the header block of file
Additional information: 2
Thu Aug 27 21:33:18 2009
ORA-205 signalled during: ALTER DATABASE MOUNT...
/3G/bscs_db4/admin/pbscs_lm/bdump->db:BSCSR2>
terima kasih
salam
Christian
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email by mistake please notify the sender by return
e-mail and delete this message from your system. Any unauthorized use or
dissemination of this e-mail in whole or in part is strictly prohibited. PT
Federal International Finance, which has its seat at North of Jakarta,
Indonesia, including its affiliated companies, shall not be liable for the
improper or incomplete transmission of the information contained in this e-mail
nor for any delay in its receipt or damage to your system. PT Federal
International Finance (or its affiliated companies) does not guarantee that the
integrity of this communication has been maintained nor that this communication
is free of viruses, interceptions or interference.
