how do I refresh my archive logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how do I refresh my archive logs

  1. #1
    Join Date
    Dec 2000
    Posts
    18

    Exclamation

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2000
    Posts
    18
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    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
  •  



Click Here to Expand Forum to Full Width