Dataguard setup for Exadata gen2 at Customer – detailed version.<\/p>\n\n\n
For this post, I will present how I created the dataguard – duplicated database at same cluster. There is a couple of steps to be completed and – many errors can occur if the steps are not followed correctly. Let’s create a list with the brief of steps for each step to be completed to archive success for this configuration. Got some issues with # character in password.<\/p>\n\n\n
SOURCE Database<\/strong><\/p>\n\n\n TARGET Database<\/strong><\/p>\n\n\n To create source – boston database<\/strong><\/p>\n\n\n <\/p>\n\n\n Archivelog and Force Logging<\/strong><\/p>\n\n\n Create standby redo logs – Need create one more than redo groups on boston.<\/strong><\/p>\n\n\n Update password file<\/strong><\/p>\n\n\n Target – starting london1 instance<\/strong><\/p>\n\n\n Source database – Boston status<\/strong><\/p>\n\n\n Listener reload (update all nodes) <\/p>\n\n\n We need update again at final to finish configuration if target have instances running on all nodes. We need start with london1 running on host01 and boston running on all nodes.<\/p><\/blockquote>\n\n\n Reload listener and force register for more static services<\/strong><\/p>\n\n\n Update tnsnames.ora and listener.ora<\/strong><\/p>\n\n\n Test Connectivity<\/strong> – boston and london – TEST IT in all NODES !!!!<\/p>\n\n\n Copy wallet files from BOSTON to LONDON<\/strong><\/p>\n\n\n Make sure the wallet from BOSTON is same on LONDON. Make sure you have a copy from wallet before start to deal with it.<\/p>\n\n\n Check sqlnet.ora the location and make properly copy of files:<\/p>\n\n\n Duplicate database<\/strong><\/p>\n\n\n Configure Dataguard<\/strong> – Activate Dataguard Broker on london and boston<\/p>\n\n\n Create asm directory to Dataguard Broker configuration files<\/strong><\/p>\n\n\n Check alert log of Dataguard Broker<\/strong> <\/p>\n\n\n Configure Flashback Database in London<\/strong> – In case of failover – reinstate database will not work if this not configured properly in London ( standby )<\/p>\n\n\n Configure Dataguard Broker<\/strong> – Create configuration<\/p>\n\n\n Final checks<\/strong><\/p>\n\n\n Errors and solutions<\/strong><\/p>\n\n\n Some usefull commands to be used on Dataguard Broker dgmgrl<\/strong><\/p>\n\n\n glogin update<\/strong><\/p>\n\n\n Check if wallet is in use on boston and london<\/strong><\/p>\n\n\n ACE<\/a>\nBe updated from the changes on your favorites documents on MOS<\/a>\ncheck oracle database<\/a>\nconvert database snapshot<\/a>\nDataGuard Exadata<\/a>\nDataguard RAC<\/a>\ndbaascli<\/a>\nDBMS_JOB<\/a>\nduplicate auxiliary<\/a>\nDUPLICATE fail with ORA-38788<\/a>\nduplicate using backup location<\/a>\nEM_LOADERJOB<\/a>\nEM_LOADERJOB.unlock_target<\/a>\nEXACC<\/a>\nexachk<\/a>\nExadata Cloud at customer Gen2<\/a>\nEXADATA GEN2<\/a>\nExadata Patch 19c<\/a>\nlinux kernel best practices<\/a>\nlinux kernel parameters<\/a>\nMetalink update you<\/a>\nMissing UNLOCK_TARGET<\/a>\nMove from DBMS_JOB to DBMS_SCHEDULER<\/a>\nOEM alert log growing<\/a>\nopatch<\/a>\nOPATCHAUTO-72043<\/a>\nORA-01261<\/a>\nORA-09925<\/a>\nORA-12514<\/a>\nORA-27300<\/a>\nORA-27301<\/a>\nORA-27302<\/a>\nORA-38784<\/a>\nORA-38788<\/a>\nORA-38788: More standby database recovery is needed<\/a>\noracle duplicate failure<\/a>\nrda<\/a>\nReceive updates from MOS<\/a>\nrecover database<\/a>\nRMAN-04014<\/a>\nRMAN-06403.<\/a>\ntablespace size<\/a>\ntablespace sysaux<\/a>\ntfa<\/a>\nWARNING: too many parse errors<\/a><\/p>\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" Dataguard setup for Exadata gen2 at Customer – detailed version. For this post, I will present how I created the dataguard – duplicated database at same cluster. There is a couple of steps to be completed and – many errors … Continue lendo [18.0.0.0 SID:boston1][oracle@tech01:\/home\/oracle ] ~$ srvctl config database -d boston\nDatabase unique name: boston\nDatabase name:\nOracle home: \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\nOracle user: oracle\nSpfile: +DATA\/boston\/spfile.ora\nPassword file: +datac1\/boston\/password\/passwd\nDomain: techmax.domain\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools:\nDisk Groups: DATAC1\nMount point paths:\nServices: boston1\nType: RAC\nStart concurrency:\nStop concurrency:\nOSDBA group: dba\nOSOPER group: racoper\nDatabase instances: boston1,boston2,boston3,boston4\nConfigured nodes: tech01,tech02,tech03,tech04\nCSS critical: no\nCPU count: 0\nMemory target: 0\nMaximum memory: 0\nDefault network number for database services:\nDatabase is administrator managed\n[18.0.0.0 SID:boston1][oracle@tech01:\/home\/oracle ] ~$\nsrvctl getenv database -d boston\nboston:\nTNS_ADMIN=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/boston\n<\/code><\/pre>\n\n\n[18.0.0.0 SID:boston1][oracle@tech01:\/home\/oracle ] ~$ srvctl config database -d london\nDatabase unique name: london\nDatabase name:\nOracle home: \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\nOracle user: oracle\nSpfile: \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/spfilelondon1.ora\nPassword file: \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/orapwlondon\nDomain: techmax.domain\nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools:\nDisk Groups: DATAC1,RECOC1\nMount point paths:\nServices:\nType: RAC\nStart concurrency:\nStop concurrency:\nOSDBA group: dba\nOSOPER group: racoper\nDatabase instances: london1\nConfigured nodes: tech01\nCSS critical: no\nCPU count: 0\nMemory target: 0\nMaximum memory: 0\nDefault network number for database services:\nDatabase is administrator managed\n[18.0.0.0 SID:boston1][oracle@tech01:\/home\/oracle ] ~$\nsrvctl getenv database -d london\nlondon:\nTNS_ADMIN=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/london\n<\/code><\/pre>\n\n\ncreate json file: boston.json\n{\n\"object\": \"db\",\n\"action\": \"start\",\n\"operation\": \"createdb\",\n\"params\": {\n\"nodelist\": \"\",\n\"dbname\": \"boston\",\n\"edition\": \"EE_EP\",\n\"version\": \"12.2.0.0\",\n\"ohome_name\": \"OraHome3\",\n\"adminPassword\": \" WElc0me__0\",\n\"sid\": \"boston\",\n\"pdbName\": \"PDB1\",\n\"charset\": \"WE8MSWIN1252\",\n\"ncharset\": \"AL16UTF16\",\n\"backupDestination\": \"NONE\" },\n\"outputfile\": \"\/home\/oracle\/createdbboston.out\",\n\"FLAGS\": \"\"\n}\nCreate jason to check status: checkstatusboston.json\n{\n \"object\": \"db\",\n \"action\": \"status\",\n \"operation\": \"createdb\",\n \"id\": 170,\n \"params\": {\n \"dbname\": \"boston\"\n },\n \"outputfile\": \"\/home\/oracle\/createdb.out\",\n \"FLAGS\": \"\"\n}\n\/var\/opt\/oracle\/dbaasapi\/dbaasapi -i boston.json<\/code><\/pre>\n\n\n[18.0.0.0 SID:boston1][oracle@tech01:\/home\/oracle ] ~$ sqlplus \/ as sysdba\nSQL*Plus: Release 18.0.0.0.0 - Production on Wed May 27 20:55:06 2020\nVersion 18.6.0.0.0\nCopyright (c) 1982, 2018, Oracle. All rights reserved.\nConnected to:\nOracle Database 18c EE Extreme Perf Release 18.0.0.0.0 - Production\nVersion 18.6.0.0.0\nDB_UNIQUE_NAME DATABASE_ROLE VERSION COMPATIBLE STATUS\n-------------------- ---------------- ---------- ---------- --------\nboston PRIMARY 18.0.0.0.0 12.2.0.1.0 MOUNTED\nHOST_NAME INSTANCE_NAME STATUS Startup time LOGINS CONNECTED\n---------------------------------- -------------- -------- ------------------ -------- --------------\ntech01.techmax.domain boston1 MOUNTED 27-MAY-2020 20:47 ALLOWED CURRENT\nSQL> alter database archivelog ;\nDatabase altered.\nSQL> ALTER DATABASE force logging;\nDatabase altered.\nSQL> SELECT force_logging FROM v$database;\nFORCE_LOGGING\n---------------------------------------\nYES\nSQL> quit\nDisconnected from Oracle Database 18c EE Extreme Perf Release 18.0.0.0.0 - Production\nVersion 18.6.0.0.0\n[18.0.0.0 SID:boston1][oracle@tech01:\/home\/oracle ] ~$\n<\/code><\/pre>\n\n\nSQL> select group#, thread#, bytes\/1024\/1024 from v$log order by thread#, group#;\n GROUP# THREAD# BYTES\/1024\/1024\n---------- ---------- ---------------\n 1 1 4000\n 2 1 4000\n 3 1 4000\n 4 1 4000\n 9 2 4000\n 10 2 4000\n 11 2 4000\n 12 2 4000\n 13 3 4000\n 14 3 4000\n 15 3 4000\n 16 3 4000\n 17 4 4000\n 18 4 4000\n 19 4 4000\n 20 4 4000\n16 rows selected.\nSQL>\nSQL> select group#, thread#, bytes\/1024\/1024 from v$standby_log order by thread#, group#;\n GROUP# THREAD# BYTES\/1024\/1024\n---------- ---------- ---------------\n 5 1 4000\n 6 1 4000\n 7 1 4000\n 8 1 4000\n 21 1 4000\n 22 2 4000\n 23 2 4000\n 24 2 4000\n 25 2 4000\n 26 2 4000\n 27 3 4000\n 28 3 4000\n 29 3 4000\n 30 3 4000\n 31 3 4000\n 32 4 4000\n 33 4 4000\n 34 4 4000\n 35 4 4000\n 36 4 4000\n20 rows selected.\nalter database add logfile thread 1 group 1 '+DATAC1' size 4000m;\nalter database add logfile thread 1 group 2 '+DATAC1' size 4000m;\nalter database add logfile thread 1 group 3 '+DATAC1' size 4000m;\nalter database add logfile thread 1 group 4 '+DATAC1' size 4000m;\nalter database add logfile thread 1 group 5 '+DATAC1' size 4000m;\nalter database add logfile thread 2 group 6 '+DATAC1' size 4000m;\nalter database add logfile thread 2 group 7 '+DATAC1' size 4000m;\nalter database add logfile thread 2 group 8 '+DATAC1' size 4000m;\nalter database add logfile thread 2 group 9 '+DATAC1' size 4000m;\nalter database add logfile thread 2 group 10 '+DATAC1' size 4000m;\n...\nOR\nALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+DATAC1') SIZE 4G;\nALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+DATAC1') SIZE 4G;\nALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+DATAC1') SIZE 4G;\nALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+DATAC1') SIZE 4G;\nALTER DATABASE ADD STANDBY LOGFILE THREAD 1 ('+DATAC1') SIZE 4G;\n-- for each instance - repeat change the thread number\nALTER DATABASE ADD STANDBY LOGFILE THREAD 2 ('+DATAC1') SIZE 4G;\nALTER DATABASE ADD STANDBY LOGFILE THREAD 2 ('+DATAC1') SIZE 4G;\nALTER DATABASE ADD STANDBY LOGFILE THREAD 2 ('+DATAC1') SIZE 4G;\nALTER DATABASE ADD STANDBY LOGFILE THREAD 2 ('+DATAC1') SIZE 4G;\nALTER DATABASE ADD STANDBY LOGFILE THREAD 2 ('+DATAC1') SIZE 4G;\n<\/code><\/pre>\n\n\norapwd file=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/orapwlondon password=\"TechMaster1_\" force=y entries=10\ncp \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/orapwlondon \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/orapwboston\nor try to get a copy from boston database:\nASMCMD> cp pwdboston.674.1043766629 \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/orapwlondon\ncopying +datac1\/boston\/password\/pwdboston.674.1043766629 -> \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/orapwlondon\nASMCMD>\nGo to grid and execute the copy of password for boston and london:\n[grid@tech01 admin]$ asmcmd\nASMCMD> cd +datac1\/london\/password\nASMCMD> cp \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/orapwlondon passwd\ncopying \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/orapwlondon -> +datac1\/london\/password\/passwd\nASMCMD> ls\norapwlondon\npasswd\npwdlondon.1244.1040809123<\/code><\/pre>\n\n\nexport ORACLE_SID=london1\n[18.0.0.0 SID:london1][oracle@tech01:\/home\/oracle\/working ] working$ cat startuplondon.sql\nshut abort\nhost srvctl stop instance -d london -i london1\nstartup nomount pfile='\/home\/oracle\/working\/london.ora';\nhost rm -f \/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/dbs\/spfilelondon.ora\ncreate spfile from pfile='\/home\/oracle\/working\/london.ora';\nhost srvctl start instance -d london -i london1 -o nomount\nhost srvctl status database -d london -v\nexit\n...\n[18.0.0.0 SID:london1][oracle@tech01:\/home\/oracle\/working ] working$ srvctl status database -d london\nInstance london1 is running on node tech01\n[18.0.0.0 SID:boston1][oracle@tech01:\/home\/oracle\/working ] working$ cat \/home\/oracle\/working\/london.ora\nDB_NAME=boston\nDB_UNIQUE_NAME=london\nsga_target=8G\n*.db_domain='techmax.domain'\n*.compatible='12.2.0.1.0'\n#*.local_listener='LISTENER'\n#*.remote_listener='p-scan.techmax.domain:1521'\n*.db_recovery_file_dest='+RECOC1'\n*.db_recovery_file_dest_size=10737418240\n*.dg_broker_config_file1='+DATAC1\/london\/BROKER\/dr1london.dat'\n*.dg_broker_config_file2='+DATAC1\/london\/BROKER\/dr2london.dat'\n*.cluster_database=FALSE\n*.instance_number=1\n*.undo_tablespace='UNDOTBS1'\n*.standby_file_management='AUTO'\n*.dg_broker_start=FALSE\n*.REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE\n*.db_create_file_dest='+DATAC1'\n*.db_create_online_log_dest_1='+DATAC1'\n*.enable_pluggable_database=true\n[18.0.0.0 SID:boston1][oracle@tech01:\/home\/oracle\/working ] working$ source $HOME\/london.env\n[18.0.0.0 SID:london][oracle@tech01:\/home\/oracle\/working ] working$ export ORACLE_SID=london1\n[18.0.0.0 SID:london1][oracle@tech01:\/home\/oracle\/working ] working$ sqlplus \/ as sysdba @startuplondon.sql\nSQL*Plus: Release 18.0.0.0.0 - Production on Wed May 27 21:11:37 2020\nVersion 18.6.0.0.0\nCopyright (c) 1982, 2018, Oracle. All rights reserved.\nConnected to:\nOracle Database 18c EE Extreme Perf Release 18.0.0.0.0 - Production\nVersion 18.6.0.0.0\nDB_UNIQUE_NAME DATABASE_ROLE VERSION COMPATIBLE STATUS\n-------------------- ---------------- ---------- ---------- --------\nlondon PHYSICAL STANDBY 18.0.0.0.0 12.2.0.1.0 MOUNTED\nHOST_NAME INSTANCE_NAME STATUS Startup time LOGINS CONNECTED\n---------------------------------- -------------- -------- ------------------ -------- --------------\ntech01.techmax.domain london1 MOUNTED 27-MAY-2020 17:17 ALLOWED CURRENT\nORACLE instance shut down.\nORACLE instance started.\nTotal System Global Area 8578638416 bytes\nFixed Size 12456528 bytes\nVariable Size 1392508928 bytes\nDatabase Buffers 7130316800 bytes\nRedo Buffers 43356160 bytes\nFile created.\nInstance london1 is running on node tech01\nDisconnected from Oracle Database 18c EE Extreme Perf Release 18.0.0.0.0 - Production\nVersion 18.6.0.0.0\n[18.0.0.0 SID:london1][oracle@tech01:\/home\/oracle\/working ] working$\n[18.0.0.0 SID:london1][oracle@tech01:\/home\/oracle\/working ] working$\nPlease add the london instance to the oracle cluster.\nsrvctl remove database -d london -noprompt\nsrvctl add database -d london -oraclehome $ORACLE_HOME\nsrvctl setenv database -d london -T \"TNS_ADMIN=\/u02\/app\/oracle\/product\/19.0.0.0\/dbhome_4\/network\/admin\/london\"\nsrvctl modify database -d london -pwfile +DATAC1\/london\/PASSWORD\/orapwlondon\nsrvctl modify database -d london -spfile +DATAC1\/london\/spfilelondon.ora\nsrvctl modify database -d london -domain pbh\nsrvctl modify database -d london -diskgroup DATAC1,RECOC1\nsrvctl modify database -d london -startoption mount\nsrvctl add instance -db london -instance london1 -node techcdb01\nsrvctl add instance -db london -instance london2 -node techcdb02\nAfter the initial load you can test the start of instance and database.\nsrvctl start database -d london -v\nsrvctl status instance -d london -node exaccdb01\nsrvctl status instance -d london -node exaccdb02\nsrvctl getenv database -d london\nsrvctl config database -d london\nsrvctl status database -d london -v\nInstance london1 is running on node tech01. Instance status: .\n<\/code><\/pre>\n\n\n18.0.0.0 SID:london1][oracle@tech01:\/home\/oracle\/working ] working$ srvctl status database -d boston -v\nInstance boston1 is running on node tech01. Instance status: Open.\nInstance boston2 is running on node tech02. Instance status: Open.\nInstance boston3 is running on node tech03. Instance status: Open.\nInstance boston4 is running on node tech04. Instance status: Open.\n<\/code><\/pre>\n\n\n[grid@tech01 admin]$ cat listener.ora (add this to your listener)\n# DG\nSID_LIST_LISTENER=\n (SID_LIST=\n (SID_DESC=\n (GLOBAL_DBNAME=boston.techmax.domain)\n (ORACLE_HOME=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2)\n (SID_NAME=boston1)\n (ENVS=\"TNS_ADMIN=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/boston\")\n (ENVS=\"ORACLE_UNQNAME=boston\"))\n (SID_DESC=\n (GLOBAL_DBNAME=london.techmax.domain)\n (ORACLE_HOME=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2)\n (SID_NAME=london1)\n (ENVS=\"TNS_ADMIN=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/london\")\n (ENVS=\"ORACLE_UNQNAME=london\"))\n (SID_DESC=\n (GLOBAL_DBNAME=boston_DGMGRL.techmax.domain)\n (ORACLE_HOME=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2)\n (SID_NAME=boston1)\n (ENVS=\"TNS_ADMIN=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/boston\")\n (ENVS=\"ORACLE_UNQNAME=boston\"))\n (SID_DESC=\n (GLOBAL_DBNAME=london_DGMGRL.techmax.domain)\n (ORACLE_HOME=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2)\n (SID_NAME=london1)\n (ENVS=\"TNS_ADMIN=\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/london\")\n (ENVS=\"ORACLE_UNQNAME=london\"))\n )<\/code><\/pre>\n\n\nGrid user:\nlsnrctl reload\nlsnrctl status\nOracle user:\nsqlplus \/ as sysdba\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 4 09:49:54 2020\nVersion 19.3.0.0.0\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\nConnected to:\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\nSQL> alter system register;\nSystem altered.<\/code><\/pre>\n\n\ntnsnames.ora will be present for each TNS_ADMIN location for each database. In this case we need update both boston and london locations. The *(UR=A)* clause is intended to work with a dynamically registered handler so the use of SERVICE_NAME versus SID is preferred, check the MOS doc ID 362656.1 to get some background about it. For tnsnames.ora consider update all locations returned in srctl getenv - TNS_ADMIN - add the entries below. Copy the files for all nodes, and restart listener. All hosts - are tech01.techmax.domain and at final we need change to scan name instead of host01 (tech01.techmax.domain).\nCreate same entries in $GRID_HOME\/network\/admin\/tnsnames.ora for all nodes. Can be removed after the duplicate.\nSame tnsnames.ora need be copied to london in all nodes.<\/pre>\n\n\n
[18.0.0.0 SID:boston1][oracle@tech01:\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/london ] london$\ncat tnsnames.ora (add this to your tnsnames.ora for both london and boston)\nBOSTON =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = p-scan.techmax.domain)(PORT = 1521))\n (CONNECT_DATA =\n (SERVER = DEDICATED)\n (SERVICE_NAME = boston.techmax.domain)\n (UR=A)\n )\n )\nBOSTON_DGMGRL =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = p-scan.techmax.domain)(PORT = 1521))\n (CONNECT_DATA =\n (SERVER = DEDICATED)\n (SERVICE_NAME = boston_DGMGRL.techmax.domain)\n (FAILOVER_MODE =\n (TYPE = select)\n (METHOD = basic)\n )\n )\n )\nLONDON_DGMGRL =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = tech01.techmax.domain)(PORT = 1521))\n (CONNECT_DATA =\n (SERVER = DEDICATED)\n (SERVICE_NAME = london_DGMGRL.techmax.domain)\n )\n )\nLONDON =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = tech01.techmax.domain)(PORT = 1521))\n (CONNECT_DATA =\n (SERVER = DEDICATED)\n (SERVICE_NAME = london.techmax.domain)\n (UR=A)\n )\n )\nLONDON1 =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = tech01.techmax.domain)(PORT = 1521))\n (CONNECT_DATA =\n (SERVER = DEDICATED)\n (SERVICE_NAME = london1.techmax.domain)\n (UR=A)\n )\n )\n#optional for tests\nLISTENER =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = p-scan.techmax.domain)(PORT = 1521))\n )\n<\/code><\/pre>\n\n\n[12.2.0 SID:boston1][oracle@tech01:\/home\/oracle\/working ] working$\nsqlplus sys\/\"xxx\"@london as sysdba\nSQL*Plus: Release 12.2.0.1.0 Production on Wed May 27 21:34:50 2020\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\nLast Successful login time: Wed May 27 2020 17:25:09 -03:00\nConnected to:\nOracle Database 18c EE Extreme Perf Release 18.0.0.0.0 - Production\nSQL> quit\nDisconnected from Oracle Database 18c EE Extreme Perf Release 18.0.0.0.0 - Production\nsqlplus sys\/\"xxx\"@boston as sysdba<\/code><\/pre>\n\n\ncat $TNS_ADMIN\/sqlnet.ora\n(DIRECTORY=\/var\/opt\/oracle\/dbaas_acfs\/boston\/tde_wallet))\n(DIRECTORY=\/var\/opt\/oracle\/dbaas_acfs\/boston\/db_wallet)))\nMake a backup before start to deal with it.\ncp -r \/var\/opt\/oracle\/dbaas_acfs\/boston\/* \/backup\/\ncp -r \/var\/opt\/oracle\/dbaas_acfs\/london\/* \/backup\/\ncp \/var\/opt\/oracle\/dbaas_acfs\/boston\/tde_wallet \/var\/opt\/oracle\/dbaas_acfs\/london\/tde_wallet\ncp \/var\/opt\/oracle\/dbaas_acfs\/boston\/db_wallet \/var\/opt\/oracle\/dbaas_acfs\/london\/db_wallet<\/code><\/pre>\n\n\nBefore start the duplicate, need confirm if london1 instance is running even for srvctl status instance -d london -i london1 (grid). Duplicate below will get some issues see last section. London needs only one instance = cluster =false..<\/pre>\n\n\n
[oracle@tech01 ~]$\nsrvctl status instance -d london -i london1\nInstance london1 is running on node tech01\n[oracle@tech01 ~]$\nsrvctl status database -d london\nInstance london1 is running on node tech01\nInstance london2 is not running on node tech02\nrman target sys\/\"TechMaster1_\"@boston auxiliary sys\/\"TechMaster1_\"@london\nDUPLICATE target database for standby from active database\n SPFILE\n parameter_value_convert ('boston','LONDON','BOSTON','LONDON')\n set db_unique_name='london'\n set db_name='boston'\n set cluster_database='FALSE'\n set db_file_name_convert='boston','london','BOSTON','LONDON'\n set log_file_name_convert='boston','london','BOSTON','LONDON'\n set pdb_file_name_convert='boston','london','BOSTON','LONDON'\n set db_create_file_dest='+DATAC1'\n set db_create_online_log_dest_1='+DATAC1'\n set audit_trail='none'\n set standby_file_management='AUTO'\n set log_archive_dest_1='location=+RECOC1'\n set LOG_ARCHIVE_DEST_10='location=+DATAC1'\n set remote_listener=''\n set enable_pluggable_database='TRUE'\n SET LISTENER_NETWORKS ''\n SET CLUSTER_INTERCONNECTS ''\n set core_dump_dest '\/u02\/app\/oracle\/diag\/rdbms\/LONDON\/london1\/cdump'\n set instance_name 'london1'\n NOFILENAMECHECK\n DORECOVER;<\/code><\/pre>\n\n\nConnected to BOSTON:\nalter system set dg_broker_start=FALSE sid='*' scope=both;\nalter system set dg_broker_config_file1='+DATAC1\/BOSTON\/BROKER\/dr1boston.dat' sid='*' scope=both;\nalter system set dg_broker_config_file2='+DATAC1\/BOSTON\/BROKER\/dr2boston.dat' sid='*' scope=both;\nalter system set dg_broker_start=TRUE sid='*' scope=both;\nConnected to LONDON:\nalter system set dg_broker_start=FALSE sid='*' scope=both;\nalter system set dg_broker_config_file1='+DATAC1\/LONDON\/BROKER\/dr1london.dat' sid='*' scope=both;\nalter system set dg_broker_config_file2='+DATAC1\/LONDON\/BROKER\/dr2london.dat' sid='*' scope=both;\nalter system set dg_broker_start=TRUE sid='*' scope=both;\n<\/code><\/pre>\n\n\nCreate directory for dataguard broker files inside of asm.\nConnected with grid user:\nasmcmd mkdir +DATAC1\/BOSTON\/BROKER\/\nasmcmd mkdir +DATAC1\/LONDON\/BROKER\/\n[root@techdb01 ~]# su - grid\nLast login: Thu Jun 4 11:48:21 -03 2020\n[19.0.0.0 SID:+ASM1][grid@techdb01:\/home\/grid ] ~$ asmcmd mkdir +DATAC1\/BOSTON\/BROKER\/\n[19.0.0.0 SID:+ASM1][grid@techdb01:\/home\/grid ] ~$ asmcmd mkdir +DATAC1\/LONDON\/BROKER\/\n[19.0.0.0 SID:+ASM1][grid@techdb01:\/home\/grid ] ~$<\/code><\/pre>\n\n\nCheck errors on dataguard broker:\nln -s \/u02\/app\/oracle\/diag\/rdbms\/boston\/boston1\/trace\/drcboston1.log drcboston1.log\ntail -f drcboston1.log<\/code><\/pre>\n\n\nSQL> alter database flashback on;<\/code><\/pre>\n\n\nResume of the configuration to be done:\nCREATE CONFIGURATION DGBOSTON as\n PRIMARY DATABASE IS boston\n CONNECT IDENTIFIER IS boston;\nshow configuration;\nadd database london as connect identifier is london;\nenable configuration;\nshow database london;\nshow configuration;\nAll steps below:\ndgmgrl sys\/\"TechMaster1_\"@boston\nDGMGRL for Linux: Release 18.0.0.0.0 - Production on Wed May 27 17:21:40 2020\nVersion 18.6.0.0.0\nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\nWelcome to DGMGRL, type \"help\" for information.\nConnected to \"boston\"\nConnected as SYSDBA.\nDGMGRL> CREATE CONFIGURATION DGBOSTON as\n> PRIMARY DATABASE IS boston\n> CONNECT IDENTIFIER IS boston;\nConfiguration \"dgboston\" created with primary database \"boston\"\nDGMGRL> show configuration\nConfiguration - dgboston\n Protection Mode: MaxPerformance\n Members:\n boston - Primary database\nFast-Start Failover: DISABLED\nConfiguration Status:\nDISABLED\nDGMGRL> add database london as connect identifier is london;\nDatabase \"london\" added\nDGMGRL> enable configuration;\nEnabled.\nDGMGRL> show configuration\nConfiguration - dgboston\n Protection Mode: MaxPerformance\n Members:\n boston - Primary database\n Warning: ORA-16809: multiple warnings detected for the member\n london - Physical standby database\n Warning: ORA-16854: apply lag could not be determined\nFast-Start Failover: DISABLED\nConfiguration Status:\nWARNING (status updated 31 seconds ago)\nDGMGRL> show database london\nDatabase - london\n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 1 second ago)\n Apply Lag: 0 seconds (computed 1 second ago)\n Average Apply Rate: 17.00 KByte\/s\n Real Time Query: OFF\n Instance(s):\n london1\nDatabase Status:\nSUCCESS\nDGMGRL> quit\n[18.0.0.0 SID:london1][oracle@tech01:\/home\/oracle\/working ] working$ dgmgrl sys\/\"TechMaster1_\"@boston DGMGRL for Linux: Release 18.0.0.0.0 - Production on Wed May 27 17:25:08 2020\nVersion 18.6.0.0.0\nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\nWelcome to DGMGRL, type \"help\" for information.\nConnected to \"boston\"\nConnected as SYSDBA.\nDGMGRL> show configuration\nConfiguration - dgboston\n Protection Mode: MaxPerformance\n Members:\n boston - Primary database\n Warning: ORA-16809: multiple warnings detected for the member\n london - Physical standby database\nFast-Start Failover: DISABLED\nConfiguration Status:\nWARNING (status updated 22 seconds ago)\nDGMGRL> show database boston\nDatabase - boston\n Role: PRIMARY\n Intended State: TRANSPORT-ON\n Instance(s):\n boston1\n boston2\n boston3\n boston4\nDatabase Status:\nSUCCESS\nDGMGRL> show database london\nDatabase - london\n Role: PHYSICAL STANDBY\n Intended State: APPLY-ON\n Transport Lag: 0 seconds (computed 1 second ago)\n Apply Lag: 0 seconds (computed 1 second ago)\n Average Apply Rate: 6.00 KByte\/s\n Real Time Query: OFF\n Instance(s):\n london1\nDatabase Status:\nSUCCESS\nDGMGRL> quit\n<\/code><\/pre>\n\n\nselect * from v$encryption_wallet;\nselect time, name, message, action FROM pdb_plug_in_violations;\ndbaascli tde status --dbname london\ndbaascli tde status --dbname boston\nDrop london:\nexport ORACLE_SID=london\n[ SID:no sid][oracle@tech01:\/home\/oracle\/working ] working$ cat droplondon.sql\nshut abort\nstartup mount exclusive restrict;\ndrop database;\nshut abort\nhost srvctl stop instance -d london -i london1\nstartup mount exclusive restrict;\ndrop database;\nhost srvctl status instance -d london -i london1<\/code><\/pre>\n\n\nERROR: London running only one instance. Put running all instances.\nalter system set cluster_database=true scope=spfile sid='*';\nalter system set instance_number=1 scope=spfile sid='london1';\nalter system set instance_number=2 scope=spfile sid='london2';\nalter system set undo_tablespace='UNDOTBS1' scope=spfile sid='london1';\nalter system set undo_tablespace='UNDOTBS2' scope=spfile sid='london2';\nalter system set thread=1 scope=spfile sid='london1';\nalter system set thread=2 scope=spfile sid='london2';\n[SID:london1][oracle@exaccdb01:\/home\/oracle ] ~$ srvctl stop database -d london\n[SID:london1][oracle@exaccdb01:\/home\/oracle ] ~$ srvctl start database -d london\n[SID:london1][oracle@exaccdb01:\/home\/oracle ] ~$ srvctl status database -d london -v\nInstance london1 is running on node exaccdb01. Instance status: Mounted (Closed).\nInstance london2 is running on node exaccdb02. Instance status: Mounted (Closed).\n[SID:london1][oracle@exaccdb01:\/home\/oracle ] ~$\nERROR:\nconnected to auxiliary database (not started)\nOracle instance started\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of Duplicate Db command at 05\/27\/2020 15:38:50\nRMAN-05501: aborting duplication of target database\nRMAN-03015: error occurred in stored script Memory Script\nRMAN-06403: could not obtain a fully authorized session\nRMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available\nORA-27101: shared memory realm does not exist\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 4150\nAdditional information: 14021371\nRMAN>\nSOLUTION:\n1) Start london instance using srvctl\n2) Reload listener - check listener.ora\n3) Test password\n4) boston and london - entries in tnsnames.ora need point to IP host01.\nERROR:\nStarting restore at 27-MAY-20\nallocated channel: ORA_AUX_DISK_1\nchannel ORA_AUX_DISK_1: SID=6 device type=DISK\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of Duplicate Db command at 05\/27\/2020 16:11:10\nRMAN-05501: aborting duplication of target database\nRMAN-03015: error occurred in stored script Memory Script\nRMAN-06136: Oracle error from auxiliary database: ORA-17629: Cannot connect to the remote database server\nORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified\nORA-17629: Cannot connect to the remote database server\nSolution:\n1) Reload listener\n2) Check london1 status\n3) Test connectivity to boston - need point to host01 in all node\nERROR - Duplicate abort\nAdded - the entries on grid network\/admin\/tnsnames.ora\n[19.0.0.0 SID:+ASM1][grid@techdb01:\/u01\/app\/19.0.0.0\/grid\/network\/admin ] admin$ ls -ltr\n-rw-r--r-- 1 grid oinstall 1101 Jun 4 10:32 tnsnames.ora\nWithout this - will cause this error:\nRMAN-05501: aborting duplication of target database\nRMAN-03015: error occurred in stored script Memory Script\nRMAN-06136: Oracle error from auxiliary database: ORA-17629: Cannot connect to the remote database server\nORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified\nORA-17629: Cannot connect to the remote database server\nSolution: Add entries in tnsnames.ora to $GRID_HOME\/network\/admin\nMake sure all wallets are same from source database - Copy all from Boston to Lodon\nCheck the sqlnet.ora file to make sure you are copying from BOSTON to LONDON wallet files\nPlease make copy before update it.\n[oracle@techdb01 london]$ cat sqlnet.ora\nSQLNET.ENCRYPTION_SERVER = required\nSQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA1)\nSQLNET.CRYPTO_CHECKSUM_SERVER = required\nENCRYPTION_WALLET_LOCATION =\n (SOURCE=\n (METHOD=FILE)\n (METHOD_DATA=\n (DIRECTORY=\/var\/opt\/oracle\/dbaas_acfs\/london\/tde_wallet)))\nSQLNET.ENCRYPTION_TYPES_SERVER = (AES256, AES192, AES128)\nSQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS = TRUE\nHTTPS_SSL_VERSION = 1.2\nSQLNET.EXPIRE_TIME = 10\nSQLNET.WALLET_OVERRIDE = FALSE\nSSL_VERSION = 1.2\nWALLET_LOCATION = (SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=\/var\/opt\/oracle\/dbaas_acfs\/london\/db_wallet)))\n[oracle@techdb01 london]$ ls -ltr \/var\/opt\/oracle\/dbaas_acfs\/london\/tde_wallet\ntotal 88\ndrwxrwx--- 2 oracle oinstall 20480 Jun 2 13:33 tde_seps\n-rw------- 1 oracle oinstall 2555 Jun 2 13:34 ewallet_2020060216341943.p12\n-rw------- 1 oracle oinstall 0 Jun 2 15:12 ewallet.p12.lck\n-rw------- 1 oracle oinstall 0 Jun 2 15:12 cwallet.sso.lck\n-rw------- 1 oracle asmadmin 5467 Jun 2 15:13 ewallet_2020060218133052.p12\n-rw------- 1 oracle oinstall 8011 Jun 2 15:13 ewallet.p12\n-rw------- 1 oracle oinstall 8056 Jun 2 15:13 cwallet.sso\n[oracle@techdb01 london]$ ls -ltr \/var\/opt\/oracle\/dbaas_acfs\/london\/db_wallet\ntotal 4\n-rw------- 1 oracle oinstall 0 Jun 2 12:49 cwallet.sso.lck\n-rw------- 1 oracle oinstall 813 Jun 2 12:50 cwallet.sso\nCopy in all nodes - be sure you have a bkp before update it.\n[oracle@techdb01 london]$ cp \/var\/opt\/oracle\/dbaas_acfs\/boston\/db_wallet\/* \/var\/opt\/oracle\/dbaas_acfs\/london\/db_wallet\/\n[oracle@techdb01 london]$ cp -r \/var\/opt\/oracle\/dbaas_acfs\/boston\/tde_wallet\/* \/var\/opt\/oracle\/dbaas_acfs\/london\/tde_wallet\/\nERROR:\nThis happened because we are using same machine\/server to duplicate boston database to london. If you are using a database to duplicate in another grid\/server this need to follow the default duplicate.\nsql statement: alter database mount standby database\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of Duplicate Db command at 05\/29\/2020 10:12:14\nRMAN-05501: aborting duplication of target database\nRMAN-03015: error occurred in stored script Memory Script\nRMAN-03009: failure of sql command on clone_default channel at 05\/29\/2020 10:12:14\nRMAN-11003: failure during parse\/execution of SQL statement: alter database mount standby database\nORA-01103: database name 'BOSTON' in control file is not 'LONDON'\nRMAN>\nSolution:\nDuplicate with this:\n set db_unique_name='london'\n set db_name='boston'\nrmanduplicate.sql\n[18.0.0.0 SID:london1][oracle@tech01:\/home\/oracle\/working ] working$ cat rmanduplicate.sql\nDUPLICATE target database for standby from active database\n SPFILE\n parameter_value_convert ('boston','london','BOSTON','london')\n set db_unique_name='london'\n set db_name='boston'\n set cluster_database='FALSE'\n set db_file_name_convert='boston','london','BOSTON','london'\n set log_file_name_convert='boston','london','BOSTON','london'\n set db_create_file_dest='+DATAC1'\n set db_create_online_log_dest_1='+DATAC1'\n set audit_trail='none'\n set log_archive_dest_1='location=+RECOC1'\n set LOG_ARCHIVE_DEST_10='location=+DATAC1'\n set remote_listener=''\n set enable_pluggable_database='TRUE'\n NOFILENAMECHECK\n DORECOVER;\nERROR:\ncreate configuration hang on dataguard DG BROKER\nUsing old configuration for boston database.\nDGMGRL> CREATE CONFIGURATION DGBOSTON PRIMARY DATABASE IS boston CONNECT IDENTIFIER IS boston;\nError: ORA-16571: Oracle Data Guard configuration file creation failure\nFailed.\n[18.0.0.0 SID:london1][oracle@tech01:\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/london ] london$ locate drcboston \/u02\/app\/oracle\/diag\/rdbms\/boston\/boston\/trace\/drcboston.log\n\/u02\/app\/oracle\/diag\/rdbms\/boston\/boston1\/trace\/drcboston1.log\n\/u02\/app\/oracle\/diag\/rdbms\/london\/boston1\/trace\/drcboston1.log\n[18.0.0.0 SID:london1]\n[oracle@tech01:\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/london ] london$ tail -f \/u02\/app\/oracle\/diag\/rdbms\/boston\/boston1\/trace\/drcboston1.log\nConfiguration file disk update failed for\nBroker operation, error is ORA-16571\n ORA-17503: ksfdopn:2 Failed to open file +DATAC1\/boston\/BROKER\/dr1london.dat\n ORA-15173: entry 'BROKER' does not exist in directory 'boston'\n2020-05-29T10:52:34.760-03:00\n ORA-17503: ksfdopn:2 Failed to open file +DATAC1\/boston\/BROKER\/dr2london.dat\n ORA-15173: entry 'BROKER' does not exist in directory 'boston'\ncannot open configuration file \"+DATAC1\/boston\/BROKER\/dr2london.dat\"\n ORA-17503: ksfdopn:2 Failed to open file +DATAC1\/boston\/BROKER\/dr2london.dat\n ORA-15173: entry 'BROKER' does not exist in directory 'boston'\nBroker operation completed with error ORA-16571\nFailed to get the ConfigurationWideServiceName property value, status=ORA-16532.\nREMOVE CONFIGURATION completed successfully\n2020-05-29T10:55:42.532-03:00\nBroker operation\nNo database profile named boston found in configuration\nBroker operation completed successfully\nADD DATABASE\nPublished configuration wide service boston_CFG\nINTERNAL ERROR: Unexpected dynamic default property HostName.\nADD DATABASE completed successfully\nSOLUTION:\nRecreate the dataguard broker configuration files.\nRestart boston database for all nodes\nsrvctl stop database -d boston\nsrvctl start database -d boston\nsrvctl stop database -d london\nsrvctl start database -d london\n[grid@tech01 ~]$ asmcmd\nASMCMD>\nASMCMD>\nASMCMD> mkdir +DATAC1\/boston\/BROKER\/\nASMCMD> mkdir +DATAC1\/london\/BROKER\/\nASMCMD> exit\nError:\nDGMGRL> add database london as connect identifier is london;\nError: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set\nSolution connected to london1:\nSQL> alter system set log_archive_dest_2='' scope=both sid='*';\nSystem altered.\nError: Cannot drop london database\n[oracle@exaccdb01 ~]$ sqlplus \/ as sysdba\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 3 11:11:46 2020\nVersion 19.3.0.0.0\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\nConnected to:\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\nSQL> show parameter instance\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nactive_instance_count integer\ncluster_database_instances integer 2\ninstance_abort_delay_time integer 0\ninstance_groups string\ninstance_mode string READ-WRITE\ninstance_name string london1\ninstance_number integer 1\ninstance_type string RDBMS\nopen_links_per_instance integer 4\nparallel_instance_group string\nSQL> drop database;\ndrop database\n*\nERROR at line 1:\nORA-01586: database must be mounted EXCLUSIVE and not open for this operation\nSolution: Update cluster parameter to FALSE\nSQL> shut abort\nORACLE instance shut down.\nSQL> startup mount exclusive restrict;\nORACLE instance started.\nTotal System Global Area 7963757000 bytes\nFixed Size 9157064 bytes\nVariable Size 1677721600 bytes\nDatabase Buffers 4613734400 bytes\nRedo Buffers 69308416 bytes\nIn-Memory Area 1593835520 bytes\nDatabase mounted.\nSQL> show parameter cluster\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ncdb_cluster boolean FALSE\ncdb_cluster_name string\ncluster_database boolean TRUE\ncluster_database_instances integer 2\ncluster_interconnects string 100.107.2.1:100.107.2.2\nSQL> drop database;\ndrop database\n*\nERROR at line 1:\nORA-01586: database must be mounted EXCLUSIVE and not open for this operation\nSQL> alter system set cluster_database=false scope=spfile sid='*';\nSystem altered.\nSQL> create pfile='$HOME\/initlondon.ora' from spfile;\nFile created.\nSQL> shut abort\nORACLE instance shut down.\nSQL> startup mount exclusive restrict;\nORACLE instance started.\nTotal System Global Area 7963757000 bytes\nFixed Size 9157064 bytes\nVariable Size 1677721600 bytes\nDatabase Buffers 4613734400 bytes\nRedo Buffers 69308416 bytes\nIn-Memory Area 1593835520 bytes\nDatabase mounted.\nSQL> show parameter instance\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nactive_instance_count integer\ncluster_database_instances integer 1\ninstance_abort_delay_time integer 0\ninstance_groups string\ninstance_mode string READ-WRITE\ninstance_name string london1\ninstance_number integer 1\ninstance_type string RDBMS\nopen_links_per_instance integer 4\nparallel_instance_group string\nSQL> drop database;\nRevise files under ASM after remove london database:\nIs possible to remain some files under ASM disgroup RECOC1 for archivelogs and controlfiles autobackup for london temporary database (used only to be present in control plane)\n[grid@techdb01 scripts]$ .\/asmdu.sh -d recoc1\/london -g\nInstances running on techdb01 : +APX1, +ASM1, boston1, CDBD021, CDBH011, CDBH021, CDBIT1, CDBP011, CDBP021, CDBP051, CDBP081, CDBP211\n DiskGroup Redundancy Total GB Usable GB % Free\n --------- ----------- -------- --------- ------\n recoc1 HIGH 30648.00 26862.23 87\n recoc1\/london subdirectories size\n Subdir Used GB Raw Used GB\n ------ ------- -----------\n ARCHIVELOG\/ 0.61 1.83\n AUTOBACKUP\/ 0.17 0.50\n CONTROLFILE\/ 0.00 0.00\n ------ ------- ---------\n Total 0.78 2.33\n[grid@techdb01 scripts]$ asmcmd\nASMCMD> cd recoc1\nASMCMD> cd london\nASMCMD> cd archivelog\nASMCMD> ls\n2020_06_02\/\n2020_06_03\/\nASMCMD> pwd\n+recoc1\/london\/archivelog\nASMCMD> rm *\nYou may delete multiple files and\/or directories.\nAre you sure? (y\/n) y\nORA-15032: not all alterations performed\nORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)\nASMCMD> ls\n2020_06_02\/\n2020_06_03\/\nASMCMD> cd 2020_06_02\/\nASMCMD> ls\nthread_1_seq_1.386.1042032297\nthread_1_seq_2.319.1042032327\nthread_1_seq_3.507.1042032359\nthread_1_seq_4.618.1042032497\nthread_1_seq_5.682.1042032589\nthread_1_seq_6.622.1042032861\nthread_1_seq_7.617.1042032925\nthread_1_seq_8.608.1042033179\nthread_1_seq_9.607.1042033179\nthread_2_seq_1.623.1042032465\nthread_2_seq_2.662.1042032589\nthread_2_seq_3.638.1042032861\nthread_2_seq_4.613.1042033043\nthread_2_seq_5.528.1042033115\nASMCMD> rm *\nYou may delete multiple files and\/or directories.\nAre you sure? (y\/n) y\nASMCMD> cd ..\nASMCMD> ls\n2020_06_03\/\nASMCMD> cd 20*\nASMCMD> ls\nthread_1_seq_10.487.1042105389\nthread_2_seq_6.1088.1042105389\nASMCMD> rm *\nYou may delete multiple files and\/or directories.\nAre you sure? (y\/n) y\nASMCMD> cd ..\nASMCMD> ls\nASMCMD> pwd\n+recoc1\/london\/archivelog\nASMCMD> cd ..\nASMCMD> ls\nARCHIVELOG\/\nAUTOBACKUP\/\nCONTROLFILE\/\nASMCMD> cd autobackup\nASMCMD> ls\n2020_06_02\/\nASMCMD> cd 20*\nASMCMD> rm *\nYou may delete multiple files and\/or directories.\nAre you sure? (y\/n) y\nASMCMD> cd ..\nASMCMD> quit\n[grid@techdb01 scripts]$ .\/asmdu.sh -d recoc1\/london -g\nInstances running on techdb01 : +APX1, +ASM1, boston1, CDBD021, CDBH011, CDBH021, CDBIT1, CDBP011, CDBP021, CDBP051, CDBP081, CDBP211\n DiskGroup Redundancy Total GB Usable GB % Free\n --------- ----------- -------- --------- ------\n recoc1 HIGH 30648.00 26863.00 87\n recoc1\/london subdirectories size\n Subdir Used GB Raw Used GB\n ------ ------- -----------\n ARCHIVELOG\/ 0.00 0.00\n AUTOBACKUP\/ 0.00 0.00\n CONTROLFILE\/ 0.00 0.00\n ------ ------- ---------\n Total 0.00 0.00\n[grid@techdb01 scripts]$\n<\/code><\/pre>\n\n\n\nEDIT DATABASE 'london' SET STATE='APPLY-OFF';\nEDIT DATABASE 'london' SET STATE='APPLY-ON';\nEDIT DATABASE 'london' SET property delaymins=1440;\nEDIT DATABASE 'london' SET property applyparallel=4;\nconvert DATABASE 'london' to snapshot standby;\nconvert DATABASE 'london' to physical standby;\nReal apply SQL - physical standby\nEDIT DATABASE 'london' SET STATE='APPLY-OFF';\nshut immediate\nstartup\nalter database recover managed standby database using current logfile disconnect;\nalter database recover managed standby database cancel;\nEDIT DATABASE 'london' SET STATE='APPLY-ON';\n<\/code><\/pre>\n\n\n[18.0.0.0 SID:london1][oracle@tech01:\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/sqlplus\/admin ] admin$ cat glogin.sql\nset linesize 200\ndefine _editor=vi\nset serveroutput on size 1000000\nset pagesize 9999\ncolumn plan_plus_exp format a80\ncolumn global_name new_value gname\nset termout off\ndefine gname=idle\ncolumn global_name new_value gname\nselect lower(user)||'@'||instance_name||'('||host_name||')' global_name from v$instance;\n--set sqlprompt '&gname> '\nset termout on\ncolumn db_unique_name format a20\ncolumn database_role format a16\ncolumn db_version format a10\ncolumn db_status format a8\ncolumn db_compatible format a10\ncolumn db_version heading VERSION\ncolumn db_status heading STATUS\ncolumn db_compatible heading COMPATIBLE\nselect d.db_unique_name, d.database_role, d.open_mode, v.version db_version,\np.value db_compatible, v.status db_status\nfrom gv$database d, gv$instance v, gv$parameter p\nwhere p.name = 'compatible'\nand d.inst_id=v.inst_id and v.inst_id = p.inst_id\n;\ncol logins format a8\ncolumn instance_name format A12\ncolumn status format A8\ncolumn CONNECTED format A12\ncolumn host_name format A32\nselect host_name,instance_name,\nstatus, to_char(startup_time,\n'DD-MON-YYYY HH24:MI ') \"Startup time\",logins,\ndecode(instance_name,(select instance_name from v$instance) ,'CURRENT','NOT CURRENT') CONNECTED\nfrom gv$instance\n\/\n<\/code><\/pre>\n\n\n[18.0.0.0 SID:boston1][oracle@tech01:\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/boston ] boston$ cat sqlnet.ora\nSQLNET.ENCRYPTION_SERVER = required\nSQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA1)\nSQLNET.CRYPTO_CHECKSUM_SERVER = required\nENCRYPTION_WALLET_LOCATION =\n (SOURCE=\n (METHOD=FILE)\n (METHOD_DATA=\n (DIRECTORY=\/var\/opt\/oracle\/dbaas_acfs\/boston\/tde_wallet)))\nSQLNET.ENCRYPTION_TYPES_SERVER = (AES256, AES192, AES128)\nSQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS = TRUE\nHTTPS_SSL_VERSION = 1.2\nSQLNET.EXPIRE_TIME = 10\nSQLNET.WALLET_OVERRIDE = FALSE\nSSL_VERSION = 1.2\nWALLET_LOCATION = (SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=\/var\/opt\/oracle\/dbaas_acfs\/boston\/db_wallet)))\nError:\nSQL> set lines 200 pages 9999\ncSQL> ol WRL_PARAMETER format a50\nSQL> select * from V_$ENCRYPTION_WALLET;\nWRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR KEYSTORE FULLY_BAC CON_ID\n-------------------- -------------------------------------------------- -------- -------------------- --------- -------- --------- ----------\nFILE \/u02\/app\/oracle\/admin\/boston\/wallet NOT_AVAI UNKNOWN SINGLE NONE UNDEFINED 1\n LABLE\nFILE NOT_AVAI UNKNOWN SINGLE UNITED UNDEFINED 2\n LABLE\nFILE NOT_AVAI UNKNOWN SINGLE UNITED UNDEFINED 3\n LABLE\nSQL> quit\nNeed be to correct location - restart boston and check in london - copy sqlnet.ora to update in all nodes. Repeat london and boston\n[18.0.0.0 SID:boston1][oracle@tech01:\/u02\/app\/oracle\/product\/18.0.0.0\/dbhome_2\/network\/admin\/london ] london$\n scp sqlnet.ora oracle@tech02:`pwd`\n<\/code><\/pre>\n\n