Re: Defining Obsolete Backups in RMAN

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 20 May 2005 16:58:33 +0200
Message-ID: <d6ktma$mdm$1@news1.zwoll1.ov.home.nl>

amerar_at_iwc.net wrote:
> Hi All,
>
> Question:
>
> Say I have 3 weeks of backup, and I want to get rid of everything but
> one week. Will this REPORT command give me a list of everything I can
> delete:
>
> REPORT OBSOLETE UNTIL TIME 'SYSDATE-7';
>

No:
RMAN> REPORT OBSOLETE UNTIL TIME 'SYSDATE-7'; no obsolete backups found

RMAN>
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
-------------------- ------ ------------------ --------------------
Backup Set           27     12-APR-05
  Backup Piece       27     12-APR-05
/o/oracle9/920/dbs/0tghmhfs_1_1
Backup Set           28     12-APR-05
  Backup Piece       28     12-APR-05
/o/oracle9/920/dbs/0sghmhfs_1_1
Backup Set           29     12-APR-05
  Backup Piece       29     12-APR-05
/o/oracle9/920/dbs/0ughmhft_1_1
Backup Set           30     12-APR-05
  Backup Piece       30     12-APR-05
/o/oracle9/920/dbs/10ghmhfv_1_1
Backup Set           31     12-APR-05
  Backup Piece       31     12-APR-05

/o/oracle9/920/dbs/0vghmhfu_1_1

-- 
Regards,
Frank van Bortel

Received on Fri May 20 2005 - 09:58:33 CDT