archived logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: archived logs

  1. #1
    Join Date
    Aug 2008
    Posts
    2

    Question archived logs

    Hello
    I am using oracle 10.
    I have just installed a new fresh database.
    I have put it in archived archive log mode.
    there is only one user using the database.
    after a 5-6 days,the archived log files were using 1GB.


    how do i need to do to delete them automatically?
    thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    with rman

  3. #3
    Join Date
    Aug 2008
    Posts
    2

    Question

    how excatly?
    can you porst the command script?

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    You may want to think about a backup strategy... your archivelog issue would vanish in thin air when you are done with it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hire a DBA Please don't follow what people are saying here.

  6. #6
    Join Date
    Aug 2008
    Posts
    3
    Quote Originally Posted by noumian
    Hello
    I am using oracle 10.
    I have just installed a new fresh database.
    I have put it in archived archive log mode.
    there is only one user using the database.
    after a 5-6 days,the archived log files were using 1GB.


    how do i need to do to delete them automatically?
    thanks
    You can use an OS scheduler to delete old archive log files as I do. I have got a Solaris OS and use crontab(scheduler) to schedule archive log removal script. I just perform a search of files that are older than 2 days and delete them. Search and delete commands depend on your operating system.

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by WillI'm
    I just perform a search of files that are older than 2 days and delete them.
    Please tell us you are taking backup of those archive logs before you delete them, are you?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  8. #8
    Join Date
    Aug 2008
    Posts
    3
    Quote Originally Posted by PAVB
    Please tell us you are taking backup of those archive logs before you delete them, are you?
    Of course. Right before deleting them and keep it for one week

  9. #9
    Join Date
    Dec 2007
    Posts
    82
    I suggest take full backup once week and after that delete old archieve logs that are created before full backup taken. every week full backup and 1 week archive logs are enough however it is subject to your company standards.
    Cheers...
    /MR

  10. #10
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by mdvreddy
    ...every week full backup and 1 week archive logs are enough
    Wouldn't it be dependent of the poster's..
    - Backup/Recovery strategy,
    - DR strategy and
    - SLA?

    Why such a non-sense generalization?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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