Nah lho, kalau file system ga ada, menurut saya sih, databasenya udah ga bisa di apa2in lagi. karena informasi schema system dan informasi database (library, dictonary, koreksi ya kalao salah) ada di tbs system .
Ini bukan production kan ??? mudah2an masih ada offline backupnya. regards Henri ----- Original Message ----- From: Setijo Agus<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Sent: Thursday, May 07, 2009 1:01 PM Subject: Re: [indo-oracle] gagal saat re-create control file 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> > <mailto:setijo%40ptubs.com>> wrote: > > From: Setijo Agus <[email protected]<mailto:setijo%40ptubs.com> > <mailto:setijo%40ptubs.com>> > Subject: Re: [indo-oracle] gagal saat re-create control file > To: [email protected]<mailto:indo-oracle%40yahoogroups.com> > <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 =============================== ________________________________ 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. [Non-text portions of this message have been removed]
