RMAN-08138: WARNING: archived log not deleted - must create more backups archived log file name

RMAN-08138: WARNING: archived log not deleted - must create more backups archived log file name      

 

RMAN-08138 : Reason of  RMAN-08138 is RMAN DELETION policy

while we deleting archivelogs files using RMAN, RMAN checks whether archivelog file has been taken backup N times to Disk or Tape before deleting archivelog files.

 

Default :  ARCHIVELOG DELETION POLICY TO NONE

 

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TESTPRY are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;

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   'F:\ORCL_BACKUP\TEST_BACKUP\02_FEB_2016\TEST_%d_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\APP\DILIPBAKSHI\PRODUCT\11.2.0\DBHOME_2\DATABASE\SNCFTESTPRY.ORA'; # default

 

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TESTPRY are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
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   'F:\ORCL_BACKUP\TEST_BACKUP\02_FEB_2016\TEST_%d_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\APP\DILIPBAKSHI\PRODUCT\11.2.0\DBHOME_2\DATABASE\SNCFTESTPRY.ORA'; # default

RMAN> backup archivelog all FORMAT 'F:\temp\Temp3\Backup\RMAN_BACKUP\%n_ARCHIVE_BKP_%p_%s_%D_%M_%Y_%U' delete input;

 Starting backup at 17-NOV-16

using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1686 RECID=2307 STAMP=928106656
channel ORA_DISK_1: starting piece 1 at 17-NOV-16
channel ORA_DISK_1: finished piece 1 at 17-NOV-16
piece handle=F:\TEMP\TEMP3\BACKUP\RMAN_BACKUP\TESTPRYX_ARCHIVE_BKP_1_1693_17_11_2016_KTRL4Q5H_1_1 tag=TAG20161117T104712 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07

channel ORA_DISK_1: deleting archived log(s)

RMAN-08138: WARNING: archived log not deleted - must create more backups archived log file name      =F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16\O1_MF_1_1686_D2S7B6YJ_.ARC

thread=1 sequence=1686

Finished backup at 17-NOV-16

 

Starting Control File and SPFILE Autobackup at 17-NOV-16
piece handle=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\AUTOBACKUP\2016_11_17\O1_MF_S_928147640_D2THC29D_.BKP comment=NONE

Finished Control File and SPFILE Autobackup at 17-NOV-16

Note : According to above policy RMAN will not delete those Archivelog files which have not been  backed up 2 Times to Disk

RMAN> list archivelog all backed up 1 times to DISK;

List of Archived Log Copies for database with db_unique_name TESTPRY
=====================================================================
Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
2307    1    1686    A 16-NOV-16
Name:F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16 \O1_MF_1_1686_D2S7B6YJ_.ARC

 

RMAN> list archivelog all backed up 0 times to DISK;

List of Archived Log Copies for database with db_unique_name TESTPRY
=====================================================================
Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
2307    1    1686    A 16-NOV-16
Name:F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16\O1_MF_1_1686_D2S7B6YJ_.ARC

2308    1    1687    A 16-NOV-16
Name:F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_17\O1_MF_1_1687_D2THGPLY_.ARC

 

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

old RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TESTPRY are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
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   'F:\ORCL_BACKUP\TEST_BACKUP\02_FEB_2016\TEST_%d_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\APP\DILIPBAKSHI\PRODUCT\11.2.0\DBHOME_2\DATABASE\SNCFTESTPRY.ORA'; # default

 

RMAN>

RMAN> backup archivelog all FORMAT 'F:\temp\Temp3\Backup\RMAN_BACKUP\%n_ARCHIVE_BKP_%p_%s_%D_%M_%Y_%U' delete input;

Starting backup at 17-NOV-16

current log archived
using channel ORA_DISK_1
skipping archived log file F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16\O1_MF_1_1686_D2S7B6YJ_.ARC; already backed up 1 time(s)
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1687 RECID=2308 STAMP=928147759
input archived log thread=1 sequence=1688 RECID=2309 STAMP=928149066
channel ORA_DISK_1: starting piece 1 at 17-NOV-16
channel ORA_DISK_1: finished piece 1 at 17-NOV-16
piece handle=F:\TEMP\TEMP3\BACKUP\RMAN_BACKUP\TESTPRYX_ARCHIVE_BKP_1_1695_17_11_2016_KVRL4RIB_1_1 tag=TAG20161117T111106 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_17\O1_MF_1_1687_D2THGPLY_.ARC RECID=2308 STAMP=928147759
archived log file name=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_17\O1_MF_1_1688_D2TJQK8D_.ARC RECID=2309 STAMP=928149066
channel ORA_DISK_1: deleting archived log(s)
archived log file name=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16\O1_MF_1_1686_D2S7B6YJ_.ARC RECID=2307 STAMP=928106656
Finished backup at 17-NOV-16

Starting Control File and SPFILE Autobackup at 17-NOV-16
piece handle=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\AUTOBACKUP\2016_11_17\O1_MF_S_928149073_D2TJQW31_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 17-NOV-16

 

Note : This time No RMAN-08138: warning  raised.