How do i delete old backups from RMAN after opening the database with resetlogs.Here is the scenario.Assume i got 1 weeks data from sunday to sunday.After a week On Monday database crash lost all the database files,redos,control files,restored and recovered the databases and opened the DB with reset logs ok.
Now I want to delete the backups which are older than 6 days.When i try to generate the obsolete list.It gives me the following error.
RMAN> report obsolete until time 'sysdate-1';
RMAN-03022: compiling command: report
RMAN-03026: error recovery releasing channel resources
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure during compilation of command
RMAN-03013: command type: report
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME is before RESETLOGS time
So do i need to reset the incarnation to previous one to delete the old backups from tape???
I know that we have to use reset database to make the database to current incarnation.Please understand my Question.After i do so,my database is in different incarnation.Ok.Now i dont want all those backups whichever i have taken before,So i want to delete those backups.when i want to see all those before 1 day
RMAN>report obsolete until time 'SYSDATE-1';
The above mentioned error is generated.Then how can i delete the old backups from tape.