Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change log_archive_dest_1 in rac 11g?

Bahram OrujovMar 2 2018 — edited Mar 2 2018

Hi. I have two instance in rac database and one standby database. I want to change log_archive_dest_1 location to use_db_recovery_file_dest in rac database.

I know that I will use this command.

alter system set log_archive_dest_1='location=use_db_recovery_file_dest' scope=both;

But my question is that "Should I restart the instances after running this command? If yes - how can I do this?"

My database version is 11gR2.

This post has been answered by AndrewSayer on Mar 2 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2018
Added on Mar 2 2018
5 comments
2,197 views