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.
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
point of clarification,
do I have to startup in mount or no mount before I execute the command "alter database open resetlogs"
Yes the db has to be in mount stage and u must type "ALTER DATABASE OPEN RESETLOGS"
A Winner never Quits, A Quitter never Wins
Click Here to Expand Forum to Full Width