Which statement is true about a whole consistent database backup on a database running in
ARCHIVELOG mode?
A.
The backup will consist of used data blocks only.
B.
The database must be shut down to accomplish the backup.
C.
The backup can be accomplished without shutting down the database.
D.
The backup will contain all database files that have never been backed up.
“Offline backup” (also called “cold” backup or consistent backup): Backup refers to the database is not open in the case of execution.
It is called a consistent backup because the data file header system change number (SCN) and the control file SCN match.
“Online Backup” (also called “hot” backups or consistent backup): refers to a backup in case the database is open execution.
It is non-consistent backups, because in the case of the database to ensure that the data files can not be opened with the control file synchronization.
shut down the DB to complete the backup
Archived data – consistent only if shutdown