Control file bukannya sama semua yach?Jadi untuk control file 07, mestinya bisa diambil dari control file lain..
On Sat, Sep 5, 2009 at 10:55 AM, Christian Rohanda Wiyoto yahoo < [email protected]> wrote: > > > 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]<leon_190699%40yahoo.com>> > wrote: > > From: Leonard Sukendro <[email protected] <leon_190699%40yahoo.com>> > Subject: Re: [indo-oracle] start oracle GAGAL!!!!--oracle-ORA-27047: unable > to read the header block of file > > To: [email protected] <indo-oracle%40yahoogroups.com> > 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] > > > [Non-text portions of this message have been removed]
