Devilzc0de Forum Follow @devilzc0de
  • Home
  • Hacking
  • Networking
  • Programming
  • O.S
  • Server
  • Tweets
  • Search
  • Member List
  • Calendar
Current time: 05-19-2013, 07:22 AM Hello There, Guest! (Login — Register)
Devilzc0de Forum › Information Technology › Database › Oracle
Cara backup database oracle

Home General Computer Multimedia Business Lounge

Post Reply 
Tweet
Threaded Mode | Linear Mode
Cara backup database oracle
04-26-2012, 02:47 PM
Post: #1
ngalamcity Offline
./Devilz 1st Cadet
Posts: 25
Joined: Mar 2012
Reputation: 4
Cara backup database oracle
gan gmn cara backup n import db oracle lewat SQL developer or sqlplus.. suramsuram

kemaren ad di menu SQL developernya .. tp quk d SQL developer q g ad ..

tolong gan.. prustasisuram belajarbelajarstresscuteboy
Visit this user's website Find all posts by this user
Quote this message in a reply
04-30-2012, 01:30 PM (This post was last modified: 04-30-2012 01:31 PM by ngalamcity.)
Post: #2
ngalamcity Offline
./Devilz 1st Cadet
Posts: 25
Joined: Mar 2012
Reputation: 4
RE: Cara backup database oracle
gue udah nemu gan..

nh


$exp username/password@localhost/sidnya file=c:\backup.dmp full=y log=c:\log_backup.log


trus enter..

klo versi d bawah 11 g pke "exp"

hehe hmm wawa bangga dugem

moga bermanfaat .. senengpinter
Visit this user's website Find all posts by this user
Quote this message in a reply
 Reputed by :  ohara_inamiji(+1)
05-21-2012, 12:48 AM
Post: #3
dion_ableh Offline
./Devilz 1st Cadet
Posts: 17
Joined: May 2012
Reputation: 1
RE: Cara backup database oracle
Itu backup full sampe ke Log File nya juga ya bro?
Kalo gw seringnya pake Command Prompt lalu ketik exp (untuk export dump file) atau imp (untuk import dump file).

Just saran :
Kadang - kadang yang harus hati2 didalam melakukan backup adalah terkait dengan tablespace nya. Sehingga pada waktu dilakukan import (restore) DB tidak terjadi kegagalan.

Mohon advicenya dari temen2 semua.
Find all posts by this user
Quote this message in a reply
 Reputed by :  ohara_inamiji(+1)
05-21-2012, 08:09 AM (This post was last modified: 05-21-2012 08:10 AM by ngalamcity.)
Post: #4
ngalamcity Offline
./Devilz 1st Cadet
Posts: 25
Joined: Mar 2012
Reputation: 4
RE: Cara backup database oracle
(05-21-2012 12:48 AM)dion_ableh Wrote:  Itu backup full sampe ke Log File nya juga ya bro?
Kalo gw seringnya pake Command Prompt lalu ketik exp (untuk export dump file) atau imp (untuk import dump file).

Just saran :
Kadang - kadang yang harus hati2 didalam melakukan backup adalah terkait dengan tablespace nya. Sehingga pada waktu dilakukan import (restore) DB tidak terjadi kegagalan.

Mohon advicenya dari temen2 semua.

q jg pke cmd quk.. q pke oracle 11.
kalo perintah oracle 11 ke atas udah pke $exp n $imp.
kalo log itu cuman laporan dr aktivitas export or import. contoh tabel ap aj yg di import or export.

q kemaren udah coba n udah berhasil tanpa eror untuk export n importnya ketawa banggadugemhore
Visit this user's website Find all posts by this user
Quote this message in a reply
05-21-2012, 08:24 AM
Post: #5
Baplak Offline
./Devilz Commander
Posts: 280
Joined: Dec 2010
Reputation: 0
RE: Cara backup database oracle
(05-21-2012 08:09 AM)ngalamcity Wrote:  
(05-21-2012 12:48 AM)dion_ableh Wrote:  Itu backup full sampe ke Log File nya juga ya bro?
Kalo gw seringnya pake Command Prompt lalu ketik exp (untuk export dump file) atau imp (untuk import dump file).

Just saran :
Kadang - kadang yang harus hati2 didalam melakukan backup adalah terkait dengan tablespace nya. Sehingga pada waktu dilakukan import (restore) DB tidak terjadi kegagalan.

Mohon advicenya dari temen2 semua.

q jg pke cmd quk.. q pke oracle 11.
kalo perintah oracle 11 ke atas udah pke $exp n $imp.
kalo log itu cuman laporan dr aktivitas export or import. contoh tabel ap aj yg di import or export.

q kemaren udah coba n udah berhasil tanpa eror untuk export n importnya ketawa banggadugemhore
ada yang punya link download oracle gk
Visit this user's website Find all posts by this user
Quote this message in a reply
05-21-2012, 03:45 PM (This post was last modified: 05-21-2012 03:48 PM by ngalamcity.)
Post: #6
ngalamcity Offline
./Devilz 1st Cadet
Posts: 25
Joined: Mar 2012
Reputation: 4
RE: Cara backup database oracle
(05-21-2012 08:24 AM)Baplak Wrote:  ada yang punya link download oracle gk

http://www.oracle.com/technetwork/indexe...index.html
Visit this user's website Find all posts by this user
Quote this message in a reply
« Next Oldest | Next Newest »
Post Reply 


Topic Tools
Topic Link :
BBCode :
HTML Code :
View a Printable Version Send Thread to a Friend Subscribe to this thread
Submit Google Submit Face book Submit to Digg Submit to Reddit Submit to Furl Submit to Del.icio.us Submit to Jeqq

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  ORACLE ( session 6 ) Belatung Kubur 5 135 12-15-2012 07:50 PM
Last Post: Alldy Newbie
Wink ORACLE ( session I ) Belatung Kubur 7 217 12-15-2012 07:35 PM
Last Post: hazel
  ORACLE ( session 4 ) Belatung Kubur 8 171 12-15-2012 04:13 PM
Last Post: kidofdream
  ORACLE ( session 5 ) Belatung Kubur 5 142 12-15-2012 11:25 AM
Last Post: Belatung Kubur
  ORACLE ( session 3 ) Belatung Kubur 1 98 12-15-2012 08:06 AM
Last Post: genta
  oracle XE ( session 2 ) Belatung Kubur 2 127 12-15-2012 03:09 AM
Last Post: Belatung Kubur
  [Tutor] membuat user + table di oracle genta 4 210 11-28-2012 01:02 PM
Last Post: genta
Wink HOW TO FIX ora : 12514 on oracle 10g Belatung Kubur 6 153 11-26-2012 04:21 PM
Last Post: jibril
  [Tutor] membuat aplikasi database oracle genta 11 435 11-19-2012 04:39 PM
Last Post: chiboga
  [Tutor] import dump file oracle beda versi Belatung Kubur 8 530 11-09-2012 11:00 AM
Last Post: iatngicu12

Users Browsing
1 Guest(s)

  • Contact Us
  • devilzc0de
  • Return to Top
  • Mobile Version
  • RSS Syndication
  • Help
Current time: 05-19-2013, 07:22 AM Powered By MyBB, © 2002-2013 MyBB Group. Theme created by Justin S. | Mixed By Chaer.Newbie | Fixed By Aditya

USING THIS SITE INDICATES THAT YOU HAVE READ AND ACCEPT OUR TERMS. IF YOU DO NOT ACCEPT THESE TERMS, YOU ARE NOT AUTHORIZED TO USE THIS SITE