troubleshooting Question

RMAN Retention Policy Question

Avatar of xoxomos
xoxomos asked on
Oracle Database
9 Comments1 Solution742 ViewsLast Modified:
I've got a retention policy of redundancy 1
When i report obsolete I see backup from March 24 included, but there are backups from March 23 that do not appear.

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies

Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          81951  24-MAR-10          /u04/archived_logs/1_48669_665266938.arc
Archive Log          81950  24-MAR-10          /u03/archived_logs/1_48669_665266938.arc
Archive Log          81955  24-MAR-10          /u04/archived_logs/1_48670_665266938.arc
Archive Log          81954  24-MAR-10          /u03/archived_logs/1_48670_665266938.arc
Archive Log          81958  24-MAR-10          /u04/archived_logs/1_48671_665266938.arc
Archive Log          81957  24-MAR-10          /u03/archived_logs/1_48671_665266938.arc

Why is RMAN not seeing backups from March 23 as obsolete?

List of Backup Sets

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
592     Full    215.81G    DISK        00:55:23     23-MAR-10      
        BP Key: 592   Status: AVAILABLE  Compressed: NO  Tag: BACKUP_BB60.CSUHAY_032310110002
        Piece Name: /u05/rman/PRIMARY/backupset/2010_03_23/o1_mf_ncsdf_BACKUP_BB60.CSUHAY_0_5tmbmp3p_.bkp
  Control File Included: Ckp SCN: 3372023929218   Ckp time: 23-MAR-10
  SPFILE Included: Modification time: 11-FEB-10
  List of Datafiles in backup set 592
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 3372023929269 23-MAR-10 /u02/app/oracle/oradata/BB60/system01.dbf
  2       Full 3372023929269 23-MAR-10 /u02/app/oracle/oradata/BB60/tools01.dbf
  4       Full 3372023929269 23-MAR-10 /u02/app/oracle/oradata/BB60/undo01.dbf
  5       Full 3372023929269 23-MAR-10 /u02/app/oracle/oradata/BB60/users01.dbf

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros