RMAN report need backup unexpected results
Date: Wed, 30 Jul 2014 17:29:21 -0400
Message-ID: <CAEHB_aqoRtcvfKQ1X41xMhm4SeS-e_DXBqwXDAiFOwGaJw3L1w_at_mail.gmail.com>
Hi All,
I need to create some monitoring scripts to make sure that all of our database have adequate RMAN backups. All of our databases are set to recovery window of 14 days...
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name BIOOCT1 are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; Obsolete backups are regularly purged as part of the backup script. For this particular database the oldest level 0 backup is from 12 July...
RMAN> list backup summary;
List of Backups
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
2453 B 0 A DISK 12-JUL-14 1 1 YES 2014-07-12_062414_LEV0
2454 B 0 A DISK 12-JUL-14 1 1 YES 2014-07-12_062414_LEV0
2456 B A A DISK 12-JUL-14 1 1 YES 2014-07-12_062414_LEV0
2457 B 1 A DISK 14-JUL-14 1 1 YES 2014-07-14_181501_LEV1
2458 B 1 A DISK 14-JUL-14 1 1 YES 2014-07-14_181501_LEV1
2459 B A A DISK 14-JUL-14 1 1 YES 2014-07-14_181501_LEV1
2460 B A A DISK 14-JUL-14 1 1 YES 2014-07-14_181501_LEV1
2461 B A A DISK 14-JUL-14 1 1 YES 2014-07-14_181501_LEV1 I figured that I would use "report need backup" to determine if there is an issue and alert via email however I tried the following as a test...
RMAN> report need backup recovery window of 30 days;
Report of files that must be backed up to satisfy 30 days recovery window
File Days Name
---- ----- -----------------------------------------------------
It came back with nothing. I do not have backups old enough to support recovery to a point in time 30 days back so am wondering why the "report need backup recovery window of 30 days;" did not list all of the data files? The functionality is described in the docs as follows...
RECOVERY WINDOW OF integer DAYS
Reports datafiles for which there are not sufficient backups to satisfy a recovery window-based retention policy for the specified number of days, that is, datafiles without sufficient backups for point-in-time recovery to any point back to the time SYSDATE - integer. See Table 2-31 for description of output.
So seems to me that it should list all data files in this case. Has anyone else seen this seemingly incorrect behavior? This is for Oracle Enterprise Edition 11.2.0.2 on OEL 5.5.
Thanks,
Ken.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 30 2014 - 23:29:21 CEST