Sudah di jalankan perintah oradim oradim -new/edit/delete -sid (oracle_sid) -startmode manual -pfile "path_to\your\pfile"
From: [email protected] [[email protected]] On Behalf Of Dena Arif Widianto [[email protected]] Sent: Tuesday, February 02, 2010 8:28 AM To: [email protected] Subject: [indo-oracle] Memindahkan database dari server satu ke server yg lain Dear para master oracle, Saya ingin memindahkan database dari server satu ke server lainnya, namun masih mengalami kebuntuan. MOhon bantuannya. Yang sudah saya lakukan adalah sbb: Step 1: Stop the Oracle service on the new server to make sure everything smooth. On Windows 2003 server, just go into the Service console of Administrative tools, and click Stop button for Oracle service. Step 2: Make sure the oracle service on both machines are similar. Like the existing one called MYDATA then the new one should be better called MYDATA too. If not, then create an Oralce service with the same name on the new server. I am not sure whether this step is mandatory or not. But to have less trouble, why not we keep them identical. Step 3: Copy two files from the Oracle application folder to the same folder on the new server. These two files are SPFILE and Password files. In my case, they are D:\oracle\product\10.2.0\db_1\database\SPFILEMYDATA.ora and D:\oracle\product\10.2.0\db_1\database\PWDMYDATA.ora Step 4: Copy data folder to new server. There are a lot of control files in this folder whose name same as the Oracle service name. And it should be under the folder of oradata. In my case I copied the whole folder of c:\oracle\oradata\MYDATA to the directory of c:\oracle\oradata\ on the new server. Step 5: re-start the oracle service on the new server. ________________________________ ========================================================= 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] Mulai 1 januari 2010 PT. Federal International Finance menempati gedung baru MENARA FIF - Jl. TB. Simatupang Kav. 15, Cilandak Barat Jakarta 12340, Telp: (021) 769 8899, Fax: (021) 7590 5599 ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
