Database is used to store the data, which is the most crucial part of a business. It is important to keep the data safe; and therefore, backup provides a way to safeguard data against any loss.
There are mainly three types of backup, which are given as follows:
i. Full backup or normal backup — Refers to the backup of all the datafiles, control files, and SPFILEs.
ii. Incremental backup — Refers to the backup of files and folders that have been modified or created after the previous backup. After this backup, the attribute is again reset.
iii. Differential backup — Refers to the backup of files and folders that have been modified or created after a previous full or incremental backup. The difference here is that the attributes are not reset. Therefore, every time it backup those files whose attributes have not been reset or changed.
There are mainly three types of backup, which are given as follows:
i. Full backup or normal backup — Refers to the backup of all the datafiles, control files, and SPFILEs.
ii. Incremental backup — Refers to the backup of files and folders that have been modified or created after the previous backup. After this backup, the attribute is again reset.
iii. Differential backup — Refers to the backup of files and folders that have been modified or created after a previous full or incremental backup. The difference here is that the attributes are not reset. Therefore, every time it backup those files whose attributes have not been reset or changed.