lha kl nggak ada system01.dbf, agak sulit lho ngatasinya, dimana plng tidak install oracle di mesin lain lalu copy system01.dbf sebelum jauh ................. ini db production atau db test ?, jika db test mending install ulang saja
salam hendra chen wrote: > > > Itu masalah nya file system01.dbf tidak ada di tempat nya pak. > coba cek di script create control file bapak, apakah posisi datafile > system01.dbf nya sama dengan posisi real nya. > jika tidak, ubah di script bapak atau pindahkan datafile system01.dbf > itu ke posisi yang sesuai dengan yang tertulis di script create > control file bapak. > > Best Regards, > > Hendra > > --- On Thu, 7/5/09, Setijo Agus <[email protected] > <mailto:setijo%40ptubs.com>> wrote: > > From: Setijo Agus <[email protected] <mailto:setijo%40ptubs.com>> > Subject: Re: [indo-oracle] gagal saat re-create control file > To: [email protected] <mailto:indo-oracle%40yahoogroups.com> > Date: Thursday, 7 May, 2009, 7:53 AM > > salah satu teman saya, pernah mengalami hal yang sama "kehilangan > control file", krn dianggap bukan file yang penting > salah satu langkahnya saya pernah menulisnya di > http://setijoagus. wordpress. com/2009/ 03/18/clone- oracle-10gr2- > dari-windows- ke-linux/ > walaupun untuk di linux, ttp secara prinsip bisa diterapkan di windows > salam > setijo agus > > Taufiq Hidayat wrote: > > > > > > erornya masih yg sama kn dari yg awal? Klo ini berarti control filenya > > lebih dari satu y..coba: > > 1. shutdown immediate > > 2. copy control file 02 dan rename jadi control file 01 > > 3. startup > > > > Best Regards, > > > > Taufiq > > > > ____________ _________ _________ __ > > From: pehabiboe <pehabi...@yahoo. co.id <mailto:pehabiboe% > 40yahoo.co. id>> > > To: indo-oracle@ yahoogroups. com <mailto:indo- oracle%40yahoogr > oups.com> > > Sent: Wednesday, May 6, 2009 3:44:15 PM > > Subject: [indo-oracle] gagal saat re-create control file > > > > ORA-01503: CREATE CONTROLFILE failed > > ORA-01565: error in identifying file > > 'C:\ORACLE\PRODUCT\ 10.2.0\ORADATA\ xxx\SYSTEM01. DBF' > > ORA-27041: unable to open file > > OSD-04002: unable to open file > > O/S-Error: (OS 2) The system cannot find the file specified. > > > > solusinya gimana yah ??? > > > > [Non-text portions of this message have been removed] > > > > > > -- > ============ ========= ========= = > gold jewelry manufacture > UBSGOLD.COM > UNIVERSE OF GOLD > UNTUNG BERSAMA SEJAHTERA > ============ ========= ========= = > > New Email addresses available on Yahoo! > Get the Email name you've always wanted on the new @ymail and > @rocketmail. > Hurry before someone else does! > http://mail.promotions.yahoo.com/newdomains/sg/ > <http://mail.promotions.yahoo.com/newdomains/sg/> > > [Non-text portions of this message have been removed] > > -- =============================== gold jewelry manufacture UBSGOLD.COM UNIVERSE OF GOLD UNTUNG BERSAMA SEJAHTERA ===============================
