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.
"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
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
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.
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.
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.
mporislav
Highly Voted 3 years, 1 month agoflaviogcmelo
Highly Voted 2 years, 2 months agoantonica
Most Recent 3 months, 2 weeks agoguretto
6 months, 1 week ago_gio_
1 year agonobody347
2 years, 10 months agoDBA007
2 years, 4 months agorodriguesJC
2 years, 8 months agoNeil107
2 years, 11 months agoObserverPL
3 years, 1 month agoObserverPL
3 years, 1 month agoAldrid
3 years, 2 months agoAldrid
3 years, 1 month agoRogazan
3 years, 1 month agoAldrid
3 years, 2 months agoRinD
3 years, 2 months agoRinD
3 years, 2 months ago