1Z0-025 Free Dumps Study Materials
Question 3: Which two statements regarding the use of Recovery manager with a database in
NOARCHIVELOG mode are true? (Choose two)
A. The target database must be in MOUNT mode for restriction of data files.
B. A DBA can only restore using RMAN if the backups were taken or registered with recovery
manager.
C. Recovery manager cannot be used with a database running in NOARCHIVELOG mode.
D. For full recovery of a database not in NOARCHIVELOG mode using recovery manager, a current
recovery catalog in mandatory.
E. To restore to a previous point in time using recovery manager, the command PARTIAL RECOVER
must be included in the RMAN script.
Correct Answer: A,B
Explanation:
If a database in ARCHIVELOG mode to use recovery manager the target database must
be MOUNTED for restriction of data files. Also DBA can only use backups were taken
or registered with recovery manger for restore purposes.
Incorrect Answers:
C: Recovery manager can be also used with a database running in NOARCHIVELOG mode.
D: For full recovery of a database not in NOARCHIVELOG mode recovery catalog is not mandatory.
E: There is no PARTIAL RECOVER command used in RMAN. Oracle 8, DBA Certification Exam Guide,
Jason S Couchman, p. 683-686 Chapter 14: Database Failure and Recovery