130. You executed the following command in Recovery Manager (RMAN) against your Oracle 10g
database:
RMAN> REPORT NEED BACKUP days 3;
What would be the output of this command?
A.a list of files that require a backup within three days
B.a list of files that have not been backed up for three days
C.a list of files that RMAN recommends be backed up only once in every three days, based on low
volatility
D.a list of files for which a backup has already been performed and may need a backup after three days
Answer: B
4.8.2 Reporting on Files Needing a Backup Under a Retention Policy
Use the REPORT
NEED
BACKUP
command to determine which database files need backup under a specific retention policy.
With no arguments, REPORT
NEED
BACKUP
reports which objects need backup under the currently configured retention policy. The output for a configured retention policy of REDUNDANCY 1 is similar to this example:
REPORT NEED BACKUP; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of files with less than 1 redundant backups File #bkps Name ---- ----- ----------------------------------------------------- 2 0 /oracle/oradata/trgt/undotbs01.dbf
Note:
If you disable the retention policy usingCONFIGURE
RETENTION
POLICY
TO
NONE
, then
REPORT
NEED
BACKUP
returns an error message, because without a retention policy, RMAN cannot determine which files need to be backed up.
4.8.2.1 Using RMAN REPORT NEED BACKUP with Different Retention Policies
You can specify different criteria for REPORT
NEED
BACKUP
, using one of the following forms of the command:
-
REPORT
NEED
BACKUP
RECOVERY
WINDOW
OF
n
DAYS
Displays objects requiring backup to satisfy a recovery window-based retention policy.
-
REPORT
NEED
BACKUP
REDUNDANCY
n
Displays objects requiring backup to satisfy a redundancy-based retention policy.
-
REPORT
NEED
BACKUP
DAYS
=
n
Displays files that require more than
n
days' worth of archived redo log files for recovery. -
REPORT
NEED
BACKUP
INCREMENTAL
n
Displays files that require application of more than
n
incremental backups for recovery.