You need to recover a database running In NOARCHIVELOG mode. Which two statements are
true in this scenario?
A.
You can perform complete recovery by using the command:
RESTORE DATABASE
FROM TAG“consistent_whole_backup”;
RECOVER DATABASE;
B.
You can perform incomplete recovery by using the command:
RESTORE DATABASE;
FROM TAG “consistent_whole_backup”;
RECOVER DATABASE NOREDO;
C.
Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.
D.
Media recovery is possible in most cases.
Explanation:
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmrecov.htm#CACGEAEE
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89841
B,C
Explanation for C answer:
Restoring a database running in NOARCHIVELOG mode is similar to restoring a database in ARCHIVELOG mode. The main differences are:
Only consistent backups can be used in restoring a database in NOARCHIVELOG mode.
Media recovery is not possible because no archived redo logs exist.
Explanation for B answer:
When you are recovering a NOARCHIVELOG database, specify the NOREDO option on the RECOVER command to indicate that RMAN does not attempt to apply archived redo logs. Otherwise, RMAN returns an error