Archivelog files managment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Archivelog files managment

  1. #1
    Join Date
    Dec 2001
    Posts
    141

    Archivelog files managment

    Hi all !
    Does someone knows where I can find shell scripts to administrate archivelog files ?
    We're planning to create a 8.1.7.4 database on Solaris 5.8 in archivelog mode and I would like to find shell scripts to :
    - move archivelog files when the destination is full up to 80% (for example) to another directory,
    - copy the archivelog files to tape,
    - etc ...
    I need some advices.
    Thanks a lot in advance ...

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    not sure what's the part you are looking for but to look for filesystem usage you simply use df -k

    something like

    Code:
    fs_usage=df -k | grep "your arch log filesystem" | awk '{ print $5 }'
    
    if [ "${fs_usage}" -gt 80 ]; then
       ...............................
    fi
    to copy or move to tape look tar

  3. #3
    Join Date
    Nov 2001
    Posts
    335
    pando,

    you should use awk '{ print $4 }' . That will give you used space, at least on AIX.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  4. #4
    Join Date
    Feb 2003
    Posts
    85
    In Solaris and Linux it's $5

    Code:
    Filesystem            kbytes    used   avail capacity  Mounted on

  5. #5
    Join Date
    Jul 2002
    Posts
    335

    Re: Archivelog files managment

    Originally posted by htanga
    Hi all !
    Does someone knows where I can find shell scripts to administrate archivelog files ?
    We're planning to create a 8.1.7.4 database on Solaris 5.8 in archivelog mode and I would like to find shell scripts to :
    - move archivelog files when the destination is full up to 80% (for example) to another directory,
    - copy the archivelog files to tape,
    - etc ...
    I need some advices.
    Thanks a lot in advance ...
    You really would be better off writing them yourself, not only would it be good experience, but when they go wrong (and they will) you'll be able to debug them yourself.

    Bazza

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