-
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
-
-
how excatly?
can you porst the command script?
-
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.
-
Hire a DBA Please don't follow what people are saying here.
-
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.
-
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.
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|