| Deleting Old Archive logs [message #246064] |
Tue, 19 June 2007 13:43  |
Koolwant
Messages: 49
Registered: June 2007
Location: new jersey
|
Member |
|
|
Hi experts
In my production database,I have to delete old archvie log files .I am always little scared to delete anything on production,but this time i have to .I am not using RMAN .
Can somebody tell me how to delete bunch of files (header or old ) files together.
Thanks
Kool
|
|
|
|
| Re: Deleting Old Archive logs [message #246065 is a reply to message #246064] |
Tue, 19 June 2007 14:28  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
use it as example it leave latest 40 files and delete older,but before running it on PRODUCTION check it on DEV or TEST
# Starting the Loop for Deletion, Leaving the Latest 40 Arc.Files
unalias rm
for i in `cat ${DAILYLOGS}`
do
count=`expr ${count} + 1`
if (( ${count} > 40 )); then
echo "Deleting ${count}; ${STATS_LOG_DIR}/${i}\n" >> $DEL_LOG
rm ${STATS_LOG_DIR}/${i}
fi
done
you can change it according to your requirment on your daily basis of archivelog generation.
|
|
|
|
| Re: Deleting Old Archive logs [message #246070 is a reply to message #246064] |
Tue, 19 June 2007 15:02 |
Koolwant
Messages: 49
Registered: June 2007
Location: new jersey
|
Member |
|
|
Thanks for your reply DreamzZ
The solution you have given me is kind of difficult to understand for me .Can you please tell me what is DAILYLOGS,
STATS_LOG_DIR,DEL_LOG.I am kind of scared to delete files coz it is Production environment.and i dont have same data in test database to, so that i can test it on that.
Please can you suggest me over here
$>ls -ltra|head -40>>old_arch
then
rm old_arch
I am trying to do it this way but the files from arch get copied to old_arch file NOT Moved..What i wanna do is i wanna move old files to another file and then delete the whole file (or directory).
I am sorry if i am annoying you.
Regards
[Updated on: Tue, 19 June 2007 15:04] Report message to a moderator |
|
|
|
| Re: Deleting Old Archive logs [message #246076 is a reply to message #246070] |
Tue, 19 June 2007 16:27 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
check this example
| Quote: | 1.11.8 Delete Files in Bulk
As a DBA, you sometimes need to remove older files from a filesystem. For example, you may want to remove older archived redo logs from your redo log filesystem in order to free up space for more current logs to be archived. You can do this with the help of the find command. The find command in the following example will identify all files that are more than seven days old:
>find . -mtime +7
./archlog251.arc.Z
./archlog252.arc.Z
./archlog253.arc.Z
./archlog254.arc.Z
Now that you have a list of files, you can use the find command's -exec argument to execute the rm command against each file that is found. For example:
find . -mtime +7 -exec rm {} \;
You can use this command to automatically remove all files that are more than seven days old. Note that -exec functions similarly to the xargs command shown earlier in this book.
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
