{"id":29481,"date":"2022-02-22T22:17:55","date_gmt":"2022-02-22T22:17:55","guid":{"rendered":"https:\/\/dbtut.com\/?p=29481"},"modified":"2022-02-22T22:19:48","modified_gmt":"2022-02-22T22:19:48","slug":"physical-standby-setup-single-node","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/","title":{"rendered":"Physical Standby Setup-SINGLE NODE"},"content":{"rendered":"

In today’s article, we will talk about Physical Standby Setup-SINGLE NODE.<\/p>\n

1. We query the status of the listener to see which services are running in the primary database.<\/p>\n

2.<\/p>\n

\t[root@prod ~]# su - oracle\r\n\t[oracle@prod ~]$ lsnrctl status\r\n\t\r\n\tLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-FEB-2017 07:02:36\r\n\t\r\n\tCopyright (c) 1991, 2013, Oracle.  All rights reserved.\r\n\t\r\n\tConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))\r\n\tSTATUS of the LISTENER\r\n\t------------------------\r\n\tAlias                     LISTENER\r\n\tVersion                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production\r\n\tStart Date                16-FEB-2017 22:25:36\r\n\tUptime                    0 days 8 hr. 37 min. 1 sec\r\n\tTrace Level               off\r\n\tSecurity                  ON: Local OS Authentication\r\n\tSNMP                      OFF\r\n\tListener Parameter File   \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora\r\n\tListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/prod\/listener\/alert\/log.xml\r\n\tListening Endpoints Summary...\r\n\t  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\r\n\t  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod.tivibulab.local)(PORT=1521)))\r\n\tServices Summary...\r\n\tService \"prod\" has 1 instance(s).\r\n\t  Instance \"prod\", status READY, has 1 handler(s) for this service...\r\n\tService \"prodXDB\" has 1 instance(s).\r\n\t  Instance \"prod\", status READY, has 1 handler(s) for this service...\r\n\tThe command completed successfully\r\n\t\r\n<\/pre>\n
3.\u00a0We query the contents of the Listener.ORA file.<\/p>\n
\t[oracle@prod admin]$ cat listener.ora\r\n\t# listener.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora\r\n\t# Generated by Oracle configuration tools.\r\n\t\r\n\tLISTENER =\r\n\t  (DESCRIPTION_LIST =\r\n\t    (DESCRIPTION =\r\n\t      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\r\n\t      (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521))\r\n\t    )\r\n\t  )\r\n\t\r\n\tADR_BASE_LISTENER = \/u01\/app\/oracle\r\n<\/pre>\n
4.We query the contents of the SQLNET.ORA file to see which naming methods are in the primary database.<\/p>\n
\t[oracle@prod ~]$ cd $ORACLE_HOME\/network\/admin\r\n\t[oracle@prod admin]$ ls\r\n\tlistener.ora  samples  shrept.lst  sqlnet.ora  tnsnames.ora\r\n\t[oracle@prod admin]$ cat sqlnet.ora \r\n\t# sqlnet.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/sqlnet.ora\r\n\t# Generated by Oracle configuration tools.\r\n\t\r\n\tNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)\r\n\t\r\n\tADR_BASE = \/u01\/app\/oracle\r\n\t\r\n<\/pre>\n
5.\u00a0We query which services are registered in the TNSNAMES.ORA file.<\/p>\n
\t[oracle@prod admin]$ cat tnsnames.ora\r\n\t# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\t# Generated by Oracle configuration tools.\r\n\t\r\n\tPROD =\r\n\t  (DESCRIPTION =\r\n\t    (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521))\r\n\t    (CONNECT_DATA =\r\n\t      (SERVER = DEDICATED)\r\n\t      (SERVICE_NAME = prod)\r\n\t    )\r\n\t  )\r\n<\/pre>\n
6.We add the TNSNAMES method to the SQLNET.ORA file. We use NETMGR for this.<\/p>\n
a. By connecting to the server from the terminal, switching to the Oracle user and running netmgr.<\/p>\n
\"\"<\/p>\n
b. We check the “Profile” settings.<\/p>\n
\"\"<\/p>\n
c. We extract the EZCONNECT method in the “Selected Methods” section.<\/p>\n
\"\"<\/p>\n
The reason why HOSTNAME is not added directly is because the order of Methods is wanted to be made as TNSNAMES-HOSTNAME-EZCONNECT. Otherwise, as we will see below, no method would be active.<\/p>\n
\t\t[oracle@prod admin]$ cat sqlnet.ora \r\n\t\t# sqlnet.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/sqlnet.ora\r\n\t\t# Generated by Oracle configuration tools.\r\n\t\t\r\nADR_BASE = \/u01\/app\/oracle<\/pre>\n
\u00e7. First we add HOSTNAME and then EZCONNECT to “Selected Methods” .<\/p>\n
\"\"<\/p>\n
d. Save the changes made in the “File” section and exit.<\/p>\n
e. We check whether the change is reflected in the SQLNET.ORA file.<\/p>\n
\t\t[oracle@prod admin]$ cat sqlnet.ora \r\n\t\t# sqlnet.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/sqlnet.ora\r\n\t\t# Generated by Oracle configuration tools.\r\n\t\t\r\n\t\tNAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)\r\n\t\t\r\n\t\tADR_BASE = \/u01\/app\/oracle\r\n<\/pre>\n
7. Services are added to the TNSNAMES.ORA file that will enable Clients to automatically connect to Standby when Physical Standby and Primary cannot be accessed. We use NETMGR for this.<\/p>\n
a. By connecting to the server from the terminal, switch to the Oracle user and run netmgr.<\/p>\n
\"\"<\/p>\n
b. In the window that opens, with the Service Naming tab active, click the Create button with the “+” sign.<\/p>\n
\"\"<\/p>\n
In our configuration, the Service Naming field will not be that much service. There will be only 1 service. It seems too much here because it was made for testing purposes.<\/p>\n
c. We write “standby” in the Net Service Naming field.<\/p>\n
\"\"<\/p>\n
\u00e7. We choose “TCP\/IP” as the network protocol.<\/p>\n
\"\"<\/p>\n
d. As Hostname, we write “prod.tivibulab.local”, which is the Hostname of the Primary database, and “1521” as the Port.<\/p>\n
The hostname is learned as follows.<\/p>\n
\t\t[oracle@prod admin]$ hostname\r\n\t\tprod.tivibulab.local\r\n<\/pre>\n
\"\"<\/p>\n
e. Select “standby” as Service Name and “Dedicated Server” as Connection Type.<\/p>\n
\"\"<\/p>\n
f. With Finish, we complete the service creation process<\/p>\n
\"\"<\/p>\n
g. The service is configured. Click on the Advanced button.<\/p>\n
\"\"<\/p>\n
\u011f. We write “32767” in the Session Data Unit field. This value increases the network throughput. Normally, this value is 64KB for 12cR1, but we enter 32767 because NETMGR does not support this value. It will then be edited manually.<\/p>\n
\"\"<\/p>\n
h. Send and Receive Buffer Sizes are set for the network throughput. We make this adjustment accordingly.<\/p>\n
\t\tTCP Socket Buffer size=BDP*3=network bandwidth*latency*3\r\n<\/pre>\n
This value is compared to 10 MB. Whichever is greater is entered.<\/p>\n
Let’s calculate.<\/h5>\n
Network Bandwidth= 1 Gbit\/s<\/span>
\nLatency=0.288 ms [This value can be seen by pinging the Primary Far SYNC instance, where it sends the Redos from the Primary]<\/span><\/p>\n
\t\t \r\n\t\t[root@primary ~]# ping 172.20.42.62\r\n\t\tPING 172.20.42.62 (172.20.42.62) 56(84) bytes of data.\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=1 ttl=64 time=0.339 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=2 ttl=64 time=0.285 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=3 ttl=64 time=0.301 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=4 ttl=64 time=0.297 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=5 ttl=64 time=0.294 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=6 ttl=64 time=0.217 ms\r\n\t\t\r\n\t\t--- 172.20.42.62 ping statistics ---\r\n\t\t6 packets transmitted, 6 received, 0% packet loss, time 5001ms\r\n\t\trtt min\/avg\/max\/mdev = 0.217\/0.288\/0.339\/0.042 ms\r\n<\/pre>\n
TCP Socket Buffer size= 1,000,000* (1\/8) * 0.288*(1\/1000)s * 3 = 108 bytes<\/p>\n
Therefore, the value of 10MB=10*1024*1024=10485760 bytes is written to the “Show Advanced” section of each 2 Adress Configuration section.<\/p>\n
\"\"<\/p>\n
In our configuration, there will be only one Address in the “Address Configuration” field. Here, there are 2 for testing purposes.<\/p>\n
\u0131. We write “prmy” in the Net Service Naming field.<\/p>\n
\"\"<\/p>\n
i. Settings are saved by clicking “Save” in the “File” section.<\/p>\n
j.We choose “TCP\/IP” as the network protocol.<\/p>\n
\"\"<\/p>\n
k. As Hostname, we write “prod.tivibulab.local”, which is the Hostname of the Primary database, and “1521” as the Port.<\/p>\n
\"\"<\/p>\n
l. We choose “prmy” as Service Name and “Dedicated Server” as Connection Type.<\/p>\n
\"\"<\/p>\n
m. With Finish, we complete the service creation process.<\/p>\n
\"\"<\/p>\n
n. The service is configured. Click on the Advanced button.<\/p>\n
\"\"<\/p>\n
o. We write “32767” in the Session Data Unit field. This value increases the network throughput. Normally, this value is 64KB recommended for 12cR1, but 32767 is entered because NETMGR does not support this value. It will then be edited manually.<\/p>\n
\"\"<\/p>\n
\u00f6.The database that will be primary in the role change is added to the Address Configuration field. We do this with the + sign.<\/p>\n
\"\"<\/p>\n
p. As the hostname, we write the Target Standby database information of Switchover and Failover. We write “standby.tivibulab.local” as the Hostname and “1521” as the Port.<\/p>\n
\"\"<\/p>\n
r. Send and Receive Buffer Sizes are set for the network throughput. We make this adjustment accordingly.<\/p>\n
TCP Socket Buffer size=BDP*3=network bandwidth*latency*3<\/p>\n
This value is compared to 10MB. Whichever is greater is entered.<\/p>\n
Let’s calculate.<\/h5>\n
Network Bandwidth= 1 Gbit\/s
\nLatency=0.288 ms [This value can be seen by pinging the Primary Far SYNC instance where it sends the Redos from the Primary]\n
 <\/p>\n
\t\t[root@primary ~]# ping 172.20.42.62\r\n\t\tPING 172.20.42.62 (172.20.42.62) 56(84) bytes of data.\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=1 ttl=64 time=0.339 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=2 ttl=64 time=0.285 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=3 ttl=64 time=0.301 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=4 ttl=64 time=0.297 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=5 ttl=64 time=0.294 ms\r\n\t\t64 bytes from 172.20.42.62: icmp_seq=6 ttl=64 time=0.217 ms\r\n\t\t\r\n\t\t--- 172.20.42.62 ping statistics ---\r\n\t\t6 packets transmitted, 6 received, 0% packet loss, time 5001ms\r\n\t\trtt min\/avg\/max\/mdev = 0.217\/0.288\/0.339\/0.042 ms\r\n<\/pre>\n
TCP Socket Buffer size= 1,000,000* (1\/8) * 0.288*(1\/1000)s * 3 = 108 bytes<\/p>\n
Therefore, we write the value of 10MB=10*1024*1024=10485760 bytes in the “Show Advanced” section of each 2 Adress Configuration section.<\/p>\n
\"\"<\/p>\n
s. Similarly, the SDU_UNIT and SEND-RECV_BUF_SIZE parameters of the PROD service are edited.<\/p>\n
\u015f. We save it by clicking “Save” in the “File” section of the settings.<\/p>\n
t. We change the SDU value to “65535”. For this, open the TNSNAMES.ORA file with the vi text editor and run the following command.<\/p>\n
\t\t:%s\/SDU = 32767\/SDU = 65535\/g\r\n<\/pre>\n
u. We check whether the change is reflected in the TNSNAMES.ORA file.<\/p>\n
\t\t[oracle@prod admin]$ cat tnsnames.ora \r\n\t\t# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\t\t# Generated by Oracle configuration tools.\r\n\t\t\r\n\t\tPROD =\r\n\t\t  (DESCRIPTION =\r\n\t\t    (ADDRESS_LIST =\r\n\t\t      (ADDRESS = (PROTOCOL = TCP)(HOST = prod.tivibulab.local)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n\t\t    )\r\n\t\t    (SDU = 65535)\r\n\t\t    (CONNECT_DATA =\r\n\t\t      (SERVER = DEDICATED)\r\n\t\t      (SERVICE_NAME = prod)\r\n\t\t    )\r\n\t\t  )\r\n\t\t\r\n\t\tPRMY =\r\n\t\t  (DESCRIPTION =\r\n\t\t    (ADDRESS_LIST =\r\n\t\t      (ADDRESS = (PROTOCOL = TCP)(HOST = prod.tivibulab.local)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n\t\t      (ADDRESS = (PROTOCOL = TCP)(HOST = standby.tivibulab.local)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n\t\t    )\r\n\t\t    (SDU = 65535)\r\n\t\t    (CONNECT_DATA =\r\n\t\t      (SERVER = DEDICATED)\r\n\t\t      (SERVICE_NAME = prmy)\r\n\t\t    )\r\n\t\t  )\r\n\t\t\r\n\t\tSTANDBY =\r\n\t\t  (DESCRIPTION =\r\n\t\t    (ADDRESS_LIST =\r\n\t\t      (ADDRESS = (PROTOCOL = TCP)(HOST = standby.tivibulab.local)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n\t\t    )\r\n\t\t    (SDU = 65535)\r\n\t\t    (CONNECT_DATA =\r\n\t\t      (SERVER = DEDICATED)\r\n\t\t      (SERVICE_NAME = standby)\r\n\t\t    )\r\n\t\t  )\r\n<\/pre>\n
8. Copy the TNSNAMES.ORA file to the Standby database.<\/p>\n
\t[oracle@prod admin]$ scp tnsnames.ora standby:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora \r\n\tThe authenticity of host 'standby (172.20.42.67)' can't be established.\r\n\tRSA key fingerprint is d5:8d:60:b8:52:55:f5:01:a4:fb:06:05:45:bd:55:a7.\r\n\tAre you sure you want to continue connecting (yes\/no)? yes\r\n\tWarning: Permanently added 'standby,172.20.42.67' (RSA) to the list of known hosts.\r\n\toracle@standby's password: \r\n\ttnsnames.ora                             100% 1140     1.1KB\/s   00:00    \r\n<\/pre>\n
9.we check if the file goes to the Standby database.<\/p>\n
\t[oracle@standby admin]$ cat tnsnames.ora \r\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nPROD =\r\n  (DESCRIPTION =\r\n    (ADDRESS_LIST =\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = prod.tivibulab.local)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n    )\r\n    (SDU = 65535)\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = prod)\r\n    )\r\n  )\r\n\r\nPRMY =\r\n  (DESCRIPTION =\r\n    (ADDRESS_LIST =\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = prod.tivibulab.local)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = standby.tivibulab.local)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n    )\r\n    (SDU = 65535)\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = prmy)\r\n    )\r\n  )\r\n\r\nSTANDBY =\r\n  (DESCRIPTION =\r\n    (ADDRESS_LIST =\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = standby.tivibulab.local)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n    )\r\n    (SDU = 65535)\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = standby)\r\n    )\r\n  )\r\n<\/pre>\n
1.\u00a0Copy the SQLNET.ORA file to the Standby database.<\/p>\n
\t[oracle@prod admin]$ scp sqlnet.ora standby:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/sqlnet.ora \r\n\toracle@standby's password: \r\n\tsqlnet.ora                               100%  229     0.2KB\/s   00:00    \r\n\t\r\n<\/pre>\n
2. We check if the file is in the Standby database.<\/p>\n
\t[oracle@standby admin]$ cat sqlnet.ora \r\n\t# sqlnet.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/sqlnet.ora\r\n\t# Generated by Oracle configuration tools.\r\n\t\r\n\tNAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)\r\n\t\r\n\tADR_BASE = \/u01\/app\/oracle\r\n\t\r\n<\/pre>\n
3. Edit the LISTENER.ORA file.<\/p>\n
a. We set it for the Default LISTENER network throughput. We edit the SEND and RECV_BUFSIZE as stated above.<\/p>\n
\"\"<\/p>\n
b. The change is saved.<\/p>\n
\"\"<\/p>\n
The reason for this error is that this value cannot be set as 10485760 in NETMGR. Therefore, the value 65535 is set. Then we open the file from the vi text editor and edit it.<\/p>\n
c. Click on “Database Services” and add Static listener. This is because RMAN and Broker can open the database when the database is closed.<\/p>\n
\"\"<\/p>\n
\u00e7. As the first service, we add the Primary database.<\/p>\n
\"\"<\/p>\n
d. We add the second database from the “Add Database” tab.<\/p>\n
\"\"<\/p>\n
e.The second database’s name has a format. This format is <instance_name>_DGMGRL_<domain_name>. It is added in accordance with this format.<\/p>\n
\"\"<\/p>\n
f. Changes made are saved in the “File” section.<\/p>\n
g. We check the correctness of the changes in the LISTENER.ORA file.<\/p>\n
\t\t[oracle@prod admin]$ cat listener.ora \r\n\t\t# listener.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora\r\n\t\t# Generated by Oracle configuration tools.\r\n\t\t\r\n\t\tSID_LIST_LISTENER =\r\n\t\t  (SID_LIST =\r\n\t\t    (SID_DESC =\r\n\t\t      (GLOBAL_DBNAME = prod)\r\n\t\t      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1)\r\n\t\t      (SID_NAME = prod)\r\n\t\t    )\r\n\t\t    (SID_DESC =\r\n\t\t      (GLOBAL_DBNAME = prod_DGMGRL)\r\n\t\t      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1)\r\n\t\t      (SID_NAME = prod)\r\n\t\t    )\r\n\t\t  )\r\n\t\t\r\n\t\tLISTENER =\r\n\t\t  (DESCRIPTION_LIST =\r\n\t\t    (DESCRIPTION =\r\n\t\t      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\r\n\t\t    )\r\n\t\t    (DESCRIPTION =\r\n\t\t      (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521)(SEND_BUF_SIZE = 65535)(RECV_BUF_SIZE = 65535))\r\n\t\t    )\r\n\t\t  )\r\n\t\t\r\n\t\tADR_BASE_LISTENER = \/u01\/app\/oracle\r\n<\/pre>\n
\u011f.We optimize the BUF_SIZE parameters. We open the file with vi and make the necessary adjustments.<\/p>\n
\t\t:%s\/BUF_SIZE = 65535\/BUF_SIZE = 10485760\/g\r\n<\/pre>\n
h.We’ll check if there’s any change.<\/p>\n
\t\t[oracle@prod admin]$ cat listener.ora \r\n\t\t# listener.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora\r\n\t\t# Generated by Oracle configuration tools.\r\n\t\t\r\n\t\tSID_LIST_LISTENER =\r\n\t\t  (SID_LIST =\r\n\t\t    (SID_DESC =\r\n\t\t      (GLOBAL_DBNAME = prod)\r\n\t\t      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1)\r\n\t\t      (SID_NAME = prod)\r\n\t\t    )\r\n\t\t    (SID_DESC =\r\n\t\t      (GLOBAL_DBNAME = prod_DGMGRL)\r\n\t\t      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1)\r\n\t\t      (SID_NAME = prod)\r\n\t\t    )\r\n\t\t  )\r\n\t\t\r\n\t\tLISTENER =\r\n\t\t  (DESCRIPTION_LIST =\r\n\t\t    (DESCRIPTION =\r\n\t\t      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\r\n\t\t    )\r\n\t\t    (DESCRIPTION =\r\n\t\t      (ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))\r\n\t\t    )\r\n\t\t  )\r\n\t\t\r\n\t\tADR_BASE_LISTENER = \/u01\/app\/oracle\r\n<\/pre>\n
I. By RELOAD the Listener, we ensure the permanence of the changes.<\/p>\n
\t\t[oracle@prod admin]$ lsnrctl reload\r\n\t\t\r\n\t\tLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-FEB-2017 08:03:29\r\n\t\t\r\n\t\tCopyright (c) 1991, 2013, Oracle.  All rights reserved.\r\n\t\t\r\n\t\tConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod.tivibulab.local)(PORT=1521)(SEND_BUF_SIZE=65535)(RECV_BUF_SIZE=65535)))\r\n\t\tThe command completed successfully\r\n<\/pre>\n
i. We check the status of the Listener to see if the services have started.<\/p>\n
\t\t[oracle@prod admin]$ lsnrctl status\r\n\t\t\r\n\t\tLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-FEB-2017 07:48:48\r\n\t\t\r\n\t\tCopyright (c) 1991, 2013, Oracle.  All rights reserved.\r\n\t\t\r\n\t\tConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))\r\n\t\tSTATUS of the LISTENER\r\n\t\t------------------------\r\n\t\tAlias                     LISTENER\r\n\t\tVersion                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production\r\n\t\tStart Date                17-FEB-2017 07:25:12\r\n\t\tUptime                    0 days 0 hr. 23 min. 35 sec\r\n\t\tTrace Level               off\r\n\t\tSecurity                  ON: Local OS Authentication\r\n\t\tSNMP                      OFF\r\n\t\tListener Parameter File   \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora\r\n\t\tListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/prod\/listener\/alert\/log.xml\r\n\t\tListening Endpoints Summary...\r\n\t\t  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\r\n\t\t  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod.tivibulab.local)(PORT=1521)))\r\n\t\tServices Summary...\r\n\t\tService \"prod\" has 2 instance(s).\r\n\t\t  Instance \"prod\", status UNKNOWN, has 1 handler(s) for this service...\r\n\t\t  Instance \"prod\", status READY, has 1 handler(s) for this service...\r\n\t\tService \"prodXDB\" has 1 instance(s).\r\n\t\t  Instance \"prod\", status READY, has 1 handler(s) for this service...\r\n\t\tService \"prod_DGMGRL\" has 1 instance(s).\r\n\t\t  Instance \"prod\", status UNKNOWN, has 1 handler(s) for this service...\r\n\t\tThe command completed successfully\r\n<\/pre>\n
j. Similar arrangements are made in the standby database. But there is no LISTENER.ORA because there is no database installed in Standby yet. We can also see this when checked from NETMGR.<\/p>\n
\"\"<\/p>\n
k.A listener named LISTENER is created.<\/p>\n
\"\"<\/p>\n
l.\u00a0After the Listener is created, we initialize the Listener for the persistence of the changes. The RELOAD command will give an error because there is no LISTENER running here, so it cannot be STOPed. Therefore, the START command is executed.<\/p>\n
\t\t[oracle@standby admin]$ lsnrctl\r\n\t\t\r\n\t\tLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-FEB-2017 07:54:49\r\n\t\t\r\n\t\tCopyright (c) 1991, 2013, Oracle.  All rights reserved.\r\n\t\t\r\n\t\tWelcome to LSNRCTL, type \"help\" for information.\r\n\t\t\r\n\t\tLSNRCTL> start\r\n\t\tStarting \/u01\/app\/oracle\/product\/11.2.0\/db_1\/bin\/tnslsnr: please wait...\r\n\t\t\r\n\t\tTNSLSNR for Linux: Version 11.2.0.4.0 - Production\r\n\t\tSystem parameter file is \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora\r\n\t\tLog messages written to \/u01\/app\/oracle\/diag\/tnslsnr\/standby\/listener\/alert\/log.xml\r\n\t\tListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby.tivibulab.local)(PORT=1521)))\r\n\t\t\r\n\t\tConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=standby.tivibulab.local)(PORT=1521)(SEND_BUF_SIZE=65535)(RECV_BUF_SIZE=65535)))\r\n\t\tSTATUS of the LISTENER\r\n\t\t------------------------\r\n\t\tAlias                     LISTENER\r\n\t\tVersion                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production\r\n\t\tStart Date                17-FEB-2017 07:54:52\r\n\t\tUptime                    0 days 0 hr. 0 min. 0 sec\r\n\t\tTrace Level               off\r\n\t\tSecurity                  ON: Local OS Authentication\r\n\t\tSNMP                      OFF\r\n\t\tListener Parameter File   \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora\r\n\t\tListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/standby\/listener\/alert\/log.xml\r\n\t\tListening Endpoints Summary...\r\n\t\t  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby.tivibulab.local)(PORT=1521)))\r\n\t\tServices Summary...\r\n\t\tService \"standby\" has 1 instance(s).\r\n\t\t  Instance \"standby\", status UNKNOWN, has 1 handler(s) for this service...\r\n\t\tService \"standby_DGMGRL\" has 1 instance(s).\r\n\t\t  Instance \"standby\", status UNKNOWN, has 1 handler(s) for this service...\r\n\t\tThe command completed successfully\r\n<\/pre>\n
4. Since I don’t want the database to start automatically when the server with the standby database reboots, I make the necessary adjustments in \/etc\/oratab.<\/p>\n
\t[oracle@standby admin]$ echo standby:\/u01\/app\/oracle\/product\/11.2.0\/db_1:N >> \/etc\/oratab\r\n\t\r\n<\/pre>\n
5. We check if the change is reflected.<\/p>\n
\t[oracle@standby admin]$ cat \/etc\/oratab\r\n\t#\r\n\t\r\n\t\r\n\t\r\n\t# This file is used by ORACLE utilities.  It is created by root.sh\r\n\t# and updated by either Database Configuration Assistant while creating\r\n\t# a database or ASM Configuration Assistant while creating ASM instance.\r\n\t\r\n\t# A colon, ':', is used as the field terminator.  A new line terminates\r\n\t# the entry.  Lines beginning with a pound sign, '#', are comments.\r\n\t#\r\n\t# Entries are of the form:\r\n\t#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:\r\n\t#\r\n\t# The first and second fields are the system identifier and home\r\n\t# directory of the database respectively.  The third filed indicates\r\n\t# to the dbstart utility that the database should , \"Y\", or should not,\r\n\t# \"N\", be brought up at system boot time.\r\n\t#\r\n\t# Multiple entries with the same $ORACLE_SID are not allowed.\r\n\t#\r\n\t#\r\n\tstandby:\/u01\/app\/oracle\/product\/11.2.0\/db_1:N\r\n<\/pre>\n
6. It is ensured that everything is logged in the primary database.<\/p>\n
Prod] SQL> select force_logging from v$database;\r\n\t\r\n\tFOR\r\n\t---\r\n\tNO\r\n\t\r\n\t[Prod] SQL> alter database force logging;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Prod] SQL> select force_logging from v$database;\r\n\t\r\n\tFOR\r\n\t---\r\n\tYES\r\n<\/pre>\n
7. We learn the number of Online Redo Logs in the primary database.<\/p>\n
\t[Prod] SQL> select group#,bytes from v$log;\r\n\t\r\n\t    GROUP#      BYTES\r\n\t---------- ----------\r\n\t         1   52428800\r\n\t         2   52428800\r\n\t         3   52428800\r\n<\/pre>\n
8. Standby Log Files are created in the primary database. The reason why this was created in Primary is to be ready before the role change processes.<\/p>\n
\t[Prod] SQL> alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/prod\/stdbyredo01.log') size 50M;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Prod] SQL> alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/prod\/stdbyredo02.log') size 50M;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Prod] SQL> alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/prod\/stdbyredo03.log') size 50M;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Prod] SQL> alter database add standby logfile ('\/u01\/app\/oracle\/oradata\/prod\/stdbyredo04.log') size 50M;\r\n\t\r\n\tDatabase altered.\r\n<\/pre>\n
The reason for creating one more than the number of Online Redo Logs is that the Log Switch process in the Primary database is not kept waiting due to the slowness that will occur due to Network or other reasons, because the Redo’s go late to the Standby side.<\/p>\n
9. We check whether the Standby Log Files are created.<\/p>\n
\t[Prod] SQL> select group#,bytes from v$standby_log;\r\n\t\r\n\t    GROUP#      BYTES\r\n\t---------- ----------\r\n\t         4   52428800\r\n\t         5   52428800\r\n\t         6   52428800\r\n\t         7   52428800\r\n<\/pre>\n
10. We set where the archives to be created in the primary database will be saved.<\/p>\n
\t[Prod] SQL> alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=prod' scope=both;\r\n\t\r\n\tSystem altered.\r\n<\/pre>\n
11. We set the parameter to send the archives to the specified location. Although this parameter is already ENABLE in Default, we set it again for discipline.<\/p>\n
\t[Prod] SQL> alter system set log_archive_dest_state_1='enable' scope=both;\r\n\t\r\n\tSystem altered.\r\n<\/pre>\n
12.We set the number of archive processes.<\/p>\n
\t[Prod] SQL> alter system set log_archive_max_processes=8 scope=both;\r\n\t\r\n\tSystem altered.\r\n<\/pre>\n
13. We specify which databases the Data Guard Environment will consist of.<\/p>\n
\t[Prod] SQL> alter system set log_archive_config='dg_config=(prod,standby)' scope=both;\r\n\t\r\n\tSystem altered.\r\n<\/pre>\n
14. We ensure that datafiles and online redo logs to be added to the Primary are automatically added to the Standby side.<\/p>\n
\t[Prod] SQL> alter system set standby_file_management='auto' scope=both;\r\n\t\r\n\tSystem altered.\r\n<\/pre>\n
15. Necessary directories are created on the standby side.<\/p>\n
\t[oracle@standby ~]$ mkdir -p \/u01\/app\/oracle\/admin\/standby\/adump\r\n\t[oracle@standby ~]$ mkdir -p \/u01\/app\/oracle\/oradata\/standby\r\n\t[oracle@standby ~]$ mkdir -p \/u01\/app\/oracle\/fast_recovery_area\/standby\r\n<\/pre>\n
16. In order for the standby database to be duplicated with RMAN, it must be in the NOMOUNT step.<\/p>\n
2 parameters are required to bring a database to NOMOUNT. One of them is DB_NAME and the other is DB_DOMAIN.<\/p>\n
With a PFILE with these parameters, the database can be brought to NOMOUNT. Other parameters take their default values in memory.<\/p>\n
\t[oracle@standby ~]$ echo 'DB_NAME=standby' > \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initstandby.ora\r\n<\/pre>\n
We do not use the DB_DOMAIN parameter. If we were to use it, we would run the following command.<\/p>\n
\techo 'DB_DOMAIN=example.com' >> \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initstandby.ora\r\n<\/pre>\n
17. Copy the Primary’s Password file to the Standby side.<\/p>\n
\t\r\n\t[oracle@prod admin]$ cd \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/\r\n\t[oracle@prod dbs]$ scp orapwprod standby:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwstandby\r\n\toracle@standby's password: \r\n\torapwprod                                                                       100% 1536     1.5KB\/s   00:00   \r\n\t\r\n<\/pre>\n
18. We NOMOUNT by connecting to the standby database.<\/p>\n
\t[oracle@standby dbs]$ sqlplus \/ as sysdba\r\n\t\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 17 08:50:14 2017\r\n\t\r\n\tCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\n\t\r\n\tConnected to an idle instance.\r\n\t\r\n\t[Standby] SQL> startup nomount;\r\n\tORACLE instance started.\r\n\t\r\n\tTotal System Global Area  263090176 bytes\r\n\tFixed Size                  2252256 bytes\r\n\tVariable Size             205521440 bytes\r\n\tDatabase Buffers           50331648 bytes\r\n\tRedo Buffers                4984832 bytes\r\n\t\r\n<\/pre>\n
19. On the standby side, we connect to RMAN as TARGET as Primary database and as Standby database as AUXILIARY.<\/p>\n
\t[oracle@standby dbs]$ rman target sys\/Passw0rd4@prod auxiliary sys\/Passw0rd4@standby\r\n\t\r\n\tRecovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 17 08:51:26 2017\r\n\t\r\n\tCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\t\r\n\tconnected to target database: PROD (DBID=347976743)\r\n\tconnected to auxiliary database: STANDBY (not mounted)\r\n\t\r\n<\/pre>\n
20. Primary database is DUPLICATED<\/p>\n
\tRMAN> run {\r\n\t2> allocate channel prmy1 type disk;\r\n\t3> allocate auxiliary channel stby1 type disk;\r\n\t4> duplicate target database for standby from active database\r\n\t5> spfile\r\n\t6> parameter_value_convert 'prod','standby'\r\n\t7> set db_unique_name='standby'\r\n\t8> set db_file_name_convert='prod','standby'\r\n\t9> set log_file_name_convert='prod','standby'\r\n\t10> set fal_server='prod'\r\n\t11> nofilenamecheck;\r\n\t12> allocate auxiliary channel stby type disk;\r\n\t13> sql channel stby \"alter database recover managed standby database disconnect\"; }\r\n\t\r\n\tusing target database control file instead of recovery catalog\r\n\tallocated channel: prmy1\r\n\tchannel prmy1: SID=73 device type=DISK\r\n\t\r\n\tallocated channel: stby1\r\n\tchannel stby1: SID=429 device type=DISK\r\n\t\r\n\tStarting Duplicate Db at 17-FEB-17\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   backup as copy reuse\r\n\t   targetfile  '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwprod' auxiliary format \r\n\t '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwstandby'   targetfile \r\n\t '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/spfileprod.ora' auxiliary format \r\n\t '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/spfilestandby.ora'   ;\r\n\t   sql clone \"alter system set spfile= ''\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/spfilestandby.ora''\";\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tStarting backup at 17-FEB-17\r\n\tFinished backup at 17-FEB-17\r\n\t\r\n\tsql statement: alter system set spfile= ''\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/spfilestandby.ora''\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   sql clone \"alter system set  audit_file_dest = \r\n\t ''\/u01\/app\/oracle\/admin\/standby\/adump'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  control_files = \r\n\t ''\/u01\/app\/oracle\/oradata\/standby\/control01.ctl'', ''\/u01\/app\/oracle\/fast_recovery_area\/standby\/control02.ctl'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  dispatchers = \r\n\t ''(PROTOCOL=TCP) (SERVICE=standbyXDB)'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  log_archive_dest_1 = \r\n\t ''location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=standby'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  db_unique_name = \r\n\t ''standby'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  db_file_name_convert = \r\n\t ''prod'', ''standby'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  log_file_name_convert = \r\n\t ''prod'', ''standby'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  fal_server = \r\n\t ''prod'' comment=\r\n\t '''' scope=spfile\";\r\n\t   shutdown clone immediate;\r\n\t   startup clone nomount;\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tsql statement: alter system set  audit_file_dest =  ''\/u01\/app\/oracle\/admin\/standby\/adump'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  control_files =  ''\/u01\/app\/oracle\/oradata\/standby\/control01.ctl'', ''\/u01\/app\/oracle\/fast_recovery_area\/standby\/control02.ctl'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  dispatchers =  ''(PROTOCOL=TCP) (SERVICE=standbyXDB)'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  log_archive_dest_1 =  ''location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=standby'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  db_unique_name =  ''standby'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  db_file_name_convert =  ''prod'', ''standby'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  log_file_name_convert =  ''prod'', ''standby'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  fal_server =  ''prod'' comment= '''' scope=spfile\r\n\t\r\n\tOracle instance shut down\r\n\t\r\n\tconnected to auxiliary database (not started)\r\n\tOracle instance started\r\n\t\r\n\tTotal System Global Area    3457368064 bytes\r\n\t\r\n\tFixed Size                     2258120 bytes\r\n\tVariable Size                771754808 bytes\r\n\tDatabase Buffers            2667577344 bytes\r\n\tRedo Buffers                  15777792 bytes\r\n\tallocated channel: stby1\r\n\tchannel stby1: SID=63 device type=DISK\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   backup as copy current controlfile for standby auxiliary format  '\/u01\/app\/oracle\/oradata\/standby\/control01.ctl';\r\n\t   restore clone controlfile to  '\/u01\/app\/oracle\/fast_recovery_area\/standby\/control02.ctl' from \r\n\t '\/u01\/app\/oracle\/oradata\/standby\/control01.ctl';\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tStarting backup at 17-FEB-17\r\n\tchannel prmy1: starting datafile copy\r\n\tcopying standby control file\r\n\toutput file name=\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/snapcf_prod.f tag=TAG20170217T085345 RECID=2 STAMP=936176025\r\n\tchannel prmy1: datafile copy complete, elapsed time: 00:00:01\r\n\tFinished backup at 17-FEB-17\r\n\t\r\n\tStarting restore at 17-FEB-17\r\n\t\r\n\tchannel stby1: copied control file copy\r\n\tFinished restore at 17-FEB-17\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   sql clone 'alter database mount standby database';\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tsql statement: alter database mount standby database\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   set newname for tempfile  1 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/temp01.dbf\";\r\n\t   switch clone tempfile all;\r\n\t   set newname for datafile  1 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/system01.dbf\";\r\n\t   set newname for datafile  2 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/sysaux01.dbf\";\r\n\t   set newname for datafile  3 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/undotbs01.dbf\";\r\n\t   set newname for datafile  4 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/users01.dbf\";\r\n\t   set newname for datafile  5 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/example01.dbf\";\r\n\t   backup as copy reuse\r\n\t   datafile  1 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/system01.dbf\"   datafile \r\n\t 2 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/sysaux01.dbf\"   datafile \r\n\t 3 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/undotbs01.dbf\"   datafile \r\n\t 4 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/users01.dbf\"   datafile \r\n\t 5 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/example01.dbf\"   ;\r\n\t   sql 'alter system archive log current';\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\trenamed tempfile 1 to \/u01\/app\/oracle\/oradata\/standby\/temp01.dbf in control file\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\tStarting backup at 17-FEB-17\r\n\tchannel prmy1: starting datafile copy\r\n\tRMAN-03009: failure of backup command on prmy1 channel at 02\/17\/2017 08:53:53\r\n\tORA-19602: cannot backup or copy active file in NOARCHIVELOG mode\r\n\tcontinuing other job steps, job failed will not be re-run\r\n\tchannel prmy1: starting datafile copy\r\n\tRMAN-03009: failure of backup command on prmy1 channel at 02\/17\/2017 08:53:53\r\n\tORA-19602: cannot backup or copy active file in NOARCHIVELOG mode\r\n\tcontinuing other job steps, job failed will not be re-run\r\n\tchannel prmy1: starting datafile copy\r\n\tRMAN-03009: failure of backup command on prmy1 channel at 02\/17\/2017 08:53:53\r\n\tORA-19602: cannot backup or copy active file in NOARCHIVELOG mode\r\n\tcontinuing other job steps, job failed will not be re-run\r\n\tchannel prmy1: starting datafile copy\r\n\tRMAN-03009: failure of backup command on prmy1 channel at 02\/17\/2017 08:53:53\r\n\tORA-19602: cannot backup or copy active file in NOARCHIVELOG mode\r\n\tcontinuing other job steps, job failed will not be re-run\r\n\tchannel prmy1: starting datafile copy\r\n\treleased channel: prmy1\r\n\treleased channel: stby1\r\n\tRMAN-00571: ===========================================================\r\n\tRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\n\tRMAN-00571: ===========================================================\r\n\tRMAN-03002: failure of Duplicate Db command at 02\/17\/2017 08:53:53\r\n\tRMAN-05501: aborting duplication of target database\r\n\tRMAN-03015: error occurred in stored script Memory Script\r\n\tRMAN-03009: failure of backup command on prmy1 channel at 02\/17\/2017 08:53:53\r\n\tORA-19602: cannot backup or copy active file in NOARCHIVELOG mode\r\n<\/pre>\n
The cause of the error is that the Primary database is not in Archive mode.<\/p>\n
21. We put the Standby databases in archive mode in order to prepare for Primary and Role change operations.<\/p>\n
a. We query the archive mode states of the databases.<\/p>\n
\t\t[Prod] SQL> select log_mode from v$database;\r\n\t\t\r\n\t\tLOG_MODE\r\n\t\t------------\r\n\t\tNOARCHIVELOG\r\n\t\t\r\n\t\t[Standby] SQL> select log_mode from v$database;\r\n\t\t\r\n\t\tLOG_MODE\r\n\t\t------------\r\n\t\tNOARCHIVELOG\r\n<\/pre>\n
b. The size of the archive area is set to a suitable value according to our disk size.<\/p>\n
\t\t\r\n\t\t[Prod] SQL> alter system set db_recovery_file_dest_size=10G scope=both;\r\n\t\t\r\n\t\tSystem altered.\r\n\t\t\r\n\t\t[Standby] SQL> alter system set db_recovery_file_dest_size=10G scope=both;\r\n\t\t\r\n\t\tSystem altered.\r\n<\/pre>\n
c. We’ll check if the change has taken place.<\/p>\n
\t\t[Prod] SQL> show parameter db_recovery_file_dest\r\n\t\t\r\n\t\tNAME                                 TYPE        VALUE\r\n\t\t------------------------------------ ----------- ------------------------------\r\n\t\tdb_recovery_file_dest                string      \/u01\/app\/oracle\/fast_recovery_\r\n\t\t                                                 area\r\n\t\tdb_recovery_file_dest_size           big integer 10G\r\n\t\t\r\n\t\t[Standby] SQL> show parameter db_recovery_file_dest\r\n\t\t\r\n\t\tNAME                                 TYPE        VALUE\r\n\t\t------------------------------------ ----------- ------------------------------\r\n\t\tdb_recovery_file_dest                string      \/u01\/app\/oracle\/fast_recovery_\r\n\t\t                                                 area\r\n\t\tdb_recovery_file_dest_size           big integer 10G\r\n\t\t\r\n\t\t\r\n<\/pre>\n
\u00e7.We put databases in archive mode.<\/p>\n
\t\t[Prod] SQL> shu immediate;\r\n\t\tDatabase closed.\r\n\t\tDatabase dismounted.\r\n\t\tORACLE instance shut down.\r\n\t\t[Prod] SQL> startup mount;\r\n\t\tORACLE instance started.\r\n\t\t\r\n\t\tTotal System Global Area 3457368064 bytes\r\n\t\tFixed Size                  2258120 bytes\r\n\t\tVariable Size             771754808 bytes\r\n\t\tDatabase Buffers         2667577344 bytes\r\n\t\tRedo Buffers               15777792 bytes\r\n\t\tDatabase mounted.\r\n\t\t[Prod] SQL> select status from v$instance;\r\n\t\t\r\n\t\tSTATUS\r\n\t\t------------\r\n\t\tMOUNTED\r\n<\/pre>\n
d. We’ll check if they switch to archive mode.<\/p>\n
\t\t[Prod] SQL> alter database archivelog;\r\n\t\t\r\n\t\tDatabase altered.\r\n\t\t\r\n\t\t[Prod] SQL> select log_mode from v$database;\r\n\t\t\r\n\t\tLOG_MODE\r\n\t\t------------\r\n\t\tARCHIVELOG\r\n<\/pre>\n
e.We initialize the primary database.<\/p>\n
\t\t[Prod] SQL> alter database open;\r\n\t\t\r\n\t\tDatabase altered.\r\n\t\t\r\n\t\t[Prod] SQL> select status from v$instance;\r\n\t\t\r\n\t\tSTATUS\r\n\t\t------------\r\n\t\tOPEN\r\n<\/pre>\n
f. Since some of the RMAN command was running, the database was switched to MOUNT mode and SPFILE was created. Therefore, the database is closed and the SPFILE file is deleted, and then we move on to the NOMOUNT step.<\/p>\n
22. We restart the RMAN command.<\/p>\n
\t\r\n\tRMAN> run {\r\n\t2> allocate channel prmy1 type disk;\r\n\t3> allocate auxiliary channel stby1 type disk;\r\n\t4> duplicate target database for standby from active database\r\n\t5> spfile\r\n\t6> parameter_value_convert 'prod','standby'\r\n\t7> set db_unique_name='standby'\r\n\t8> set db_file_name_convert='prod','standby'\r\n\t9> set log_file_name_convert='prod','standby'\r\n\t10> set fal_server='prod'\r\n\t11> nofilenamecheck;\r\n\t12> allocate auxiliary channel stby type disk;\r\n\t13> sql channel stby \"alter database recover managed standby database disconnect\"; }\r\n\t\r\n\tusing target database control file instead of recovery catalog\r\n\tallocated channel: prmy1\r\n\tchannel prmy1: SID=14 device type=DISK\r\n\t\r\n\tallocated channel: stby1\r\n\tchannel stby1: SID=429 device type=DISK\r\n\t\r\n\tStarting Duplicate Db at 17-FEB-17\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   backup as copy reuse\r\n\t   targetfile  '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwprod' auxiliary format \r\n\t '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwstandby'   targetfile \r\n\t '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/spfileprod.ora' auxiliary format \r\n\t '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/spfilestandby.ora'   ;\r\n\t   sql clone \"alter system set spfile= ''\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/spfilestandby.ora''\";\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tStarting backup at 17-FEB-17\r\n\tFinished backup at 17-FEB-17\r\n\t\r\n\tsql statement: alter system set spfile= ''\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/spfilestandby.ora''\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   sql clone \"alter system set  audit_file_dest = \r\n\t ''\/u01\/app\/oracle\/admin\/standby\/adump'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  control_files = \r\n\t ''\/u01\/app\/oracle\/oradata\/standby\/control01.ctl'', ''\/u01\/app\/oracle\/fast_recovery_area\/standby\/control02.ctl'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  dispatchers = \r\n\t ''(PROTOCOL=TCP) (SERVICE=standbyXDB)'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  log_archive_dest_1 = \r\n\t ''location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=standby'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  db_unique_name = \r\n\t ''standby'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  db_file_name_convert = \r\n\t ''prod'', ''standby'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  log_file_name_convert = \r\n\t ''prod'', ''standby'' comment=\r\n\t '''' scope=spfile\";\r\n\t   sql clone \"alter system set  fal_server = \r\n\t ''prod'' comment=\r\n\t '''' scope=spfile\";\r\n\t   shutdown clone immediate;\r\n\t   startup clone nomount;\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tsql statement: alter system set  audit_file_dest =  ''\/u01\/app\/oracle\/admin\/standby\/adump'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  control_files =  ''\/u01\/app\/oracle\/oradata\/standby\/control01.ctl'', ''\/u01\/app\/oracle\/fast_recovery_area\/standby\/control02.ctl'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  dispatchers =  ''(PROTOCOL=TCP) (SERVICE=standbyXDB)'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  log_archive_dest_1 =  ''location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=standby'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  db_unique_name =  ''standby'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  db_file_name_convert =  ''prod'', ''standby'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  log_file_name_convert =  ''prod'', ''standby'' comment= '''' scope=spfile\r\n\t\r\n\tsql statement: alter system set  fal_server =  ''prod'' comment= '''' scope=spfile\r\n\t\r\n\tOracle instance shut down\r\n\t\r\n\tconnected to auxiliary database (not started)\r\n\tOracle instance started\r\n\t\r\n\tTotal System Global Area    3457368064 bytes\r\n\t\r\n\tFixed Size                     2258120 bytes\r\n\tVariable Size                771754808 bytes\r\n\tDatabase Buffers            2667577344 bytes\r\n\tRedo Buffers                  15777792 bytes\r\n\tallocated channel: stby1\r\n\tchannel stby1: SID=63 device type=DISK\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   backup as copy current controlfile for standby auxiliary format  '\/u01\/app\/oracle\/oradata\/standby\/control01.ctl';\r\n\t   restore clone controlfile to  '\/u01\/app\/oracle\/fast_recovery_area\/standby\/control02.ctl' from \r\n\t '\/u01\/app\/oracle\/oradata\/standby\/control01.ctl';\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tStarting backup at 17-FEB-17\r\n\tchannel prmy1: starting datafile copy\r\n\tcopying standby control file\r\n\toutput file name=\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/snapcf_prod.f tag=TAG20170217T090636 RECID=3 STAMP=936176796\r\n\tchannel prmy1: datafile copy complete, elapsed time: 00:00:01\r\n\tFinished backup at 17-FEB-17\r\n\t\r\n\tStarting restore at 17-FEB-17\r\n\t\r\n\tchannel stby1: copied control file copy\r\n\tFinished restore at 17-FEB-17\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   sql clone 'alter database mount standby database';\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tsql statement: alter database mount standby database\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   set newname for tempfile  1 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/temp01.dbf\";\r\n\t   switch clone tempfile all;\r\n\t   set newname for datafile  1 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/system01.dbf\";\r\n\t   set newname for datafile  2 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/sysaux01.dbf\";\r\n\t   set newname for datafile  3 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/undotbs01.dbf\";\r\n\t   set newname for datafile  4 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/users01.dbf\";\r\n\t   set newname for datafile  5 to \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/example01.dbf\";\r\n\t   backup as copy reuse\r\n\t   datafile  1 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/system01.dbf\"   datafile \r\n\t 2 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/sysaux01.dbf\"   datafile \r\n\t 3 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/undotbs01.dbf\"   datafile \r\n\t 4 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/users01.dbf\"   datafile \r\n\t 5 auxiliary format \r\n\t \"\/u01\/app\/oracle\/oradata\/standby\/example01.dbf\"   ;\r\n\t   sql 'alter system archive log current';\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\trenamed tempfile 1 to \/u01\/app\/oracle\/oradata\/standby\/temp01.dbf in control file\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\texecuting command: SET NEWNAME\r\n\t\r\n\tStarting backup at 17-FEB-17\r\n\tchannel prmy1: starting datafile copy\r\n\tinput datafile file number=00001 name=\/u01\/app\/oracle\/oradata\/prod\/system01.dbf\r\n\toutput file name=\/u01\/app\/oracle\/oradata\/standby\/system01.dbf tag=TAG20170217T090644\r\n\tchannel prmy1: datafile copy complete, elapsed time: 00:00:25\r\n\tchannel prmy1: starting datafile copy\r\n\tinput datafile file number=00002 name=\/u01\/app\/oracle\/oradata\/prod\/sysaux01.dbf\r\n\toutput file name=\/u01\/app\/oracle\/oradata\/standby\/sysaux01.dbf tag=TAG20170217T090644\r\n\tchannel prmy1: datafile copy complete, elapsed time: 00:00:15\r\n\tchannel prmy1: starting datafile copy\r\n\tinput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/prod\/example01.dbf\r\n\toutput file name=\/u01\/app\/oracle\/oradata\/standby\/example01.dbf tag=TAG20170217T090644\r\n\tchannel prmy1: datafile copy complete, elapsed time: 00:00:07\r\n\tchannel prmy1: starting datafile copy\r\n\tinput datafile file number=00003 name=\/u01\/app\/oracle\/oradata\/prod\/undotbs01.dbf\r\n\toutput file name=\/u01\/app\/oracle\/oradata\/standby\/undotbs01.dbf tag=TAG20170217T090644\r\n\tchannel prmy1: datafile copy complete, elapsed time: 00:00:03\r\n\tchannel prmy1: starting datafile copy\r\n\tinput datafile file number=00004 name=\/u01\/app\/oracle\/oradata\/prod\/users01.dbf\r\n\toutput file name=\/u01\/app\/oracle\/oradata\/standby\/users01.dbf tag=TAG20170217T090644\r\n\tchannel prmy1: datafile copy complete, elapsed time: 00:00:01\r\n\tFinished backup at 17-FEB-17\r\n\t\r\n\tsql statement: alter system archive log current\r\n\t\r\n\tcontents of Memory Script:\r\n\t{\r\n\t   switch clone datafile all;\r\n\t}\r\n\texecuting Memory Script\r\n\t\r\n\tdatafile 1 switched to datafile copy\r\n\tinput datafile copy RECID=3 STAMP=936176857 file name=\/u01\/app\/oracle\/oradata\/standby\/system01.dbf\r\n\tdatafile 2 switched to datafile copy\r\n\tinput datafile copy RECID=4 STAMP=936176857 file name=\/u01\/app\/oracle\/oradata\/standby\/sysaux01.dbf\r\n\tdatafile 3 switched to datafile copy\r\n\tinput datafile copy RECID=5 STAMP=936176857 file name=\/u01\/app\/oracle\/oradata\/standby\/undotbs01.dbf\r\n\tdatafile 4 switched to datafile copy\r\n\tinput datafile copy RECID=6 STAMP=936176857 file name=\/u01\/app\/oracle\/oradata\/standby\/users01.dbf\r\n\tdatafile 5 switched to datafile copy\r\n\tinput datafile copy RECID=7 STAMP=936176857 file name=\/u01\/app\/oracle\/oradata\/standby\/example01.dbf\r\n\tFinished Duplicate Db at 17-FEB-17\r\n\t\r\n\tallocated channel: stby\r\n\tchannel stby: SID=131 device type=DISK\r\n\t\r\n\tsql statement: alter database recover managed standby database disconnect\r\n\treleased channel: prmy1\r\n\treleased channel: stby1\r\n\treleased channel: stby\r\n\t\r\n\tRMAN> exit\r\n\t\r\n\t\r\n\tRecovery Manager complete.\r\n\t\r\n<\/pre>\n
23. We query the status of the standby database.<\/p>\n
\t[Standby] SQL> select status from v$instance;\r\n\t\r\n\tSTATUS\r\n\t------------\r\n\tMOUNTED\r\n<\/pre>\n
24. We check the mode of the database.<\/p>\n
\t[Standby] SQL> select open_mode, database_role from v$database;\r\n\t\r\n\tOPEN_MODE            DATABASE_ROLE\r\n\t-------------------- ----------------\r\n\tMOUNTED              PHYSICAL STANDBY\r\n<\/pre>\n
25. We ensure that the Archive Redo Logs go to the Standby database.<\/p>\n
\t[Prod] SQL> alter system set log_archive_dest_2='SERVICE=standby SYNC REOPEN=15 valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=standby' scope=both;\r\n\t\r\n\tSystem altered.\r\n\t\r\n\t[Prod] SQL> show parameter log_archive_dest_2\r\n\t\r\n\tNAME                                 TYPE        VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tlog_archive_dest_2                   string      SERVICE=standby SYNC REOPEN=15\r\n\t                                                  valid_for=(ONLINE_LOGFILES,PR\r\n\t                                                 IMARY_ROLE) db_unique_name=sta\r\n\t                                                 ndby\r\n\t\r\n<\/pre>\n
26. The installation process of our standby database is completed. Now we get to the controls.<\/p>\n
a. We learn the current log sequence number.<\/p>\n
\t\t[Prod] SQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\t\t\r\n\t\tMAX(SEQUENCE#)    THREAD#\r\n\t\t-------------- ----------\r\n\t\t            10          1\r\n\t\t\t\t\t\r\n\t\t[Standby] SQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\t\t\r\n\t\tMAX(SEQUENCE#)    THREAD#\r\n\t\t-------------- ----------\r\n\t\t            10          1\r\n\t\t\r\n\t\t\r\n<\/pre>\n
b. We check whether the logs go to Standby by performing the Log Switch operation.<\/p>\n
\t\t[Prod] SQL> alter system switch logfile;\r\n\t\t\r\n\t\tSystem altered.\r\n\t\t\r\n\t\t[Prod] SQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\t\t\r\n\t\tMAX(SEQUENCE#)    THREAD#\r\n\t\t-------------- ----------\r\n\t\t            11          1\r\n\t\t\t\t\t\r\n\t\t[Standby] SQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\t\t\r\n\t\tMAX(SEQUENCE#)    THREAD#\r\n\t\t-------------- ----------\r\n\t\t            11          1\r\n<\/pre>\n
27. Logs go to Standby successfully, but we check if they are being applied.<\/p>\n
\t[Standby] SQL> select recovery_mode from v$archive_dest_status;\r\n\t\r\n\tRECOVERY_MODE\r\n\t-----------------------\r\n\tMANAGED\r\n<\/pre>\n
MANAGED<\/h5>\n
It means Archive Apply, not Real Time. In other words, as the logs come to the Standby side, the apply process will take place.<\/p>\n
28. Since I want Standby to be active very quickly in the event of a disaster, I activate the Real-Time Apply feature.<\/p>\n
\t[Standby] SQL> alter database recover managed standby database cancel;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Standby] SQL> alter database recover managed standby database using current logfile disconnect;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Standby] SQL> select recovery_mode from v$archive_dest_status;\r\n\t\r\n\tRECOVERY_MODE\r\n\t-----------------------\r\n\tMANAGED REAL TIME APPLY\r\n\t\r\n<\/pre>\n
29. By creating a table, it is checked whether it is formed on the standby side.<\/p>\n
\t[Prod] SQL> create user test identified by test account unlock;\r\n\t\r\n\tUser created.\r\n\t\r\n\t[Prod] SQL> grant dba to test;\r\n\t\r\n\tGrant succeeded.\r\n\t\r\n\t[Prod] SQL> create table test.employees_yedek as select * from hr.employees;\r\n\t\r\n\tTable created.\r\n\t\r\n\t[Prod] SQL> select table_name from dba_tables where owner='TEST';\r\n\t\r\n\tTABLE_NAME\r\n\t------------------------------\r\n\tEMPLOYEES_YEDEK\r\n\t\r\n\t[Standby] SQL> select table_name from dba_tables where owner='TEST';\r\n\tselect table_name from dba_tables where owner='TEST'\r\n\t                       *\r\n\tERROR at line 1:\r\n\tORA-01219: database not open: queries allowed on fixed tables\/views only\r\n<\/pre>\n
The reason for this error is that the Database is not in OPEN mode. That is, Active Data Guard is not ENABLE.<\/p>\n
30. Considering that we have a license, the database is transferred to Active Data Guard.<\/p>\n
a. We stop the Log Apply process.<\/p>\n
\t\t[Standby] SQL> alter database recover managed standby database cancel;\r\n\t\t\r\n\t\tDatabase altered.\r\n<\/pre>\n
b. We open the database.<\/p>\n
\t\t[Standby] SQL> alter database open;\r\n\t\t\r\n\t\tDatabase altered.\r\n<\/pre>\n
c. We query the instance’s status.<\/p>\n
\t\t[Standby] SQL> select status from v$instance;\r\n\t\t\r\n\t\tSTATUS\r\n\t\t------------\r\n\t\tOPEN\r\n<\/pre>\n
\u00e7. We query the role with the database’s open mode.<\/p>\n
\t\t[Standby] SQL> select open_mode, database_role from v$database;\r\n\t\t\r\n\t\tOPEN_MODE            DATABASE_ROLE\r\n\t\t-------------------- ----------------\r\n\t\tREAD ONLY            PHYSICAL STANDBY\r\n<\/pre>\n
d. We query Recovery Mode.<\/p>\n
\t\t[Standby] SQL> select recovery_mode from v$archive_dest_status;\r\n\t\t\r\n\t\tRECOVERY_MODE\r\n\t\t-----------------------\r\n\t\tIDLE\r\n<\/pre>\n
e. We start Real Time Apply.<\/p>\n
\t\t[Standby] SQL> alter database recover managed standby database using current logfile disconnect;\r\n\t\t\r\n\t\tDatabase altered.\r\n<\/pre>\n
f. We are checking if Real Time Apply has started.<\/p>\n
\t\t[Standby] SQL> select recovery_mode from v$archive_dest_status;\r\n\t\t\r\n\t\tRECOVERY_MODE\r\n\t\t-----------------------\r\n\t\tMANAGED REAL TIME APPLY\r\n<\/pre>\n
g. We check whether the table created in Article 37 is formed on the Standby side.<\/p>\n
\t\t[Standby] SQL> select table_name from dba_tables where owner='TEST';\r\n\t\t\r\n\t\tTABLE_NAME\r\n\t\t------------------------------\r\n\t\tEMPLOYEES_YEDEK\r\n<\/pre>\n
31. I want to take backups from standby side. For this reason, we make the necessary parameter adjustments so that Incremental Backups can be taken faster and without tiring the system.<\/p>\n
\t[Standby] SQL> alter database enable block change tracking using file '\/u01\/app\/oracle\/oradata\/standby\/rman_change_track.file';\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Standby] SQL> select filename, status, bytes from v$block_change_tracking;\r\n\t\r\n\tFILENAME\r\n\t--------------------------------------------------------------------------------\r\n\tSTATUS          BYTES\r\n\t---------- ----------\r\n\t\/u01\/app\/oracle\/oradata\/standby\/rman_change_track.file\r\n\tENABLED      11599872\r\n\t\r\n\t\r\n\t\t\r\n<\/pre>\n
 <\/p>\n
 <\/p>\n
<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will talk about Physical Standby Setup-SINGLE NODE. 1. We query the status of the listener to see which services are running in the primary database. 2. [root@prod ~]# su – oracle [oracle@prod ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 17-FEB-2017 07:02:36 Copyright (c) 1991, 2013, Oracle. All …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":30224,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-29481","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nPhysical Standby Setup-SINGLE NODE - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will talk about Physical Standby Setup-SINGLE NODE. 1. We query the status of the listener to see which services\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Physical Standby Setup-SINGLE NODE - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will talk about Physical Standby Setup-SINGLE NODE. 1. We query the status of the listener to see which services\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-22T22:17:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-22T22:19:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"833\" \/>\n\t<meta property=\"og:image:height\" content=\"307\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"32 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Physical Standby Setup-SINGLE NODE\",\"datePublished\":\"2022-02-22T22:17:55+00:00\",\"dateModified\":\"2022-02-22T22:19:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/\"},\"wordCount\":1899,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/\",\"name\":\"Physical Standby Setup-SINGLE NODE - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg\",\"datePublished\":\"2022-02-22T22:17:55+00:00\",\"dateModified\":\"2022-02-22T22:19:48+00:00\",\"description\":\"In today's article, we will talk about Physical Standby Setup-SINGLE NODE. 1. We query the status of the listener to see which services\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg\",\"width\":833,\"height\":307},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Physical Standby Setup-SINGLE NODE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Physical Standby Setup-SINGLE NODE - Database Tutorials","description":"In today's article, we will talk about Physical Standby Setup-SINGLE NODE. 1. We query the status of the listener to see which services","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/","og_locale":"en_US","og_type":"article","og_title":"Physical Standby Setup-SINGLE NODE - Database Tutorials","og_description":"In today's article, we will talk about Physical Standby Setup-SINGLE NODE. 1. We query the status of the listener to see which services","og_url":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/","og_site_name":"Database Tutorials","article_published_time":"2022-02-22T22:17:55+00:00","article_modified_time":"2022-02-22T22:19:48+00:00","og_image":[{"width":833,"height":307,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg","type":"image\/jpeg"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"32 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Physical Standby Setup-SINGLE NODE","datePublished":"2022-02-22T22:17:55+00:00","dateModified":"2022-02-22T22:19:48+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/"},"wordCount":1899,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/","url":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/","name":"Physical Standby Setup-SINGLE NODE - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg","datePublished":"2022-02-22T22:17:55+00:00","dateModified":"2022-02-22T22:19:48+00:00","description":"In today's article, we will talk about Physical Standby Setup-SINGLE NODE. 1. We query the status of the listener to see which services","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/02\/Ekran-Alintisi-11.jpg","width":833,"height":307},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/02\/22\/physical-standby-setup-single-node\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Physical Standby Setup-SINGLE NODE"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/29481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=29481"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/29481\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/30224"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=29481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=29481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=29481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}