You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters: Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)
A.
The backup can be used as an incremental level 0 backup.
B.
The database instance must be shut down to take the backup.
C.
The database must be in MOUNT state to take the backup.
D.
The backup consists of blocks that have been formatted.
E.
The system Change Number (SCN) is the same for all the data files in the backup.
I think the difference for this question, compared to an earlier question, is that this is a backup using RMAN as opposed to a user-managed backup.
The database must be closed to get a consistent copy of the files so the database is technically shutdown first and then mounted. We can then take a cold backup using RMAN, which would make the backup consistent.
I would go with C,E in this case.
To eliminate confusion, we can first shutdown the database using normal, immediate, or transactional. We can then mount the database separately after the graceful shutdown.
Even though the database is in mount mode, it is still technically closed and not open. I think some people are confusing that fact.
I'm confused by this question.
"A backup is either consistent or inconsistent. To make a consistent backup, your database must have been shut down cleanly and remain closed for the duration of the backup."
"If the database is in ARCHIVELOG mode, then you can make inconsistent backups that are recoverable using archived redo log files. Open database backups are inconsistent because the online redo log files contain changes not yet applied to the data files."
So.. how can you make a consistent backup of a database that's running in Archivelog Mode like the question is asking?
https://docs.oracle.com/database/121/ADMQS/GUID-74B864F7-2413-4142-BDB0-7B98BE960462.htm#ADMQS09111
By keeping database in MOUNT mode to take consistent backup using RMAN. RMAN cannot take backup unless db is mounted (it reads the control file). Also we can take consistent backup if database is shutdown, but that's not via RMAN but it's user managed, ie, cold backup
BCE are correct...
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRADV002
"Consistent Backups
You can use the BACKUP command to make consistent and inconsistent backups of the database. A consistent backup occurs when the database is in a consistent state. A database is in a consistent state after being shut down with the SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands. A consistent shutdown guarantees that all redo has been applied to the datafiles. If you mount the database and make a backup at this point, then you can restore the database backup later and open it without performing media recovery."
Correct answer: BE
Why B is correct??
Because all the data files are in read/write mode, so yuo need to first it closed cleanly by Shutdown then mount state.
There written must be in MOUNT state, but you can make consistent backup which called "cold backup" ( shutdown and .. ), that means there are other ways for consistent backup, not only mount.
BE is correct because...
consistent backup
A whole database backup that you can open with the RESETLOGS option without performing media recovery. In other words, you do not need to apply redo to datafiles in this backup for it to be consistent. All datafiles in a consistent backup must:
Have the same checkpoint system change number (SCN) in their headers, unless they are datafiles in tablespaces that are read-only or offline normal (in which case they will have a clean SCN that is earlier than the checkpoint SCN)
Contain no changes past the checkpoint SCN, that is, are not fuzzy
Match the datafile checkpoint information stored in the control file
You can only take consistent backups after you have made a clean shutdown of the database. The database must not be opened until the backup has completed.
Why not BC?
To perform a whole database backup when the database is closed -> (For consistent reasons)
https://docs.oracle.com/database/121/ADMQS/GUID-E6AB87FC-DE6E-433C-AB61-F2055B6CC547.htm
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
A consistent backup of a database or part of a database is a backup in which all read/write datafiles and control files have been checkpointed with respect to the same system change number (SCN), and it can be processed after NORMAL SHUTODOWN
There written must be in MOUNT state, but you can make consistent backup which called "cold backup" ( shutdown and take cold backup without MOUNT state and RMAN ), that means there are other ways for consistent backup, not only mount.
upvoted 1 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.
rdnkrkmz
Highly Voted 5 years, 10 months agosherifelia
Highly Voted 5 years agodfabac
Most Recent 2 years, 6 months agoRay520
2 years, 7 months agoRay_gk
2 years, 7 months agoRay_gk
2 years, 7 months agomrSam
2 years, 11 months agoRay520
2 years, 4 months agoClozoerie
3 years, 4 months agoModasser
3 years, 7 months agoexampro46
3 years, 6 months agoJohn1956
4 years, 2 months agodancymonkey
4 years, 3 months agodancymonkey
4 years, 3 months agodancymonkey
4 years, 4 months agoNorthKorean
4 years, 8 months agoNorthKorean
4 years, 8 months agoexampro46
3 years, 6 months ago