alter system set log_archive_dest_2 gives LRM-00117: syntax error at ',' at the start of input
edited May 8, 2016 5:00AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Can someone help me see where the syntax error is in my sql command ?
I am trying to configure a dataguard physical standby database. One of the first steps is to setup the log_archive_dest_2 parameter. However I am getting a syntax error when I execute the following command:
SQL> alter system set log_archive_dest_2='service=pstdby valid_for=(ONLINE_LOGFILES, PRIMARY_ROLE) db_unique_name=pstdby' scope=both;
alter system set log_archive_dest_2='service=pstdby valid_for=(ONLINE_LOGFILES, PRIMARY_ROLE) db_unique_name=pstdby' scope=both
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
0