Database Backup and Recovery (MOSC)

MOSC Banner

Oracle database 12.2.0.1.0 - how can unavailable backup pieces be deleted

Hallo Community

  • first

My query is:

select decode (STATUS,'A','Available','D', 'Deleted','U','Unavailable','X' , 'Expired' ) arc_status, count(*) from V$BACKUP_PIECE group by status

ARC_STATUS  COUNT(*)

----------- ----------

Unavailable     84

Deleted      1985

Available     1103

After

crosscheck backup;

delete noprompt expired backup;

delete noprompt obsolete recovery window of 35 days;

nothing changes

My question, where do unavailable backup pieces come from and how can I clean them up?

We use Oracle Release 12.2.0.1.0, RMAN catalog and Commvault Backup.

In the Commvault solution we use the following customized rman script

...

crosscheck backup;

delete noprompt expired backup;

...

  • second

The same query - an other database

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