-
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 ...
-
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
-
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!
-
In Solaris and Linux it's $5
Code:
Filesystem kbytes used avail capacity Mounted on
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|