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