Incremental[=By_Area or Complete] Noincremental Determines the extent of the backup operation to be performed. The four possible options are: o Noincremental If you do not specify any of the possible Incremental qualifier options, the default is the Noincremental qualifier. With the Noincremental qualifier, a full backup operation is performed on the database. o Incremental If you specify the Incremental qualifier, an incremental backup of all the storage areas that have changed since the last full and complete backup operation on the database is performed. o Incremental=By_Area If you specify the Incremental=By_Area qualifier, an incremental backup operation is performed. The Incremental=By_ Area qualifier backs up those database pages that have changed in each selected storage area since the last full backup operation was performed on the area. The last full backup operation performed on the area is the later of the following: - The last full and complete backup operation performed on the database - The last full by-area backup operation performed on the area With an incremental by-area backup operation, each storage area backed up might contain changes for a different time interval, which can make restoring multiple storage areas more complex. o Incremental=Complete If you specify the Incremental=Complete qualifier, an incremental backup operation on all of the storage areas that have changed since the last full and complete backup operation on the database is performed. Selecting the Incremental=Complete qualifier is the same as selecting the Incremental qualifier. Following a full database backup operation, each subsequent incremental backup operation replaces all previous incremental backup operations. The following two messages are meant to provide an aid for designing more effective backup strategies. They are printed as part of the per-area summary statistics, and they provide a guide to the incremental benefit of the incremental operation: o "Est. cost to backup relative to a full backup is x.yy" o "Est. cost to restore relative to a full restore is x.yy" These estimates are only approximate and reflect the disk input/output (I/O) cost for the backup or restore operations of that area. Tape I/O, CPU, and all other costs are ignored. The disk I/O costs take into account the number of I/O operations needed and the requirement for a disk head seek to perform the I/O. Each disk type has its own relative costs-transfer rate, latency, seek time-and the cost of a given sequence of I/Os is also affected by competition for the disk by other processes. Consequently, the estimates do not translate directly into "clock time." But they should nevertheless be useful for determining the point at which the incremental operation is becoming less productive. The relative costs can vary widely, and can be much higher than 1.00. The actual cost depends on the number and location of the pages backed up. An incremental restore operation must always follow a full restore operation, so the actual estimate of restoring the area is actually 1.00 higher than reported when that full restore operation is accounted for. The guideline that Oracle Corporation recommends is, "Perform full backup operations when the estimated cost of a restore operation approaches 2.00."