-
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
Jeff Hunter
-
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
-
Yes the db has to be in mount stage and u must type "ALTER DATABASE OPEN RESETLOGS"
Rgds
Ganesh .R
A Winner never Quits, A Quitter never Wins
Ganesh .R
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|