[oracle@orcl19p ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 14 13:27:24 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.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; startup mount; Database closed. Database dismounted. ORACLE instance shut down. SQL> ORACLE instance started. Total System Global Area 2147482336 bytes Fixed Size 9136864 bytes Variable Size 603979776 bytes Database Buffers 1526726656 bytes Redo Buffers 7639040 bytes Database mounted. SQL> 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> SQL> col member format a100 SQL> select group#, member from v$logfile; GROUP# MEMBER ---------- ---------------------------------------------------------------------------------------------------- 1 +DATA/DG19/ONLINELOG/group_1.258.999299485 1 +RECO/DG19/ONLINELOG/group_1.257.999299489 2 +DATA/DG19/ONLINELOG/group_2.259.999299495 2 +RECO/DG19/ONLINELOG/group_2.258.999299499 3 +DATA/DG19/ONLINELOG/group_3.260.999299503 3 +RECO/DG19/ONLINELOG/group_3.259.999299509 4 +DATA/DG19/ONLINELOG/group_4.276.1005574117 4 +RECO/DG19/ONLINELOG/group_4.266.1005574121 5 +DATA/DG19/ONLINELOG/group_5.277.1005574135 5 +RECO/DG19/ONLINELOG/group_5.267.1005574139 6 +DATA/DG19/ONLINELOG/group_6.278.1005574145 GROUP# MEMBER ---------- ---------------------------------------------------------------------------------------------------- 6 +RECO/DG19/ONLINELOG/group_6.268.1005574149 7 +DATA/DG19/ONLINELOG/group_7.279.1005574155 7 +RECO/DG19/ONLINELOG/group_7.269.1005574159 14 rows selected. SQL> SQL> alter system set standby_file_management = auto scope = both sid = '*'; System altered. SQL> SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.0.0.0 [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.2.0.B2/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_DG19P = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p.oralocal)(PORT = 1521)) DG19 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p.oralocal)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dg19) ) ) [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.2.0.B2/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_DG19P = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p.oralocal)(PORT = 1521)) DG19 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p.oralocal)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = dg19) ) ) DG19S = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s.oralocal)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = dg19s) ) ) [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ tnsping DG19S TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 14-APR-2019 14:31:23 Copyright (c) 1997, 2018, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s.oralocal)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = dg19s))) OK (0 msec) [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ exit logout [root@orcl19p ~]# su - grid Last login: Sun Apr 14 09:33:55 CEST 2019 [grid@orcl19p ~]$ [grid@orcl19p ~]$ [grid@orcl19p ~]$ cat $ORACLE_HOME/network/admin/listener.ora #Backup file is /u01/app/grid/crsdata/orcl19p/output/listener.ora.bak.orcl19p.grid line added by Agent # listener.ora Network Configuration File: /u01/app/19.2.0.B2/grid/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p.oralocal)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent [grid@orcl19p ~]$ [grid@orcl19p ~]$ [grid@orcl19p ~]$ [grid@orcl19p ~]$ [grid@orcl19p ~]$ vi $ORACLE_HOME/network/admin/listener.ora [grid@orcl19p ~]$ [grid@orcl19p ~]$ [grid@orcl19p ~]$ cat $ORACLE_HOME/network/admin/listener.ora #Backup file is /u01/app/grid/crsdata/orcl19p/output/listener.ora.bak.orcl19p.grid line added by Agent # listener.ora Network Configuration File: /u01/app/19.2.0.B2/grid/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p.oralocal)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dg19_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/19.2.0.B2/dbhome_1) (SID_NAME = dg19) ) ) [grid@orcl19p ~]$ [grid@orcl19p ~]$ [grid@orcl19p ~]$ lsnrctl reload LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 14-APR-2019 14:41:32 Copyright (c) 1991, 2018, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl19p.oralocal)(PORT=1521))) The command completed successfully [grid@orcl19p ~]$ [grid@orcl19p ~]$ exit logout [root@orcl19p ~]# [root@orcl19p ~]# su - oracle Last login: Sun Apr 14 14:42:04 CEST 2019 on pts/0 [oracle@orcl19p ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 14 14:43:15 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to an idle instance. SQL> show parameter _name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cdb_cluster_name string cell_offloadgroup_name string db_file_name_convert string db_name string dg19 db_unique_name string dg19 global_names boolean FALSE instance_name string dg19 lock_name_space string log_file_name_convert string pdb_file_name_convert string processor_group_name string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string dg19 SQL> SQL> alter database open; Database altered. SQL> alter system archive log current; System altered. SQL> SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.0.0.0 [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ scp $ORACLE_HOME/dbs/orapwdg19 orcl19s:$ORACLE_HOME/dbs/orapwdg19s oracle@orcl19s's password: orapwdg19 100% 2048 2.9MB/s 00:00 [oracle@orcl19p ~]$ ##################################################################### NOW AT STANDBY SERVER ##################################################################### [root@orcl19s ~]# [root@orcl19s ~]# su - grid Last login: Sun Apr 14 09:33:54 CEST 2019 [grid@orcl19s ~]$ cat $ORACLE_HOME/network/admin/listener.ora #Backup file is /u01/app/grid/crsdata/orcl19s/output/listener.ora.bak.orcl19s.grid line added by Agent # listener.ora Network Configuration File: /u01/app/19.2.0.B2/grid/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s.oralocal)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent [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 #Backup file is /u01/app/grid/crsdata/orcl19s/output/listener.ora.bak.orcl19s.grid line added by Agent # listener.ora Network Configuration File: /u01/app/19.2.0.B2/grid/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s.oralocal)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dg19s_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/19.2.0.B2/dbhome_1) (SID_NAME = dg19s) ) ) [grid@orcl19s ~]$ [grid@orcl19s ~]$ [grid@orcl19s ~]$ logout [root@orcl19s ~]# [root@orcl19s ~]# [root@orcl19s ~]# [root@orcl19s ~]# su - oracle Last login: Sun Feb 3 22:43:19 CET 2019 on pts/0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ export ORACLE_SID=dg19s [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 DG19 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19p.oralocal)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = dg19) ) ) DG19S = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19s.oralocal)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = dg19s) ) ) [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ mkdir -p /u01/app/oracle/admin/dg19/adump [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ vi /tmp/dg19s.ora [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ cat /tmp/dg19s.ora *.db_name='dg19' [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 14 15:29:06 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount pfile = '/tmp/dg19s.ora'; ORACLE instance started. Total System Global Area 243268208 bytes Fixed Size 8895088 bytes Variable Size 180355072 bytes Database Buffers 50331648 bytes Redo Buffers 3686400 bytes SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ export NLS_DATE_FORMAT="DD/MM/RRRR HH24:MI:SS" [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ rman target sys/oracle@dg19 auxiliary sys/oracle@dg19s Recovery Manager: Release 19.0.0.0.0 - Beta on Sun Apr 14 15:38:09 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: DG19 (DBID=1504141016) connected to auxiliary database: DG19 (not mounted) RMAN> RMAN> DUPLICATE TARGET DATABASE 2> FOR STANDBY 3> FROM ACTIVE DATABASE 4> DORECOVER 5> SPFILE 6> SET db_unique_name='dg19s' 7> NOFILENAMECHECK; Starting Duplicate Db at 14/04/2019 15:38:33 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=39 device type=DISK current log archived contents of Memory Script: { backup as copy reuse passwordfile auxiliary format '/u01/app/oracle/product/19.2.0.B2/dbhome_1/dbs/orapwdg19s' ; restore clone from service 'dg19' spfile to '/u01/app/oracle/product/19.2.0.B2/dbhome_1/dbs/spfiledg19s.ora'; sql clone "alter system set spfile= ''/u01/app/oracle/product/19.2.0.B2/dbhome_1/dbs/spfiledg19s.ora''"; } executing Memory Script Starting backup at 14/04/2019 15:38:34 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=92 device type=DISK Finished backup at 14/04/2019 15:38:35 Starting restore at 14/04/2019 15:38:36 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 dg19 channel ORA_AUX_DISK_1: restoring SPFILE output file name=/u01/app/oracle/product/19.2.0.B2/dbhome_1/dbs/spfiledg19s.ora channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 14/04/2019 15:38:39 sql statement: alter system set spfile= ''/u01/app/oracle/product/19.2.0.B2/dbhome_1/dbs/spfiledg19s.ora'' contents of Memory Script: { sql clone "alter system set db_unique_name = ''dg19s'' comment= '''' scope=spfile"; shutdown clone immediate; startup clone nomount; } executing Memory Script sql statement: alter system set db_unique_name = ''dg19s'' comment= '''' scope=spfile Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 2147482336 bytes Fixed Size 9136864 bytes Variable Size 603979776 bytes Database Buffers 1526726656 bytes Redo Buffers 7639040 bytes duplicating Online logs to Oracle Managed File (OMF) location duplicating Datafiles to Oracle Managed File (OMF) location contents of Memory Script: { sql clone "alter system set control_files = ''+DATA/DG19S/CONTROLFILE/current.257.1005579555'', ''+RECO/DG19S/CONTROLFILE/current.256.1005579555'' comment= ''Set by RMAN'' scope=spfile"; restore clone from service 'dg19' standby controlfile; } executing Memory Script sql statement: alter system set control_files = ''+DATA/DG19S/CONTROLFILE/current.257.1005579555'', ''+RECO/DG19S/CONTROLFILE/current.256.1005579555'' comment= ''Set by RMAN'' scope=spfile Starting restore at 14/04/2019 15:39:15 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 dg19 channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03 output file name=+DATA/DG19S/CONTROLFILE/current.259.1005579559 output file name=+RECO/DG19S/CONTROLFILE/current.258.1005579559 Finished restore at 14/04/2019 15:39:21 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; set newname for clone datafile 11 to new; restore from nonsparse from service 'dg19' 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 executing command: SET NEWNAME Starting restore at 14/04/2019 15:39:27 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 dg19 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:26 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service dg19 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:07 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service dg19 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:15 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service dg19 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:07 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service dg19 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 dg19 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:08 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service dg19 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:01 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service dg19 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 dg19 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:07 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service dg19 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 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: using network backup set from service dg19 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00011 to +DATA channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 Finished restore at 14/04/2019 15:41:01 sql statement: alter system archive log current current log archived contents of Memory Script: { restore clone force from service 'dg19' archivelog from scn 1396809; switch clone datafile all; } executing Memory Script Starting restore at 14/04/2019 15:41:01 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: using network backup set from service dg19 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=18 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: using network backup set from service dg19 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=19 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 14/04/2019 15:41:04 datafile 1 switched to datafile copy input datafile copy RECID=12 STAMP=1005579664 file name=+DATA/DG19S/DATAFILE/system.260.1005579569 datafile 2 switched to datafile copy input datafile copy RECID=13 STAMP=1005579664 file name=+DATA/DG19S/8105A9E8B4064D4DE053016410AC782F/DATAFILE/system.261.1005579593 datafile 3 switched to datafile copy input datafile copy RECID=14 STAMP=1005579664 file name=+DATA/DG19S/DATAFILE/sysaux.262.1005579601 datafile 4 switched to datafile copy input datafile copy RECID=15 STAMP=1005579664 file name=+DATA/DG19S/8105A9E8B4064D4DE053016410AC782F/DATAFILE/sysaux.263.1005579615 datafile 5 switched to datafile copy input datafile copy RECID=16 STAMP=1005579664 file name=+DATA/DG19S/DATAFILE/undotbs1.264.1005579623 datafile 6 switched to datafile copy input datafile copy RECID=17 STAMP=1005579664 file name=+DATA/DG19S/8105A9E8B4064D4DE053016410AC782F/DATAFILE/undotbs1.265.1005579631 datafile 7 switched to datafile copy input datafile copy RECID=18 STAMP=1005579664 file name=+DATA/DG19S/DATAFILE/users.266.1005579637 datafile 8 switched to datafile copy input datafile copy RECID=19 STAMP=1005579664 file name=+DATA/DG19S/8106653B19CA6636E053016410AC3C21/DATAFILE/system.267.1005579639 datafile 9 switched to datafile copy input datafile copy RECID=20 STAMP=1005579664 file name=+DATA/DG19S/8106653B19CA6636E053016410AC3C21/DATAFILE/sysaux.268.1005579645 datafile 10 switched to datafile copy input datafile copy RECID=21 STAMP=1005579664 file name=+DATA/DG19S/8106653B19CA6636E053016410AC3C21/DATAFILE/undotbs1.269.1005579653 datafile 11 switched to datafile copy input datafile copy RECID=22 STAMP=1005579664 file name=+DATA/DG19S/8106653B19CA6636E053016410AC3C21/DATAFILE/users.270.1005579661 contents of Memory Script: { set until scn 1396990; recover standby clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 14/04/2019 15:41:04 using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 18 is already on disk as file +RECO/DG19S/ARCHIVELOG/2019_04_14/thread_1_seq_18.259.1005579663 archived log for thread 1 with sequence 19 is already on disk as file +RECO/DG19S/ARCHIVELOG/2019_04_14/thread_1_seq_19.260.1005579663 archived log file name=+RECO/DG19S/ARCHIVELOG/2019_04_14/thread_1_seq_18.259.1005579663 thread=1 sequence=18 archived log file name=+RECO/DG19S/ARCHIVELOG/2019_04_14/thread_1_seq_19.260.1005579663 thread=1 sequence=19 media recovery complete, elapsed time: 00:00:00 Finished recover at 14/04/2019 15:41:06 contents of Memory Script: { delete clone force archivelog all; } executing Memory Script released channel: ORA_DISK_1 released channel: ORA_AUX_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=92 device type=DISK deleted archived log archived log file name=+RECO/DG19S/ARCHIVELOG/2019_04_14/thread_1_seq_18.259.1005579663 RECID=1 STAMP=1005579662 deleted archived log archived log file name=+RECO/DG19S/ARCHIVELOG/2019_04_14/thread_1_seq_19.260.1005579663 RECID=2 STAMP=1005579663 Deleted 2 objects Finished Duplicate Db at 14/04/2019 15:42:08 RMAN> exit Recovery Manager complete. [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ ##################################################################### NOW AT PRIMARY SERVER ##################################################################### [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 14 15:44:12 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.0.0.0 SQL> ALTER SYSTEM SET dg_broker_start=true; System altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.0.0.0 [oracle@orcl19p ~]$ ##################################################################### NOW AT STANDBY SERVER ##################################################################### [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 14 15:44:20 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.0.0.0 SQL> ALTER SYSTEM SET dg_broker_start=true; System altered. SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u01/app/oracle/product/19.2.0 .B2/dbhome_1/dbs/spfiledg19s.o ra SQL> SQL> show parameter unique NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_unique_name string dg19s SQL> show parameter db_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_name string dg19 SQL> SQL> create pfile = '/tmp/pfiledg19s.ora' from spfile = '/u01/app/oracle/product/19.2.0.B2/dbhome_1/dbs/spfiledg19s.ora'; File created. SQL> create spfile = '+DATA' from pfile = '/tmp/pfiledg19s.ora'; File created. SQL> SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ logout [root@orcl19s ~]# su - grid Last login: Sun Apr 14 16:38:06 CEST 2019 on pts/0 [grid@orcl19s ~]$ asmcmd ASMCMD> ls -l +DATA/DG19S Type Redund Striped Time Sys Name Y 8105A9E8B4064D4DE053016410AC782F/ Y 8106653B19CA6636E053016410AC3C21/ Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ ASMCMD> ls -l +DATA/DG19S/PARAMETERFILE/ Type Redund Striped Time Sys Name PARAMETERFILE UNPROT COARSE APR 14 16:00:00 Y spfile.278.1005583325 ASMCMD> exit [grid@orcl19s ~]$ logout [root@orcl19s ~]# su - oracle Last login: Sun Apr 14 16:40:22 CEST 2019 on pts/0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ srvctl add database -db dg19s -oraclehome /u01/app/oracle/product/19.2.0.B2/dbhome_1 -spfile +DATA/DG19S/PARAMETERFILE/spfile.278.1005583325 -pwfile /u01/app/oracle/product/19.2.0.B2/dbhome_1/dbs/orapwdg19s -role PHYSICAL_STANDBY -startoption "READ ONLY" -stopoption IMMEDIATE -dbname dg19 -diskgroup DATA,RECO [oracle@orcl19s ~]$ ##################################################################### NOW AT PRIMARY SERVER ##################################################################### [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ dgmgrl sys/oracle@dg19 DGMGRL for Linux: Release 19.0.0.0.0 - Beta on Sun Apr 14 15:45:33 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "dg19" Connected as SYSDBA. DGMGRL> DGMGRL> CREATE CONFIGURATION dg19b2 AS PRIMARY DATABASE IS dg19 CONNECT IDENTIFIER IS dg19; Configuration "dg19b2" created with primary database "dg19" DGMGRL> DGMGRL> ADD DATABASE dg19s AS CONNECT IDENTIFIER IS dg19s MAINTAINED AS PHYSICAL; Database "dg19s" added DGMGRL> DGMGRL> show configuration verbose; Configuration - dg19b2 Protection Mode: MaxPerformance Members: dg19 - Primary database dg19s - 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 = 'dg19_CFG' Fast-Start Failover: Disabled Configuration Status: DISABLED DGMGRL> DGMGRL> enable configuration Enabled. DGMGRL> show configuration verbose; Configuration - dg19b2 Protection Mode: MaxPerformance Members: dg19 - Primary database dg19s - 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 = 'dg19_CFG' Fast-Start Failover: Disabled Configuration Status: SUCCESS DGMGRL> DGMGRL> show database verbose dg19s Database - dg19s Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seconds (computed 1 second ago) Average Apply Rate: 91.00 KByte/s Active Apply Rate: 0 Byte/s Maximum Apply Rate: 0 Byte/s Real Time Query: OFF Instance(s): dg19s Properties: DGConnectIdentifier = 'dg19s' 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=orcl19s.oralocal)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dg19s_DGMGRL)(INSTANCE_NAME=dg19s)(SERVER=DEDICATED)))' TopWaitEvents = '(monitor)' SidName = '(monitor)' Log file locations: Alert log : /u01/app/oracle/diag/rdbms/dg19s/dg19s/trace/alert_dg19s.log Data Guard Broker log : /u01/app/oracle/diag/rdbms/dg19s/dg19s/trace/drcdg19s.log Database Status: SUCCESS DGMGRL> DGMGRL> EDIT DATABASE dg19s SET PROPERTY 'LogXptMode'='SYNC'; Property "LogXptMode" updated DGMGRL> DGMGRL> EDIT DATABASE dg19 SET PROPERTY 'LogXptMode'='SYNC'; Property "LogXptMode" updated DGMGRL> DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; Succeeded. DGMGRL> DGMGRL> show configuration verbose Configuration - dg19b2 Protection Mode: MaxAvailability Members: dg19 - Primary database dg19s - 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 = 'dg19_CFG' Fast-Start Failover: Disabled Configuration Status: SUCCESS DGMGRL> DGMGRL> exit [oracle@orcl19p ~]$ ##################################################################### NOW AT STANDBY SERVER ##################################################################### [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 14 16:49:21 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.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 - Beta Version 19.2.0.0.0 [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ [oracle@orcl19s ~]$ srvctl start database -d dg19s [oracle@orcl19s ~]$ ##################################################################### NOW AT PRIMARY SERVER ##################################################################### [oracle@orcl19p ~]$ dgmgrl sys/oracle@dg19 DGMGRL for Linux: Release 19.0.0.0.0 - Beta on Sun Apr 14 16:52:15 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "dg19" Connected as SYSDBA. DGMGRL> show configuration verbose Configuration - dg19b2 Protection Mode: MaxAvailability Members: dg19 - Primary database dg19s - 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 = 'dg19_CFG' Fast-Start Failover: Disabled Configuration Status: SUCCESS DGMGRL> DGMGRL> show database verbose dg19s Database - dg19s Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seconds (computed 1 second ago) Average Apply Rate: 1.00 KByte/s Active Apply Rate: 0 Byte/s Maximum Apply Rate: 0 Byte/s Real Time Query: ON Instance(s): dg19s Properties: DGConnectIdentifier = 'dg19s' ObserverConnectIdentifier = '' FastStartFailoverTarget = '' PreferredObserverHosts = '' LogShipping = 'ON' RedoRoutes = '' LogXptMode = 'SYNC' 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=orcl19s.oralocal)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dg19s_DGMGRL)(INSTANCE_NAME=dg19s)(SERVER=DEDICATED)))' TopWaitEvents = '(monitor)' SidName = '(monitor)' Log file locations: Alert log : /u01/app/oracle/diag/rdbms/dg19s/dg19s/trace/alert_dg19s.log Data Guard Broker log : /u01/app/oracle/diag/rdbms/dg19s/dg19s/trace/drcdg19s.log Database Status: SUCCESS DGMGRL> DGMGRL> exit [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ [oracle@orcl19p ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 14 16:53:40 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta Version 19.2.0.0.0 SQL> SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 DGPDB MOUNTED SQL> alter pluggable database DGPDB open instances = all; Pluggable database altered. SQL>