Printable View
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
with rman
how excatly?:confused: :confused:
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.
Hire a DBA Please don't follow what people are saying here.
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.Quote:
Originally Posted by noumian
Please tell us you are taking backup of those archive logs before you delete them, are you?Quote:
Originally Posted by WillI'm
Of course. Right before deleting them and keep it for one weekQuote:
Originally Posted by PAVB
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
Wouldn't it be dependent of the poster's..Quote:
Originally Posted by mdvreddy
- Backup/Recovery strategy,
- DR strategy and
- SLA?
Why such a non-sense generalization?