Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What is the differene between:

BACKUP INCREMENTAL LEVEL 0 DATABASE; 

and

BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

? I read some manuals, but I don't get the idea beacuse of my poor english.

share|improve this question

2 Answers 2

up vote 2 down vote accepted

An INCREMENTAL LEVEL 0 is a full backup of all used blocks in the database.
An INCREMENTAL LEVEL 1 CUMULATIVE is a backup of only the blocks that have changed since the last incremental backup.

... the definitions above paraphrased from the Glossary of Oracle Database Backup and Recovery User's Guide 11g Release 2.

share|improve this answer

Incremental level 1 cummulative is a backup only the blocks that have changed since the last incremental 0 backup

@George3 you should have mentioned incremental level 0 not any incremental.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.