Database Backup and Recovery (MOSC)

MOSC Banner

rman not deleting archive logs

edited Sep 23, 2011 4:29AM in Database Backup and Recovery (MOSC) 10 commentsAnswered ✓
I am new to rman.nd have read the docs and seem to be runnig properly configured rman commands but its not expiring or deleting the archive logs. What am I doing wrong? I do a hot backup with rman and everything seems to go as you would expect.Not incremental just simple backup with a recovery window set to 22 days. no catalog.  Next I run the following to handle archive logs (so I think);
run {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 22 DAYS;
sql 'alter system archive log current';
delete noprompt obsolete;
crosscheck archivelog all;
delete noprompt expired archivelog all backed up 1 times to disk completed before 'sysdate-2';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center