Untuk Pak Leonard,
Karena menggunakan comulative incremental, maka pada mgg III yg dibackup adalah
semuaperubahan dari level 0 (mgg I).
Berikut ini cuplikan artikelnya:
9. Incremental backups
A level N incremental backup backs up blocks that have changed since the
most recent incremental backup at level N or less.
9.1. Level 0 - the basis of the incremental backup strategy
RMAN> run {
2> allocate channel dev1 type disk;
3> backup
4> incremental level 0
5> filesperset 4
6> format '/oracle/backups/sunday_level0_%t'
7> (database);
8> release channel dev1;
9> }
Line#
4: Level 0 backup - backups of level > 0 can be applied to this
5: Specifies maximum files in the backupset
A list of the database backupsets will show the above backup. The 'type'
column is marked 'Incremental'; the 'LV' column shows '0'.
9.2. Example backup strategy using incremental backups
A typical incremental backup cycle would be as follows:
- Sun night - level 0 backup performed
- Mon night - level 2 backup performed
- Tue night - level 2 backup performed
- Wed night - level 2 backup performed
- Thu night - level 1 backup performed
- Fri night - level 2 backup performed
- Sat night - level 2 backup performed
If the database suffered a failure on Sat morning and this resulted in
a restore operation, RMAN could recover to the point of failure by
restoring the backups from Sunday, Thursday, and Friday. This is
because Thursdays level 1 backup contains all changes since Sunday, and
Friday's level 2 backup contains all changes since Thursday. Whether
the database could be completely recovered would depend on whether
archive logging is enabled.
10. Cumulative incremental backups
A cumulative incremental backup backs up all blocks that have changed since
the the most recent incremental backup at level N-1 or less (contrast with
non-cumulative incremental backups that backup blocks that have changed
since the the most recent incremental backup at level N or less). This
means that more work is done in performing the backup (duplication of
backup effort), but time may be saved when restoring (potentially fewer
backupsets to restore).
RMAN> run {
2> allocate channel dev01 type disk;
3> backup incremental level 1 cumulative database;
4> release channel dev01;
5> }
Semoga membantu,
Rgds
Mufiq MAHYA
--- Leonard Sukendro <[EMAIL PROTECTED]> wrote:
>
> OS: redhat AS3, Oracle 9.2.0.5
>
> dear all,
>
> bapak2, mo numpang tanya nech soal rman nech, sorry
> klo pertanyaannya rada mendasar n dh pernah dbahas...
> misalnya saya punya jadwal backup:
> mgg I: level 0
> mgg II: level 1 C
> mgg III: level 1 C
> pas backup mgg III, yg di backup itu perubahan dr awal
> level 0 ato dr level 1 C yg terakhir ya?
> saya pernah coba, dia mundur lagi ke lvl0, tp koq saya
> pernah dgr, cmn mundur ke lvl 1 C ya?
> mohon penjelasannya, sapa tau ada yg pernah coba juga
>
> thx bgt sebelumnya,
> [L]
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indo-oracle/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
