New Features for Administrators - Question 059

Consider this RMAN command:

RMAN> CONFIGURE RETENTION POLICY
2> TO RECOVERY WINDOW OF 7 DAYS;

What does the command accomplish?

A. Establishes the fixed number of backups that must be kept for media recovery

B. Establishes the fixed number of backups required to perform media recovery within 7 days

C. Sets the fixed number of days that backups are held for media recovery

D. Ensures that sufficient backups and logs will be kept so that a point-in-time recovery to any time in the last 7 days is possible

Answer: C

Explanation:

This command sets the fixed number of days that backups are held for media recovery. You can use the CONFIGURE command to specify a recovery window policy that establishes the number of days the backups are to be retained.

Incorrect Answers

A: You can use the CONFIGURE RETENTION POLICY TO REDUNANCY number command to specify a redundancy policy that establishes the number of backups files and control files you want to retain.

B: It does not establish the fixed number of backups required to perform media recovery within 7 days. This command sets the fixed number of days that backups are held for media recovery.

D: This command does not ensure that sufficient backups and logs will be kept so that a point-in-time recovery to any time in the last 7 days is possible.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 183-189

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 79-86

Chapter 3: New Oracle9i Availability and Recoverability Features