Changing parameters log_archive_format and log_archive_dest_1


  I want to know what is the best practice to change each one of those parameters in the database.    log_archive_format and log_archive_dest_1

 Also, can i perform  ' Alter System.... scope=both;'  for changing each one of these parameters ?

joe_echavarriaDatabase AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I do not understand the question.  

I don't think there is a best practice when setting the format.  I leave mine as the default.  I would only do something different if some internal policy told me to.

You set the destination to whatever folder you want to hold the archived redo logs.  Again, not sure there is a best practice.

alter system is the correct way to set them.  The only part I'm not sure about is the scope=both.  Try it.  it will either work or not.  You might need to use scope=spfile and bounce the database.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnsoneSenior Oracle DBACommented:
I believe that LOG_ARCHIVE_DEST and LOG_ARCHIVE_DES_n can be modified with scope=both.  However, LOG_ARCHIVE_FORMAT is not modifiable and must be changed with scope=spfile and then bounce the database.
joe_echavarriaDatabase AdministratorAuthor Commented:
After changing the log_archive_format and log_archive_dest_1, do i have tell RMAN about this ?

Or is there any thing to configure in RMAN after making this changes ?
slightwv (䄆 Netminder) Commented:
Unless you've done something strange, RMAN should know about where the archived redo logs are and what their names are.

That said:
I suppose it depends on what you've told RMAN to backup and look for,  RMAN is powerful enough, I'm sure you can tell it to look for something specific and then change the names/locations and it will now be missed.

On a test system, make the changes and look at what RMAN backs up with your current configuration.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.