Network File System Agustus 26, 2008
Posted by setijoagus in Linux.Tags: Network File System
add a comment
I. Tujuan
Sebagai acuan untuk prosedur sharing file di Linux dengan menggunakan NFS, artinya kita dapat melakukan mount partisi disk pada komputer remote seolah-olah berada di komputer lokal, fungsinya mirip dengan Samba.
Dimana salah satu PC Linux dapat dikonfigurasi agar berjalan sebagai NFS Server maupun NFS Client, seperti yang akan kita coba nanti. Pada contoh ini, akan dijalankan NFS Server pada komputer ber-IP 192.168.5.1, sedangkan client-nya adalah beberapa/semua komputer yang memiliki IP antara 192.168.5.1 sampai 192.168.5.255. Volume disk yang di-share adalah /archive
II. Cara Pengerjaan
SISI SERVER
1. Untuk menjalankan NFS Server, ada beberapa file konfigurasi yang harus diedit, yaitu :
/etc/exports list apa dan bagaimana suatu volume disk di-share.
/etc/hosts.allow menentukan komputer client mana saja
yang diperbolehkan untuk menggunakan service yang ada di komputer server.
/etc/hosts.deny menentukan komputer client mana saja
yang diperbolehkan untuk menggunakan service yang ada di komputer server.
2. Dengan menambahkan baris berikut baris berikut pada file /etc/exports pada komputer server (IP : 192.168.5.1)
# mkdir /archive
# chown oracle.oinstall /archive -R
# vi /etc/exports
/archive 192.168.5.1(ro,no_subtree_check) 192.168.5.2(rw,no_subtree_check)
artinya men-share /archive read-only untuk client 192.168.5.1, sedangkan client 192.168.5.2 mendapat akses read-write.
Sedangkan arti no_subtree_check adalah tidak akan dilakukan pengecekan apakah file yang diakses itu berada pada volume dan tree yang sesuai, tujuannya agar mempercepat transfer data
# vi /etc/exports
/archive 192.168.5.0/255.255.255.0(rw,no_subtree_check)
artinya memberikan akses /archive read-write pada semua client pada rentang IP 192.168.5.1 sampai 192.168.5.255 cukup tambahkan baris berikut.
3. Untuk menjalankan jalankan daemon-daemon yang diperlukan oleh NFS yaitu rpc.nfsd, rpc.lockd, rps.statd, rpc.mountd dan rpc.rquotad. Selain itu, NFS juga bergantung pada daemon portmapper, yang disebut portmap atau rpc.portmap. Skrip untuk menjalankan semua daemon tersebut biasanya sudah disediakan pada masing-masing distro Linux.
# service nfs start
Starting NFS services: [ OK ]
Starting NFS quotas: [ OK ]
Starting NFS daemon: [ OK ]
Starting NFS mountd: [ OK ]
# service portmap start
Starting portmap: [ OK ]
4. Agar daemon tersebut dapat dijalankan setiap kali booting.
# chkconfig nfs on
# chkconfig portmap on
5. Untuk memastikan apakah daemon tersebut sudah berjalan dan siap untuk menerima request.
# rpcinfo -p
program vers proto port
100000 2 tcp 111 portmapper
100000 2 udp 111 portmapper
100024 1 udp 881 status
SISI CLIENT
6. Untuk menjalankan NFS Client hanya dibutuhkan tiga daemon, yaitu portmap, lockd dan statd..
# mkdir /archive
# chown oracle.oinstall /archive -R
# mount 192.168.5.1:/archive /archive
7. Agar filesistem di atas di-mount setiap kali booting, tambahkan baris berikut pada file /etc/fstab.
# vi /etc/fstab
192.168.5.1:/archive /archive nfs rw,hard,intr 0 0
8. Karena setup di sisi server nantinya digunakan oleh user oracle ,maka test dapat dilakukan sebagai berikut.
a. Apakah punya hak akses read ?
$ ls /archive/
test2.txt test.txt
b. Apakah punya hak akses write ?
$ ls -la /archive/ > /archive/test3
$ ls /archive/
test2.txt test3 test.txt
Oracle Advanced Replication Agustus 26, 2008
Posted by setijoagus in REPLICATION, oracle.Tags: ORACLE ADVANCE REPLIKASI, Oracle Advanced Replication
8 comments
I. Tujuan
Seandainya kita memiliki kantor cabang dan diinginkan untuk mengetahui perubahan transaksi yang terjadi di kantor cabang. Selain itu kantor pusat sesekali harus juga mengupdate data kantor cabang sedangkan jaringan yang menghubungkan antara kantor cabang dan pusat terbatas bandwidth dan performancenya (sering putus), maka salah satu solusinya adalah menggunakan Oracle advance replikasi. Berikut acuan untuk prosedur instalasi Oracle 10g advance replikasi, pada contoh di bawah ini 2 site akan memiliki data yang sama pada interval tertentu. Pada pembahasan ini tidak disertakan konfigurasi VPN.
II. Cara Pengerjaan
1. Install 2 site dengan oracle 10g (dalam contoh ini O/S menggunakan Oracle Enterprise Linux 5), setelah berhasil melakukan instalasi oracle 10g, jangan lupa untuk mengatur agar tnsnames.ora juga dapat mengakses site lawannya.
ISCATM
2. Unlock user scott dan setup global
ORACLE_SID=iscatm; export ORACLE_SID
sqlplus / as sysdba
alter user scott account unlock;
alter user scott identified by tiger;
conn scott/tiger;
conn system/ORACLE0@iscatm
alter system set global_names=TRUE;
alter system set job_queue_processes = 1;
3. create admin replikasi dan menyiapkan grant yang dibutuhkan
CREATE USER repadmin IDENTIFIED BY repadmin;
BEGIN
DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA (
username => ‘repadmin’);
END;
/
GRANT SELECT ANY DICTIONARY TO repadmin;
BEGIN
DBMS_DEFER_SYS.REGISTER_PROPAGATOR (
username => ‘repadmin’);
END;
/
BEGIN
DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP (
username => ‘repadmin’,
privilege_type => ‘receiver’,
list_of_gnames => NULL);
END;
/
4. Membuat Schedule job yang digunakan untuk melakukan push transaksi dari master sesuai dengan interval yang diatur, sesuaikan dengan bandwidth, kualitas jaringan.
CONNECT repadmin/repadmin@iscatm
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
next_date => SYSDATE,
– interval 1 jam
interval => ‘SYSDATE + 1/24′,
delay_seconds => 0);
END;
/
ISCATM2
5. Ulangi langkah 2 s/d 4 untuk site lawannya
6. unlock user scott dan setup global
ORACLE_SID=iscatm2; export ORACLE_SID
sqlplus / as sysdba
alter user scott account unlock;
alter user scott identified by tiger;
conn scott/tiger;
conn system/ORACLE0@iscatm2
alter system set global_names=TRUE;
alter system set job_queue_processes = 1;
7. create admin replikasi dan menyiapkan grant yang dibutuhkan
CREATE USER repadmin IDENTIFIED BY repadmin;
BEGIN
DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA (
username => ‘repadmin’);
END;
/
GRANT SELECT ANY DICTIONARY TO repadmin;
BEGIN
DBMS_DEFER_SYS.REGISTER_PROPAGATOR (
username => ‘repadmin’);
END;
/
BEGIN
DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP (
username => ‘repadmin’,
privilege_type => ‘receiver’,
list_of_gnames => NULL);
END;
/
8. Membuat Schedule job yang digunakan untuk melakukan push transaksi dari master sesuai dengan interval yang diatur, sesuaikan dengan bandwidth, kualitas jaringan.
CONNECT repadmin/repadmin@iscatm2
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
next_date => SYSDATE,
– interval 1 jam
interval => ‘SYSDATE + 1/24′,
delay_seconds => 0);
END;
/
ISCATM
9. Membuat private db links
conn system/ORACLE0@iscatm
create public database link iscatm2 using ‘iscatm2′;
conn repadmin/repadmin@iscatm
create database link iscatm2 connect to repadmin identified by repadmin;
conn repadmin/repadmin@iscatm
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH (
destination => ‘ISCATM2.LOCALDOMAIN’,
– interval 10 menit
interval => ‘SYSDATE + (1/144)’,
next_date => SYSDATE,
parallelism => 1,
execution_seconds => 1500,
delay_seconds => 1200);
END;
/
ISCATM2
10. Ulangi untuk membuat private db links pada site lawan.
conn system/ORACLE0@iscatm2
create public database link iscatm using ‘iscatm’;
conn repadmin/repadmin@iscatm2
create database link iscatm connect to repadmin identified by repadmin;
conn repadmin/repadmin@iscatm2
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH (
destination => ‘ISCATM.LOCALDOMAIN’,
– interval 10 menit
interval => ‘SYSDATE + (1/144)’,
next_date => SYSDATE,
parallelism => 1,
execution_seconds => 1500,
delay_seconds => 1200);
END;
/
ISCATM
11. membuat replication group untuk MASTERDEF site, Register objects dan menambahkan master desination site. Dalam contoh pembahasan ini tabel – tabel yang direplikasi adalah scott.dept dan scott.emp.
conn repadmin/repadmin@iscatm
begin
dbms_repcat.create_master_repgroup (
gname => ’scott_repg’);
end;
/
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
gname => ’scott_repg’,
type => ‘TABLE’,
oname => ‘EMP’,
sname => ’scott’,
use_existing_object => TRUE,
copy_rows => FALSE);
END;
/
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
gname => ’scott_repg’,
type => ‘TABLE’,
oname => ‘DEPT’,
sname => ’scott’,
use_existing_object => TRUE,
copy_rows => FALSE);
END;
/
BEGIN
DBMS_REPCAT.ADD_MASTER_DATABASE (
gname => ’scott_repg’,
master => ‘iscatm2′,
use_existing_objects => TRUE,
copy_rows => FALSE,
propagation_mode => ‘ASYNCHRONOUS’);
END;
/
conn repadmin/repadmin@iscatm
SELECT DBLINK FROM DBA_REPSITES WHERE GNAME = ‘SCOTT_REPG’;
conn repadmin/repadmin@iscatm
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => ’scott’,
oname => ‘emp’,
type => ‘TABLE’,
min_communication => TRUE);
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => ’scott’,
oname => ‘dept’,
type => ‘TABLE’,
min_communication => TRUE);
END;
/
ISCATM dan ISCATM2
12. Membuat skrip repmon.sql seperti dibawah ini untuk masing – masing site, skrip ini berguna melakukan monitoring replikasi.
rem ————————————————————-
rem http://www.orafaq.com/scripts/advrepl/repmon.txt
rem ————————————————————-
rem Filename: repmon.sql
rem Purpose: Monitor replication status, sites and groups
rem Date: 03-Oct-2000
rem Author: Frank Naude, Oracle FAQ
rem ————————————————————-
connect repadmin/repadmin
set pages 50000
col sname format a20 head “SchemaName”
col masterdef format a10 head “MasterDef?”
col oname format a20 head “ObjectName”
col gname format a20 head “GroupName”
col object format a35 trunc
col dblink format a35 head “DBLink”
col message format a25
col broken format a6 head “Broken?”
prompt Replication schemas/ sites
select sname, masterdef, dblink
from sys.dba_repschema;
prompt RepCat Log (after a while you should see no entries):
select request, status, message, errnum
from sys.dba_repcatlog;
prompt Entries in the job queue
select job, last_date, last_sec, next_date, next_sec, broken, failures,
what
from sys.dba_jobs
where schema_user = ‘REPADMIN’;
prompt Replication Status:
select sname, master, status
from sys.dba_repcat;
– Returns all conflict resolution methods
– select * from all_repconflict;
– Returns all resolution methods in use
– select * from all_represolution;
prompt Objects registered for replication
select gname, type||’ ‘||sname||’.'||oname object, status
from sys.dba_repobject;
ISCATM
13. Memulai replikasi, dengan terlebih dulu memeriksa apakah DBA_REPCATLOG sudah bernilai 0, jika belum replikasi belum dapat dijalankan. Pantau terus sampai kondisi bernilai 0.
conn repadmin/repadmin@iscatm
SELECT COUNT(*) FROM DBA_REPCATLOG WHERE GNAME = ‘SCOTT_REPG’;
14. Start Replikasi
conn repadmin/repadmin@iscatm
BEGIN
DBMS_REPCAT.RESUME_MASTER_ACTIVITY (
gname => ’scott_repg’);
END;
/
15. status replikasi, ada beberapa status replikasi :
a. NORMAL: Normal unquiesced state.
b. QUIESCING: Being quiesced, but some non-DBA sessions are still active.
c. QUIESCED: Quiesced; no non-DBA sessions are active or allowed.
conn repadmin/repadmin@iscatm
SELECT GNAME, STATUS FROM DBA_REPGROUP;
conn repadmin/repadmin@iscatm2
SELECT GNAME, STATUS FROM DBA_REPGROUP;
16. Untuk menghentikan replikasi
conn repadmin/repadmin@iscatm
BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (
gname => ’scott_repg’);
END;
/
17. test replikasi salah satu site
conn scott/tiger@iscatm
select * from dept;
insert into dept values (50,’DUMMY’,'DUMMY’);
commit;
select * from dept;
select * from dept@iscatm2;
18. jika isi data antara 2 site belum sama, kemungkinan interval job belum terlampaui (job belum dijalankan), untuk memaksa agar job segera dijalankan. Maka terlebih dulu harus mengetahui no job, jalankan repmon.sql.
conn repadmin/repadmin@iscatm
@repmon.sql;
BEGIN
dbms_job.run(49);
dbms_job.run(50);
dbms_job.run(51);
END;
/
conn scott/tiger@iscatm2
select * from dept order by deptno;
ISCATM2
19. Terlihat isi tabel dept di antara 2 site kini telah sama, sebaliknya kita juga dapat melakukan proses insert, update dan delete dari site lawan.
conn scott/tiger@iscatm2
delete dept where deptno > 40;
commit;
select * from dept;
select * from dept@iscatm;
20. Sama dengan langkah no 18, jika isi data antara 2 site belum sama, kemungkinan interval job belum terlampaui (job belum dijalankan), untuk memaksa agar job segera dijalankan. Maka terlebih dulu harus mengetahui no job, jalankan repmon.sql.
conn repadmin/repadmin@iscatm2
@repmon.sql;
BEGIN
dbms_job.run(49);
dbms_job.run(50);
dbms_job.run(51);
END;
/
Copy dengan SSH Agustus 26, 2008
Posted by setijoagus in Linux.Tags: Copy dengan SSH
add a comment
I. Tujuan
Sebagai acuan teori untuk prosedur scp – secure copy atau remote file copy program atau copy dengan SSH, yang merupakan alternative copy selain FTP.
II. Cara Pengerjaan
1. format scp
scp [-pqrvBC46] [-F ssh_config] [-S program] [-P port] [-c cipher]
[-i identity_file] [-o ssh_option] [[user@]host1:]file1 [...]
[[user@]host2:]file2
2. perintah scp secara langsung seperti di bawah ini
scp gv140905.dmp 172.20.141.1:/u01/app/oracle/product/10.1.0/db_1/dmp
Could not create directory ‘/home/oracle/.ssh’.
The authenticity of host ‘172.20.141.1 (172.20.141.1)’ can’t be established.
RSA key fingerprint is b2:92:5c:ec:83:38:0b:bd:ee:17:e5:2e:90:83:96:5b.
Are you sure you want to continue connecting (yes/no)? yes
Failed to add the host to the list of known hosts (/home/oracle/.ssh/known_hosts).
oracle@172.20.141.1’s password:
gv140905.dmp 100% |*****************************| 901 MB 08:18
3. contoh diatas akan sulit diterapkan pada sebuah script, karena harus terlebih dulu memasukan password. Agar SSH atau SCP tidak menanyakan password maka baik sisi client maupun sisi server harus diset.
Configuration: Client Side
4. Generate SSH encryption key pair untuk filecopy account.
ssh-keygen -t dsa -f $HOME/.ssh/id_dsa -P ”
Generating public/private dsa key pair.
/home/oracle/.ssh/id_dsa already exists.
Overwrite (y/n)? y
Your identification has been saved in /home/oracle/.ssh/id_dsa.
Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.
The key fingerprint is:
f3:f2:02:cf:a2:38:56:3b:51:55:5d:dc:ad:44:84:cb oracle@ptubsor2
5. keterangan ssh-keygen -t dsa
identification disimpan di /home/oracle/.ssh/id_dsa.
public key disimpan di /home/oracle/.ssh/id_dsa.pub.
key fingerprint adalah : f3:f2:02:cf:a2:38:56:3b:51:55:5d:dc:ad:44:84:cb oracle@ptubsor2
6. keyfiles disimpan di .ssh subdirectory dari home directory.
cd /home/oracle/.ssh
ls -la
total 8
drwxr-xr-x 2 oracle oinstall 4096 Sep 15 11:39 .
drwx—— 8 oracle oinstall 4096 Sep 15 11:37 ..
-rw——- 1 oracle oinstall 0 Sep 15 11:39 id_dsa
-rw-r–r– 1 oracle oinstall 0 Sep 15 11:39 id_dsa.pub
7. Copy public key komputer tujuan yang akan dicopy.
scp /home/oracle/.ssh/id_dsa.pub oracle@172.20.140.31:public-key.tmp
oracle@172.20.140.31:public-key.tmp
The authenticity of host ‘172.20.140.31 (172.20.140.31)’ can’t be established.
RSA key fingerprint is c1:a8:05:92:d0:b0:75:0d:90:46:3a:b7:d9:33:98:82.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added ‘172.20.140.31′ (RSA) to the list of known hosts.
Enter passphrase for key ‘/home/oracle/.ssh/id_dsa’:
Enter passphrase for key ‘/home/oracle/.ssh/id_dsa’:
oracle@172.20.140.31’s password:
id_dsa.pub 100% |*****************************| 0 00:00
Configuration – Server Side
8. Login server tujuan sebagai user. Create .ssh subdirectory pada home directory
pwd
/home/oracle
mkdir .ssh
chmod 700 .ssh
cd .ssh
9. Tambahkan public-key.tmp ke akhir file authorized_keys
cat ~/public-key.tmp >> authorized_keys
chmod 700 /home/oracle/.ssh
rm ~/public-key.tmp
/home/oracle/backup/pindah
test scp tanpa login
10. Lakukan test dari client / tempat asal file ke server / tujuan copy
scp /home/oracle/initptubsor2.ora oracle@172.20.140.31:/home/oracle/contohinit.ora
initptubsor2.ora 100% |*****************************| 1348 00:00
Clone Database Oracle 8i Windows ke Linux Agustus 26, 2008
Posted by setijoagus in Oracle Backup, oracle.Tags: Clone Database Oracle 8i
add a comment
1. Tujuan
Untuk melakukan clone database pada Oracle 8i Enterprise Edition pada Operating System Windows NT ke Linux dengan benar.
2. Ringkasan Metoda
Menggunakan Oracle 8i Enterprise Edition Operating System pada Windows NT Server dan Linux
3. Cara Kerja
1. Jalankan Ms.Dos Prompt pada server yang akan diclone / dicopy / dipindah.
2. Jalankan Server Manager dan connect internal atau sys as sysdba
3. Jalankan perintah ALTER DATABASE untuk menciptakan CONTROLFILE script
4. Shut down database
5. Exit Server Manager.
6. Copy database files ke lokasi baru atau server oracle yang baru (server oracle yang baru harus telah di install oracle server dan telah dilakukkan shutdown database). Dimana letak data biasanya di oradataorcl . Copykan semua file yang terletak di folder tsb.
Orclcontrol.ctl
orcluser01.dbf
orcldata01ts01.dbf
orcltemp01.dbf
orclredog01m01.log
orclredog02m01.log
folder tujuan di Linux, misalnya : /u01/app/oracle/oradata/orcl
7. Periksa file initorcl.ora and pwdorcl.ora di directory orantdatabase,
8. Edit file inittest.ora, sesuaikan server parameters
DB_NAME =
CONTROL_FILES [drive_letter]:oradata
9. Di directory server yang diclone/ dicopy, cari file extension TRC yang terakhir., selanjutnya rename menjadi cr_ctlfile.sql dan copykan ke server yang baru
10. Edit file cr_ctlfile.sql :
a. hapus dari baris pertama sampai baris yang diawali #
b. Ubah perintah CREATE CONTROLFILE
CREATE CONTROLFILE REUSE DATABASE “ORACLE” NORESETLOGS NOARCHIVELOG
menjadi
CREATE CONTROLFILE REUSE SET DATABASE “TEST” RESETLOGS NOARCHIVELOG
c. Ubah semua directory oradata lama ke directory oradata baru
d. Hapus baris RECOVER DATABASE
e. Edit baris
ALTER DATABASE OPEN;
Menjadi
ALTER DATABASE OPEN RESETLOGS;
11. Cari file init.ora yang terletak di folder D:ORACLEADMINPTUBSOR2PFILE
12. Edit letak Control_files yang baru didalam contoh di bawah ini d:oracleoradataptubsor2control01.ctl ke posisi directory baru. Ubah db_name, instance_name, services_name jika diperlukan.
13. Run Server Manager dan connect sebagai internal atau sys as sysdba
[oracle@jems]$ cd /u01/app/oracle/product/8.1.7/dbs
[oracle@jems dbs]$ svrmgrl
Oracle Server Manager Release 3.1.7.0.0 – Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.1 – Production
With the Partitioning option
JServer Release 8.1.7.0.1 – Production
SVRMGR> connect internal
Connected.
SVRMGR>
14. Run the cr_ctlfile.sql command script yang telah diedit.
SVRMGR> @cr_ctlfile.sql
ORACLE instance started.
Total System Global Area 5112820 bytes
Fixed Size 45584 bytes
Variable Size 4133348 bytes
Database Buffers 409600 bytes
Redo Buffers 524288 bytes
Statement processed.
Statement processed.
SVRMGR>
15. Jalankan startup seperti biasa
BandwidthMeter LAN Agustus 26, 2008
Posted by setijoagus in Network.Tags: BandwidthMeter LAN
add a comment
I. Tujuan
Sebagai acuan untuk prosedur mengukur BandwidthMeter LAN
II. Cara Pengerjaan
1. Bandwidthmeter adalah sebuah tools aplikasi yang digunakan untuk mengukur kecepatan download dari server x ke komputer client pada suatu saat tertentu.
2. Metode yang dipakai untuk menghasilkan angka Bandwidthmeter di LAN khususnya UBS adalah pada saat kita link/click URL :
http://ubs3/bandwidthmeter/meter.php
atau
http://172.20.140.195/bandwidthmeter/meter.php
maka akan di download satu file dari server ubs3 (besarnya X), pada saat start download itu pula akan dicatat oleh aplikasi waktu di komputer lokal sebagai start_time , dan pada saat download complete, maka aplikasi akan mencatat waktu komputer lokal sebagai end_time. Nah dengan tiga paramater yang diketahui maka kita ambil rumus dibawah :
hasil = X/(end_time-start_time)
3. Kecepatan koneksi LAN pada dasarnya tergantung banyak faktor. Seperti halnya jalan raya yang memiliki banyak tikungan dan jalan dengan batas kecepatan yang bervariasi.
4. Karena itu kecepatan koneksi secara keseluruhan sangat bergantung dari kesibukan dan performansi perangkat yang dilalui dan juga kesibukan server ubs3.
5. Untuk menghasilkan data yang relatif stabil, anda dapat mencoba pengukuran pada jam diluar jam sibuk. Jangan lupa pada saat melakukan pengukuran untuk tidak menjalankan program lain pada PC anda karena akan mempengaruhi akurasi pengukuran.
6. Hal Hal yang mempengaruhi pengukuran adalah :
a. Trafik LAN dari link client ke server ubs3
b. Trafik LAN dari client apabila komputer client ada dalam intranet
c. Tingkat kesibukan dan aktifitas server ubs3 pada saat itu
Jadi kemungkinan setiap pengukuran akan menghasilkan angka yang berbeda.
7. Cara membuat alat ukur BandwidthMeter :
a. download file – file yang dibutuhkan dalam bemtuk zip di http://www.gambitdesign.com/bandwidthmeter/
b. Unzip package bandwidthmeter-0.72.zip.
c. copykan bandwidthmeter directory ke lokasi web server. Untuk UBS sudah ada web server di komputer UBS3 / 172.20.140.195, dimana web server tersebut menggunakan apache server dan support php.
d. Modifikasi file config.inc.php khususnya
$mysql = True jika menggunakan MySQL untuk log
$mysql = False jika tidak menggunakan log
8. Contoh hasil test LAN khususnya UBS pada saat kita link/click URL :
http://ubs3/bandwidthmeter/meter.php
atau
http://172.20.140.195/bandwidthmeter/meter.php
Startup – Shutdown otomatis ORACLE 10g Agustus 26, 2008
Posted by setijoagus in Oracle Backup, oracle.Tags: Startup - Shutdown otomatis ORACLE 10g
2 comments
I. Tujuan
Sebagai acuan teori untuk prosedur startup-shutdown database dan listener otomatis ORACLE 10g Single di LINUX centos 4.2
II. Cara Pengerjaan
1. pembuatan script start database di $ORACLE_HOME/bin
[oracle@ubs bin]$ cd $ORACLE_HOME/bin
[oracle@ubs bin]$ vi startora10g
#!/bin/sh
# Start the oracle database
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ubs
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/dbstart
exit 0
[oracle@ubs bin]$ chmod u+x startora10g
2. pembuatan script stop database di $ORACLE_HOME/bin
[oracle@ubs bin]$ cd $ORACLE_HOME/bin
[oracle@ubs bin]$ vi stopora10g
#!/bin/sh
# Start the oracle database
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ubs
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/dbshut
exit 0
[oracle@ubs bin]$ chmod u+x stopora10g
3. pembuatan script restart, start dan stop di $ORACLE_HOME/bin
[oracle@ubs bin]$ cd $ORACLE_HOME/bin
[oracle@ubs bin]$ vi oracle10g
#!/bin/sh
#
# chkconfig: 345 51 49
# description: startup and shutdown the Oracle 8i database
#
echo “Oracle 10g database start/stop/restart”
ORA_OWNER=oracle
ORA_HOME=/u01/app/oracle/product/10.2.0/db_1
case “$1″ in
’start’)
# Start the database
echo -n “Starting the database for 10g: “
su – $ORA_OWNER -c $ORA_HOME/bin/startora10g
echo
;;
’stop’)
# Stop the database
echo -n “Shutting down database for 10g: “
su – $ORA_OWNER -c $ORA_HOME/bin/stopora10g
echo
;;
‘restart’)
# Restart the Oracle databases:
echo -n “Restarting database for 10g: “
$0 stop
$0 start
echo
;;
*)
echo “Usage: oracle10g [ start | stop | restart }"
exit 1
esac
exit 0
[oracle@ubs bin]$ chmod u+x oracle10g
4. Login root dan edit /etc/oratab.
[oracle@ubs bin]$ su – root
Password:
[root@ubs ~]# vi /etc/oratab
ubs:/u01/app/oracle/product/10.2.0/db_1:N
menjadi
ubs:/u01/app/oracle/product/10.2.0/db_1:Y
5. copykan script oracle10g ke /etc/rc.d/init.d/
[root@ubs ~]# cp /u01/app/oracle/product/10.2.0/db_1/bin/oracle10g /etc/rc.d/init.d/
[root@ubs ~]# cd /etc/rc.d/init.d
[root@ubs init.d]# chmod 700 oracle10g
6. jika menggunakan Oracle 10g Release 2, edit script dbstart atau jika terjadi error dengan message:
Failed to auto-start Oracle Net Listener using /ade/vikrkuma_new/oracle/bin/tnslsnr
edit file “$ORACLE_HOME/bin/dbstart” ganti /edit (line 78):
ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
dengan :
ORACLE_HOME_LISTNER=$ORACLE_HOME
7. test script oracle10g start dengan login sebagai root
[root@ubs ~]# cd /etc/rc.d/init.d
[root@ubs ~]# ./oracle10g
Oracle 10g database start/stop/restart
Usage: oracle10g [ start | stop | restart }
[root@ubs init.d]# ./oracle10g start
Oracle 10g database start/stop/restart
Starting the database for 10g: Processing Database instance “ubs”: log file /u01/app/oracle/product/10.1.0/db_1/startup.log
8. test script oracle10g restart
[root@ubs init.d]# ./oracle10g restart
Oracle 10g database start/stop/restart
Restarting database for 10g: Oracle 10g database start/stop/restart
Shutting down database for 10g:
Oracle 10g database start/stop/restart
Starting the database for 10g: Processing Database instance “ubs”: log file /u01/app/oracle/product/10.1.0/db_1/startup.log
9. test script oracle10g stop
[root@ubs init.d]# ./oracle10g stop
Oracle 10g database start/stop/restart
Shutting down database for 10g:
10. chkconfig pada script oracle10g
[root@ubs init.d]# /sbin/chkconfig –add oracle10g
[root@ubs init.d]# /sbin/chkconfig –list oracle10g
oracle10g 0:off 1:off 2:off 3:on 4:on 5:on 6:off
LISTENER
11. pembuatan script status listener di $ORACLE_HOME/bin
[oracle@ubs bin]$ cd $ORACLE_HOME/bin
[oracle@ubs bin]$ vi statuslsnr
#!/bin/sh
# Start the oracle listener
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ubs
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/lsnrctl status
exit 0
[oracle@ubs bin]$ chmod u+x statuslsnr
12. pembuatan script start listener di $ORACLE_HOME/bin
[oracle@ubs bin]$ cd $ORACLE_HOME/bin
[oracle@ubs bin]$ vi startlsnr
#!/bin/sh
# Start the oracle listener
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ubs
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/lsnrctl start
exit 0
[oracle@ubs bin]$ chmod u+x startlsnr
13. pembuatan script stop listener di $ORACLE_HOME/bin
[oracle@ubs bin]$ cd $ORACLE_HOME/bin
[oracle@ubs bin]$ vi stoplsnr
#!/bin/sh
# Start the oracle listener
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ubs
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/lsnrctl stop
exit 0
[oracle@ubs bin]$ chmod u+x stoplsnr
14. pembuatan script status,start dan stop listener di $ORACLE_HOME/bin
[oracle@ubs bin]$ cd $ORACLE_HOME/bin
[oracle@ubs bin]$ vi listener10g
#!/bin/sh
#
# chkconfig: 345 51 49
# description: startup and shutdown the Oracle 10g listener
#
echo “Oracle 10g listener start/stop/status”
ORA_OWNER=oracle
ORA_HOME=/u01/app/oracle/product/10.2.0/db_1
case “$1″ in
’start’)
# Start the listener
echo -n “Starting the Listener for 10g: “
su – $ORA_OWNER -c $ORA_HOME/bin/startlsnr
echo
;;
’stop’)
# Stop the listener
echo -n “Shutting down Listener for 10g: “
su – $ORA_OWNER -c $ORA_HOME/bin/stoplsnr
echo
;;
’status’)
# Status the listener
echo -n “Status Listener for 10g: “
su – $ORA_OWNER -c $ORA_HOME/bin/statuslsnr
echo
;;
‘restart’)
# Restart the Oracle databases:
echo -n “Restarting Listener for 10g: “
$0 stop
$0 start
echo
;;
*)
echo “Usage: listener10g [ status | start | stop | restart }"
exit 1
esac
exit 0
[oracle@ubs bin]$ chmod u+x listener10g
15. test script listener10g sebagai root
[oracle@ubs bin]$ su – root
Password:
[root@ubs ~]# cd /u01/app/oracle/product/10.2.0/db_1/bin
[root@ubs bin]# ./listener10g
Oracle 10g listener start/stop/status
Usage: listener10g [ status | start | stop | restart }
[root@ubs bin]# ./listener10g status
Oracle 10g listener start/stop/status
Status Listener for 10g:
LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 04-OCT-2007 16:13:57
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ubs)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 – Production
Start Date 04-OCT-2007 15:51:45
Uptime 0 days 0 hr. 22 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ubs)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary…
Service “PLSExtProc” has 1 instance(s).
Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
16. copykan script listener10g ke /etc/rc.d/init.d/
[root@ubs bin]# cp /u01/app/oracle/product/10.2.0/db_1/bin/listener10g /etc/rc.d/init.d/
[root@ubs bin]# cd /etc/rc.d/init.d/
[root@ubs init.d]# chmod 700 listener10g
17. chkconfig pada script listener10g
[root@ubs init.d]# /sbin/chkconfig –add listener10g
[root@ubs init.d]# /sbin/chkconfig –list listener10g
listener10g 0:off 1:off 2:off 3:on 4:on 5:on 6:off
DATAPUMP ORACLE 10g Agustus 26, 2008
Posted by setijoagus in Oracle Backup, oracle.Tags: DATAPUMP ORACLE 10g
4 comments
I. Tujuan
Sebagai acuan teori untuk prosedur datapump ORACLE 10g LINUX.
II. Cara Pengerjaan
1. Tujuan menggunakan Export/Import atau DataPump
a. Untuk memindahkan Data Database
Development > QA > Production
b. Melakukan Logical Backup
c. Migrasi Database
Operating System[MS] > Operating System [Linux]
Oracle Version [9i] > 10g
One Character Set > Other Character Set
2. Untuk lebih mengenal perintah expdp
[oracle@ubs ~]$ expdp help=y
Format : expdp KEYWORD=value or KEYWORD=(value1,value2,…,valueN)
Example: expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir
SCHEMAS=scott or TABLES=(T1:P1,T1:P2), if T1 is partitioned
Table
3. Persiapan menggunakan perintah expdp
[oracle@ubs ~]$ mkdir /home/oracle/backup
[oracle@ubs ~]$ sqlplus / as sysdba
SQL> create or replace directory dumpfile as ‘/home/oracle/backup’;
Directory created.
SQL> GRANT READ, WRITE ON DIRECTORY dumpfile TO master;
Grant succeeded.
SQL> exit
4. Menjalankan perintah expdp
[oracle@ubs ~]$ expdp master/password schemas=master directory=dumpfile dumpfile=master01.dmp logfile=master01.log
Export: Release 10.2.0.1.0 – Production on Saturday, 06 October, 2007 8:55:28
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
Starting “MASTER”.”SYS_EXPORT_SCHEMA_01″: master/******** schemas=master directory=dumpfile dumpfile=master01.dmp logfile=master01.log
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 2.005 GB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported “MASTER”.”UBJDIVB” 178.8 MB 1659508 rows
. . exported “MASTER”.”GVBJMKA” 171.3 MB 1205875 rows
. . exported “MASTER”.”AC9400″ 151.1 MB 1510169 rows
. . exported “MASTER”.”PG001B” 123.6 MB 1088242 rows
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . exported “MASTER”.”AC9400_AKSES_LAPORAN” 6.351 KB 5 rows
. . exported “MASTER”.”AC9400_BAGIAN” 5.273 KB 3 rows
. . exported “MASTER”.”AR_DT_BARU” 5.953 KB 6 rows
. . exported “MASTER”.”PIB_CAPACITY” 6.507 KB 1 rows
. . exported “MASTER”.”PIB_CAPA_DETIL” 7.171 KB 2 rows
. . exported “MASTER”.”TOAD_PLAN_TABLE” 20.05 KB 81 rows
. . exported “MASTER”.”UBJ_DIV_KE_FC” 29.78 KB 141 rows
. . exported “MASTER”.”XBH111C” 6.265 KB 1 rows
. . exported “MASTER”.”XCO_BERAT_BATU” 27.34 KB 550 rows
. . exported “MASTER”.”CB22ST” 0 KB 0 rows
. . exported “MASTER”.”DIV_BOM” 0 KB 0 rows
. . exported “MASTER”.”DIV_BOMDIV” 0 KB 0 rows
. . exported “MASTER”.”DIV_BOMPJ” 0 KB 0 rows
. . exported “MASTER”.”DIV_BOMPM” 0 KB 0 rows
. . exported “MASTER”.”DIV_BOMPR” 0 KB 0 rows
. . exported “MASTER”.”KOMPUTER” 0 KB 0 rows
. . exported “MASTER”.”LOG_AKTIF_MODEL” 0 KB 0 rows
. . exported “MASTER”.”MK_HASIL_RETURA” 0 KB 0 rows
. . exported “MASTER”.”MK_HASIL_RETURB” 0 KB 0 rows
. . exported “MASTER”.”T1″ 0 KB 0 rows
. . exported “MASTER”.”TOAD_PLAN_SQL” 0 KB 0 rows
. . exported “MASTER”.”U_RETUR_A” 0 KB 0 rows
. . exported “MASTER”.”U_RETUR_B” 0 KB 0 rows
. . exported “MASTER”.”XBH001G” 0 KB 0 rows
Master table “MASTER”.”SYS_EXPORT_SCHEMA_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for MASTER.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/backup/master01.dmp
Job “MASTER”.”SYS_EXPORT_SCHEMA_01″ successfully completed at 08:58:35
5. Jika menggunakan perintah exp
[oracle@ubs ~]$ exp userid=master/password file=/home/oracle/backup/master02.dmp log=/home/oracle/backup/master02.txt
Export: Release 10.2.0.1.0 – Production on Sat Oct 6 11:24:45 2007
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MASTER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user MASTER
About to export MASTER’s objects …
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export MASTER’s tables via Conventional Path …
. . exporting table AC9400 1510169 rows exported
. . exporting table AC9400USER 3351 rows exported
. . exporting table AC9400_AKSES_LAPORAN 5 rows exported
. . exporting table AC9400_BAGIAN 3 rows exported
. . exporting table ALLOY 632 rows exported
. . exporting table AR_DT_BARU 6 rows exported
. . exporting table ATRIBUT 924 rows exported
. . exporting table A_DIV 28 rows exported
. . exporting table BBOMKOPR 81349 rows exported
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . exporting table XBOMPR 152656 rows exported
. . exporting table XCO_BERAT_BATU 550 rows exported
. . exporting table XTEMP_PRODUK 12055 rows exported
. . exporting table XUBJDIVA 287069 rows exported
. . exporting table XUBJDIVB 912878 rows exported
. . exporting table XUBJDIVC 490328 rows exported
. . exporting table XUBJDIVD 60561 rows exported
. . exporting table X_UBJDIVA 33575 rows exported
. . exporting table X_UBJDIVB 100788 rows exported
. . exporting table X_UBJDIVC 333 rows exported
. . exporting table ZCO_BERAT_BATU 959 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
6. Kecepatan proses, lebih cepat expdp dibandingkan exp
Menggunakan expdp
06 October, 2007 08:55:28
06 October, 2007 08:58:35
hasil = 00:03:07
Menggunakan exp
Sat Oct 6 11:39:14 WIT 2007
Sat Oct 6 11:45:59 WIT 2007
hasil = 00:06:45
7. Besarnya file, lebih kecil expdp dibandingkan exp
[oracle@ubs ~]$ ls -la /home/oracle/backup/
total 3594300
drwxr-xr-x 2 oracle oinstall 4096 Oct 6 11:39 .
drwx—— 20 oracle oinstall 4096 Oct 6 11:39 ..
-rw-r—– 1 oracle oinstall 1675464704 Oct 6 08:58 master01.dmp
-rw-r–r– 1 oracle oinstall 15859 Oct 6 08:58 master01.log
-rw-r–r– 1 oracle oinstall 2001436672 Oct 6 11:45 master02.dmp
-rw-r–r– 1 oracle oinstall 31551 Oct 6 11:45 master02.txt
8. Status job expdp, pada saat expdp dijalankan, kemudian ctrl+c.
[oracle@ubs backup]$ expdp master/password schemas=master directory=dumpfile dumpfile=master03.dmp logfile=master03.log
Export: Release 10.2.0.1.0 – Production on Saturday, 06 October, 2007 12:58:31
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
Starting “MASTER”.”SYS_EXPORT_SCHEMA_01″: master/******** schemas=master directory=dumpfile dumpfile=master03.dmp logfile=master03.log
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Export> status
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /home/oracle/backup/master03.dmp
bytes written: 4,096
Worker 1 Status:
State: EXECUTING
9. Status job expdp, dengan mengunakan perintah sql
SQL> select * from dba_datapump_jobs;
OWNER_NAME JOB_NAME
—————————— ——————————
OPERATION JOB_MODE
—————————— ——————————
STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
—————————— ———- —————– —————–
FARESO SYS_EXPORT_SCHEMA_01
EXPORT SCHEMA
EXECUTING 1 1 3
SQL> /
OWNER_NAME JOB_NAME
—————————— ——————————
OPERATION JOB_MODE
—————————— ——————————
STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
—————————— ———- —————– —————–
PRODGV SYS_EXPORT_SCHEMA_01
EXPORT SCHEMA
EXECUTING 1 1 3
10. Expdp dapat dijalankan secara pararel, kemudian ctrl+c.
[oracle@ubs backup]$ expdp master/password schemas=master directory=dumpfile parallel=4 dumpfile=master_%U.dmp logfile=masterP.log
Export: Release 10.2.0.1.0 – Production on Saturday, 06 October, 2007 14:03:12
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
Starting “MASTER”.”SYS_EXPORT_SCHEMA_01″: master/******** schemas=master directory=dumpfile parallel=4 dumpfile=master_%U.dmp logfile=masterP.log
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Export> status
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 4
Job Error Count: 0
Dump File: /home/oracle/backup/master_01.dmp
bytes written: 4,096
Dump File: /home/oracle/backup/master_%u.dmp
Worker 1 Status:
State: EXECUTING
Export> status
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 4
Job Error Count: 0
Dump File: /home/oracle/backup/master_%u.dmp
Dump File: /home/oracle/backup/master_01.dmp
bytes written: 4,096
Dump File: /home/oracle/backup/master_02.dmp
bytes written: 4,096
Dump File: /home/oracle/backup/master_03.dmp
bytes written: 4,096
Dump File: /home/oracle/backup/master_04.dmp
bytes written: 4,096
Worker 1 Status:
State: EXECUTING
Object Schema: MASTER
Object Type: SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Completed Objects: 1
Worker Parallelism: 1
Worker 2 Status:
State: EXECUTING
Object Schema: MASTER
Object Name: UBJDIVB
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 175
Worker Parallelism: 1
Worker 3 Status:
State: EXECUTING
Object Schema: MASTER
Object Name: GVBJMKA
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 175
Worker Parallelism: 1
Worker 4 Status:
State: EXECUTING
Object Schema: MASTER
Object Name: AC9400
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 175
Worker Parallelism: 1
[oracle@ubs backup]$ ls -la master_**.dmp
-rw-r—– 1 oracle oinstall 468606976 Oct 6 14:05 master_01.dmp
-rw-r—– 1 oracle oinstall 641900544 Oct 6 14:05 master_02.dmp
-rw-r—– 1 oracle oinstall 562462720 Oct 6 14:05 master_03.dmp
-rw-r—– 1 oracle oinstall 2506752 Oct 6 14:05 master_04.dmp
11. Expdp untuk rmap memindahkan tablespace
a. Misalkan diinginkan untuk memindah skema PRODGV dari tablespace USERS ke GV
b. create tablespace baru
SQL> CREATE TABLESPACE gv DATAFILE
‘/u02/gv01.dbf’ SIZE 500M AUTOEXTEND OFF,
‘/u02/gv02.dbf’ SIZE 500M AUTOEXTEND OFF,
‘/u02/gv03.dbf’ SIZE 500M AUTOEXTEND OFF,
‘/u02/gv04.dbf’ SIZE 500M AUTOEXTEND OFF,
‘/u02/gv05.dbf’ SIZE 500M AUTOEXTEND OFF,
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
‘/u02/gv23.dbf’ SIZE 500M AUTOEXTEND OFF,
‘/u02/gv24.dbf’ SIZE 500M AUTOEXTEND OFF,
‘/u02/gv25.dbf’ SIZE 500M AUTOEXTEND OFF
NOLOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
c. memberikan hak ke tablespace baru
SQL> alter USER PRODGV DEFAULT TABLESPACE gv;
SQL> GRANT UNLIMITED TABLESPACE TO GV;
d. memberikan hak akses read & write untuk directory dumpfile
SQL> GRANT READ, WRITE ON DIRECTORY dumpfile TO prodgv;
e. melakukan expdmp terlebih dulu sebelum drop tabel skema PRODGV
[oracle@ubs backup]$ expdp prodgv/password schemas=prodgv directory=dumpfile parallel=4 dumpfile=prodgv_%U.dmp logfile=prodgvP.log
SQL> DROP TABLE PRODGV.AGUSXGVLPP31 CASCADE CONSTRAINTS;
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
f. melakukan impdmp
[oracle@ubs backup]$ impdp prodgv/password remap_tablespace=users:gv directory=dumpfile parallel=4 dumpfile=prodgv_%U.dmp logfile=prodgvP2.log
Import: Release 10.2.0.1.0 – Production on Monday, 08 October, 2007 8:41:36
Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
Master table “PRODGV”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded
Starting “PRODGV”.”SYS_IMPORT_FULL_01″: prodgv/******** remap_tablespace=users:gv directory=dumpfile parallel=4 dumpfile=prodgv_%U.dmp logfile=prodgvP2.log
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported “PRODGV”.”GV005B” 248.0 MB 2419730 rows
. . imported “PRODGV”.”GV015A” 240.4 MB 1630369 rows
. . imported “PRODGV”.”GV005BXX” 174.6 MB 1708818 rows
. . imported “PRODGV”.”GV010B” 168.9 MB 945345 rows
. . imported “PRODGV”.”BACKUPD_GVSTBHN_200607″ 136.4 MB 1503043 rows
. . imported “PRODGV”.”GVBOMRC” 146.9 MB 817502 rows
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
