In which two cases would you perform only consistent backup? (Choose two.)
A.
You are working on a database where downtime is not tolerated.
B.
You are working on a database where downtime can be tolerated.
C.
You are working on a database that operates in ARCHIVELOG mode.
D.
You are working on a database that operates in NOARCHIVELOG mode.
E.
You are working on a database where all the tablespaces are locally managed.
F.
You are working on a database where control files and redo log files are multiplexed.
G.
You are working on a database where control files and redo log files are not multiplexed.
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.
A consistent backup is a backup of one or more database files that you make after the database has been closed with a clean SHUTDOWN command. Unlike an inconsistent backup, a consistent, whole database backup does not require recovery after it is restored.
A consistent whole database backup is the only valid backup option for databases operating in NOARCHIVELOG mode, because otherwise redo will need to be applied to create consistency. In NOARCHIVELOG mode, Oracle does not archive the redo logs, and so the required redo logs may not exist on disk.