archive log

[sathiyanarayanan]

Hi,

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

thanks

[marist89]

Once your archived log files are backed up, you can delete them.

[sonofsita]

If those are old and not required archive logs the same may be deleted.

[sambavan]

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;

Sam

[sathiyanarayanan]

hi sambavan,

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