Delete Old Archivelogs

[kwil38]

I am using Oracle 10g and RMAN on Linux.

Is there a way to automatically delete archivelogs that have been backed up 3 times via OEM or a script?

Currently, I'm deleting them manually with the following:

rman catalog=rman/*****@RMAN target=netbackup/******@PROD
RMAN> delete archivelog all completed before 'sysdate -3';

Thanks!

 

[LKBrwnDBA]

Yes,

In EM: Click on Maintenance tab, select "Schedule Backup".

Select Archive logs from "Customized backup".

Somewhere you will have to choose to "remove archive logs".

Good Luck!


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[kwil38]

Sorry, I wasn't very clear on what I needed.

I'm using Netbackup (which in turn uses RMAN) to backup my database. I don't want to create and run the backup from OEM, only to create a job which simply deletes archivelogs that have been backed up 3 times.

Is that possible?

 

[stefanhei]

You could try this:
call the backup command 3 times in your script, once for today, once for yesterday and once for all older and deleted the backuped logs of the last step.

BACKUP ARCHIVELOG FROM 'trunc(sysdate-1)';
BACKUP ARCHIVELOG TIME BETWEEN 'trunc(sysdate-2)' AND 'trunc(sysdate-3)';
BACKUP ARCHIVELOG UNTIL 'trunc(sysdate-3)' DELETE INPUT;

I assume the backup is done after midnight...

Stefan

 

[Thargy]

kwil,

the correct way to do this is to use RMAN's built-in facilities which are designed to do this automatically.

One defines a retention policy and then instructs RMAN to delete old archive logs, in accordance with that policy.

Below is my config script which does this. Note the first line which configures the retention policy. This has a reduncancy of 3, as you require.

CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'e:\oracle\rman_backups\dev0\cab_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   'e:\oracle\rman_backups\dev0\backup_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'e:\oracle\rman_backups\dev0\SNCF_dev0.ORA';

When I inovke the overnight backup routine, I do the backup and then delete obsolete archive logs in accordance with the previously configured policy. My standard file is below:-

backup database plus archivelog;
restore database validate;
delete noprompt obsolete;
exit;

The delete noprompt obsolete does the deletion.

Let us know how this works out for you.

Regards

T


Grinding away at things Oracular

 

[LKBrwnDBA]

You did say:

Is there a way to automatically delete archivelogs that have been backed up 3 times via OEM or a script?

You can either create an RMAN job in OEM to delete the logs or write a "script" with the rman command and execute with "cron" scheduler.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb