Databases Reference
In-Depth Information
Solution
Use the
report need backup
form of the
report
command to find out which backups you need to make to conform
to the retention policy you put in place. Here's how you execute the
report need backup
command to see which
database files are in need of backup:
RMAN> 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 /u01/app/oracle/product/12.1.0/db_1/dbs/dbx1catdb.dbf
3 0 /u01/app/oracle/product/12.1.0/db_1/dbs/dbu1catdb.dbf
4 0 /u01/app/oracle/oradata/catdb/cattbs_01.dbf
5 0 /u01/app/oracle/oradata/catdb/virt_catalog1.dbf
RMAN>
The output of the
report need backup
command tells you that you must back up several database files to
comply with your retention policy.
How It Works
The
report need backup
command reports which data files and archived redo logs need to be backed up to conform
to the backup retention policy you have put in place. You must have configured your own retention policy, or at least
have enabled the default retention policy, for the
report need backup
command to work. If you disable the default
retention policy, RMAN won't be able to figure out which of your data files or archived redo logs need a backup. Here's
an example that shows the result of running the
report need backup
command after disabling the default retention
policy, which is set to 1.
The following command shows the current retention policy:
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
RMAN>
The command shows that the retention policy is configured to a redundancy of 1. Let's change the configured
retention policy from one backup to none, as shown here:
RMAN> configure retention policy to none;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
