Which three types of backups can be performed for a database running in NOARCHIVELOG mode?
Which three types of backups can be performed for a database running in NOARCHIVELOG mode?
For a database running in NOARCHIVELOG mode, backups can be performed under certain conditions. A consistent whole database backup can be done when the database is shut down cleanly, ensuring that all changes are written to disk, making option A correct. It's possible to back up noncritical tablespaces without shutting down the instance, as these are not critical to the core operation of the database, making option B correct. Backup of only those blocks that have changed since the last backup while the database is mounted can also be performed, which is option D. Option C is incorrect because in NOARCHIVELOG mode, the database needs to be shut down, and option E is incorrect because only the used blocks in critical tablespaces cannot be backed up while the database is open.
The answer is "ABD"
ABD,too
ABD is correct. Tablespace in offline status can be backup with rman when database is running in noarchivelog mode.
Answer AD
I think it's ACD. C because the "instance" does not need to be shutdown.
Only A and D are correct
I think answer A only; D is not correct because NOARCHIVELOG databases can only be backed up if shutdown.
D is OK while database is mounted