oracledba.help
Scripts

setDGParams.primary.sql

<- Scripts

-- /tmp/setDGParams.primary.sql
set verify off

-- Prompt
prompt
accept v_confirm prompt 'Press Enter to set Data Guard parameters for Primary.'
prompt

-- Process
prompt Making changes...
ALTER DATABASE FORCE LOGGING;
ALTER SYSTEM SET log_archive_config='DG_CONFIG=(oradb,oradb_sb)' SCOPE=both;
ALTER SYSTEM SET log_archive_format='%t_%s_%r.arc'               SCOPE=spfile;
ALTER SYSTEM SET remote_login_passwordfile='EXCLUSIVE'           SCOPE=spfile;
ALTER SYSTEM SET standby_file_management='AUTO'                  SCOPE=both;

-- ALTER SYSTEM SET log_archive_dest_1='LOCATION=/u01/oradata/ORADB/onlinelog/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oradb'   SCOPE=both;
ALTER SYSTEM SET log_archive_dest_2='SERVICE=oradb_sb ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oradb_sb' SCOPE=both;

ALTER SYSTEM SET db_file_name_convert='ORADB_SB','ORADB'  SCOPE=spfile;
ALTER SYSTEM SET log_file_name_convert='ORADB_SB','ORADB' SCOPE=spfile;

ALTER SYSTEM SET fal_server='oradb_sb' SCOPE=both;
ALTER SYSTEM SET fal_client='oradb'    SCOPE=both;

ALTER SYSTEM SET sec_case_sensitive_logon=false SCOPE=both;
ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME  UNLIMITED;
ALTER PROFILE default LIMIT PASSWORD_REUSE_TIME UNLIMITED;

-- End
prompt
prompt Process Ended
prompt