Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this scenario? (Choose two.)
A.
The user-managed backup consists of only formatted data blocks.
B.
The database must be shut down to take a user-managed backup.
C.
The RMAN backup contains only data files.
D.
The RMAN backup can be performed while the database is open.
E.
The database must be in MOUNT state to take RMAN backup.
This one is tough... to get a consistent backup, the database cannot be open... However this is running in Archivelog mode so you can do an RMAN backup while db is open, however that does not mean it is a consistent whole db backup.
This should be BE.
Database must be either in shutdown mode or MOUNT (In case archivelog is enabled) to take consistent backups. We can take backups when archivelog is enabled while database is open, but that will not be consistent backup. Hence D is wrong.
I would actually say that A and B are correct. I see there are many differing opinions. I will give my input on why I believe A and B to be true using this source https://docs.oracle.com/database/121/BRADV/osbackup.htm#BRADV016
The Oracle doc describes user-managed backups as "a strategy that does not depend on using Recovery Manager (RMAN)."
B: the oracle doc states "You can make a consistent whole database backup of all files in a database after the database has been shut down with the NORMAL, IMMEDIATE, or TRANSACTIONAL options." In fact, shutting down the database is the first example provided in a CONSISTENT whole database backup in the doc.
C: You can take a whole database backup using RMAN though by definition this also includes AT LEAST one control file. Also, per the Oracle doc "whole database backup is consistent because all files are checkpointed to the same SCN. You can restore the consistent database backup without further recovery." If we take a backup using RMAN with the DB in archivelog mode, upon restoration of the DB using a backup up, the database will not be consistent without further recovery using the redo and archived redo logs.
D: RMAN itself must be at least mounted to perform backups since backup info is stored in the control file
For D, forgot to add the RMAN backup can be performed with the DB open though as mentioned it will not be consistent since the DB is in archivelog mode
E: while the DB truly MUST be in mount state for RMAN to take a backup the backup it is possible for the backup to not be consistent as the controlfile could be modified in some way. And again, the oracle doc stipulates the DB must be shutdown for a consistent whole database backup.
The only other option is A though ONLY formatted data blocks may make others uncertain. I wonder if the answer choice for this question was given incorrectly. I have seen that a few times using these dumps.
Coming back to this, I think that B and E are correct. I think my rationale for E being wrong was me thinking too much about the question. With the DB in mount mode, only the sys user would be able to make changes that would affect the control file so other users would not be able to modify it in any way. So B and E would be my guess now.
sorry : If you focus on the question it is A, B
you can make backups with RMAN and the database open, but not in this case.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-database-backups.html#GUID-65C5E03A-E906-47EB-92AF-6DC273DBD0A8
It's B, D because in the question say : You want to take a consistent whole database backup.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-database-backups.html#GUID-65C5E03A-E906-47EB-92AF-6DC273DBD0A8
Hi All, whole database backup means all the files of database i.e parameter,network files and crd files...This is achievable only with user managed backup i.e copy and paste..
B -> Consistent whole database backup -> need shutdown
E -> Restore REDO for additional
https://docs.oracle.com/database/121/BRADV/osbackup.htm#BRADV199
BD.
You can do a backup when de database is open: https://docs.oracle.com/database/121/ADMQS/GUID-E6AB87FC-DE6E-433C-AB61-F2055B6CC547.htm
And you need the database shutdown to do a backup "user-managed": https://docs.oracle.com/cd/E11882_01/backup.112/e10642/osbackup.htm#BRADV199
AB is correct. To take user managed back up the DB should be shutdown first. http://pages.di.unipi.it/ghelli/didattica/bdldoc/B19306_01/backup.102/b14191/osbackup002.htm
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Havok
Highly Voted 4 years, 10 months agordnkrkmz
Highly Voted 5 years, 10 months agoRay520
Most Recent 2 years, 4 months agodfabac
2 years, 6 months agodfabac
2 years, 6 months agoRay_gk
2 years, 8 months agoRay_gk
2 years, 8 months agoRay_gk
2 years, 8 months agoRay_gk
2 years, 8 months agoRay_gk
2 years, 7 months agoOracle2020
3 years, 4 months agoOracle2020
3 years, 4 months agocharan94
3 years, 7 months agodancymonkey
4 years, 4 months agoPhoenix22
4 years, 8 months agosoniat
3 years, 9 months agohggz
4 years, 8 months agohggz
4 years, 3 months agoNorwayOracle
2 years, 9 months agobkk
4 years, 9 months ago