RMAN - Pb to delete backupset
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
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
0