Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

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
Avatar of vishal68
vishal68Flag of India image

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

This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answers