In my database there are lot of archive log files say around 350 files which went unnoticed and this takes lots of time when every day we take online fullbackup.
I want to reset logs how to do this.
u will not be able to reset logs until otherwise it is a incomplete recovery.
how to reset my logs
Once your archived log files are backed up, you can delete them.
If those are old and not required archive logs the same may be deleted.
Why would you want to reset logs? How are you doing the backup? using rman/OS? why not just backup archive logs and delete them?
1. Shutdown the database in normal/immediate mode
2. Take a cold backup
3. startup mount
4. recover database until cancel;
5. alter database open resetlogs;
Life is a journey, not a destination!
u are right after doing cold backup i mounted and recovered unitl cancel but when i try to open with resetlogs it says that only with incomplete recoery u can resetlogs
i also did a false incomplete recory
Click Here to Expand Forum to Full Width