how do I refresh my archive logs

[gma800]

One of my arhchive logs was deleted, what I did was as follows,

stop the archiving, I enabled no archive log

then I started it on mount and enabled the arcchive log and
backed up the whole db again, to make a new full backup, and possibly erase the previous archive log

my querstion is when I queried the v$archvied_log, it still shows the all archive logs, how do I reset this. since I have already made a new backup.

[marist89]

Your archive history only gets reset when you open the database with the "resetlogs" keyword. Your best bet would be:
1. shutdown immediate (leave archiving on)
2. Do a cold backup
3. alter database open resetlogs

[gma800]

thanks marist89,

point of clarification,

do I have to startup in mount or no mount before I execute the command "alter database open resetlogs"

thanks

[aarganesh]

Yes the db has to be in mount stage and u must type "ALTER DATABASE OPEN RESETLOGS"
Rgds
Ganesh .R