Maksud saya seblm dishutdown masih bisa dialter -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yoel Sent: Wednesday, July 26, 2006 5:04 PM To: [email protected] Subject: Re: [indo-oracle] Error Control File
Maaf mas, kalo sudah di shutdown mana bisa di alter? :) On 7/26/06, Mochamad Irwan Harahap <[EMAIL PROTECTED]> wrote: > > Mas, DB nya di shutdown dulu sebelum di alter :P > > > -----Original Message----- > From: [email protected] <indo-oracle%40yahoogroups.com> [mailto: > [email protected] <indo-oracle%40yahoogroups.com>] > On Behalf Of handy > Sent: 26 Juli 2006 15:46 > To: [email protected] <indo-oracle%40yahoogroups.com> > Subject: [indo-oracle] Error Control File > > Hi expert, > > Hallo saya baru saja melakukan perpindahan control file (backup) pada > oracle9i R2 di SLES8, dengan cara : > > Sebelumnya komposisi ctrl saya adalah sebagai berikut: > > $HOME/ORADATA/u01/ctrl01.ctl > > $HOME/ORADATA/u01/ctrl02.ctl > > $HOME/ORADATA/u02/ctrl03.ctl > > Lalu saya ingin mencoba kembali dengan mengubah ctrl02 pada u02 > > $HOME/ORADATA/u02/ctrl02.ctl > > Saya melakukan perubahan ctrl itu dengan : > > 1.meng alter SPFILE > > Alter SYSTEM SET Control_files = > > '$HOME/ORADATA/u01/ctrl01.ctl', > > $HOME/ORADATA/u02/ctrl02.ctl' Scope = spfile ; > > 2. Meng Shutdown database > > 3. Kemudian mengcopy ctrl02.ctl dari u01 ke u02 > > 4. meng start up kembali > > Masalahnya : > > 1. Akan tetapi saya mengalami database tidak dapat distartup > > 2. o..ya saya berusaha mengembalikan spt sediakala dengan menulis pada > spfile nya langsung akan tetapi tetap error dan > > Error messagenya spt dibawah ini : > > ora-01122:database file 1 failed verification check > > ora-01110;data file 1: > > '/oracle/u01/oradata/oracle9/system01.dbf' > > ora-01207:file is more recent than controlfile - old controlfile > > Dapatkah para expert membantu saya ?? > > Thanks and best regards, > > Handy > > [Non-text portions of this message have been removed] > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED]<indo-oracle-unsubscribe%40yahoogroup s.com> > Website: http://indo-oracle.blogspot.com > Mirror: http://indooracle.wordpress.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.com > Yahoo! Groups Links > > ========================================================= > This e-mail, including any attachment is confidential and may be > privileged. Use or disclosure of it by anyone other than an intended > adressee is strictly prohibited. If you are not an intended addressee, > please notify the sender by telephone or e-mail and delete the e-mail and > any attachment from your system. > > PT Excelcomindo Pratama Tbk. ("the " Company") does not accept any > liability in respect of communication made by its employee which is contrary > to the company policy or outside the scope of the employment of the > individual concerned. The employee responsible will be personally liable for > any damages or other liability arising. > ========================================================= > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 7/25/2006 -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
