+ Reply to Thread
Results 1 to 10 of 10

Thread: archived logs

  1. 08-13-2008 03:25 AM #1
    noumian
    noumian is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 08-13-2008 03:51 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    with rman
    Reply With Quote Reply With Quote
  3. 08-13-2008 04:59 AM #3
    noumian
    noumian is offline Junior Member
    Join Date
    Aug 2008
    Posts
    2

    Question

    how excatly?
    can you porst the command script?
    Reply With Quote Reply With Quote
  4. 08-13-2008 05:42 AM #4
    PAVB's Avatar
    PAVB
    PAVB is online now Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,492
    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.
    Reply With Quote Reply With Quote
  5. 08-13-2008 06:08 AM #5
    hrishy
    hrishy is offline Super Moderator
    Join Date
    Jan 2001
    Posts
    2,828
    Hire a DBA Please don't follow what people are saying here.
    Reply With Quote Reply With Quote
  6. 08-19-2008 04:48 AM #6
    WillI'm
    WillI'm is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  7. 08-19-2008 06:07 AM #7
    PAVB's Avatar
    PAVB
    PAVB is online now Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,492
    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.
    Reply With Quote Reply With Quote
  8. 08-20-2008 05:45 AM #8
    WillI'm
    WillI'm is offline Junior Member
    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
    Reply With Quote Reply With Quote
  9. 08-20-2008 07:51 AM #9
    mdvreddy
    mdvreddy is offline Junior Member
    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
    Reply With Quote Reply With Quote
  10. 08-21-2008 03:31 AM #10
    PAVB's Avatar
    PAVB
    PAVB is online now Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,492
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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