ok, makasih yah atas saran dari para master oracle...untungnya sih ini hanya db test aja kok bukan production...jadi sekarang menambah ilmunya
--- In [email protected], Henriap <henr...@...> wrote: > > 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:set...@...> > 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 <set...@...<mailto:setijo%40ptubs.com> > > <mailto:setijo%40ptubs.com>> wrote: > > > > From: Setijo Agus <set...@...<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] >
