Incremental or cumulative Export backup Oracle
Posted on 2011-09-04
Which backup type I should use (incremental or complete or cumulative) for the following case?
For instance I have oracle database with 10 tables no changes will happened to this tables except only one table data only will be grown in daily basis.
What shall I select incremental or cumulative if I want to export only the data changed?
With example please?However I did the following script to make full export once daily
exp \"/@test1 as sysdba\" FILE=e:\jtest\test1.dmp LOG=e:\jtest\test1INCR.log FULL=Y ROWS=Y COMPRESS=Y STATISTICS=NONE DIRECT=Y RECORDLENGTH=65535 INCTYPE=COMPLETE
Now I need to know how to perform either cumulative or incremental backup. Please with example?