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]
