Database Backup and Recovery (MOSC)

MOSC Banner

RMAN - Pb to delete backupset

edited Mar 20, 2009 4:37AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
Hello, For RMAN, 2 corruptions have occured:
select distinct c.file# "File#",s.set_count ,c.block# "Starting Block#", c.blocks "Range" from v$backup_corruption c, v$backup_set s where c.set_stamp = s.set_stamp and c.set_count = s.set_count order by 1,2;
     File#  SET_COUNT Starting Block#      Range
---------- ---------- --------------- ----------
         6       1717          729152          1
         6       1746          729152          1

I have corrected these ones. But when trying to delete corresponding backupset:
$ORACLE_HOME/bin/rman
connect catalog rmant/xxxxx@xxxxxx
connect target
list backupset 1708;
list backupset 1746;
delete noprompt backupset 1717;  --> RMAN-06004: ORACLE error from recovery catalog database: RMAN-20215: backup set not found
delete noprompt backupset 1746;  --> RMAN-06004: ORACLE error from recovery catalog database: RMAN-20215: backup set not found

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