RMAN-08137: WARNING: archived log not deleted, needed
for standby or upstream capture process
2. Standby destination not accepting any logs due to issues
3. RMAN archive log configuration is set to none/default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
First run below command to identify the archive log gap
SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
WHERE ARCH.THREAD# = APPL.THREAD#
Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
1 185685 185669 16
If there is an archive gap then the issue is either standby archive destination is full or standby destination has some issues and not accepting any more logs, based up on the error take appropriate action. As long as you archive logs backed upon on Primary you can proceed deleting the archive logs on standby
In order to manage the archive logs you have 2 options
1. Create a shell script to check applied logs on standby and delete rest on periodic basis
2. Configure FRA for archive logs and set the RMAN archive log deletion policy as per below
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=800GBG;
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/u01/oracle/FRA';
In case if you are using ASM specify disk group
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+FRA_DISK';
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+FRA_DISK';
You need to set LOG_ARCHIVE_DEST_1 parameter DB_RECOVERY_FILE_DEST so that archived logfiles will be created at Flash recovery area.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST';
Set the RMAN archived log deletion policy as follows.
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
With above setting the applied archived logs will be deleted automatically when there is a space constraint in flash recovery area.
It’s different for the database where you do the backup, because you want to be sure that the backup is done before an archive log is deleted:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST';
Set the RMAN archived log deletion policy as follows.
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
With above setting the applied archived logs will be deleted automatically when there is a space constraint in flash recovery area.
It’s different for the database where you do the backup, because you want to be sure that the backup is done before an archive log is deleted:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;
Regards
Satishababu Gunukula, Oracle ACE
ReplyDeleteI think your blog will easily to get the correct market, because it’s having the piece of content. So it can easily to attract the visitors.
Local Packers And Movers Bangalore
Packers And Movers Bangalore to Chennai
Packers And Movers Bangalore to Mumbai
Packers And Movers Bangalore to Delhi
Packers And Movers Bangalore to Gurgaon
Packers And Movers Bangalore to Bhubaneswar
This comment has been removed by the author.
ReplyDelete
ReplyDeleteThank you very much for writing such an interesting article on this topic. This has really made me think and I hope to read more. @ Packers and Movers Ahmedabad
Packers and Movers Bangalore as a Services providing company can make all the difference to your ###Home Relocation experience. Bangalore based Company which offers versatile solutions, Right team that easily reduce the stress associated with a ✔✔✔Household Shifting, ***Vehicle Transportation. we help things run smoothly and reduce breakages and offer you seamless, Affordable, Reliable Shifting Services, Compare Shifting Charges @ Packers And Movers Bangalore
ReplyDeleteSuperb post, we enjoyed each and everything as per written in your post. Thank you for this informative article because it’s really helpful, I really like site.
ReplyDeletePlease visit our website: @ Packers and Movers Kolkata
Packers and Movers Hyderabad Give Certified and Verified Service Providers, Cheap and Best ###Office Relocation Charges, ***Home Shifting, ✔✔✔Goods Insurance worth Rs. 10,000, Assurance for Local and Domestic House Shifting. Safe and Reliable Household Shifting Services in Hyderabad with Reasonable Packers and Movers Price Quotation @ Packers And Movers Hyderabad
ReplyDeleteThanks for sharing such a valuable information.Im very thankful to you that you had given me this opportunity to write on this blog.please visit our website I assure you that it will be very useful for @ Packers And Movers Hyderabad
ReplyDeletePackers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔ ✔ ✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges. @ Packers And Movers Chennai
ReplyDeletePackers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List , Compare Charges, Save Money And Time.@
ReplyDelete@ Packers And Movers Bangalore
Welcome to Elitemodelsbangalore.com, home of the premium High Class Escorts in Bangalore area. Our Bangalore escorts are the supreme Bangalore has to offer and will provide an unforgettable Bangalore Escort experience!
ReplyDeleteModels Escorts in Bangalore | Top Bangalore Escorts | VIP Escorts in Bangalore | Pune Escorts Models | Escorts in Pune | Elite Escort Service in Bangalore | VVIP Pune escorts | High Profile Bangalore Escorts | Bangalore High Profile Escorts | Elite Escorts in Pune | Bangalore High Class Escorts
Superb post, we enjoyed each and everything as per written in your post. Thank you for this informative article because it’s really helpful, I really like site.
ReplyDeletePlease visit our website: @ Packers and Movers Ahmedabad
Get Packers and Movers Kolkata List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Kolkata Price Quotation instantly and Save Cost and Time. ???Packers and Movers Kolkata Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers and Movers Kolkata
ReplyDeletePackers And Movers Anna Nagar East Chennai
ReplyDeletePackers And Movers Arumbakkam Chennai
Packers And Movers Ashoknagar Chennai
Packers And Movers Aynavaram Chennai
Packers And Besantnagar Adyar Chennai
Pune Escorts | Elite VVIP Models Escorts Pune | Pune VIP Escorts Models
ReplyDeletePune Companion is big female models escorts agency and we comes to take several type services for taking sexual pleasure as Pune Escorts, Escorts in Pune, VVIP Escorts Pune, Pune VVIP Escorts, Elite Escorts in Pune, Pune Elite Escorts, Pune Independent Escorts, Models Escorts Pune, Pune Escorts Models, High Society Pune Escorts, Independent Escorts Pune, Hot Escorts Services Pune, Passionate Pune Escorts Services and more.
Visit here - https://www.punecompanion.com
Click Here - https://www.elitevvipmodels.com
Click Here - http://www.elitevipmodels.co.in
This is the best article I have seen. This is awesome content. Thanks for providing value to your web.
ReplyDeleteTop 10 silk saree with designer blouse
This is the best article I have seen. This is awesome content. Thanks for providing value to your web.
ReplyDeleteHyundai Aura car Price in India and Specifications
Packers And Movers Hyderabad to Kolkata
ReplyDeletePackers And Movers Hyderabad to Lucknow
Packers And Movers Hyderabad to Patna
Packers And Movers Hyderabad to Haridwar
Packers And Movers Hyderabad to Noida
Nice blog has been shared by you. before i read this blog i didn't have any knowledge about this but now i got some knowledge.
ReplyDeleteso keep on sharing such kind of an interesting blogs. Oracle Institute in Delhi
Packers and Movers Bangalore for 100% Affordable and Professional Packers and Movers in Bangalore Compare Charges of Movers and Packers, Household Shifting Services @ Packers And Movers Bangalore
ReplyDeleteGet Packers and Movers Jaipur List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Jaipur Price Quotation instantly and Save Cost and Time. Packers and Movers Jaipur ??? Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers Jaipur
ReplyDeletePackers And Movers Royapettah Chennai
ReplyDeletePackers And Movers Rv Nagar Chennai
Packers And Movers Kandanchavadi Chennai
Packers And Movers Saidapet Chennai
Packers And Movers Saligramam Chennai
Thank you so much for sharing this awesome info! Keep posting, eCheck
ReplyDeletethepetsabout.com
ReplyDeletehappylifestyletrends.com
restaurantsnearme-opennow
Lets have a look at a recent news item that is quite
ReplyDeleteentertainmentbee.com
themoviesbio.com
petrefine.com
Everything is going to be alright. Are we really being honest
ReplyDeletefrasesparaenamorarz.com
fras-es.com
punaisesdelit.org
groupe-sanguine.fr
meilleur-gps.fr
off white x jordan 1
ReplyDeletekyrie shoes
golden goose
jordan shoes
retro jordans
kyrie shoes
golden goose
yeezy boost 700
chrome hearts outlet
birkin bag
This is an informative post, looking for more. Please find local stores on fyndhere ios and andriod app
ReplyDeleteyou can try this out great post to read More Bonuses Fendi Dolabuy Going Here navigate to these guys
ReplyDeletewebsite link over here see page go to these guys blog click here for more info
ReplyDelete