Saturday 6 March 2021

RMAN : RMAN-08137: WARNING: archived log not deleted needed for standby or upstream capture process archived log file

Scenario Preview : 

Recently we find some error using rman backup as we are unable to delete archivelog. Although backup was successful but archivelog not deleting at there end. Reason was physical standby database was not sync and archivelog not applied at  DR  site.

Even in primary database  rman setting is set to CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

Solution:

We forcefully deleted archivelog so NO error found at the next rman scheduled backup.

delete noprompt force archivelog all;

Error in rman backup log :

 archived log file name=+FRA1/SMRPROD/ARCHIVELOG/2021_02_20/thread_2_seq_1002.666.1064966457 thread=2 sequence=1002

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=+FRA1/SMRPROD/ARCHIVELOG/2021_02_20/thread_2_seq_1003.667.1064979311 thread=2 sequence=1003

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=+FRA1/SMRPROD/ARCHIVELOG/2021_02_20/thread_1_seq_640.668.1064979313 thread=1 sequence=640

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=+FRA1/SMRPROD/ARCHIVELOG/2021_02_20/thread_2_seq_1004.669.1064979315 thread=2 sequence=1004

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=+FRA1/SMRPROD/ARCHIVELOG/2021_02_20/thread_1_seq_641.670.1064979317 thread=1 sequence=641

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=+FRA1/SMRPROD/ARCHIVELOG/2021_02_20/thread_1_seq_642.671.1064979761 thread=1 sequence=642

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=+FRA1/SMRPROD/ARCHIVELOG/2021_02_20/thread_2_seq_1005.672.1064979763 thread=2 sequence=1005

13659,1       97%


RMAN >  crosscheck archivelog all;

RMAN > delete noprompt force archivelog all;

archived log file name=+FRA2/smrprod/archivelog/2_1065_1051537325.dbf RECID=2981 STAMP=1065309321

deleted archived log

archived log file name=+FRA2/smrprod/archivelog/2_1066_1051537325.dbf RECID=2983 STAMP=1065312067

deleted archived log

archived log file name=+FRA2/smrprod/archivelog/2_1067_1051537325.dbf RECID=2984 STAMP=1065324915

deleted archived log

archived log file name=+FRA2/smrprod/archivelog/2_1068_1051537325.dbf RECID=2986 STAMP=1065324921

deleted archived log

archived log file name=+FRA2/smrprod/archivelog/2_1069_1051537325.dbf RECID=2988 STAMP=1065325462

deleted archived log

archived log file name=+FRA2/smrprod/archivelog/2_1070_1051537325.dbf RECID=2990 STAMP=1065332821

Deleted 427 objects



No comments:

Post a Comment