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
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