Hi,
Is there a way to delete old archive logs automatically, lets say older than one week? I dont want to backup or use older than one week archives and I want them to be deleted automatically.
I am using oracle 10g and Sun solaris 10.
Thanks
Printable View
Hi,
Is there a way to delete old archive logs automatically, lets say older than one week? I dont want to backup or use older than one week archives and I want them to be deleted automatically.
I am using oracle 10g and Sun solaris 10.
Thanks
When you backup the archive logs with RMAN, specify the "DELETE INPUT" option.
:rolleyes:
I guess there is a misunderstanding, I dont want any backup, I just wanted them to be deleted automatically.
I know how to delete at RMAN, but I needed this to be done automatic in specified time period.
Thanks
Of course there is, it's unix you can code almost anything... :p
Code:find $ARCHIVE -mtime +6 | xargs rm -rf
it works in windows server as follows:: dont know abt solaris scheduling...
schedule a task using scheduled tasks in windows server dat runs a batch file everyday..The batch file contains command to create rman session that executes this block...
RMAN> run{
2> allocate channel abc device type disk;
3> resync catalog;
4> crosscheck archivelog all;
5> delete noprompt archivelog all completed before 'sysdate-6';
6> release channel abc;
7> }