Which two statements are true in this scenario?

You need to recover a database running In NOARCHIVELOG mode. Which two statements are
true in this scenario?

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

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

chucv

chucv

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

Reply