Database Backup and Recovery (MOSC)

MOSC Banner

Delete backup of archivelogs

edited Nov 28, 2011 7:17AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
 Hi all,
   I backed archivelog with two cases like:

   1. backup incremental level 0 format '/archive/xbank_%t_%s_level0.dbk' database plus archivelog;

   2. backup format '/archive/xbank_%t_%s.arcbk' archivelog until time "to_date(to_char(trunc(sysdate) || ':10:00:00'), 'DD-MON-YY:hh24:mi:ss')" delete input;

   So, archivelogs can reside at backup of database (with extension is .dbk) or at backup of archivelog (.arcbk). How can I only delete backups of archivelog (.arcbk) ?, I tried use some scripts:

   delete backup of archivelog all;  ==> RMAN can delete backups of database that archivelogs were backed in its. 

   or

   delete backup of archivelog all like '/archive/xbank_%t_%s.arcbk';   ==> error: RMAN-06143: LIKE may only be specified with COPY

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