Databases Reference
In-Depth Information
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO NONE;
new RMAN configuration parameters are successfully stored
RMAN>
If you now issue the
report need backup
command, you'll see the following error:
RMAN> report need backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 09/21/2012 14:09:13
RMAN-06525: RMAN retention policy is set to none
RMAN>
The error occurs because the RMAN retention policy was set to none, thus making it impossible for RMAN to
figure out whether you need to make any backups.
You can specify different options with the
report need backup
command. Here are the most useful options you
can use with this command:
This command shows objects that require a backup to conform to a redundancy-based retention policy:
RMAN> report need backup redundancy
n
;
This command shows objects that require a backup to conform to a window-based retention policy:
RMAN> report need backup recovery window of
n
days
This command shows data files that require more than
n
days' worth of archived redo logs for a recovery:
RMAN> report need backup days=
n
;
This command shows only the required backups on disk:
RMAN> report need backup device type disk;
This command shows only required backups on tape:
RMAN> report need backup device type sbt;
Finding Data Files Affected by Unrecoverable Operations
Problem
You want to identify which data files have been affected by unrecoverable operations, since RMAN needs to back up
those files as soon as possible after you perform an unrecoverable operation.
