What is Partial Backup?

What is Partial Backup?

- A partial backup is similar to a full database backup, but a it does not contain all the filegroups.

- It contains all the data in the primary filegroup, every read/write filegroup, and any optionally-specified read-only files.

- A partial backup is any operating system backup short of a full backup, taken while the database is open or shut down.

The following are all examples of partial database backups:

a. Backup of all datafiles for an individual tablespace.
b. Backup of a single datafile.
c. Backup of a control file.

- They are only useful for a database operating in ARCHIVELOG mode, because an archived redo log is present, the datafiles restored from a partial backup can be made consistent with the rest of the database during recovery procedures.
What is Mirrored on-line Redo Log?
Due to Mirrored online redo logs and disk array mirroring, the occurrence of redo log corruptions has dropped to practically zero......
How do you increase the performance of %LIKE operator?
How do you increase the performance of %LIKE operator? - The % placed after he search word can enable the use of index if one is specified in the index column.....
What is a standby database? Physical vs logical standby databases
What is a standby database? Physical vs logical standby databases - A standby database is a backup database that can be promoted should the primary fail...
Post your comment