OraFAQ Forum: Backup & Recovery » WARNING: archived log not deleted

Home » RDBMS Server » Backup & Recovery » WARNING: archived log not deleted - must create more backups during a backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

WARNING: archived log not deleted - must create more backups during a backup [message #540422]

Mon, 23 January 2012 08:18

BeefStu
Messages: 208
Registered: October 2011

Senior Member

I ran into the message RMAN-08138: WARNING: archived log not
deleted - must create more backups during a backup. From what
I understand this is caused when logs are removed that are needed for recovery.

Based on my script below, can somebody point out how
this may happen?

Thanks to all who answer


rman target / nocatalog <<EOT
CONFIGURE CHANNEL DEVICE TYPE DISK clear ;
CONFIGURE CHANNEL DEVICE TYPE TAPE clear ;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear ;
CONFIGURE RETENTION POLICY TO recovery window of 14 days;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '${BACKUP_DIR}/${ORACLE_SID}_autobkup_CF%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 5;
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '${BACKUP_DIR}/${ORACLE_SID}_HOT_df_%d_t%t_s%s_p%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '${BACKUP_DIR}/${ORACLE_SID}_snapcf.f';
show all;
crosscheck backupset;
crosscheck copy;
delete noprompt expired backup;
delete noprompt expired copy;
delete noprompt obsolete;
backup tag '$dbTAG' incremental level 0 FORMAT '${BACKUP_DIR}/${ORACLE_SID}_HOT_df_%d_t%t_s%s_p%p' SKIP INACCESSIBLE database;
crosscheck archivelog all;
backup tag '$alTAG' FORMAT '${BACKUP_DIR}/${ORACLE_SID}_HOT_al_%d_t%t_s%s_p%p' archivelog all;

delete noprompt archivelog ALL BACKED UP 1 TIMES TO SBT_TAPE COMPLETED BEFORE ="SYSDATE-1/2";
EOT

Report message to a moderator

Re: WARNING: archived log not deleted - must create more backups during a backup [message #540424 is a reply to message #540422]

Mon, 23 January 2012 08:34

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

RMAN-08138: WARNING: archived log not deleted - must create more backups
 *Cause: An archived log that should have been deleted was not as it
         it did not meet the user specified archive log deletion policy
         of number of backups required before deleting the logs.
 *Action: This is an informational message. The archived log can be
          deleted after more backups are created to satify archivelog
          deletion policy.

Quote:

delete noprompt archivelog ALL BACKED UP 1 TIMES TO SBT_TAPE COMPLETED BEFORE ="SYSDATE-1/2";

Quote:

CONFIGURE RETENTION POLICY TO recovery window of 14 days;

In addition, $ in a RMAN script can lead to problem.

Regards
Michel

Report message to a moderator

Previous Topic:	How to configure RMAN for specific backup strategy
Next Topic:	cannot connect catalog - RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:44:38 CST 2025