Which of the following best describes a full backup?

Which of the following best describes a full backup?

Which of the following best describes a full backup?

A.
All datafiles of a database

B.
All datafiles, archive logs, and control files

C.
All datafiles and control files

D.
All the used blocks in a datafile

Explanation:
From the training book:
“Full backup: Makes a copy of each data block that contains data and that is within the files
being backed up.”
“A full backup contains all used data file blocks.”
“A full backup is different from a whole database backup.”
Conclusion – it means that not all data files are backed up when you do full backup.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Eamon

Eamon

I don’t trust the explanation given here. A “training book” is not necessarily an official source. I’d put it on the same level as “my granny says … ”

@to_whom_ever_posted_this, please provide an (official) source.

Jake from SF

Jake from SF

D is correct:

https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm

4.4.2 Making Incremental Backups: BACKUP INCREMENTAL
After starting RMAN, run the BACKUP INCREMENTAL command at the RMAN prompt. This example makes a level 0 incremental backup of the database:

BACKUP INCREMENTAL LEVEL 0 DATABASE;

This example makes a differential level 1 backup of the SYSTEM tablespace and datafile tools01.dbf. It will only back up those data blocks changed since the most recent level 1 or level 0 backup:

Using this logic, that means a full backup will capture all used data blocks in a DB.