Category Archives: Database

Belajar Database

Cara Backup dan Restore DB2 – OS yang sama

Berikut ini adalah cara Backup dan Restore database DB2 dengan OS yang sama.

Backup :

1.db2 deactivate database <nama_db>
2.db2 force applications all
3.db2 backup database btn to <lokasi backup>  ex: d:\btn\backup, /home/db2inst1/backupdb/
Restore :

1. copy image backup file (ex:BTN.0.DB2.NODE0000.CATN0000.20120224085107.001) ke suatu folder [ex: c:\backup, /home/db2inst1/backupdb/]

2.db2 deactivate database <nama_db>
3.db2 force applications all
4. db2 restore database [nama_database] from [folder_file_backup] on [folder_db2_data]
into [nama_database] redirect without prompting

explain:
[nama_database] => nama database, ex: btn
[folder_file_backup] => folder di step 2, ex: c:\backup
[folder_db2_data] => folder letak data2 table db2 disimpan, secara default C:\
jika terdapat c:\DB2\NODE0000, maka isi C:\
atau(di linux)

db2 force applications all
db2 restore db btn_wb from /home/db2inst1/backupdb/ into btn_wb redirect
5. db2 restore database btn_wb continue

Advertisements

How To : Installasi Oracle XE pada Ubuntu 64 Bit

Environtment : Ubuntu 10.04 LTS – the Lucid Lynx 64 Bit
Installer    : oracle-xe-universal_10.2.0.1-1.0_i386.deb

rile@chameleon-desktop:~$sudo apt-get install libaio1

rile@chameleon-desktop:~$sudo dpkg -i –force-architecture <path-location>/oracle-xe-universal_10.2.0.1-1.0_i386.deb

rile@chameleon-desktop:~$sudo /etc/init.d/oracle-xe configure

setting oracle

rile@chameleon-desktop:~$sudo gedit /home/rile/.bashrc

tambahkan

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID=XE
export PATH

jika sudah selesai, Anda bisa langsung mengakses http://127.0.0.1:8080/apex
dari browser Anda

penampakan oracle terinstall di Ubuntu 64 bit

Definisi Basisdata

Definisi

Basis = markas / gudang / tempat bersarang / tempat berkumpul.

Data = representasi dari fakta dunia yang mewakili suatu obyek (manusia, barang, peristiwa, keadaan dsb) yang direkam dalam bentuk angka, huruf, simbol, teks, gambar, bunyi atau kombinasinya.

Read the rest of this entry