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]> wrote: From: Setijo Agus <[email protected]> Subject: Re: [indo-oracle] gagal saat re-create control file To: [email protected] 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/ [Non-text portions of this message have been removed]
