Wednesday, June 6, 2018

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

In processof the backup archived log to ZDLRA we got a message:
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process


The backup of datafiles is run successfully, but archived logs got a stuck:


Starting backup at 2018-JUN-06 17:28:14
current log archived
channel ch01: starting archived log backup set
channel ch01: specifying archived log(s) in backup set
input archived log thread=1 sequence=850 RECID=791 STAMP=978108063
input archived log thread=1 sequence=851 RECID=792 STAMP=978108142
input archived log thread=1 sequence=852 RECID=793 STAMP=978108145
input archived log thread=1 sequence=853 RECID=794 STAMP=978109461
channel ch01: starting piece 1 at 2018-JUN-06 17:28:17
channel ch01: finished piece 1 at 2018-JUN-06 17:28:24
piece handle=4136710722_20180606_1_13t4pidh_1 tag=A_FD comment=API Version 2.0,MMS Version 12.2.0.1
channel ch01: backup set complete, elapsed time: 00:00:07
channel ch01: deleting archived log(s)
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_850_fkhs3gvz_.arc thread=1 sequence=850
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_851_fkhs5y1c_.arc thread=1 sequence=851
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_852_fkhs61cw_.arc thread=1 sequence=852
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_853_fkhth5dm_.arc thread=1 sequence=853
Finished backup at 2018-JUN-06 17:28:25


The workaround is:

SQL> alter system set log_archive_dest_state_3='DEFER' scope=both sid='*';

System altered.

And you'll have:

Starting backup at 2018-JUN-06 17:34:26
current log archived
channel ch01: starting archived log backup set
channel ch01: specifying archived log(s) in backup set
input archived log thread=1 sequence=850 RECID=791 STAMP=978108063
input archived log thread=1 sequence=851 RECID=792 STAMP=978108142
input archived log thread=1 sequence=852 RECID=793 STAMP=978108145
input archived log thread=1 sequence=853 RECID=794 STAMP=978109461
channel ch01: starting piece 1 at 2018-JUN-06 17:34:28
channel ch01: finished piece 1 at 2018-JUN-06 17:34:35
piece handle=4136710722_20180606_1_17t4pip4_1 tag=A_FD comment=API Version 2.0,MMS Version 12.2.0.1
channel ch01: backup set complete, elapsed time: 00:00:07
channel ch01: deleting archived log(s)
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_850_fkhs3gvz_.arc RECID=791 STAMP=978108063
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_851_fkhs5y1c_.arc RECID=792 STAMP=978108142
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_852_fkhs61cw_.arc RECID=793 STAMP=978108145
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_853_fkhth5dm_.arc RECID=794 STAMP=978109461
Finished backup at 2018-JUN-06 17:34:36



But if you return your setting back:

SQL> alter system set log_archive_dest_state_3='enable' scope=both sid='*';

System altered.

The problem appears:

Starting backup at 2018-JUN-06 17:35:41
current log archived
channel ch01: starting archived log backup set
channel ch01: specifying archived log(s) in backup set
input archived log thread=1 sequence=860 RECID=801 STAMP=978111311
input archived log thread=1 sequence=861 RECID=802 STAMP=978111341
channel ch01: starting piece 1 at 2018-JUN-06 17:35:42
channel ch01: finished piece 1 at 2018-JUN-06 17:35:43
piece handle=4136710722_20180606_1_1bt4pire_1 tag=A_FD comment=API Version 2.0,MMS Version 12.2.0.1
channel ch01: backup set complete, elapsed time: 00:00:01
channel ch01: deleting archived log(s)
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_860_fkhw8zos_.arc thread=1 sequence=860
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/oradata/fra/O11203/archivelog/2018_06_06/o1_mf_1_861_fkhw9xjo_.arc thread=1 sequence=861
Finished backup at 2018-JUN-06 17:35:44


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...