how to delete old backups after reset;ogs

[vinodkmg]

Hi ,

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-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
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???

Thanks in advance
Regards,
Vinod

[adewri]

Yes after you do an open reset logs, you need to resync the database with the catalog or reset the incarnation, though im not very sure.

[Giani]

There is no doubt just do a reset database only at the RMAN prompt :
RMAN>reset database;
The "reset database" command gives confirmation to RMAN that you issued a resetlogs.

[vinodkmg]

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.

regards,
Vinod