Sorry, mungkin aku agak miss,
Biasanya sih, aku spt ini - SQL> create pfile from spfile; - SQL> shutdown immediate; - Move dari $HOME/ORADATA/u01/ctrl02.ctl ke $HOME/ORADATA/u02/ctrl02.ctl - Edit pfile, dan ubah path control file, kemudian save - SQL> create spfile from pfile - SQL> startup mount - SQL> recover database - SQL> alter database open Coba aja dulu -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of handy Sent: 26 Juli 2006 16:14 To: [email protected] Subject: RE: [indo-oracle] Error Control File Hehehe kalau mau alter SPFILE bisa dilakukan di sqlplus worksheet setelah selesai mengalter baru dishutdown -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mochamad Irwan Harahap Sent: Wednesday, July 26, 2006 3:53 PM To: [email protected] Subject: RE: [indo-oracle] Error Control File Mas, DB nya di shutdown dulu sebelum di alter :P -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of handy Sent: 26 Juli 2006 15:46 To: [email protected] 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] 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. ========================================================= -- -----------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 ========================================================= 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. ========================================================= -- -----------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/
