Incremental ORACLE data backup/Export

Incremental ORACLE data backup/Export
The following describes how to use the Export/Import utility to back up and restore an Oracle database: Incremental unload/load. Incremental detaching is a common data backup method, which includes three sub-classes:
(1) "completely" incremental unload
Is to completely unload the entire Oracle database. For example:
$ Exp system/password inctype = complete full = y file = today. dmp
(2) incremental unloading
That is, the changes of all databases after the last discharge operation are detached from the Oracle database. For example:
$ Exp system/password inctype = incremental file = today. dmp
The size of the incremental unload file may be only 1% of the size of the file, depending on the total amount of "new information or updated information.
(3) "cumulative" incremental unloading
The cumulative discharge method is only used to unload the changed information in the database after the last "complete" discharge. The usage is as follows:

$ Exp system/password inctype = cumulative file = today. dmp
DBAs can schedule a backup schedule and use three different ways of Data offloading to perform database backup tasks reasonably and efficiently. For example, DBA makes the following arrangement:
Monday: completely detached (F1)
Tuesday: Incremental Export (I1)
Wednesday: Incremental release (I2)
Thursday: cumulative unload (C1)
Friday: Incremental release (I3)
Saturday: Incremental release (I4)
If the database is accidentally damaged on Sunday, DBAs can restore the database as follows:
· Use the create database Command to regenerate your database structure;
· Last incremental loading of I4: $ imp system/password inctype = system full = y file = I4
· Fully incremental F1: $ imp system/password inctype = restore full = y file = F1
· Incrementally load C1: $ imp system/password inctype = restore full = y file = C1
· Perform incremental loading for information that has not been loaded by cumulative or full load:
$ Imp system/password inctype = restore full = y file = I3
$ Imp system/password inctype = restore full = y file = I4

Source: website source code
Address: http://www.isstudy.com/oracle/3001.html