Conventional. Increments. Differential backup and the advantages and disadvantages of the difference (change)
Differential backup and incremental backup, the backup only the data changes. However, the former backup is "the cumulative (cumulative)" - and a file since the last full backup as long as after, and was updated, then the next to do a differential backup each time, this file will be backed up (of course, until the next until a full backup).
This means that the differential backup of the file, are since the last full backup, the files have been changed. If you want to recover the entire system, then you can recover a full backup first, and then recover the difference between the last backup can be. Incremental backups are up against in a backup (either backup): Backup on a backup, all changes in documents.
(Incremental backup process, there is marked only backup selected files and folders, it detreated both: the backup file after the tag, in other words, clear the disk property.)
Used with the incremental backup strategy, you make a regular basis as long as a normal full backup, and then back up from time to time can make the difference.
Therefore, differences in the size of the backup, as increasing over time (assuming the full backup, the files modified every day is different). To back up the space and speed, the difference between backup and incremental backup between full backups; but whether a file or recover the entire system, speed is usually more than a full backup, incremental backup quickly (due to the search / recovery disk number less).
Based on these characteristics, the difference is worth considering a backup program, incremental backup and differential backup technology in the high-end part of the network-attached storage devices such as IBM, HP, and free escape of some brands such as ancillary products, software has been built.
3, different types of combination of back-up sample applications
(1), full backup and differential backup
To weekly data back-up plan as an example, we can carry out a full backup on Monday, Tuesday to Friday in the differential backup. If the data is destroyed on Friday, then Monday, you only need to restore the full backup and differential backup Thursday. This strategy required to back up data more time, but to restore the data using less time.
(2), full backup or incremental backups and weekly data back-up as an example, full backup on Monday, Tuesday to Friday at incremental backup. If the data is destroyed on Friday, then you need to restore a normal backup on Monday and Tuesday to Friday from all the incremental backups. This strategy required to back up data more time, but to restore the data using less time.
Related Posts of Conventional. Increments. Differential backup and the advantages and disadvantages of the difference (change)
-
rman is said to have many advantages than conventional heat
rnrman than ordinary heat is said to have many advantages: rn1, common during the hot backup will produce a lot of redo, rman will not; rn2, ordinary hot backup will spare block is also a backup, rman will only backup used block. rn3, ordinary hot sp ...
-
Conventional path Export and direct path
Export provides two methods for exporting table data: Conventional path Export Direct path Export Conventional path Export uses the SQL statement to extract data from tables. Data is read from disk into a buffer cache, and rows are transferred to the ...
-
Dialysis SCN number (change)
SCN when the Oracle database, updated by the DBMS automatically increments the maintenance to accumulate a figure. When a transaction commit time, LGWR writes log buffer will redo log file, the transaction will also synchronize the SCN to the redo lo ...
-
RAC environment, the database backup (1)
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn rn rn This difference mainly reflected in the particularity of the RAC environment. rn According to Oracle's RAC environment, different, RMAN backup ...
-
Oracle face questions Highlights
Oracle face questions Highlights - Technical articles 1. Explain the cold backup and hot backup of the differences and advantages of each Answer: hot backup mode for the archiving database, the database is still in working condition when the backup. ...
-
rman incremental backups
Including two kinds of incremental backup level: 0,1. 0 incremental backup and full backup of the difference is: The backup has never strategies for incremental backups. 0 incremental backup as a backup parent incremental backup, An incremental backu ...
-
ORACLE SQL statement optimization of technical analysis [change]
Operator Optimization IN operator IN written out with the advantages of SQL is relatively easy to write, and clear and easy to understand, this is more suitable for modern software development style. However, the SQL performance with the IN is always ...
-
ORACLE Change Data Capture introduced two (former)
4: Change Sets Change Sets is to change the data in a logical group, a change sources can include one or more change sets. However, the following restrictions: 1) In the Distributed HotLog change source mode, all change sets must be in the same stagi ...
-
RAC environment, the database backup (2)
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn RMAN Backup and Recovery - RAC environment database backup (1): http://yangtingkun.itpub.net/post/468/285260 rn This description is based on the bare de ...
-
image copy and the difference between the backup set
1, at up to disk prior to storage, backup set can use the oracle's own compression algorithm of the binary data files and archive log compression, and image copy will not do. 2, backup set will not be included free block, if one has never been wr ...
Leave a Reply