Halo, masalahnya control07 filenya corrupt, jadi gak ada backup file control yg tidak corrupt, gimana caranya membuat file control lagi dan databasenya bisa distartup? KR Christian
--- On Fri, 8/28/09, Leonard Sukendro <[email protected]> wrote: From: Leonard Sukendro <[email protected]> Subject: Re: [indo-oracle] start oracle GAGAL!!!!--oracle-ORA-27047: unable to read the header block of file To: [email protected] Date: Friday, August 28, 2009, 7:52 PM to pak christian, control file nya ada lbh dr 1 khan ya, pak? coba database nya d shutdown lagi dulu... trus bikin control07.ctl nya dr controlfile yg masi bener... krn DBnya dlm posisi shutdown, jadi tinggal copy aja dr salah satu controlfile yg masi bner secara OS, trus d rename jadi control07.ctl. .. abis itu coba startup lagi... moga2 bisa membantu ya, boss... CMIIW, [L] --- On Fri, 8/28/09, Christian Rohanda Wiyoto yahoo <christrohanda@ yahoo.com> wrote: From: Christian Rohanda Wiyoto yahoo <christrohanda@ yahoo.com> Subject: [indo-oracle] start oracle GAGAL!!!!--oracle- ORA-27047: unable to read the header block of file To: indo-oracle@ yahoogroups. com Date: Friday, August 28, 2009, 9:44 AM 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 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
