Problem solve Get help with specific problems with your technologies, process and projects.

Was incremental backup differential or cumulative?

Is there a way to tell whether an incremental backup was done in a differential or cumulative manner in RMAN?

Hi, I've been wondering if there is a way to tell whether an incremental backup was done in a differential or cumulative manner? RMAN views seem to only indicate it as an incremental level 1 backup.

The RC_BACKUP_SET view can be used to determine this information. The BACKUP_TYPE column indicates if the backup...

is a full or incremental level 0 if this column contains 'D.' If the column contains 'I,' the backup set is for an incremental backup. The INCREMENTAL_LEVEL column shows the incremental level (obviously). If you are not seeing any rows in this view where BACKUP_TYPE='I' and INCREMENTAL_LEVEL='0' then look for BACKUP_TYPE='D.'

Chapter 3 of the RMAN documentation describes all of the Recovery Catalog views.

This was last published in July 2007

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.