how to delete old backups after reset;ogs
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???
Thanks in advance
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.
"There is a difference between knowing the path and walking the path."
There is no doubt just do a reset database only at the RMAN prompt :
The "reset database" command gives confirmation to RMAN that you issued a resetlogs.
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.
Click Here to Expand Forum to Full Width