Berikut cara yang sudah saya terapkan dan berhasil (oracle 9i), jika di oracle
10g, tinggal sesuaikan path2nya saja (perbedaan oracle home dan oracle base di
9i dan 10g), caranya sama aja..
In this case, dicontohkan SID yaitu PRD..
- Step 1
Install Oracle Database 9i di server baru dengan memilih software only pada
saat proses instalasi
- Step 2
Setelah proses instalasi selesai, bukalah DBCA (Database Configuration
Assistant) yang dapat di akses melalui Start >> Oracle – OraHome92 >>
Configuration and Migration Tools >> Database Configuration Assistant.
Pilih Create a database lalu klik next..
Pilih General Purpose..
Pilih Dedicated Server Mode, lalu Next…
Ikuti defaultnya saja (nantinya dapat diatur melalui parameter file pfile),
klik Next…
Pilih Create Database lalu klik Finish..
Proses pembuatan database dimulai..
Set Password untuk SYS dan SYSTEM, namun nantinya password ini tidak digunakan
karena kita mengambil password file dari server lama.
- Step 3
1. Delete folder berikut ini (dilakukan di server baru):
· Folder PRD pada direktori {ORACLE_BASE}\admin\
· Folder PRD pada direktori {ORACLE_BASE}\oradata\
{ORACLE_BASE} = d:\oracle
{ORACLE_HOME} = d:\oracle\ora92
Note : Sebelum delete, lakukan shutdown terlebih dahulu untuk database di
server baru.
2. Shutdown Database PRD di source
SQL> sqlplus “sys/<password>@PRD as sysdba”
SQL> shutdown immediate
3. Copy folder dan file berikut dari source (server lama) ke target (server
baru) :
· Folder PRD pada direktori {ORACLE_BASE}\admin\ di source ke direktori
yang sama di target.
· Folder PRD pada direktori {ORACLE_BASE}\oradata\ ke direktori yang
sama di target.
· Copy file initPRD.ora dan PWDPRD.ora pada direktori
{ORACLE_HOME}\database\ ke direktori yang sama di target (overwrite jika sudah
ada).
4. Jika berbeda drive, lakukan create ulang control file dan sesuaikan
path-path yang terdapat di control file. Dalam kasus ini yang saya contohkan,
kita tidak perlu melakukan create ulang control file karena ORACLE_HOME
sama-sama berada di drive D.
5. Buat Service Name di server baru, lalu startup database di server baru.
6. Selesai..
"Gapailah cita-citamu setinggi langit karena jika kau meleset sekalipun, kau
akan tetap berada diantara bintang-bintang"
--- Pada Sel, 2/2/10, Dena Arif Widianto <[email protected]> menulis:
Dari: Dena Arif Widianto <[email protected]>
Judul: [indo-oracle] Memindahkan database dari server satu ke server yg lain
Kepada: "[email protected]" <[email protected]>
Tanggal: Selasa, 2 Februari, 2010, 8:28 AM
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]
Akses email lebih cepat. Yahoo! menyarankan Anda meng-upgrade browser ke
Internet Explorer 8 baru yang dioptimalkan untuk Yahoo! Dapatkan di sini!
http://downloads.yahoo.com/id/internetexplorer
[Non-text portions of this message have been removed]
