Database Backup and Recovery (MOSC)

MOSC Banner

delete obsolete rman doesn't work on AIX

edited Feb 24, 2016 4:01AM in Database Backup and Recovery (MOSC) 9 commentsAnswered

Good day,

OS:

AIX 7.1.0.0 x86-64

DBMS:

Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE    11.2.0.3.0      Production

TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

Retention policy:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

Backup's script:

BACKUP AS BACKUPSET INCREMENTAL LEVEL=0  TAG "INCR0" DATABASE include current controlfile;

DELETE NOPROMPT OBSOLETE;


Question:

I use rman to backup and configure retention policy to recovery.

in Rman delete obsolete doesn't delete backups after 7 days.

If report obsoelete it's show me just backup of controlfile and one of differential, and no archivelog.

And doesn't make status "Expired". All backups in status "Available"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center