Automatically Removing ARC Files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Automatically Removing ARC Files

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    61

    Post

    Do any one has any idea or script to remove the archive files automatically in WinNT. I am taking backup everynight of all the archive files next morning I need to remove them manully??? If you have any tip to automate this process please do share with me.Here is the other information:

    Datebase: Oracle8i R8.1.7
    OS: WinNT
    Database Size : 50GB(Approx)
    Archive Log: True


  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Write a bat program to delete the one day old programs and schedule it with AT command
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Jan 2001
    Posts
    61
    ORACLE Keeps files generated by current transaction at the same location.How I can distinguish or just delete the files generated yesterday.Is there a way I can pass the date to look and delete the files???

  4. #4
    Join Date
    Feb 2001
    Location
    Montreal
    Posts
    29
    I dont have no any idea and no script to remove the archive files automatically in WinNT. But i suggest , you supose to kepp the last 15 days archive log . You neve know where (archive log date) you want recove your database.
    Hudson

  5. #5
    Join Date
    Jan 2001
    Posts
    61
    Thanks for the suggetion...

  6. #6
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    It is a good practice to specify a saparate Directory for ARCHIVE files.That can be done in INIT.ORA

    And then it is easy to list all the files and delete the files. It is suggested to have 15 days ARCHIVE files. So you can take a backup before deleting them.
    Thanks
    Kishore Kumar

  7. #7
    Join Date
    Nov 2000
    Posts
    39
    What kind of backup program are you running?

    I'm using Veritas Backup Exec and there is an option to run a file grooming job. It allows you to back up and delete files which are n-days old.

    If you are interested, please let me know.

    Greg

  8. #8
    Join Date
    May 2001
    Posts
    1

    Cool

    OK Greg,

    I'ld really like to know how to access the option to run a file grooming job and back up and delete files which are n-days old in Veritas Backup Exec.

    I looked all through the options and couldn't find it.

    Thanks,

    TinMan777

  9. #9
    Join Date
    Nov 2000
    Posts
    39
    Backup Exec ver. 8.5

    1. Open Backup Exec console
    2. Select "Job Definitions" tab
    3. Right click to select "New" job definition
    4. Third option is "File Grooming Job".
    5. Select files to be groomed, all the necessary paremeters, etc.

    It works great for me.

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