Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
RMAN delete downstream capture

Oracle DB 12.1.0.2
Solaris 11.4
Hello Team,
I would like to know whether I can proceed with delete below since there is only 500 G free space on ASM disk +FRA. Backup on tape was not working since Dec 1. I nee dto free up space.
ENvironment is a downstream database with extract and replicat running.
RMAN> delete archivelog until time 'sysdate-1';
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2426 instance=dware11 device type=DISK
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55132.5648.1058188149 thread=1 sequence=55132
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55133.6897.1058188385 thread=1 sequence=55133
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55134.6574.1058188477 thread=1 sequence=55134
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55135.7018.1058189255 thread=1 sequence=55135
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57786.6975.1058264599 thread=2 sequence=57786
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57787.5899.1058265633 thread=2 sequence=57787
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57788.6965.1058265729 thread=2 sequence=57788
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57789.5176.1058265877 thread=2 sequence=57789
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57790.5846.1058265969 thread=2 sequence=57790
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57791.6858.1058266519 thread=2 sequence=57791
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57792.5967.1058266657 thread=2 sequence=57792
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57793.6371.1058266927 thread=2 sequence=57793
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57794.6091.1058267177 thread=2 sequence=57794
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57795.6578.1058267467 thread=2 sequence=57795
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57796.6760.1058267741 thread=2 sequence=57796
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57797.6920.1058267845 thread=2 sequence=57797
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57798.4929.1058268347 thread=2 sequence=57798
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57799.6717.1058268611 thread=2 sequence=57799
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57800.7035.1058269267 thread=2 sequence=57800
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57801.6838.1058269497 thread=2 sequence=57801
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57802.5482.1058269597 thread=2 sequence=57802
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57803.6612.1058269983 thread=2 sequence=57803
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57804.6927.1058270139 thread=2 sequence=57804
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57805.6748.1058270523 thread=2 sequence=57805
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57806.5425.1058270883 thread=2 sequence=57806
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57807.6003.1058271005 thread=2 sequence=57807
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57808.6939.1058271353 thread=2 sequence=57808
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57809.5666.1058271561 thread=2 sequence=57809
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57810.6084.1058271593 thread=2 sequence=57810
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57811.6621.1058271637 thread=2 sequence=57811
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57812.6778.1058272843 thread=2 sequence=57812
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57813.5965.1058273105 thread=2 sequence=57813
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57814.6805.1058273951 thread=2 sequence=57814
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57815.5376.1058274175 thread=2 sequence=57815
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57816.6619.1058274245 thread=2 sequence=57816
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57817.6900.1058274703 thread=2 sequence=57817
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57818.5161.1058275145 thread=2 sequence=57818
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57819.6687.1058275265 thread=2 sequence=57819
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57820.5874.1058275679 thread=2 sequence=57820
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57821.6636.1058275805 thread=2 sequence=57821
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57822.7025.1058276601 thread=2 sequence=57822
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57823.6281.1058277237 thread=2 sequence=57823
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57824.6228.1058277995 thread=2 sequence=57824
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57825.5781.1058278071 thread=2 sequence=57825
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57826.5067.1058278343 thread=2 sequence=57826
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57827.7052.1058278853 thread=2 sequence=57827
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57828.6896.1058278979 thread=2 sequence=57828
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57829.6986.1058279957 thread=2 sequence=57829
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57830.6311.1058280245 thread=2 sequence=57830
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57831.6241.1058281005 thread=2 sequence=57831
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57832.6044.1058281437 thread=2 sequence=57832
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57833.6625.1058281499 thread=2 sequence=57833
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57834.5407.1058281557 thread=2 sequence=57834
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57835.6831.1058281875 thread=2 sequence=57835
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57836.6709.1058282391 thread=2 sequence=57836
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57837.6688.1058282479 thread=2 sequence=57837
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57838.6086.1058282811 thread=2 sequence=57838
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57839.5446.1058282907 thread=2 sequence=57839
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57840.6593.1058283733 thread=2 sequence=57840
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57841.5627.1058284483 thread=2 sequence=57841
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57842.5878.1058285037 thread=2 sequence=57842
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57843.5979.1058285095 thread=2 sequence=57843
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57844.6568.1058285523 thread=2 sequence=57844
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57845.5824.1058285923 thread=2 sequence=57845
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57846.6274.1058286027 thread=2 sequence=57846
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57847.6981.1058287207 thread=2 sequence=57847
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57848.6799.1058287833 thread=2 sequence=57848
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57849.6120.1058288573 thread=2 sequence=57849
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57850.6747.1058288641 thread=2 sequence=57850
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57851.6936.1058289053 thread=2 sequence=57851
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+RECO/DWARE1/ARCHIVELOG/2020_12_04/thread_2_seq_57852.5213.1058290769 thread=2 sequence=57852
List of Archived Log Copies for database with db_unique_name DWARE1
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
144076 1 54775 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54775.6826.1058008239
144079 1 54776 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54776.6874.1058008327
144086 1 54777 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54777.1184.1058008681
144089 1 54778 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54778.6296.1058009049
144093 1 54779 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54779.6894.1058009973
144097 1 54780 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54780.4938.1058010193
144104 1 54781 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54781.7006.1058010871
144111 1 54782 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54782.7001.1058011679
144113 1 54783 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54783.5354.1058011789
144117 1 54784 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54784.1183.1058011889
144119 1 54785 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54785.6278.1058011979
144125 1 54786 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54786.5991.1058012507
144127 1 54787 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54787.5145.1058013081
144131 1 54788 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54788.6782.1058013579
144133 1 54789 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54789.5034.1058013739
144135 1 54790 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54790.5048.1058013837
144139 1 54791 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54791.5342.1058013975
144141 1 54792 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54792.6021.1058014267
144143 1 54793 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54793.6816.1058014561
144147 1 54794 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54794.5957.1058014651
144151 1 54795 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_1_seq_54795.6944.1058015595
145160 1 55096 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55096.6755.1058175703
145163 1 55097 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55097.5657.1058175733
145167 1 55098 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55098.1345.1058175883
145170 1 55099 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55099.5682.1058175913
145172 1 55100 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55100.5551.1058175943
145175 1 55101 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55101.6984.1058176587
145179 1 55102 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55102.6614.1058177225
145181 1 55103 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55103.5640.1058177275
145183 1 55104 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55104.6114.1058177345
145185 1 55105 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55105.5132.1058177763
145187 1 55106 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55106.6620.1058177999
145189 1 55107 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55107.6819.1058178221
145191 1 55108 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55108.6094.1058179449
145194 1 55109 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55109.5715.1058179887
145198 1 55110 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55110.5225.1058180529
145200 1 55111 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55111.6597.1058180725
145202 1 55112 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55112.5338.1058180899
145205 1 55113 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55113.6638.1058181685
145209 1 55114 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55114.6359.1058182781
145210 1 55115 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55115.5895.1058182977
145213 1 55116 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55116.6528.1058183433
145217 1 55117 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55117.5263.1058183951
145220 1 55118 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55118.6606.1058184621
145222 1 55119 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55119.6631.1058184753
145223 1 55120 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55120.6772.1058184941
145225 1 55121 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55121.5205.1058185047
145227 1 55122 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55122.6685.1058185363
145229 1 55123 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55123.6306.1058186385
145231 1 55124 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55124.6818.1058186489
145232 1 55125 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55125.6929.1058186571
145233 1 55126 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55126.6611.1058186719
145235 1 55127 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55127.6988.1058186815
145236 1 55128 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55128.6200.1058187295
145237 1 55129 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55129.6187.1058187503
145239 1 55130 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55130.5221.1058187601
145241 1 55131 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_1_seq_55131.5631.1058187863
144073 2 57413 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57413.5618.1058008053
144077 2 57414 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57414.5115.1058008239
144081 2 57415 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57415.6815.1058008395
144083 2 57416 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57416.6610.1058008483
144087 2 57417 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57417.6652.1058008679
144091 2 57418 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57418.5949.1058009951
144095 2 57419 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57419.6484.1058010143
144099 2 57420 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57420.6586.1058010261
144101 2 57421 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57421.6779.1058010723
144105 2 57422 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57422.5255.1058010869
144107 2 57423 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57423.6584.1058010953
144109 2 57424 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57424.6903.1058011497
144116 2 57425 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57425.6691.1058011891
144121 2 57426 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57426.6823.1058012259
144123 2 57427 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57427.6878.1058012319
144128 2 57428 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57428.6730.1058013579
144136 2 57429 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57429.6599.1058013975
144145 2 57430 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57430.6935.1058014651
144154 2 57431 A 01-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_01/thread_2_seq_57431.6439.1058015817
145158 2 57635 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57635.6934.1058175661
145161 2 57636 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57636.6557.1058175705
145164 2 57637 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57637.6125.1058175735
145165 2 57638 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57638.6587.1058175837
145168 2 57639 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57639.6735.1058175885
145171 2 57640 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57640.5719.1058175915
145173 2 57641 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57641.6036.1058175945
145174 2 57642 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57642.6959.1058176117
145176 2 57643 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57643.5455.1058176585
145177 2 57644 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57644.6775.1058176845
145178 2 57645 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57645.6647.1058176939
145180 2 57646 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57646.6881.1058177223
145182 2 57647 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57647.5478.1058177347
145184 2 57648 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57648.5297.1058177665
145186 2 57649 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57649.6756.1058177761
145188 2 57650 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57650.6535.1058178223
145190 2 57651 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57651.1349.1058179337
145192 2 57652 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57652.6024.1058179463
145193 2 57653 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57653.5157.1058179647
145195 2 57654 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57654.6507.1058179887
145196 2 57655 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57655.6639.1058180127
145197 2 57656 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57656.5324.1058180225
145199 2 57657 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57657.6780.1058180529
145201 2 57658 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57658.6723.1058180805
145203 2 57659 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57659.6677.1058181089
145204 2 57660 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57660.6694.1058181185
145206 2 57661 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57661.6329.1058181683
145207 2 57662 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57662.6304.1058181749
145208 2 57663 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57663.7007.1058182703
145211 2 57664 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57664.6990.1058182993
145212 2 57665 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57665.6573.1058183145
145214 2 57666 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57666.5953.1058183431
145215 2 57667 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57667.3934.1058183659
145216 2 57668 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57668.6809.1058183821
145218 2 57669 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57669.6797.1058183949
145219 2 57670 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57670.5732.1058184271
145221 2 57671 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57671.6968.1058184631
145224 2 57672 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57672.5524.1058185047
145226 2 57673 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57673.5362.1058185303
145228 2 57674 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57674.6089.1058185361
145230 2 57675 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57675.6796.1058186489
145234 2 57676 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57676.6883.1058186815
145238 2 57677 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57677.6392.1058187605
145240 2 57678 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57678.6955.1058187797
145242 2 57679 A 03-DEC-20
Name: +RECO/DWARE1/ARCHIVELOG/2020_12_03/thread_2_seq_57679.5366.1058187859
Do you really want to delete the above objects (enter YES or NO)?
Can I proceed with YES or NO?
Thanks,
Roshan
Best Answer
-
IF you have oracle dataguard.DO confirm from standby database what is the max sequence of archive which has been applied :
select max(sequence#) from v$log_history,
IF above mentioned archive log are applied you can try deleting those by using force options of rman.If this archive logs are not applied you an check what is the issue on standby site by referring to alert logs.
Do follow this link if you need more info:
IF you have oracle goldengate implemented.Do follow below mentioned MOS link:
Goldengate prompting RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process (Doc ID 2424616.1)
Answers
-
IF you have oracle dataguard.DO confirm from standby database what is the max sequence of archive which has been applied :
select max(sequence#) from v$log_history,
IF above mentioned archive log are applied you can try deleting those by using force options of rman.If this archive logs are not applied you an check what is the issue on standby site by referring to alert logs.
Do follow this link if you need more info:
IF you have oracle goldengate implemented.Do follow below mentioned MOS link:
Goldengate prompting RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process (Doc ID 2424616.1)