Home General Computer Multimedia Business Lounge
|
Cara backup database oracle
|
|
04-26-2012, 02:47 PM
 Post: #1 |
|||
|
|||
|
Cara backup database oracle
gan gmn cara backup n import db oracle lewat SQL developer or sqlplus..
 kemaren ad di menu SQL developernya .. tp quk d SQL developer q g ad .. tolong gan..    
|
|||
|
|
04-30-2012, 01:30 PM
(This post was last modified: 04-30-2012 01:31 PM by ngalamcity.)
Post: #2 |
|||
|
|||
|
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     moga bermanfaat ..  
|
|||
|
|
|||
 Reputed by : ohara_inamiji(+1) |
|
05-21-2012, 12:48 AM
Post: #3 |
|||
|
|||
|
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. |
|||
|
|
|||
| 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 |
|||
|
|||
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? 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  
|
|||
|
|
|
05-21-2012, 08:24 AM
Post: #5 |
|||
|
|||
RE: Cara backup database oracle
(05-21-2012 08:09 AM)ngalamcity Wrote:ada yang punya link download oracle gk(05-21-2012 12:48 AM)dion_ableh Wrote: Itu backup full sampe ke Log File nya juga ya bro? |
|||
|
|
|
05-21-2012, 03:45 PM
(This post was last modified: 05-21-2012 03:48 PM by ngalamcity.)
Post: #6 |
|||
|
|||
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 |
|||
|
|
|
« Next Oldest | Next Newest »
|
| Topic Tools | ||||||
| ||||||
       |
| 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 |
|
 |
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 |
|
|
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) |