archive log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: archive log

  1. #1
    Join Date
    Oct 2000
    Posts
    9

    Red face

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Once your archived log files are backed up, you can delete them.
    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
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    If those are old and not required archive logs the same may be deleted.
    sonofsita
    http://www.ordba.net

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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?

    Code:
      
         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
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Oct 2000
    Posts
    9

    Red face

    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


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