Skip to content

Instantly share code, notes, and snippets.

@achampav
Created March 11, 2020 15:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save achampav/170dea3090fef2ccc0cd9b405d59ebe5 to your computer and use it in GitHub Desktop.
Save achampav/170dea3090fef2ccc0cd9b405d59ebe5 to your computer and use it in GitHub Desktop.
SQL> alter system set log_archive_dest_2 = 'service=testdg_dg03_dg lgwr async noaffirm db_unique_name=testdg_dg03 valid_for=(all_logfiles,standby_role)' scope=both;
System altered.
SQL> show parameter fal
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fal_client                           string      TESTDG_DG02
fal_server                           string      testdg_dg01_dg
SQL> alter system set fal_client = 'testdg_dg02,testdg_dg03' scope = both;
System altered.
SQL> alter system set fal_server='testdg_dg01,testdg_dg02' scope = both;
System altered.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment