I use Oracle database 19c (on windows server) with archive mode enabled.

Archives log location is G:\oracle\archive.

I want to add a new location for the archives that will automaticly be enabled in case of the 1st location get full.

So I've read about a solution of configuring another archive_log_dest_n (lets say - archive_log_dest_3) parameter with the value of the new location for that purpose.

Won't it harm the DG standby configuraion that works with log_archive_log_dest_2 ?

What is the best practice for combining those 2 components (secondary archives log location, log_Archive_log_dest_2 parameter which reference the standby)?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.