Incremental exports are possible. The first thing you need to do is to perform a baseline backup. This is a full...
backup of your database. Use the FULL=Y parameter in the export utility to obtain a full backup.
There are three types of exports to be concerned with here. They are the FULL export, the CUMULATIVE export, and the INCREMENTAL export. The CUMULATIVE export will export the changes since the last CUMULATIVE or FULL export. THe INCREMENTAL export will export the changes since the last INCREMENTAL, CUMULATIVE, or FULL export.
To specify a CUMULATIVE export, use the INCTYPE=CUMULATIVE parameter instead of FULL=Y. To specify an INCREMENTAL export, use the INCTYPE=INCREMENTAL parameter instead of FULL=Y.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.