##################################################################### NOW AT PRIMARY SITE ##################################################################### [root@orcl19p ~]# su - oracle Last login: Sun Oct 27 00:01:03 CEST 2019 on pts/0 [oracle@orcl19p ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 27 14:07:02 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> show parameter convert NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string log_file_name_convert string pdb_file_name_convert string SQL> SELECT log_mode FROM v$database; LOG_MODE ------------ ARCHIVELOG SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ NO SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup mount; ORACLE instance started. Total System Global Area 2684350696 bytes Fixed Size 9138408 bytes Variable Size 637534208 bytes Database Buffers 2030043136 bytes Redo Buffers 7634944 bytes Database mounted. SQL> alter database flashback on; Database altered. SQL> alter database force logging; Database altered. SQL> set linesize 250 SQL> select bytes from v$log; BYTES ---------- 209715200 209715200 209715200 SQL> col member format a100 SQL> select group#, member from v$logfile; GROUP# MEMBER ---------- ---------------------------------------------------------------------------------------------------- 1 +DATA/ORCL19/ONLINELOG/group_1.258.1022714111 1 +RECO/ORCL19/ONLINELOG/group_1.257.1022714115 2 +DATA/ORCL19/ONLINELOG/group_2.259.1022714121 2 +RECO/ORCL19/ONLINELOG/group_2.258.1022714125 3 +DATA/ORCL19/ONLINELOG/group_3.260.1022714131 3 +RECO/ORCL19/ONLINELOG/group_3.259.1022714135 6 rows selected. SQL> alter system set standby_file_management = auto scope = both sid = '*'; System altered. SQL> alter system set log_archive_config='DG_CONFIG=(orcl19,orcl19s)' scope=both sid='*'; System altered. SQL> alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl19' scope= both sid='*'; System altered. SQL> alter system set log_archive_dest_2='SERVICE=orcl19s VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl19s' scope=both sid='*'; System altered. SQL> alter system set DB_UNIQUE_NAME=orcl19 scope=spfile sid='*'; System altered. SQL> alter system set FAL_SERVER='orcl19s' scope=both sid='*'; System altered. SQL> alter system set FAL_CLIENT='orcl19' scope=both sid='*'; System altered. SQL> create pfile = '/tmp/pfile-orcl19.ora' from spfile; File created. SQL> select group#,thread#,bytes from v$log; GROUP# THREAD# BYTES ---------- ---------- ---------- 1 1 209715200 2 1 209715200 3 1 209715200 SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+RECO') size 209715200; Database altered. SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+RECO') size 209715200; Database altered. SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+RECO') size 209715200; Database altered. SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+RECO') size 209715200; Database altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 2684350696 bytes Fixed Size 9138408 bytes Variable Size 637534208 bytes Database Buffers 2030043136 bytes Redo Buffers 7634944 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ORCL19 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19) ) ) [oracle@orcl19p ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ORCL19 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19) ) ) ORCL19S = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19s) (UR = A) ) ) [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ tnsping ORCL19S TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 27-OCT-2019 17:54:16 Copyright (c) 1997, 2019, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19s) (UR = A))) OK (10 msec) [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ logout [root@orcl19p ~]# [root@orcl19p ~]# [grid@orcl19p ~]$ [grid@orcl19p ~]$ asmcmd ASMCMD> cd +DATA ASMCMD> cd ORCL19 ASMCMD> ls -l Type Redund Striped Time Sys Name Y 95D7C2B2568F0A70E0533205A00AC96B/ Y 95D86C40430C3E85E0533205A00A0EBA/ Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ Y PASSWORD/ Y TEMPFILE/ ASMCMD> ls -l PASSWORD/ Type Redund Striped Time Sys Name PASSWORD UNPROT COARSE OCT 26 23:00:00 Y pwdorcl19.256.1022714087 ASMCMD> ASMCMD> cp PASSWORD/pwdorcl19.256.1022714087 /tmp/orapworcl19 copying +DATA/ORCL19/PASSWORD/pwdorcl19.256.1022714087 -> /tmp/orapworcl19 ASMCMD> exit [grid@orcl19p ~]$ [grid@orcl19p ~]$ [grid@orcl19p ~]$ logout [root@orcl19p ~]# [root@orcl19p ~]# [root@orcl19p ~]# chown oracle:oinstall /tmp/orapworcl19 [root@orcl19p ~]# [root@orcl19p ~]# [root@orcl19p ~]# [root@orcl19p ~]# su - oracle Last login: Sun Oct 27 17:52:38 CET 2019 on pts/0 [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 27 17:57:31 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> show parameter _name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cdb_cluster_name string cell_offloadgroup_name string db_file_name_convert string db_name string orcl19 db_unique_name string orcl19 global_names boolean FALSE instance_name string orcl191 lock_name_space string log_file_name_convert string pdb_file_name_convert string processor_group_name string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string orcl19 SQL> SQL> alter database open; Database altered. SQL> alter system archive log current; System altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ scp /tmp/orapworcl19 orcl19s:/tmp/orapworcl19 oracle@orcl19s's password: orapworcl19 100% 2048 475.6KB/s 00:00 [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ scp /tmp/pfile-orcl19.ora orcl19s:/tmp/pfile-orcl19.ora oracle@orcl19s's password: pfile-orcl19.ora 100% 1723 3.6MB/s 00:00 [oracle@orcl19p ~]$ ##################################################################### NOW AT STANDBY SITE ##################################################################### [grid@orcl19s ~]$ cat $ORACLE_HOME/network/admin/listener.ora LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN2=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN3=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent [grid@orcl19s ~]$ [grid@orcl19s ~]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-NOV-2019 14:46:51 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 02-NOV-2019 14:44:54 Uptime 0 days 0 hr. 1 min. 56 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/orcl19s/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.160.6.50)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.160.6.54)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_RECO" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_SYSTEMDG" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... The command completed successfully [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ vi $ORACLE_HOME/network/admin/listener.ora [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ cat $ORACLE_HOME/network/admin/listener.ora LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN2=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN3=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl19s) (SID_NAME = orcl19s1) (ORACLE_HOME = /u01/app/oracle/product/19.0.0.0/dbhome_1) ) ) [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ lsnrctl reload LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-NOV-2019 14:47:09 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) The command completed successfully [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-NOV-2019 14:48:18 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 02-NOV-2019 14:44:54 Uptime 0 days 0 hr. 3 min. 23 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/orcl19s/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.160.6.50)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.160.6.54)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_RECO" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_SYSTEMDG" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "orcl19s" has 1 instance(s). Instance "orcl19s1", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ logout [root@orcl19s ~]# su - oracle Last login: Sat Nov 2 14:32:08 CET 2019 on pts/1 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat /tmp/pfile-orcl19.ora orcl191.__data_transfer_cache_size=0 orcl191.__db_cache_size=1895825408 orcl191.__inmemory_ext_roarea=0 orcl191.__inmemory_ext_rwarea=0 orcl191.__java_pool_size=0 orcl191.__large_pool_size=16777216 orcl191.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment orcl191.__pga_aggregate_target=1073741824 orcl191.__sga_target=2684354560 orcl191.__shared_io_pool_size=134217728 orcl191.__shared_pool_size=620756992 orcl191.__streams_pool_size=0 orcl191.__unified_pga_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/orcl19/adump' *.audit_trail='db' *.cluster_database=true *.compatible='19.0.0' *.control_files='+DATA/ORCL19/CONTROLFILE/current.257.1022714109','+RECO/ORCL19/CONTROLFILE/current.256.1022714109' *.db_block_size=8192 *.db_create_file_dest='+DATA' *.db_name='orcl19' *.db_recovery_file_dest='+RECO' *.db_recovery_file_dest_size=8g *.db_unique_name='ORCL19' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl19XDB)' *.enable_pluggable_database=true *.fal_server='orcl19s' *.fal_client='orcl19p' family:dw_helper.instance_mode='read-only' orcl191.instance_number=1 *.local_listener='-oraagent-dummy-' *.log_archive_config='DG_CONFIG=(orcl19,orcl19s)' *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl19' *.log_archive_dest_2='SERVICE=orcl19s VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl19s' *.log_archive_format='%t_%s_%r.dbf' *.nls_language='AMERICAN' *.nls_territory='AMERICA' *.open_cursors=300 *.pga_aggregate_target=1024m *.processes=300 *.remote_login_passwordfile='exclusive' *.sga_target=2560m *.standby_file_management='AUTO' orcl191.thread=1 *.undo_tablespace='UNDOTBS1' orcl191.undo_tablespace='UNDOTBS1' [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ vi /tmp/pfile-orcl19.ora [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat /tmp/pfile-orcl19.ora *.audit_file_dest='/u01/app/oracle/admin/orcl19s/adump' *.audit_trail='db' *.compatible='19.0.0' *.db_block_size=8192 *.db_create_file_dest='+DATA' *.db_name='orcl19' *.db_recovery_file_dest='+RECO' *.db_recovery_file_dest_size=8g *.db_unique_name='orcl19s' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl19SXDB)' *.enable_pluggable_database=true *.fal_server='orcl19p' *.fal_client='orcl19s' family:dw_helper.instance_mode='read-only' orcl19s1.instance_number=1 *.log_archive_config='DG_CONFIG=(orcl19,orcl19s)' *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl19s' *.log_archive_dest_2='SERVICE=orcl19 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl19' *.log_archive_format='%t_%s_%r.dbf' *.nls_language='AMERICAN' *.nls_territory='AMERICA' *.open_cursors=300 *.pga_aggregate_target=1024m *.processes=300 *.remote_login_passwordfile='exclusive' *.sga_target=2560m *.standby_file_management='AUTO' orcl19s1.thread=1 *.undo_tablespace='UNDOTBS1' orcl19s1.undo_tablespace='UNDOTBS1' orcl19s1.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.160.6.54)(PORT=1521))' orcl19s1.remote_listener='orcl19s-scan:1521' [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora cat: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora: No such file or directory [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora ORCL19 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19) ) ) #https://gemsofprogramming.wordpress.com/2014/02/28/rman-active-duplication-auxilary-fails-or-when-the-listener-stops-hearing/ #Duplicating from an active database DOES NOT WORK when connecting to an CLUSTER/SCAN adress! ORCL19S = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19s) (UR = A) (INSTANCE_NAME = orcl19s1) ) ) [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ export ORACLE_SID=orcl19s1 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ export NLS_DATE_FORMAT="DD/MM/RRRR HH24:MI:SS" [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ mkdir -p /u01/app/oracle/admin/orcl19s/adump [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 14:52:56 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount pfile = '/tmp/pfile-orcl19.ora'; ORACLE instance started. Total System Global Area 2684350696 bytes Fixed Size 9138408 bytes Variable Size 570425344 bytes Database Buffers 2097152000 bytes Redo Buffers 7634944 bytes SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ ##################################################################### NOW AT STANDBY SITE - GRID STATUS TO VERY LISTENER ##################################################################### [grid@orcl19s ~]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-NOV-2019 14:53:52 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 02-NOV-2019 14:44:54 Uptime 0 days 0 hr. 8 min. 57 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/orcl19s/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.160.6.50)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.160.6.54)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_RECO" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_SYSTEMDG" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "orcl19s" has 2 instance(s). Instance "orcl19s1", status UNKNOWN, has 1 handler(s) for this service... Instance "orcl19s1", status BLOCKED, has 1 handler(s) for this service... The command completed successfully [grid@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus sys/oracle@orcl19s as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 14:54:25 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cp /tmp/orapworcl19 /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapworcl19s1 [oracle@orcl19s ~]$ sqlplus sys/oracle@orcl19s as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 14:54:50 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ rman target sys/oracle@orcl19 auxiliary sys/oracle@orcl19s Recovery Manager: Release 19.0.0.0.0 - Production on Sat Nov 2 14:55:24 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL19 (DBID=324042554) connected to auxiliary database: ORCL19 (not mounted) RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK; Starting Duplicate Db at 02/11/2019 14:55:34 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=54 device type=DISK contents of Memory Script: { backup as copy reuse passwordfile auxiliary format '/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapworcl19s1' ; } executing Memory Script Starting backup at 02/11/2019 14:55:34 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=97 instance=orcl191 device type=DISK Finished backup at 02/11/2019 14:55:36 duplicating Online logs to Oracle Managed File (OMF) location duplicating Datafiles to Oracle Managed File (OMF) location contents of Memory Script: { sql clone "create spfile from memory"; shutdown clone immediate; startup clone nomount; restore clone from service 'orcl19' standby controlfile; } executing Memory Script sql statement: create spfile from memory Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 2684350696 bytes Fixed Size 9138408 bytes Variable Size 570425344 bytes Database Buffers 2097152000 bytes Redo Buffers 7634944 bytes Starting restore at 02/11/2019 14:56:24 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=46 device type=DISK channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04 output file name=+DATA/ORCL19S/CONTROLFILE/current.260.1023288987 output file name=+RECO/ORCL19S/CONTROLFILE/current.260.1023288989 Finished restore at 02/11/2019 14:56:30 contents of Memory Script: { sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter database mount standby database contents of Memory Script: { set newname for clone tempfile 1 to new; set newname for clone tempfile 2 to new; set newname for clone tempfile 3 to new; switch clone tempfile all; set newname for clone datafile 1 to new; set newname for clone datafile 2 to new; set newname for clone datafile 3 to new; set newname for clone datafile 4 to new; set newname for clone datafile 5 to new; set newname for clone datafile 6 to new; set newname for clone datafile 7 to new; set newname for clone datafile 8 to new; set newname for clone datafile 9 to new; set newname for clone datafile 10 to new; restore from nonsparse from service 'orcl19' clone database ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 1 to +DATA in control file renamed tempfile 2 to +DATA in control file renamed tempfile 3 to +DATA in control file executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 02/11/2019 14:56:35 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00001 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00002 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00003 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00004 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00005 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00006 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00007 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00008 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00009 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service orcl19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00010 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07 Finished restore at 02/11/2019 14:57:33 sql statement: alter system archive log current contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=11 STAMP=1023289053 file name=+DATA/ORCL19S/DATAFILE/system.259.1023288997 datafile 2 switched to datafile copy input datafile copy RECID=12 STAMP=1023289053 file name=+DATA/ORCL19S/95D7C2B2568F0A70E0533205A00AC96B/DATAFILE/system.269.1023289011 datafile 3 switched to datafile copy input datafile copy RECID=13 STAMP=1023289053 file name=+DATA/ORCL19S/DATAFILE/sysaux.258.1023289015 datafile 4 switched to datafile copy input datafile copy RECID=14 STAMP=1023289053 file name=+DATA/ORCL19S/95D7C2B2568F0A70E0533205A00AC96B/DATAFILE/sysaux.267.1023289021 datafile 5 switched to datafile copy input datafile copy RECID=15 STAMP=1023289053 file name=+DATA/ORCL19S/DATAFILE/undotbs1.262.1023289025 datafile 6 switched to datafile copy input datafile copy RECID=16 STAMP=1023289053 file name=+DATA/ORCL19S/95D7C2B2568F0A70E0533205A00AC96B/DATAFILE/undotbs1.265.1023289033 datafile 7 switched to datafile copy input datafile copy RECID=17 STAMP=1023289053 file name=+DATA/ORCL19S/DATAFILE/users.256.1023289035 datafile 8 switched to datafile copy input datafile copy RECID=18 STAMP=1023289053 file name=+DATA/ORCL19S/95D86C40430C3E85E0533205A00A0EBA/DATAFILE/system.263.1023289037 datafile 9 switched to datafile copy input datafile copy RECID=19 STAMP=1023289053 file name=+DATA/ORCL19S/95D86C40430C3E85E0533205A00A0EBA/DATAFILE/sysaux.266.1023289043 datafile 10 switched to datafile copy input datafile copy RECID=20 STAMP=1023289053 file name=+DATA/ORCL19S/95D86C40430C3E85E0533205A00A0EBA/DATAFILE/undotbs1.264.1023289047 Finished Duplicate Db at 02/11/2019 14:58:03 RMAN> exit Recovery Manager complete. [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 15:09:27 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> create pfile = '/tmp/pfile-aft-dup.ora' from spfile; File created. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat /tmp/pfile-aft-dup.ora orcl19s1.__data_transfer_cache_size=0 orcl19s1.__db_cache_size=2097152000 orcl19s1.__inmemory_ext_roarea=0 orcl19s1.__inmemory_ext_rwarea=0 orcl19s1.__java_pool_size=0 orcl19s1.__large_pool_size=16777216 *.__oracle_base='/u01/app/oracle'# ORACLE_BASE set from environment orcl19s1.__pga_aggregate_target=1073741824 *.__reload_lsnr='0'# lreg reload listener orcl19s1.__sga_target=2684354560 orcl19s1.__shared_io_pool_size=0 orcl19s1.__shared_pool_size=553648128 orcl19s1.__streams_pool_size=0 orcl19s1.__unified_pga_pool_size=0 *._always_anti_join='CHOOSE' *._always_semi_join='CHOOSE' *._b_tree_bitmap_plans=TRUE *._bloom_serial_filter='ON' *._complex_view_merging=TRUE *._compression_compatibility='19.0.0' *._diag_adr_trace_dest='/u01/app/oracle/diag/rdbms/orcl19s/orcl19s1/trace' *._ds_xt_split_count=1 *._eliminate_common_subexpr=TRUE *._fast_full_scan_enabled=TRUE *._generalized_pruning_enabled=TRUE *._gs_anti_semi_join_allowed=TRUE *._hang_resolution_scope='OFF'# _hang_resolution_scope updated by kjznhm *._improved_outerjoin_card=TRUE *._improved_row_length_enabled=TRUE *._index_join_enabled=TRUE *._key_vector_create_pushdown_threshold=20000 *._ksb_restart_policy_times='0','60','120','240'# internal update to set default *._left_nested_loops_random=TRUE *._mv_access_compute_fresh_data='ON' *._new_initial_join_orders=TRUE *._new_sort_cost_estimate=TRUE *._nlj_batching_enabled=1 *._optim_enhance_nnull_detection=TRUE *._optim_peek_user_binds=TRUE *._optimizer_ads_use_partial_results=TRUE *._optimizer_better_inlist_costing='ALL' *._optimizer_cbqt_or_expansion='ON' *._optimizer_cluster_by_rowid_control=129 *._optimizer_control_shard_qry_processing=65528 *._optimizer_cost_based_transformation='LINEAR' *._optimizer_cost_model='CHOOSE' *._optimizer_extended_cursor_sharing='UDO' *._optimizer_extended_cursor_sharing_rel='SIMPLE' *._optimizer_extended_stats_usage_control=192 *._optimizer_join_order_control=3 *._optimizer_max_permutations=2000 *._optimizer_mode_force=TRUE *._optimizer_native_full_outer_join='FORCE' *._optimizer_or_expansion='DEPTH' *._optimizer_proc_rate_level='BASIC' *._optimizer_system_stats_usage=TRUE *._optimizer_try_st_before_jppd=TRUE *._optimizer_use_cbqt_star_transformation=TRUE *._or_expand_nvl_predicate=TRUE *._ordered_nested_loop=TRUE *._parallel_broadcast_enabled=TRUE *._pivot_implementation_method='CHOOSE' *._pred_move_around=TRUE *._push_join_predicate=TRUE *._push_join_union_view=TRUE *._push_join_union_view2=TRUE *._px_dist_agg_partial_rollup_pushdown='ADAPTIVE' *._px_groupby_pushdown='FORCE' *._px_partial_rollup_pushdown='ADAPTIVE' *._px_shared_hash_join=FALSE *._px_wif_dfo_declumping='CHOOSE' *._sql_model_unfold_forloops='RUN_TIME' *._subquery_pruning_mv_enabled=FALSE *._table_scan_cost_plus_one=TRUE *._union_rewrite_for_gs='YES_GSET_MVS' *._unnest_subquery=TRUE *._use_column_stats_for_function=TRUE *._xt_sampling_scan_granules='ON' *.audit_file_dest='/u01/app/oracle/admin/orcl19s/adump' *.audit_trail='DB' *.compatible='19.0.0' *.connection_brokers='((TYPE=DEDICATED)(BROKERS=1))','((TYPE=EMON)(BROKERS=1))'# connection_brokers default value *.control_files='+DATA/ORCL19S/CONTROLFILE/current.260.1023288987','+RECO/ORCL19S/CONTROLFILE/current.260.1023288989'#Restore Controlfile *.core_dump_dest='/u01/app/oracle/diag/rdbms/orcl19s/orcl19s1/cdump' *.cpu_count=1 *.cpu_min_count='1' *.db_block_size=8192 *.db_create_file_dest='+DATA' *.db_name='orcl19' *.db_recovery_file_dest='+RECO' *.db_recovery_file_dest_size=8G *.db_unique_name='orcl19s' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl19SXDB)' *.enable_pluggable_database=TRUE *.fal_client='orcl19s' *.fal_server='orcl19p' *.instance_number=1 *.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.160.6.54)(PORT=1521))' *.log_archive_config='DG_CONFIG=(orcl19,orcl19s)' *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl19s' *.log_archive_dest_2='SERVICE=orcl19p VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl19p' *.log_archive_format='%t_%s_%r.dbf' *.log_buffer=7132K# log buffer update *.nls_language='AMERICAN' *.nls_territory='AMERICA' *.open_cursors=300 *.optimizer_mode='ALL_ROWS' *.pga_aggregate_target=1G *.plsql_warnings='DISABLE:ALL'# PL/SQL warnings at init.ora *.processes=300 *.query_rewrite_enabled='TRUE' *.remote_listener='orcl19s-scan:1521' *.remote_login_passwordfile='EXCLUSIVE' *.result_cache_max_size=13120K *.sga_target=2560M *.standby_file_management='AUTO' *.thread=1 *.undo_tablespace='UNDOTBS1' [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ vi /tmp/pfile-aft-dup.ora [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat /tmp/pfile-aft-dup.ora *.audit_file_dest='/u01/app/oracle/admin/orcl19s/adump' *.audit_trail='DB' *.compatible='19.0.0' *.connection_brokers='((TYPE=DEDICATED)(BROKERS=1))','((TYPE=EMON)(BROKERS=1))'# connection_brokers default value *.control_files='+DATA/ORCL19S/CONTROLFILE/current.260.1023288987','+RECO/ORCL19S/CONTROLFILE/current.260.1023288989'#Restore Controlfile *.core_dump_dest='/u01/app/oracle/diag/rdbms/orcl19s/orcl19s1/cdump' *.cpu_count=1 *.cpu_min_count='1' *.db_block_size=8192 *.db_create_file_dest='+DATA' *.db_name='orcl19' *.db_recovery_file_dest='+RECO' *.db_recovery_file_dest_size=8G *.db_unique_name='orcl19s' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl19SXDB)' *.enable_pluggable_database=TRUE *.fal_client='orcl19s' *.fal_server='orcl19p' *.instance_number=1 *.log_archive_config='DG_CONFIG=(orcl19,orcl19s)' *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl19s' *.log_archive_dest_2='SERVICE=orcl19p VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl19p' *.log_archive_format='%t_%s_%r.dbf' *.log_buffer=7132K# log buffer update *.nls_language='AMERICAN' *.nls_territory='AMERICA' *.open_cursors=300 *.optimizer_mode='ALL_ROWS' *.pga_aggregate_target=1G *.plsql_warnings='DISABLE:ALL'# PL/SQL warnings at init.ora *.processes=300 *.query_rewrite_enabled='TRUE' *.remote_login_passwordfile='EXCLUSIVE' *.result_cache_max_size=13120K *.sga_target=2560M *.standby_file_management='AUTO' orcl19s1.instance_number=1 orcl19s1.thread=1 orcl19s1.undo_tablespace='UNDOTBS1' orcl19s1.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.160.6.54)(PORT=1521))' orcl19s1.remote_listener='orcl19s-scan:1521' *.cluster_database=true [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 15:17:23 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> create spfile = '+DATA' from pfile = '/tmp/pfile-aft-dup.ora'; File created. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ exit logout [root@orcl19s ~]# [root@orcl19s ~]# [root@orcl19s ~]# su - grid Last login: Sat Nov 2 15:13:39 CET 2019 [grid@orcl19s ~]$ [grid@orcl19s ~]$ asmcmd ASMCMD> ASMCMD> cd +DATA/ORCL19S ASMCMD> ASMCMD> ls -l Type Redund Striped Time Sys Name Y 95D7C2B2568F0A70E0533205A00AC96B/ Y 95D86C40430C3E85E0533205A00A0EBA/ Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ ASMCMD> ASMCMD> ASMCMD> pwcopy --dbuniquename orcl19s '/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapworcl19s1' '+DATA/ORCL19S/orapworcl19s'; PRCD-1120 : The resource for database orcl19s could not be found. PRCR-1001 : Resource ora.orcl19s.db does not exist copying /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapworcl19s1 -> +DATA/ORCL19S/orapworcl19s ASMCMD-9453: failed to register password file as a CRS resource ASMCMD> ASMCMD> ASMCMD> ls -l Type Redund Striped Time Sys Name Y 95D7C2B2568F0A70E0533205A00AC96B/ Y 95D86C40430C3E85E0533205A00A0EBA/ Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ Y PASSWORD/ PASSWORD UNPROT COARSE NOV 02 15:00:00 N orapworcl19s => +DATA/ORCL19S/PASSWORD/pwdorcl19s.268.1023290373 ASMCMD> ASMCMD> ASMCMD> ASMCMD> ASMCMD> ASMCMD> ls -l PARAMETERFILE/ Type Redund Striped Time Sys Name PARAMETERFILE UNPROT COARSE NOV 02 15:00:00 Y spfile.272.1023290247 ASMCMD> ASMCMD> ASMCMD> mkalias +DATA/ORCL19S/PARAMETERFILE/spfile.272.1023290247 +DATA/ORCL19S/spfile.ora ASMCMD> ASMCMD> ls -l Type Redund Striped Time Sys Name Y 95D7C2B2568F0A70E0533205A00AC96B/ Y 95D86C40430C3E85E0533205A00A0EBA/ Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ Y PASSWORD/ PASSWORD UNPROT COARSE NOV 02 15:00:00 N orapworcl19s => +DATA/ORCL19S/PASSWORD/pwdorcl19s.268.1023290373 PARAMETERFILE UNPROT COARSE NOV 02 15:00:00 N spfile.ora => +DATA/ORCL19S/PARAMETERFILE/spfile.272.1023290247 ASMCMD> ASMCMD> exit [grid@orcl19s ~]$ [grid@orcl19s ~]$ logout [root@orcl19s ~]# [root@orcl19s ~]# [root@orcl19s ~]# [root@orcl19s ~]# su - oracle Last login: Sat Nov 2 15:05:21 CET 2019 on pts/1 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ export ORACLE_SID=orcl19s1 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ srvctl add database -d orcl19s -oraclehome /u01/app/oracle/product/19.0.0.0/dbhome_1 -dbtype RAC -spfile '+DATA/ORCL19S/spfile.ora' -pwfile '+DATA/ORCL19S/orapworcl19s' -role PHYSICAL_STANDBY -startoption MOUNT -stopoption IMMEDIATE -dbname orcl19 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ srvctl add instance -d orcl19s -i orcl19s1 -n orcl19s [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ srvctl stop database -d orcl19s -o immediate PRCC-1016 : orcl19s was already stopped [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 16:46:10 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ srvctl start database -d orcl19s [oracle@orcl19s ~]$ srvctl stop database -d orcl19s -o immediate [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora ORCL19 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19) ) ) ORCL19S = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19s) (UR = A) (INSTANE_NAME = orcl19s1) ) ) [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora ORCL19 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19) ) ) ORCL19S = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19s) ) ) [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ logout [root@orcl19s ~]# [root@orcl19s ~]# [root@orcl19s ~]# su - grid Last login: Sat Nov 2 16:44:00 CET 2019 [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ cat $ORACLE_HOME/network/admin/listener.ora LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN2=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN3=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl19s) (SID_NAME = orcl19s1) (ORACLE_HOME = /u01/app/oracle/product/19.0.0.0/dbhome_1) ) ) [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ vi $ORACLE_HOME/network/admin/listener.ora [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ cat $ORACLE_HOME/network/admin/listener.ora LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN2=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN3=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ lsnrctl reload LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-NOV-2019 16:50:46 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) The command completed successfully [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ logout [root@orcl19s ~]# [root@orcl19s ~]# [root@orcl19s ~]# su - oracle Last login: Sat Nov 2 15:22:22 CET 2019 on pts/1 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ export ORACLE_SID=orcl19s1 [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 17:10:56 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19s ~]$ sqlplus sys/oracle@orcl19s as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 17:11:01 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ ##################################################################### NOW AT PRIMARY SITE ##################################################################### [oracle@orcl19p ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 17:12:53 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> alter system set dg_broker_config_file1='+DATA/ORCL19/dr1ORCL19.dat' scope = spfile sid = '*'; System altered. SQL> alter system set dg_broker_config_file2='+RECO/ORCL19/dr2ORCL19.dat' scope = spfile sid = '*'; System altered. SQL> alter system set dg_broker_start=true scope = spfile sid = '*'; System altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ srvctl stop database -d orcl19 [oracle@orcl19p ~]$ srvctl start database -d orcl19 [oracle@orcl19p ~]$ ##################################################################### NOW AT STANDBY SITE ##################################################################### [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 2 17:16:57 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> alter system set dg_broker_config_file1='+DATA/ORCL19S/dr1ORCL19s.dat' scope = spfile sid = '*'; System altered. SQL> alter system set dg_broker_config_file2='+RECO/ORCL19S/dr2ORCL19s.dat' scope = spfile sid = '*'; System altered. SQL> alter system set dg_broker_start=true scope = spfile sid = '*'; System altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ srvctl stop database -d orcl19s -o immediate [oracle@orcl19s ~]$ srvctl start database -d orcl19s [oracle@orcl19s ~]$ ##################################################################### NOW AT PRIMARY SITE ##################################################################### [oracle@orcl19p ~]$ dgmgrl sys/oracle@orcl19 DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sat Nov 2 17:25:44 2019 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "ORCL19" Connected as SYSDBA. DGMGRL> CREATE CONFIGURATION orcl19 AS PRIMARY DATABASE IS orcl19 CONNECT IDENTIFIER IS orcl19; Configuration "orcl19" created with primary database "orcl19" DGMGRL> DGMGRL> DGMGRL> DGMGRL> ADD DATABASE orcl19s AS CONNECT IDENTIFIER IS orcl19s MAINTAINED AS PHYSICAL; Database "orcl19s" added DGMGRL> DGMGRL> show configuration verbose; Configuration - orcl19 Protection Mode: MaxPerformance Members: orcl19 - Primary database orcl19s - Physical standby database Properties: FastStartFailoverThreshold = '30' OperationTimeout = '30' TraceLevel = 'USER' FastStartFailoverLagLimit = '30' CommunicationTimeout = '180' ObserverReconnect = '0' FastStartFailoverAutoReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'ALL' ObserverOverride = 'FALSE' ExternalDestination1 = '' ExternalDestination2 = '' PrimaryLostWriteAction = 'CONTINUE' ConfigurationWideServiceName = 'orcl19_CFG' Fast-Start Failover: Disabled Configuration Status: DISABLED DGMGRL> DGMGRL> enable configuration Enabled. DGMGRL> show configuration verbose; Configuration - orcl19 Protection Mode: MaxPerformance Members: orcl19 - Primary database orcl19s - Physical standby database Properties: FastStartFailoverThreshold = '30' OperationTimeout = '30' TraceLevel = 'USER' FastStartFailoverLagLimit = '30' CommunicationTimeout = '180' ObserverReconnect = '0' FastStartFailoverAutoReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'ALL' ObserverOverride = 'FALSE' ExternalDestination1 = '' ExternalDestination2 = '' PrimaryLostWriteAction = 'CONTINUE' ConfigurationWideServiceName = 'orcl19_CFG' Fast-Start Failover: Disabled Configuration Status: SUCCESS DGMGRL> DGMGRL> show database verbose orcl19s Database - orcl19s Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 0 seconds ago) Apply Lag: 0 seconds (computed 0 seconds ago) Average Apply Rate: 761.00 KByte/s Active Apply Rate: 0 Byte/s Maximum Apply Rate: 0 Byte/s Real Time Query: OFF Instance(s): orcl19s1 Properties: DGConnectIdentifier = 'orcl19s' ObserverConnectIdentifier = '' FastStartFailoverTarget = '' PreferredObserverHosts = '' LogShipping = 'ON' RedoRoutes = '' LogXptMode = 'ASYNC' DelayMins = '0' Binding = 'OPTIONAL' MaxFailure = '0' ReopenSecs = '300' NetTimeout = '30' RedoCompression = 'DISABLE' PreferredApplyInstance = '' ApplyInstanceTimeout = '0' ApplyLagThreshold = '30' TransportLagThreshold = '30' TransportDisconnectedThreshold = '30' ApplyParallel = 'AUTO' ApplyInstances = '0' StandbyFileManagement = '' ArchiveLagTarget = '0' LogArchiveMaxProcesses = '0' LogArchiveMinSucceedDest = '0' DataGuardSyncLatency = '0' LogArchiveTrace = '0' LogArchiveFormat = '' DbFileNameConvert = '' LogFileNameConvert = '' ArchiveLocation = '' AlternateLocation = '' StandbyArchiveLocation = '' StandbyAlternateLocation = '' InconsistentProperties = '(monitor)' InconsistentLogXptProps = '(monitor)' LogXptStatus = '(monitor)' SendQEntries = '(monitor)' RecvQEntries = '(monitor)' HostName = 'orcl19s.oralocal' StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.160.6.54)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl19s_DGMGRL)(INSTANCE_NAME=orcl19s1)(SERVER=DEDICATED)))' TopWaitEvents = '(monitor)' SidName = '(monitor)' Log file locations: Alert log : /u01/app/oracle/diag/rdbms/orcl19s/orcl19s1/trace/alert_orcl19s1.log Data Guard Broker log : /u01/app/oracle/diag/rdbms/orcl19s/orcl19s1/trace/drcorcl19s1.log Database Status: SUCCESS DGMGRL> DGMGRL> show database verbose orcl19 Database - orcl19 Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): orcl191 Properties: DGConnectIdentifier = 'orcl19' ObserverConnectIdentifier = '' FastStartFailoverTarget = '' PreferredObserverHosts = '' LogShipping = 'ON' RedoRoutes = '' LogXptMode = 'ASYNC' DelayMins = '0' Binding = 'optional' MaxFailure = '0' ReopenSecs = '300' NetTimeout = '30' RedoCompression = 'DISABLE' PreferredApplyInstance = '' ApplyInstanceTimeout = '0' ApplyLagThreshold = '30' TransportLagThreshold = '30' TransportDisconnectedThreshold = '30' ApplyParallel = 'AUTO' ApplyInstances = '0' StandbyFileManagement = '' ArchiveLagTarget = '0' LogArchiveMaxProcesses = '0' LogArchiveMinSucceedDest = '0' DataGuardSyncLatency = '0' LogArchiveTrace = '0' LogArchiveFormat = '' DbFileNameConvert = '' LogFileNameConvert = '' ArchiveLocation = '' AlternateLocation = '' StandbyArchiveLocation = '' StandbyAlternateLocation = '' InconsistentProperties = '(monitor)' InconsistentLogXptProps = '(monitor)' LogXptStatus = '(monitor)' SendQEntries = '(monitor)' RecvQEntries = '(monitor)' HostName = 'orcl19p.oralocal' StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.160.5.54)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL19_DGMGRL)(INSTANCE_NAME=orcl191)(SERVER=DEDICATED)))' TopWaitEvents = '(monitor)' SidName = '(monitor)' Log file locations: Alert log : /u01/app/oracle/diag/rdbms/orcl19/orcl191/trace/alert_orcl191.log Data Guard Broker log : /u01/app/oracle/diag/rdbms/orcl19/orcl191/trace/drcorcl191.log Database Status: SUCCESS DGMGRL> DGMGRL> validate NETWORK CONFIGURATION FOR ALL; Connecting to instance "orcl191" on database "orcl19" ... Connected to "ORCL19" Checking connectivity from instance "orcl191" on database "orcl19 to instance "orcl19s1" on database "orcl19s"... Succeeded. Connecting to instance "orcl19s1" on database "orcl19s" ... Connected to "orcl19s" Checking connectivity from instance "orcl19s1" on database "orcl19s to instance "orcl191" on database "orcl19"... Succeeded. Oracle Clusterware on database "orcl19" is available for database restart. Oracle Clusterware on database "orcl19s" is available for database restart. DGMGRL> VALIDATE STATIC CONNECT IDENTIFIER FOR ALL; Oracle Clusterware on database "orcl19" is available for database restart. Oracle Clusterware on database "orcl19s" is available for database restart. DGMGRL> DGMGRL> EDIT DATABASE orcl19 SET PROPERTY 'LogXptMode'='SYNC'; Property "LogXptMode" updated DGMGRL> EDIT DATABASE orcl19s SET PROPERTY 'LogXptMode'='SYNC'; Property "LogXptMode" updated DGMGRL> DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; Succeeded. DGMGRL> DGMGRL> show configuration verbose; Configuration - orcl19 Protection Mode: MaxAvailability Members: orcl19 - Primary database orcl19s - Physical standby database Properties: FastStartFailoverThreshold = '30' OperationTimeout = '30' TraceLevel = 'USER' FastStartFailoverLagLimit = '0' CommunicationTimeout = '180' ObserverReconnect = '0' FastStartFailoverAutoReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'ALL' ObserverOverride = 'FALSE' ExternalDestination1 = '' ExternalDestination2 = '' PrimaryLostWriteAction = 'CONTINUE' ConfigurationWideServiceName = 'orcl19_CFG' Fast-Start Failover: Disabled Configuration Status: SUCCESS DGMGRL> DGMGRL> exit [oracle@orcl19p ~]$