Which three are true about a whole database backup? (Choose three.)
Which three are true about a whole database backup? (Choose three.)
A whole database backup can consist of either backup sets or image copies. It can also be consistent if done when the database is shut down, or inconsistent if performed while the database is open and in ARCHIVELOG mode, leading to the inclusion of current states that may not be fully synchronized. The statement that it always includes all data files, the current control file, the server parameter file, and archived redo logs is incorrect because archived redo logs are not always included, especially in NOARCHIVELOG mode. Therefore, the most accurate options are that it can consist of either backup sets or image copies, it can be consistent, and it can be inconsistent.
A, C, E Regarding B : If the database is in noarchivelog mode valid backups are: 1. whole consistent backup 2. incremental consistent backup
Alternative F is wrong due to the terms "always" and "archived redo logs". The database in non-archive mode does not need the redo logs backup due to the need for the database to be in mount mode, consequently the database is consistent. https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/performing-backup-and-recovery.html#GUID-E6AB87FC-DE6E-433C-AB61-F2055B6CC547 While backing up a database that is closed, you need not back up the archived log files because the database is in a consistent state at the time of backup. Therefore, no media recovery is required if you restore the database from this backup.
F- wrong. redo log missing Perform a Whole Database Backup You can use RMAN to perform a whole backup of your database. A whole backup includes the complete contents of all data files of the database, plus the control file, archived redo log files, and server parameter file.
what is wrong with F? Question asks abot whole backup.
Because "the server parameter file" is not a database file, only a "configuration file".
"A whole backup includes the complete contents of all data files of the database, plus the control file, archived redo log files, and server parameter file. You can perform a complete recovery with the files from a whole backup." https://docs.oracle.com/en/database/oracle/oracle-database/tutorial-perf-back/index.html?opt-release-19c The problem could be with option F is, the word "Always" and "archive redo logs". This can be true only when we have taken whole database backup using the command "BACKUP DATABASE PLUS ARCHIVELOG;" So if you check the above-mentioned link, the Whole Database Backup is considered when using the command "BACKUP DATABASE PLUS ARCHIVELOG;" therefore Answer should be A,C,F
I say ACE.
I think ACE
F: a whole backup can be closed (datafiles, controlfile) or open (datafile,s controlfile, archived redologs).. so "always" is wrong
I think ACE because database may not generate archived redo logs
Agree with Aldrid - BCE. B because in case case of NOARCHIVELOG you have to CLOSE the DB (for RMAN open MOUNT) and then you have to take backup of WHOLE database.
... and again Aldrid was right :-) To reduce backup sizes for NOARCHIVELOG databases. Instead of making a whole database backup every time, you can make incremental backups. so ACE
BCE https://docs.oracle.com/cd/B10501_01/server.920/a96519/backup.htm#1004644
You can backup offline tablespace in noarchivemode... but question about database backup.. not tablespace... so you can do only whole DB backup in noarchive mode.
I don't understand, your argument seem conflict. Question is about whole database backup, not limited to only database backup.
If it can be inconsistent (option E), then it has to be done with the Database open and that is only possible in ARCHIVELOG mode, therefore option B is False. correct answers ACE.
Change to ACE https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm It is possible to make Incremental Backup In NOARCHIVELOG