Setahu saya backup ada beberapa cara :
1. Hot Backup
2. Cold Backup
1. Hot backup digunakan pada saat Database dalam keadaan OPEN.
Pada hot backup ada beberapa methode :
A. Dengan cara Full Database Backup menggunakan DMP file (c:\> Exp
system/manager file=DmpFile.dmp full=y)
B. Dengan cara copy datafile pada module archive log hidup (Alter
tablespace XX Begin backup, kemudian kopy data file dan akhiri
dengan alter tablespace XX End Backup.
2. Cold Backup, yakni backup pada posisi database Close.
Cara yang paling aman menurut saya adalah dengan cold backup pada posisi
database Close dan menerapkan Archive Log. Hal ini dapat menyelematkan data
anda sampai dengan last menit. dengan syarat anda mengkopikan archive log
file setiap hari ke media lain, dengan tujuan agar bila terjadi db crash anda
dapat merecover dengan archive file tadi
----- Original Message -----
From: oraclefen
To: [email protected]
Sent: 07 February 2006 21:32
Subject: [indo-oracle] Whole Backup or Full Backup
Dear All,
Teman teman yang terhormat, aku masih bingung nih...
apa ke untungan dan kelebihan bila melakukan backup database memakai
1. Whole Backup
2. Full Backup
dan apa juga kekurangannya...
Mana yang lebih baik diantara whole backup and full backup
Terimakasih banyak sebelumnya
Regards
Ifen
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS Membership database software Database mortgage software Pda
database software
Database management software Oracle database administration Oracle
database management
------------------------------------------------------------------------------
YAHOO! GROUPS LINKS
a.. Visit your group "indo-oracle" on the web.
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------------------------------------------------------------
------------------------------------------------------------------------------
===================================================
This Mail Scanned By Messaging Security Suite
================= Provided by IT Hardware =================
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
