{"id":34291,"date":"2022-03-15T20:45:56","date_gmt":"2022-03-15T20:45:56","guid":{"rendered":"https:\/\/dbtut.com\/?p=34291"},"modified":"2022-03-15T20:46:09","modified_gmt":"2022-03-15T20:46:09","slug":"how-to-setup-physical-standby-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/","title":{"rendered":"How To Setup Physical Standby Database"},"content":{"rendered":"

In today’s article, we will look for an answer to the question of How To Setup Physical Standby Database.<\/p>\n

In this article, DataGuard installation on Primary and Standby databases in Oracle 11g R2 architecture is explained using SQL*Plus and RMAN without using OEM.<\/p>\n

Operating system\u00a0 \u00a0: RedHat 5.9
\nDatabase Software : Oracle 11g R2
\nCluster Software\u00a0 \u00a0 \u00a0: Oracle 11g R2 Grid Infrastructure
\nStorage Structure\u00a0 \u00a0: Oracle ASM
\nServer RAM\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0: 12G
\nServer CPU\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 : 4 cores<\/p>\n

1. First, we install RedHat Linux 5.9 O.S on both the Primary and Standby sides on all four NODEs.<\/p>\n

2. We are making the necessary configuration changes on the Primary and Standby RAC nodes.<\/p>\n

3. We install Grid Infrastructure on all RAC nodes on both the Primary and Standby sides.<\/p>\n

4. We need to install RDBMS software on all RAC nodes on both the Primary and Standby sides.<\/p>\n

5. We should install Oracle 11 g R2 database only on the Primary side.<\/p>\n

6. We created new listeners named EMR_LISTENER in both databases separately.<\/p>\n

You can find the installations at dbtut.com.<\/p>\n

7. Information about the installed systems is as follows.<\/p>\n

Primary party information.<\/p>\n

\n
\n

\"\"<\/p>\n

\tORACLE_UNQNAME=primary\r\n\t\u00a0\r\n\tNode 1\r\n\tORACLE_SID=primary1\r\n\t\u00a0\r\n\tNode 2\r\n\tORACLE_SID=primary2\r\n\t\u00a0\r\n\tOracle ASM\r\n\tDATA\r\n\tFRA\r\n\tOCR\r\n\t\u00a0\r\n\t[oracle@primary1 ~]$ srvctl config database -d primary\r\n\tDatabase unique name: primary\r\n\tDatabase name: primary\r\n\tOracle home: \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n\tOracle user: oracle\r\n\tSpfile: +DATA\/primary\/spfileprimary.ora\r\n\tDomain:\r\n\tStart options: open\r\n\tStop options: immediate\r\n\tDatabase role: PRIMARY\r\n\tManagement policy: AUTOMATIC\r\n\tServer pools: primary\r\n\tDatabase instances: primary1,primary2\r\n\tDisk Groups: DATA\r\n\tMount point paths:\r\n\tServices:\r\n\tType: RAC\r\n\tDatabase is administrator managed\r\n<\/pre>\n
Standby party information.<\/p>\n
\"\"<\/p>\n
\tORACLE_UNQNAME=standby\r\n\t\u00a0\r\n\tNode 1\r\n\tORACLE_SID=standby1\r\n\t\u00a0\r\n\tNode 2\r\n\tORACLE_SID=standby2\r\n\t\u00a0\r\n\tOracle ASM\r\n\tDATA\r\n\tFRA\r\n\tOCR\r\n\t\u00a0\r\n\tPrimary ve Standby taraf Oracle .bash_profile.\r\n\t\u00a0\r\n\t(Primary 1)\r\n\t\u00a0\r\n\t# .bash_profile\r\n\t\u00a0\r\n\t# Get the aliases and functions\r\n\tif [ -f ~\/.bashrc ]; then\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\n\tfi\r\n\t\u00a0\r\n\t# User specific environment and startup programs\r\n\t\u00a0\r\n\tPATH=$PATH:$HOME\/bin\r\n\t\u00a0\r\n\texport PATH\r\n\t\u00a0\r\n\tTMP=\/tmp; export TMP\r\n\tTMPDIR=$TMP; export TMPDIR\r\n\t\u00a0\r\n\tORACLE_UNQNAME=primary; export ORACLE_UNQNAME\r\n\tORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\n\tGRID_HOME=\/u01\/11.2.0\/grid; export GRID_HOME\r\n\tDB_HOME=$ORACLE_BASE\/product\/11.2.0\/db_1; export DB_HOME\r\n\tORACLE_HOME=$DB_HOME; export ORACLE_HOME\r\n\tORACLE_SID=primary1; export ORACLE_SID\r\n\tORACLE_TERM=xterm; export ORACLE_TERM\r\n\tBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH\r\n\tPATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH; export PATH\r\n\tLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\n\tCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n\t\u00a0\r\n\tulimit -u 65536\r\n\tulimit -n 65536\r\n\t\u00a0\r\n\talias log='cd \/u01\/app\/oracle\/diag\/rdbms\/primary\/primary1\/trace; pwd'\r\n\talias oh='cd $ORACLE_HOME; pwd'\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Primary 2)\r\n\t\u00a0\r\n\t# .bash_profile\r\n\t\u00a0\r\n\t# Get the aliases and functions\r\n\tif [ -f ~\/.bashrc ]; then\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\n\tfi\r\n\t\u00a0\r\n\t# User specific environment and startup programs\r\n\t\u00a0\r\n\tPATH=$PATH:$HOME\/bin\r\n\t\u00a0\r\n\texport PATH\r\n\t\u00a0\r\n\tTMP=\/tmp; export TMP\r\n\tTMPDIR=$TMP; export TMPDIR\r\n\t\u00a0\r\n\tORACLE_UNQNAME=primary; export ORACLE_UNQNAME\r\n\tORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\n\tGRID_HOME=\/u01\/11.2.0\/grid; export GRID_HOME\r\n\tDB_HOME=$ORACLE_BASE\/product\/11.2.0\/db_1; export DB_HOME\r\n\tORACLE_HOME=$DB_HOME; export ORACLE_HOME\r\n\tORACLE_SID=primary2; export ORACLE_SID\r\n\tORACLE_TERM=xterm; export ORACLE_TERM\r\n\tBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH\r\n\tPATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH; export PATH\r\n\tLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\n\tCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n\t\u00a0\r\n\tulimit -u 65536\r\n\tulimit -n 65536\r\n\t\u00a0\r\n\talias log='cd \/u01\/app\/oracle\/diag\/rdbms\/primary\/primary2\/trace; pwd'\r\n\talias oh='cd $ORACLE_HOME; pwd'\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Standby 1)\r\n\t\u00a0\r\n\t# .bash_profile\r\n\t\u00a0\r\n\t# Get the aliases and functions\r\n\tif [ -f ~\/.bashrc ]; then\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\n\tfi\r\n\t\u00a0\r\n\t# User specific environment and startup programs\r\n\t\u00a0\r\n\tPATH=$PATH:$HOME\/bin\r\n\t\u00a0\r\n\texport PATH\r\n\t\u00a0\r\n\tTMP=\/tmp; export TMP\r\n\tTMPDIR=$TMP; export TMPDIR\r\n\t\u00a0\r\n\tORACLE_UNQNAME=standby; export ORACLE_UNQNAME\r\n\tORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\n\tGRID_HOME=\/u01\/11.2.0\/grid; export GRID_HOME\r\n\tDB_HOME=$ORACLE_BASE\/product\/11.2.0\/db_1; export DB_HOME\r\n\tORACLE_HOME=$DB_HOME; export ORACLE_HOME\r\n\tORACLE_SID=primary1; export ORACLE_SID\r\n\tORACLE_TERM=xterm; export ORACLE_TERM\r\n\tBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH\r\n\tPATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH; export PATH\r\n\tLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\n\tCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n\t\u00a0\r\n\tulimit -u 65536\r\n\tulimit -n 65536\r\n\t\u00a0\r\n\talias log='cd \/u01\/app\/oracle\/diag\/rdbms\/standby\/standby1\/trace; pwd'\r\n\talias oh='cd $ORACLE_HOME; pwd'\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Standby 2)\r\n\t\u00a0\r\n\t# .bash_profile\r\n\t\u00a0\r\n\t# Get the aliases and functions\r\n\tif [ -f ~\/.bashrc ]; then\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\n\tfi\r\n\t\u00a0\r\n\t# User specific environment and startup programs\r\n\t\u00a0\r\n\tPATH=$PATH:$HOME\/bin\r\n\t\u00a0\r\n\texport PATH\r\n\t\u00a0\r\n\tTMP=\/tmp; export TMP\r\n\tTMPDIR=$TMP; export TMPDIR\r\n\t\u00a0\r\n\tORACLE_UNQNAME=standby; export ORACLE_UNQNAME\r\n\tORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\n\tGRID_HOME=\/u01\/11.2.0\/grid; export GRID_HOME\r\n\tDB_HOME=$ORACLE_BASE\/product\/11.2.0\/db_1; export DB_HOME\r\n\tORACLE_HOME=$DB_HOME; export ORACLE_HOME\r\n\tORACLE_SID=primary2; export ORACLE_SID\r\n\tORACLE_TERM=xterm; export ORACLE_TERM\r\n\tBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH\r\n\tPATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH; export PATH\r\n\tLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\n\tCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n\t\u00a0\r\n\tulimit -u 65536\r\n\tulimit -n 65536\r\n\t\u00a0\r\n\talias log='cd \/u01\/app\/oracle\/diag\/rdbms\/standby\/standby2\/trace; pwd'\r\n\talias oh='cd $ORACLE_HOME; pwd'\r\n\t\u00a0\r\n\t\u00a0\r\n\tPrimary ve Standby taraf Grid .bash_profile.\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Primary 1)\r\n\t\u00a0\r\n\t# .bash_profile\r\n\t\u00a0\r\n\t# Get the aliases and functions\r\n\tif [ -f ~\/.bashrc ]; then\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\n\tfi\r\n\t\u00a0\r\n\t# User specific environment and startup programs\r\n\t\u00a0\r\n\tPATH=$PATH:$HOME\/bin\r\n\t\u00a0\r\n\texport PATH\r\n\t\u00a0\r\n\tTMP=\/tmp; export TMP\r\n\tTMPDIR=$TMP; export TMPDIR\r\n\t\u00a0\r\n\tORACLE_UNQNAME=primary; export ORACLE_UNQNAME\r\n\tORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\n\tORACLE_HOME=\/u01\/11.2.0\/grid; export ORACLE_HOME\r\n\tGRID_HOME=\/u01\/11.2.0\/grid; export GRID_HOME\r\n\tORACLE_SID=+ASM1; export ORACLE_SID\r\n\tORACLE_TERM=xterm; export ORACLE_TERM\r\n\tBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH\r\n\tPATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH; export PATH\r\n\tLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\n\tCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n\t\u00a0\r\n\tulimit -u 65536\r\n\tulimit -n 65536\r\n\t\u00a0\r\n\talias log='cd \/u01\/11.2.0\/grid\/log\/primary01; pwd'\r\n\talias oh='cd $ORACLE_HOME; pwd'\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Primary 2)\r\n\t\u00a0\r\n\t# .bash_profile\r\n\t\u00a0\r\n\t# Get the aliases and functions\r\n\tif [ -f ~\/.bashrc ]; then\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0. ~\/.bashrc\r\n\tfi\r\n\t\u00a0\r\n\t# User specific environment and startup programs\r\n\t\u00a0\r\n\tPATH=$PATH:$HOME\/bin\r\n\t\u00a0\r\n\texport PATH\r\n\t\u00a0\r\n\tTMP=\/tmp; export TMP\r\n\tTMPDIR=$TMP; export TMPDIR\r\n\t\u00a0\r\n\tORACLE_UNQNAME=primary; export ORACLE_UNQNAME\r\n\tORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\n\tORACLE_HOME=\/u01\/11.2.0\/grid; export ORACLE_HOME\r\n\tGRID_HOME=\/u01\/11.2.0\/grid; export GRID_HOME\r\n\tORACLE_SID=+ASM2; export ORACLE_SID\r\n\tORACLE_TERM=xterm; export ORACLE_TERM\r\n\tBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH\r\n\tPATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH; export PATH\r\n\tLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\n\tCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n\t\u00a0\r\n\tulimit -u 65536\r\n\tulimit -n 65536\r\n\t\u00a0\r\n\talias log='cd \/u01\/11.2.0\/grid\/log\/primary02; pwd'\r\n\talias oh='cd $ORACLE_HOME; pwd'\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Standby 1)\r\n\t\u00a0\r\n\t# .bash_profile\r\n\t\u00a0\r\n\t# Get the aliases and functions\r\n\tif [ -f ~\/.bashrc ]; then\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\n\tfi\r\n\t\u00a0\r\n\t# User specific environment and startup programs\r\n\t\u00a0\r\n\tPATH=$PATH:$HOME\/bin\r\n\t\u00a0\r\n\texport PATH\r\n\t\u00a0\r\n\tTMP=\/tmp; export TMP\r\n\tTMPDIR=$TMP; export TMPDIR\r\n\t\u00a0\r\n\tORACLE_UNQNAME=standby; export ORACLE_UNQNAME\r\n\tORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\n\tORACLE_HOME=\/u01\/11.2.0\/grid; export ORACLE_HOME\r\n\tGRID_HOME=\/u01\/11.2.0\/grid; export GRID_HOME\r\n\tORACLE_SID=+ASM1; export ORACLE_SID\r\n\tORACLE_TERM=xterm; export ORACLE_TERM\r\n\tBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH\r\n\tPATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH; export PATH\r\n\tLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\n\tCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n\t\u00a0\r\n\tulimit -u 65536\r\n\tulimit -n 65536\r\n\t\u00a0\r\n\talias log='cd \/u01\/11.2.0\/grid\/log\/standby01; pwd'\r\n\talias oh='cd $ORACLE_HOME; pwd'\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Standby 2)\r\n\t\u00a0\r\n\t# .bash_profile\r\n\t\u00a0\r\n\t# Get the aliases and functions\r\n\tif [ -f ~\/.bashrc ]; then\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\n\tfi\r\n\t\u00a0\r\n\t# User specific environment and startup programs\r\n\t\u00a0\r\n\tPATH=$PATH:$HOME\/bin\r\n\t\u00a0\r\n\texport PATH\r\n\t\u00a0\r\n\tTMP=\/tmp; export TMP\r\n\tTMPDIR=$TMP; export TMPDIR\r\n\t\u00a0\r\n\tORACLE_UNQNAME=standby; export ORACLE_UNQNAME\r\n\tORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\n\tORACLE_HOME=\/u01\/11.2.0\/grid; export ORACLE_HOME\r\n\tGRID_HOME=\/u01\/11.2.0\/grid; export GRID_HOME\r\n\tORACLE_SID=+ASM2; export ORACLE_SID\r\n\tORACLE_TERM=xterm; export ORACLE_TERM\r\n\tBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH\r\n\tPATH=$ORACLE_HOME\/bin:$GRID_HOME\/bin:$BASE_PATH; export PATH\r\n\tLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\n\tCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n\t\u00a0\r\n\tulimit -u 65536\r\n\tulimit -n 65536\r\n\t\u00a0\r\n\talias log='cd \/u01\/11.2.0\/grid\/log\/standby02; pwd'\r\n\talias oh='cd $ORACLE_HOME; pwd'\r\n\t\u00a0\r\n<\/pre>\n
8.The point to be noted here is that both Grid Infrastructure and new listener EMR_LISTENER, Oracle RDBMS software and Oracle database are installed on the Primary side.<\/p>\n
On the standby side, Grid Infrastructure and Oracle RDBMS are installed. On the standby side, the database is not installed.<\/p>\n<\/div>\n
9.Installation checklist;<\/div>\n
<\/div>\n
Primary database will be “FORCE LOGGING”.
\nSPFILE will be used in the primary database.
\nThere will be Standby Redo Log files in the primary database.
\nFor standby servers, a non-case sensitive password file will be created with the Password File ignorecase=y parameter.
\nNecessary directories will be created on the standby side.<\/div>\n<\/div>\n
Primary database must be in ARCHIVE MODE. If it is not in ARCHIVE MODE, we can put it in archive mode as follows. (Step 1 – Primary)<\/p>\n
First, we check if the database is in archive mode. (Primary)<\/p>\n
\tSQL> select log_mode from v$database;\r\n\t\u00a0\r\n\tLOG_MODE\r\n\t------------\r\n\tNOARCHIVELOG\r\n<\/pre>\n
We determine where the database archive log files will be saved (for the FRA field)\u00a0 (Primary 1);<\/p>\n
\t\u00a0\r\n\tSQL> alter system set db_recovery_file_dest_size=10G scope=both;\r\n\t\u00a0\r\n\tSQL> alter system set db_recovery_file_dest='+FRA' scope=both;\r\n<\/pre>\n
We determine where to save database archive log files (File System Location);<\/p>\n
\tSQL> alter system set log_archive_dest_1 = 'location=\/\u2026\u2026 ' scope = both;\r\n<\/pre>\n
If the database is not in archive mode, we can put it in archive mode as follows.<\/p>\n
 \u00a0(Primary 1-2)\r\n\t\t\u00a0\r\n\tSQL> shutdown immediate;\r\n\tDatabase closed.\r\n\tDatabase dismounted.\r\n\tORACLE instance shut down.\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\u00a0 \u00a0\u00a0(Primary 1-2)\r\n\t\u00a0\r\n\tSQL> startup mount;\r\n\tORACLE instance started.\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\u00a0 \u00a0\u00a0(Primary 1)\r\n\t\u00a0\r\n\tSQL> alter database archivelog;\r\n\t\u00a0\r\n\tDatabase altered.\r\n\t\t\u00a0\r\n\t\t\u00a0\r\n\t\u00a0\u00a0 \u00a0(Primary 1-2)\r\n\t\u00a0\r\n\tSQL> alter database open;\r\n\t\u00a0\r\n\tDatabase altered.\r\n\t\u00a0\r\n<\/pre>\n
Now let’s check the database, is it in archive mode? (Primary 1-2)<\/p>\n
\tSQL> select log_mode from v$database;\r\n\t\u00a0\r\n\tLOG_MODE\r\n\t------------\r\n\tARCHIVELOG\r\n<\/pre>\n
We perform a log switch operation to check whether it is archived to the correct location. (Primary 1)<\/p>\n
\tSQL> alter system switch logfile;\r\n\t\r\n\tSystem altered.\r\n\t\r\n\t\u00a0\r\n\tSQL> exit\r\n\tDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\n\tWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\n\tData Mining and Real Application Testing options\r\n\t[oracle@primary1 ~]$ exit\r\n\tlogout\r\n\t[root@primary1 ~]# su - grid\r\n\t[grid@primary1 ~]$ asmcmd\r\n\tASMCMD> ls\r\n\tDATA\/\r\n\tFRA\/\r\n\tOCR_VOTE\/\r\n\tASMCMD> cd fra\r\n\tASMCMD> ls\r\n\tPRIMARY\/\r\n\tASMCMD> cd primary\r\n\tASMCMD> ls\r\n\tARCHIVELOG\/\r\n\tASMCMD> cd archivelog\r\n\tASMCMD> ls\r\n\t2016_12_29\/\r\n<\/pre>\n
Primary database must be FORCE LOGGING. If the FORCE LOGGING feature of the database is not active, we need to activate it. (Step 2 – Primary)
\nThis is important because logging can still be performed even if users run queries with the NOLOGGING hint.<\/p>\n
\t\u00a0\r\n\tSQL> select FORCE_LOGGING from v$database;\r\n\t\u00a0\r\n\tFOR\r\n\t---\r\n\tNO\r\n<\/pre>\n
If the FORCE LOGGING feature is not active in the database as above, we can activate it as follows. Since this parameter is activated for newly created sessions, the connected sessions must be terminated first.<\/p>\n
For this, the database is closed and brought to mount mode. (Primary)<\/p>\n
\tSQL> shutdown immediate;  (Primary 1-2)\r\n\tDatabase closed.\r\n\tDatabase dismounted.\r\n\tORACLE instance shut down.\r\n\tSQL> startup mount;\r\n\tORACLE instance started.\r\n\t\r\n\tTotal System Global Area 6480490496 bytes\r\n\tFixed Size                  2265384 bytes\r\n\tVariable Size            1241517784 bytes\r\n\tDatabase Buffers         5217714176 bytes\r\n\tRedo Buffers               18993152 bytes\r\n\tDatabase mounted.\r\n\tSQL> alter database force logging; (Primary 1)\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\tSQL> select force_logging from v$database; (Primary 1-2)\r\n\t\r\n\tFOR\r\n\t---\r\n\tYES\r\n\t\r\n\tSQL> alter database open; (Primary 1-2)\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\tSQL> select status from gv$instance; (Primary 1)\r\n\t\r\n\tSTATUS\r\n\t------------\r\n\tOPEN\r\n\tOPEN\r\n<\/pre>\n
Now we check again. (Primary)<\/p>\n
\tSQL> select FORCE_LOGGING from v$database;\r\n\t\u00a0\r\n\tFOR\r\n\t---\r\n\tYES\r\n<\/pre>\n
http:\/\/www.oracledba.org\/11gR2\/dr\/11gR2_dataguard_RAC_to_RAC.html<\/pre>\n
We configure the Redo Log transport direction in the database from the Primary database to the Standby database. (Step 4 – Primary)<\/p>\n
1 (Primary)\r\n\t\t\u00a0\r\n\tSQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)' sid='*' scope=both;\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\tSQL> show parameter log_archive_config;\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tlog_archive_config\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 DG_CONFIG=(primary,standby)\r\n\t\r\n<\/pre>\n
We can see the config change made as follows.<\/p>\n
\t[Primary-1] SQL> select * from v$dataguard_config;\r\n\t\r\n\tDB_UNIQUE_NAME\r\n\t------------------------------\r\n\tprimary\r\n\tstandby\r\n<\/pre>\n
2 (Primary)\r\n\t\t\u00a0\r\n\tSQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary' scope=both sid='*';\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\tSQL> show parameter LOG_ARCHIVE_DEST_1\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tlog_archive_dest_1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,A\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0LL_ROLES) DB_UNIQUE_NAME=primary\r\n\t\u00a0\r\n\t\u00a0\r\n\to\u00a0\u00a0\u00a0 3 (Primary)\u00a0\u00a0 \r\n\t\t\u00a0\r\n\tSQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=standby SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby' sid='*' scope=both;\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\tSQL> show parameter LOG_ARCHIVE_DEST_2\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tlog_archive_dest_2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 SERVICE=standby SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ) DB_UNIQUE_NAME=standby\r\n\t\u00a0\r\n<\/pre>\n
The \u201cLOG_ARCHIVE_FORMAT\u201d parameter of the Database is set. (Step 5 – Primary)<\/p>\n
\tSQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.arc' SCOPE=SPFILE;\r\n\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\to\u00a0\u00a0\u00a0 ARC process say\u0131s\u0131 belirlenir. (Primary)\r\n\t\t\u00a0\r\n\tSQL> ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=8 scope=both sid='*';\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\tSQL> show parameter log_archive_max_processes\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tlog_archive_max_processes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0\u00a0 8\r\n<\/pre>\n
We set FAL_SERVER. This parameter is required after Switchover. Since the Standby database will be Primary after Switchover, we write Standby because the flow of ARCHIVEs will be from it. (Primary)<\/p>\n
\tSQL> alter system set fal_server=standby scope=both sid='*';\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\tSQL> show parameter fal_server\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tfal_server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 STANDBY\r\n\t\u00a0\r\n\t\u00a0\r\n\to\u00a0\u00a0\u00a0 7 ** Restart Required ** (Primary)\r\n\t\t\u00a0\r\n\tSQL> ALTER SYSTEM SET DB_FILE_NAME_CONVERT='standby','primary' scope=spfile sid='*';\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\to\u00a0\u00a0\u00a0 8 ** Restart Required ** (Primary)\r\n\t\t\u00a0\r\n\tSQL> ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='standby','primary' scope=spfile sid='*';\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\to\u00a0\u00a0\u00a0 9 (Primary)\r\n\t\t\u00a0\r\n\tSQL> SHOW PARAMETER standby_file_management\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tstandby_file_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string\u00a0\u00a0\u00a0\u00a0\u00a0 MANUAL\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\r\n\tSQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO scope=both sid='*';\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\t\u00a0\r\n\tSQL> SHOW PARAMETER standby_file_management\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tstandby_file_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 AUTO\r\n<\/pre>\n
A STANDBY REDO LOG is created in the primary database. The number of Standby Redo Logs created is equal to the number of Redo Logs in our database. (Step 3 – Primary)<\/p>\n
First, let’s look at the number and size of REDO LOGs we have.<\/p>\n
\tSQL> select GROUP#, THREAD#, BYTES\/1024\/1024 MB, STATUS from v$log;\r\n\t\t\u00a0\r\n\t\t\u00a0\u00a0\u00a0 GROUP#\u00a0\u00a0\u00a0 THREAD#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MB STATUS\r\n\t\t---------- ---------- ---------- ----------------\r\n\t\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 CURRENT\r\n\t\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 INACTIVE\r\n\t\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 INACTIVE\r\n\t\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 INACTIVE\r\n\t\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 INACTIVE\r\n\t\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a06\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 CURRENT\r\n\t\t\u00a0\r\n<\/pre>\n
Now we are creating a Standby Redo Log (Primary).<\/p>\n
\tSQL> alter system set standby_file_management=manual scope=both sid='*';\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n\tSQL> alter database add standby logfile thread 1 group 7 '+FRA' size 50M;\r\n\t\u00a0\r\n\tDatabase altered.\r\n\t\u00a0\r\n\tSQL> alter database add standby logfile thread 1 group 8 '+FRA' size 50M;\r\n\t\u00a0\r\n\tDatabase altered.\r\n\t\u00a0\r\n\tSQL> alter database add standby logfile thread 2 group 9 '+FRA' size 50M;\r\n\t\u00a0\r\n\tDatabase altered.\r\n\t\u00a0\r\n\tSQL> alter database add standby logfile thread 2 group 10 '+FRA' size 50M;\r\n\t\u00a0\r\n\tDatabase altered.\r\n\t\u00a0\r\n\tSQL> alter system set standby_file_management=auto scope=both sid='*';\r\n\t\u00a0\r\n\tSystem altered.\r\n\t\u00a0\r\n<\/pre>\n
Now let’s check the Standby log status(Primary).<\/p>\n
\tSQL> select GROUP#, THREAD#, BYTES\/1024\/1024 MB, STATUS from V$STANDBY_LOG; \r\n\t\u00a0\r\n\t\u00a0\u00a0\u00a0 GROUP#\u00a0\u00a0\u00a0 THREAD#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MB STATUS\r\n\t---------- ---------- ---------- ----------\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 UNASSIGNED\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 UNASSIGNED\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 UNASSIGNED\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 UNASSIGNED\r\n<\/pre>\n
The database is initialized to set the parameters (Primary).<\/p>\n
\t[oracle@primary1 dbs]$ srvctl stop database -d primary\r\n\t\u00a0\r\n\t[oracle@primary1 dbs]$ srvctl start database -d primary\r\n\t\u00a0\r\n<\/pre>\n
\"\"<\/p>\n
15.\u00a0 The primary database should be backed up and we will create a directory to put this backup file (Primary1 – Oracle).<\/p>\n
\t[oracle@primary1 ~]$ mkdir \/home\/oracle\/backup\r\n\t[oracle@primary1 ~]$ rman target \/ nocatalog\r\n\t\u00a0\r\n\tRecovery Manager: Release 11.2.0.4.0 - Production on Tue Apr 14 16:32:52 2015\r\n\t\u00a0\r\n\tCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\u00a0 All rights reserved.\r\n\t\u00a0\r\n\tconnected to target database: PRIMARY (DBID=1714152137)\r\n\tusing target database control file instead of recovery catalog\r\n\t\u00a0\r\n\tRMAN>\r\n\t\u00a0\r\n\trun{\r\n\tsql \"alter system switch logfile\";\r\n\tallocate channel ch1 type disk format '\/nfs_alan\/backup\/logical\/Primary_bkp_for_logical_%U';\r\n\tbackup database;\r\n\tbackup current controlfile for standby;\r\n\tsql \"alter system archive log current\";\r\n\t}\r\n\t\u00a0\r\n\t\u00a0\r\n\tsql statement: alter system switch logfile\r\n\t\u00a0\r\n\tallocated channel: ch1\r\n\tchannel ch1: SID=216 instance=primary1 device type=DISK\r\n\t\u00a0\r\n\tStarting backup at 14-APR-15\r\n\tchannel ch1: starting full datafile backup set\r\n\tchannel ch1: specifying datafile(s) in backup set\r\n\tinput datafile file number=00001 name=+DATA\/primary\/datafile\/system.256.876669367\r\n\tinput datafile file number=00002 name=+DATA\/primary\/datafile\/sysaux.257.876669369\r\n\tinput datafile file number=00005 name=+DATA\/primary\/datafile\/example.264.876669465\r\n\tinput datafile file number=00003 name=+DATA\/primary\/datafile\/undotbs1.258.876669369\r\n\tinput datafile file number=00006 name=+DATA\/primary\/datafile\/undotbs2.265.876669727\r\n\tinput datafile file number=00004 name=+DATA\/primary\/datafile\/users.259.876669369\r\n\tchannel ch1: starting piece 1 at 14-APR-15\r\n\tchannel ch1: finished piece 1 at 14-APR-15\r\n\tpiece handle=\/home\/oracle\/backup\/Primary_bkp_for_stndby_01q4cge7_1_1 tag=TAG20150414T163311 comment=NONE\r\n\tchannel ch1: backup set complete, elapsed time: 00:00:25\r\n\tchannel ch1: starting full datafile backup set\r\n\tchannel ch1: specifying datafile(s) in backup set\r\n\tincluding current control file in backup set\r\n\tincluding current SPFILE in backup set\r\n\tchannel ch1: starting piece 1 at 14-APR-15\r\n\tchannel ch1: finished piece 1 at 14-APR-15\r\n\tpiece handle=\/home\/oracle\/backup\/Primary_bkp_for_stndby_02q4cgf0_1_1 tag=TAG20150414T163311 comment=NONE\r\n\tchannel ch1: backup set complete, elapsed time: 00:00:01\r\n\tFinished backup at 14-APR-15\r\n\t\u00a0\r\n\tStarting backup at 14-APR-15\r\n\tchannel ch1: starting full datafile backup set\r\n\tchannel ch1: specifying datafile(s) in backup set\r\n\tincluding standby control file in backup set\r\n\tchannel ch1: starting piece 1 at 14-APR-15\r\n\tchannel ch1: finished piece 1 at 14-APR-15\r\n\tpiece handle=\/home\/oracle\/backup\/Primary_bkp_for_stndby_03q4cgf4_1_1 tag=TAG20150414T163340 comment=NONE\r\n\tchannel ch1: backup set complete, elapsed time: 00:00:01\r\n\tFinished backup at 14-APR-15\r\n\t\u00a0\r\n\tsql statement: alter system archive log current\r\n\treleased channel: ch1\r\n\t\u00a0\r\n\tRMAN>\r\n\t\u00a0\r\n\tRMAN>\r\n\t\u00a0\r\n\tRMAN> exit\r\n\t\u00a0\r\n\t\u00a0\r\n\tRecovery Manager complete.\r\n<\/pre>\n
16.\u00a0\u00a0 We create a PFILE parameter file for the Standby database from the parameter file. (Primary)<\/p>\n
\tSQL> create pfile='\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initstandby.ora' from spfile;\r\n\t\u00a0\r\n\tFile created.\r\n<\/pre>\n
17.\u00a0\u00a0 In this step, we will edit the TNS files. In the figure below, all 4 NODEs must be present. Otherwise, we will get an error as follows;<\/p>\n
\ttail -1000f \/u01\/app\/oracle\/diag\/rdbms\/primary\/primary2\/trace\/alert_primary2.log\r\n\t\u00a0\r\n\tError 12154 received logging on to the standby\r\n\tThu May 07 07:10:27 2015\r\n\t\u00a0\r\n\t\u00a0\r\n\tSQL> select error from v$archive_dest;\r\n\t\u00a0\r\n\tERROR\r\n\t-----------------------------------------------------------------\r\n\tORA-12154: TNS:could not resolve the connect identifier specified\r\n<\/pre>\n
On the primary side, we update the tnsnames.ora file on both NODEs. And the result is as follows (Step 6 – Primary 1 – 2).<\/p>\n
\t$ vi \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\t\u00a0\r\nPRIMARY =\r\n\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = primary-scan.hhuyanlab.local)(PORT = 1521))\r\n\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = primary)\r\n\u00a0\u00a0\u00a0 )\r\n\u00a0 )\r\n\t\u00a0\r\nSTANDBY =\r\n\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = standby-scan.hhuyanlab.local)(PORT = 1521))\r\n\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = standby)\r\n\u00a0\u00a0\u00a0 )\r\n\u00a0 )\r\n\u00a0\r\n\u00a0\r\nPRIMARY1 =\r\n\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = primary1-vip.hhuyanlab.local)(PORT = 1521))\r\n\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SID = primary1)\r\n\u00a0\u00a0\u00a0 )\r\n\u00a0 )\r\n\u00a0\r\nPRIMARY2 =\r\n\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = primary2-vip.hhuyanlab.local)(PORT = 1521))\r\n\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SID = primary2)\r\n\u00a0\u00a0\u00a0 )\r\n\u00a0 )\r\n\u00a0\r\nSTANDBY1 =\r\n\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = standby1-vip.hhuyanlab.local)(PORT = 1521))\r\n\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = standby)\r\n\u00a0\u00a0\u00a0 )\r\n\u00a0 )\r\n\u00a0\r\nSTANDBY2 =\r\n\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = standby2-vip.hhuyanlab.local)(PORT = 1521))\r\n\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = standby)\r\n\u00a0\u00a0\u00a0 )\r\n\u00a0 )\r\n\t\u00a0\r\n\t\u00a0\r\n<\/pre>\n
We transfer the PFILE parameter file that we previously created for Standby to the Standby Node-1 side. (Primary)<\/p>\n
\t[oracle@primary1 dbs]$ scp initstandby.ora oracle@172.20.42.25:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/\r\n\t\u00a0\r\n\tThe authenticity of host '172.20.42.25 (172.20.42.25)' can't be established.\r\n\tRSA key fingerprint is c6:6c:b3:f3:c9:f4:52:1e:82:a9:2f:ab:e2:5c:ee:59.\r\n\tAre you sure you want to continue connecting (yes\/no)? yes\r\n\tWarning: Permanently added '172.20.42.25' (RSA) to the list of known hosts.\r\n\toracle@172.20.42.25's password:\r\n\tinitstandby.ora\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 100% 2007\u00a0\u00a0\u00a0\u00a0 2.0KB\/s\u00a0\u00a0 00:00\r\n\t\u00a0\r\n<\/pre>\n
Then the BACKUP files are moved to the Standby side (Primary 1 – Oracle).<\/p>\n
\t$ scp \u2013r \/home\/oracle\/backup standby1:\/home\/oracle\r\n<\/pre>\n
3.Password files on the primary side are transferred to the Standby side with SCP (Primary 1 – Oracle).<\/p>\n
\t[oracle@primary1 dbs]$ scp orapwprimary1 standby1:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwprimary1\r\n\t\u00a0\r\n\tThe authenticity of host 'standby1 (172.20.42.25)' can't be established.\r\n\tRSA key fingerprint is c6:6c:b3:f3:c9:f4:52:1e:82:a9:2f:ab:e2:5c:ee:59.\r\n\tAre you sure you want to continue connecting (yes\/no)? yes\r\n\tWarning: Permanently added 'standby1' (RSA) to the list of known hosts.\r\n\toracle@standby1's password:\r\n\torapwprimary1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0100% 1536\u00a0\u00a0\u00a0\u00a0 1.5KB\/s\u00a0\u00a0 00:00\r\n\t\u00a0\r\n\t\u00a0\r\n\t[oracle@primary1 dbs]$ scp orapwprimary1 standby2:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwprimary2\r\n\t\u00a0\r\n\tThe authenticity of host 'standby2 (172.20.42.26)' can't be established.\r\n\tRSA key fingerprint is db:4a:b2:97:ee:0f:0f:ae:3f:81:56:a6:0e:cf:53:b8.\r\n\tAre you sure you want to continue connecting (yes\/no)? yes\r\n\tWarning: Permanently added 'standby2,172.20.42.26' (RSA) to the list of known hosts.\r\n\toracle@standby2's password:\r\n\torapwprimary1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0100% 1536\u00a0\u00a0\u00a0\u00a0 1.5KB\/s\u00a0\u00a0 00:00\r\n\t\u00a0\r\n<\/pre>\n
4. We must create DUMP directories on the standby side (Standby 1 – 2).<\/p>\n
\to\u00a0\u00a0\u00a0 STANDBY-1\r\n\t\t\u00a0\r\n\t$ mkdir -p \/u01\/app\/oracle\/admin\/standby\/adump\r\n\t$ mkdir -p \/u01\/app\/oracle\/diag\/rdbms\/standby\/primary1\r\n\t$ cd \/u01\/app\/oracle\/diag\/rdbms\/standby\/primary1\r\n\t$ mkdir trace cdump\r\n\t\u00a0\r\n\t\u00a0\r\n\to\u00a0\u00a0\u00a0 STANDBY-2\r\n\t\u00a0\r\n\t$ mkdir -p \/u01\/app\/oracle\/admin\/standby\/adump\r\n\t$ mkdir -p \/u01\/app\/oracle\/diag\/rdbms\/standby\/primary2\r\n\t$ cd \/u01\/app\/oracle\/diag\/rdbms\/standby\/primary2\r\n\t$ mkdir trace cdump\r\n<\/pre>\n
5.Now we are making updates to the Standby PFILE file we created earlier. (Standby1) ** No errors here.<\/p>\n
\t*.audit_file_dest='\/u01\/app\/oracle\/admin\/standby\/adump'\r\n\t*.audit_trail='db'\r\n\t*.cluster_database=true\r\n\t*.compatible='11.2.0.4.0'\r\n\t*.control_files='+DATA\/standby\/controlfile\/control01.ctl','+FRA\/standby\/controlfile\/control02.ctl'\r\n\t*.db_block_size=8192\r\n\t*.db_create_file_dest='+DATA'\r\n\t*.db_create_online_log_dest_1='+DATA'\r\n\t*.db_create_online_log_dest_2='+FRA'\r\n\t*.db_domain=''\r\n\t*.db_file_name_convert='primary','standby'\r\n\t*.db_name='primary'\r\n\t*.db_unique_name='standby'\r\n\t*.db_recovery_file_dest='+FRA'\r\n\t*.db_recovery_file_dest_size=48318382080\r\n\t*.diagnostic_dest='\/u01\/app\/oracle'\r\n\t*.dispatchers='(PROTOCOL=TCP) (SERVICE=primaryXDB)'\r\n\t*.fal_server='PRIMARY'\r\n\tprimary1.instance_number=1\r\n\tprimary2.instance_number=2\r\n\t*.log_archive_config='DG_CONFIG=(primary,standby)'\r\n\t*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby'\r\n\t*.log_archive_dest_2='SERVICE=primary SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary'\r\n\t*.log_archive_format='%t_%s_%r.arc'\r\n\t*.log_archive_max_processes=8\r\n\t*.log_file_name_convert='primary','standby'\r\n\t*.open_cursors=300\r\n\t*.pga_aggregate_target=1258291200\r\n\t*.processes=512\r\n\t*.remote_listener='standby-scan.hhuyanlab.local:1521'\r\n\t*.remote_login_passwordfile='exclusive'\r\n\t*.sessions=568\r\n\t*.sga_target=3776970752\r\n\t*.standby_file_management='AUTO'\r\n\tprimary2.thread=2\r\n\tprimary1.thread=1\r\n\tprimary2.undo_tablespace='UNDOTBS2'\r\n\tprimary1.undo_tablespace='UNDOTBS1'\r\n<\/pre>\n
6.\u00a0We copy the TNS files to the Standby side (Step 7 – Primary).<\/p>\n
\t[oracle@primary1 admin]$ scp tnsnames.ora standby1:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/\r\n\t\u00a0\r\n\toracle@standby1's password:\r\n\ttnsnames.ora\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 100%\u00a0 547\u00a0\u00a0\u00a0\u00a0 0.5KB\/s\u00a0\u00a0 00:00\r\n\t\u00a0\r\n\t[oracle@primary1 admin]$ scp tnsnames.ora standby2:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/\r\n\t\u00a0\r\n\toracle@standby2's password:\r\n\ttnsnames.ora\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 100%\u00a0 547\u00a0\u00a0\u00a0\u00a0 0.5KB\/s\u00a0\u00a0 00:00\r\n\t\u00a0\r\n<\/pre>\n
7.\u00a0We need to create ASM folders. (Standby 1)<\/p>\n
\t[root@standby1 ~]# su - grid\r\n\t[grid@standby1 ~]$ asmcmd\r\n\tASMCMD> ls\r\n\tDATA\/\r\n\tFRA\/\r\n\tOCRVOTE\/\r\n\tASMCMD> cd DATA\r\n\tASMCMD> ls\r\n\tASMCMD> mkdir STANDBY\r\n\tASMCMD> cd STANDBY\r\n\tASMCMD> mkdir PARAMETERFILE DATAFILE CONTROLFILE TEMPFILE ONLINELOG\r\n\t\u00a0\r\n\tASMCMD> cd FRA\r\n\tASMCMD> ls\r\n\tASMCMD> mkdir STANDBY\r\n\tASMCMD> cd STANDBY\r\n\tASMCMD> mkdir ARCHIVELOG CONTROLFILE ONLINELOG STANDBYLOG\r\n<\/pre>\n
8.\u00a0TNS files have been updated. On all nodes. (Standby 1) (Standby 2)<\/p>\n
\tPRIMARY =\r\n\t\u00a0 (DESCRIPTION =\r\n\t\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = primary-scan.hhuyanlab.local)(PORT = 1521))\r\n\t\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = primary)\r\n\t\u00a0\u00a0\u00a0 )\r\n\t\u00a0 )\r\n\t\u00a0\r\n\tSTANDBY =\r\n\t\u00a0 (DESCRIPTION =\r\n\t\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = standby-scan.hhuyanlab.local)(PORT = 1521))\r\n\t\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = standby)\r\n\t\u00a0\u00a0\u00a0 )\r\n\t\u00a0 )\r\n\t\u00a0\r\n\tPRIMARY1 =\r\n\t\u00a0 (DESCRIPTION =\r\n\t\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = primary1-vip.hhuyanlab.local)(PORT = 1521))\r\n\t\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = primary)\r\n\t\u00a0\u00a0\u00a0 )\r\n\t\u00a0 )\r\n\t\u00a0\r\n\tPRIMARY2 =\r\n\t\u00a0 (DESCRIPTION =\r\n\t\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = primary2-vip.hhuyanlab.local)(PORT = 1521))\r\n\t\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = primary)\r\n\t\u00a0\u00a0\u00a0 )\r\n\t\u00a0 )\r\n\t\u00a0\r\n\tSTANDBY1 =\r\n\t\u00a0 (DESCRIPTION =\r\n\t\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = standby1-vip.hhuyanlab.local)(PORT = 1521))\r\n\t\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = standby)\r\n\t\u00a0\u00a0\u00a0 )\r\n\t\u00a0 )\r\n\t\u00a0\r\n\tSTANDBY2 =\r\n\t\u00a0 (DESCRIPTION =\r\n\t\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = standby2-vip.hhuyanlab.local)(PORT = 1521))\r\n\t\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVER = DEDICATED)\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME = standby)\r\n\t\u00a0\u00a0\u00a0 )\r\n\t\u00a0 )\r\n<\/pre>\n
9.\u00a0This process will be done on standby 1.hhuyanlab.localhost. (Standby 1)<\/p>\n
\t[oracle@standby1 ~]$ export ORACLE_SID=primary1\r\n\t[oracle@standby1 ~]$ export ORACLE_BASE=\/u01\/app\/oracle\r\n\t[oracle@standby1 ~]$ export ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/db_1\/\r\n\t[oracle@standby1 ~]$ export PATH=$PATH:$ORACLE_HOME\/bin:.\r\n<\/pre>\n
10. We check the remote connection and parameters to the database with TNS. This will be done on standby1.hhuyanlab.local host. (Standby1)<\/p>\n
\t[oracle@standby1 ~]$ sqlplus sys\/Passw0rd4@PRIMARY as sysdba\r\n\t\u00a0\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 14 16:19:38 2015\r\n\t\u00a0\r\n\tCopyright (c) 1982, 2013, Oracle.\u00a0 All rights reserved.\r\n\t\u00a0\r\n\t\u00a0\r\n\tConnected to:\r\n\tOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\n\tWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\n\tData Mining and Real Application Testing options\r\n\t\u00a0\r\n\tSQL> show parameter name\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n\t------------------------------------ ----------- ------------------------------\r\n\tcell_offloadgroup_name\u00a0\u00a0\u00a0\u00a0\u00a0 string\r\n\tdb_file_name_convert\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 standby, primary\r\n\tdb_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 primary\r\n\tdb_unique_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 primary\r\n\tglobal_names\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 boolean\u00a0 FALSE\r\n\tinstance_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 primary1\r\n\tlock_name_space\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\r\n\tlog_file_name_convert\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 standby, primary\r\n\tprocessor_group_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\r\n\tservice_names\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 primary\r\n\t\u00a0\r\n\tSQL> exit\r\n\t\u00a0\r\n<\/pre>\n
11. Then, we open the database in mount mode on the standby side. This will be done on standby1.hhuyanlab.local host. (Standby1)<\/p>\n
\t[oracle@standby1 ~]$ sqlplus \/ as sysdba\r\n\t\u00a0\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 14 16:29:04 2015\r\n\t\u00a0\r\n\tCopyright (c) 1982, 2013, Oracle.\u00a0 All rights reserved.\r\n\t\u00a0\r\n\tConnected to an idle instance.\r\n\t\u00a0\r\n\tSQL> startup nomount pfile='\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initstandby.ora';\r\n\tORACLE instance started.\r\n\t\u00a0\r\n\tTotal System Global Area 3774713856 bytes\r\n\tFixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2258880 bytes\r\n\tVariable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 989857856 bytes\r\n\tDatabase Buffers\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a02768240640 bytes\r\n\tRedo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14356480 bytes\r\n\tSQL>\r\n\tSQL> exit\r\n\tDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\n\tWith the Partitioning, Real Application Clusters, OLAP, Data Mining\r\n\tand Real Application Testing options\r\n\t\u00a0\r\n<\/pre>\n
12.\u00a0\u00a0 We will connect to two databases at the same time from the standby side and complete the database copying process. This will be done on standby1.hhuyanlab.local host. (Standby1)<\/p>\n
\t[oracle@standby1 ~]$ rman target sys\/Passw0rd4@PRIMARY1 auxiliary \/\r\n\t\u00a0\r\n\tRecovery Manager: Release 11.2.0.4.0 - Production on Tue Apr 14 16:31:30 2015\r\n\t\u00a0\r\n\tCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\u00a0 All rights reserved.\r\n\t\u00a0\r\n\tconnected to target database: PRIMARY (DBID=1714152137)\r\n\tconnected to auxiliary database: PRIMARY (not mounted)\r\n\t\u00a0\r\n\tRMAN>\r\n\t\u00a0\r\n<\/pre>\n
13.\u00a0\u00a0 We will copy the database RESTORE operation with RMAN using the DUPLICATE DATABASE option. For this process, in the previous step, we connected to PRIMARY, which is the TARGET database, and to STANDBY, which is the AUXILIARY database, via standby1.hhuyanlab.local host. (Standby1)<\/p>\n
\t\u00a0\r\n\tRMAN> DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK;\r\n\t\u00a0\r\n\tStarting Duplicate Db at 14-APR-15\r\n\tusing channel ORA_AUX_DISK_1\r\n\t\u00a0\r\n\tcontents of Memory Script:\r\n\t{\r\n\t\u00a0\u00a0 restore clone standby controlfile;\r\n\t}\r\n\texecuting Memory Script\r\n\t\u00a0\r\n\tStarting restore at 14-APR-15\r\n\t\u00a0\r\n\tchannel ORA_AUX_DISK_1: starting datafile backup set restore\r\n\tchannel ORA_AUX_DISK_1: restoring control file\r\n\tchannel ORA_AUX_DISK_1: reading from backup piece \/home\/oracle\/backup\/Primary_bkp_for_stndby_03q4cgf4_1_1\r\n\tchannel ORA_AUX_DISK_1: piece handle=\/home\/oracle\/backup\/Primary_bkp_for_stndby_03q4cgf4_1_1 tag=TAG20150414T163340\r\n\tchannel ORA_AUX_DISK_1: restored backup piece 1\r\n\tchannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01\r\n\toutput file name=+DATA\/primary\/controlfile\/control01.ctl\r\n\toutput file name=+FRA\/primary\/controlfile\/control02.ctl\r\n\tFinished restore at 14-APR-15\r\n\t\u00a0\r\n\tcontents of Memory Script:\r\n\t{\r\n\t\u00a0\u00a0 sql clone 'alter database mount standby database';\r\n\t}\r\n\texecuting Memory Script\r\n\t\u00a0\r\n\tsql statement: alter database mount standby database\r\n\tRMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.\r\n\t\u00a0\r\n\tcontents of Memory Script:\r\n\t{\r\n\t\u00a0\u00a0 set newname for tempfile\u00a0 1 to\r\n\t\"+data\";\r\n\t\u00a0\u00a0 switch clone tempfile all;\r\n\t\u00a0\u00a0 set newname for datafile\u00a0 1 to\r\n\t\"+data\";\r\n\t\u00a0\u00a0 set newname for datafile\u00a0 2 to\r\n\t\"+data\";\r\n\t\u00a0\u00a0 set newname for datafile\u00a0 3 to\r\n\t\"+data\";\r\n\t\u00a0\u00a0 set newname for datafile\u00a0 4 to\r\n\t\"+data\";\r\n\t\u00a0\u00a0 set newname for datafile\u00a0 5 to\r\n\t\"+data\";\r\n\t\u00a0\u00a0 set newname for datafile\u00a0 6 to\r\n\t\"+data\";\r\n\t\u00a0\u00a0 restore\r\n\t\u00a0\u00a0 clone database\r\n\t\u00a0\u00a0 ;\r\n\t}\r\n\texecuting Memory Script\r\n\t\u00a0\r\n\texecuting command: SET NEWNAME\r\n\t\u00a0\r\n\trenamed tempfile 1 to +data in control file\r\n\t\u00a0\r\n\texecuting command: SET NEWNAME\r\n\t\u00a0\r\n\texecuting command: SET NEWNAME\r\n\t\u00a0\r\n\texecuting command: SET NEWNAME\r\n\t\u00a0\r\n\texecuting command: SET NEWNAME\r\n\t\u00a0\r\n\texecuting command: SET NEWNAME\r\n\t\u00a0\r\n\texecuting command: SET NEWNAME\r\n\t\u00a0\r\n\tStarting restore at 14-APR-15\r\n\tusing channel ORA_AUX_DISK_1\r\n\t\u00a0\r\n\tchannel ORA_AUX_DISK_1: starting datafile backup set restore\r\n\tchannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set\r\n\tchannel ORA_AUX_DISK_1: restoring datafile 00001 to +data\r\n\tchannel ORA_AUX_DISK_1: restoring datafile 00002 to +data\r\n\tchannel ORA_AUX_DISK_1: restoring datafile 00003 to +data\r\n\tchannel ORA_AUX_DISK_1: restoring datafile 00004 to +data\r\n\tchannel ORA_AUX_DISK_1: restoring datafile 00005 to +data\r\n\tchannel ORA_AUX_DISK_1: restoring datafile 00006 to +data\r\n\tchannel ORA_AUX_DISK_1: reading from backup piece \/home\/oracle\/backup\/Primary_bkp_for_stndby_01q4cge7_1_1\r\n\tchannel ORA_AUX_DISK_1: piece handle=\/home\/oracle\/backup\/Primary_bkp_for_stndby_01q4cge7_1_1 tag=TAG20150414T163311\r\n\tchannel ORA_AUX_DISK_1: restored backup piece 1\r\n\tchannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25\r\n\tFinished restore at 14-APR-15\r\n\t\u00a0\r\n\tcontents of Memory Script:\r\n\t{\r\n\t\u00a0\u00a0 switch clone datafile all;\r\n\t}\r\n\texecuting Memory Script\r\n\t\u00a0\r\n\tdatafile 1 switched to datafile copy\r\n\tinput datafile copy RECID=8 STAMP=877020979 file name=+DATA\/standby\/datafile\/system.257.877020955\r\n\tdatafile 2 switched to datafile copy\r\n\tinput datafile copy RECID=9 STAMP=877020979 file name=+DATA\/standby\/datafile\/sysaux.258.877020955\r\n\tdatafile 3 switched to datafile copy\r\n\tinput datafile copy RECID=10 STAMP=877020979 file name=+DATA\/standby\/datafile\/undotbs1.260.877020955\r\n\tdatafile 4 switched to datafile copy\r\n\tinput datafile copy RECID=11 STAMP=877020979 file name=+DATA\/standby\/datafile\/users.262.877020955\r\n\tdatafile 5 switched to datafile copy\r\n\tinput datafile copy RECID=12 STAMP=877020979 file name=+DATA\/standby\/datafile\/example.259.877020955\r\n\tdatafile 6 switched to datafile copy\r\n\tinput datafile copy RECID=13 STAMP=877020980 file name=+DATA\/standby\/datafile\/undotbs2.261.877020955\r\n\tFinished Duplicate Db at 14-APR-15\r\n<\/pre>\n
14. We create an SPFILE parameter file from the PFILE parameter file in the standby database. (Standby1)<\/p>\n
\tSQL> create spfile='+DATA\/STANDBY\/PARAMETERFILE\/spfilestandby.ora' from pfile='\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initstandby.ora';\r\n\t\u00a0\r\n\tFile created.\r\n<\/pre>\n
15. Then, on the standby side, we update the PFILE parameter files on both NODEs as follows. (Standby 1 – 2)<\/p>\n
\tstandby1.hhuyanlab.local\r\n\t\u00a0\r\n\t$ vi \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initprimary1.ora\r\n\t\u00a0\r\n\tspfile='+DATA\/STANDBY\/PARAMETERFILE\/spfilestandby.ora'\r\n\t\u00a0\r\n\t\u00a0\r\n\tstandby2.hhuyanlab.local\r\n\t\u00a0\r\n\t$ vi \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initprimary2.ora\r\n\t\u00a0\r\n\tspfile='+DATA\/STANDBY\/PARAMETERFILE\/spfilestandby.ora'\r\n\t\u00a0\r\n<\/pre>\n
16.\u00a0\u00a0 Now we complete the process of adding the Standby database (Standby 1 – Oracle). (in a new SESSION)<\/p>\n
\t[oracle@standby1 ~]$ srvctl add database -d standby -n primary -o \/u01\/app\/oracle\/product\/11.2.0\/db_1 -p +DATA\/STANDBY\/PARAMETERFILE\/spfilestandby.ora -r physical_standby -a DATA,FRA\r\n\t[oracle@standby1 ~]$ srvctl add instance -d standby -i primary1 -n standby1\r\n\t[oracle@standby1 ~]$ srvctl add instance -d standby -i primary2 -n standby2\r\n\t[oracle@standby1 ~]$ srvctl start database -d standby\r\n<\/pre>\n
If it does not open;<\/p>\n
\t[oracle@standby1 ~]$ srvctl modify database -d standby -s mount\r\n\t[oracle@standby1 ~]$ srvctl config database -d standby\r\n\tDatabase unique name: standby\r\n\tDatabase name: primary\r\n\tOracle home: \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n\tOracle user: oracle\r\n\tSpfile: +DATA\/STANDBY\/PARAMETERFILE\/spfilestandby.ora\r\n\tDomain:\r\n\tStart options: mount\r\n\tStop options: immediate\r\n\tDatabase role: PHYSICAL_STANDBY\r\n\tManagement policy: AUTOMATIC\r\n\tServer pools: standby\r\n\tDatabase instances: primary1,primary2\r\n\tDisk Groups: DATA,FRA\r\n\tMount point paths:\r\n\tServices:\r\n\tType: RAC\r\n\tDatabase is administrator managed\r\n\t\u00a0\r\n\t[oracle@standby1 ~]$ srvctl start database -d standby\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\r\n\t\u00a0\r\n\t[oracle@standby1 ~]$ srvctl status database -d standby\r\n\tInstance primary1 is running on node standby1\r\n\tInstance primary2 is running on node standby2\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Standby1)\r\n\t\u00a0\r\n\t[oracle@standby1 dbs]$ sqlplus \/ as sysdba\r\n\t\u00a0\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 22 14:00:57 2015\r\n\t\u00a0\r\n\tCopyright (c) 1982, 2013, Oracle.\u00a0 All rights reserved.\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Standby1)\r\n\t\u00a0\r\n\tSQL> select status from gv$instance;\r\n\t\u00a0\r\n\tSTATUS\r\n\t------------\r\n\tMOUNTED\r\n\tMOUNTED\r\n\t\u00a0\r\n<\/pre>\n
At this stage, the database did not stand up. By connecting both nodes one by one, I opened the database with the following command (Standby1 – 2).<\/p>\n
\t[oracle@standby1 dbs]$ sqlplus \/ as sysdba\r\n\t\u00a0\r\n\tSQL> startup mount;\r\n\t\u00a0\r\n<\/pre>\n
17.\u00a0\u00a0 Now we can check the database. (Standby 1)<\/p>\n
\t$ sqlplus \/ as sysdba\r\n\t\u00a0\r\n\tSQL> select name, database_role, open_mode from gv$database;\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0 DATABASE_ROLE\u00a0\u00a0\u00a0 OPEN_MODE\r\n\t--------- ---------------- --------------------\r\n\tPRIMARY\u00a0\u00a0 PHYSICAL STANDBY MOUNTED\r\nPRIMARY\u00a0\u00a0 PHYSICAL STANDBY MOUNTED<\/pre>\n
18. We are checking the Primary side now. (Primary 1)<\/p>\n
\tSQL> select name, database_role, open_mode from gv$database;\r\n\t\u00a0\r\n\tNAME\u00a0\u00a0\u00a0\u00a0\u00a0 DATABASE_ROLE\u00a0\u00a0\u00a0 OPEN_MODE\r\n\t--------- ---------------- --------------------\r\n\tPRIMARY\u00a0\u00a0 PRIMARY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ WRITE\r\n\tPRIMARY\u00a0\u00a0 PRIMARY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ WRITE\r\n<\/pre>\n
19.\u00a0\u00a0 Finally, we activate the Standby Database by running the command below (Standby1 or Standby2).<\/p>\n
\tSQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;\r\n\t\u00a0\r\n\tDatabase altered.\r\n\t\u00a0\r\n\talter database recover managed standby database using current logfile disconnect;\r\n<\/pre>\n
20. We check the Primary and Standby side.<\/p>\n
\t(Primary)\r\n\tSQL> select thread#, sequence#, status from v$log;\r\n\t\u00a0\r\n\t\u00a0\u00a0 THREAD#\u00a0 SEQUENCE# STATUS\r\n\t---------- ---------- ----------------\r\n\t\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 47 CURRENT\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 46 INACTIVE\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 27 CURRENT\r\n\t\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 26 INACTIVE\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Standby)\r\n\tSQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;\r\n\t\u00a0\r\n\tPROCESS\u00a0\u00a0 STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 THREAD#\u00a0 SEQUENCE#\u00a0\u00a0\u00a0\u00a0 BLOCK#\u00a0\u00a0\u00a0\u00a0 BLOCKS\r\n\t--------- ------------ ---------- ---------- ---------- ----------\r\n\tARCH\u00a0\u00a0\u00a0\u00a0\u00a0 CONNECTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tARCH\u00a0\u00a0\u00a0\u00a0\u00a0 CONNECTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tARCH\u00a0\u00a0\u00a0\u00a0\u00a0 CONNECTED \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tARCH\u00a0\u00a0\u00a0\u00a0\u00a0 CONNECTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tARCH\u00a0\u00a0\u00a0\u00a0\u00a0 CONNECTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tARCH\u00a0\u00a0\u00a0\u00a0\u00a0 CONNECTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tARCH\u00a0\u00a0\u00a0 \u00a0\u00a0CONNECTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tARCH\u00a0\u00a0\u00a0\u00a0\u00a0 CONNECTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tMRP0\u00a0\u00a0\u00a0\u00a0\u00a0 APPLYING_LOG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 47\u00a0\u00a0\u00a0\u00a0\u00a0 22711\u00a0\u00a0\u00a0\u00a0 102400\r\n\tRFS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a00\r\n\tRFS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\t\u00a0\r\n\tPROCESS\u00a0\u00a0 STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 THREAD#\u00a0 SEQUENCE#\u00a0\u00a0\u00a0\u00a0 BLOCK#\u00a0\u00a0\u00a0\u00a0 BLOCKS\r\n\t--------- ------------ ---------- ---------- ---------- ----------\r\n\tRFS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tRFS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\tRFS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IDLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\t\u00a0\r\n\t14 rows selected.\r\n<\/pre>\n
21.\u00a0We control the Primary and Standby side.<\/p>\n
\tStandby taraftan SCN numaras\u0131 al\u0131narak Primary veritaban\u0131nda saat kontrol\u00fc yap\u0131labilir.\r\n\t\u00a0\r\n\t(Standby)\r\n\tSQL> select current_scn from v$database;\r\n\t\u00a0\r\n\tCURRENT_SCN\r\n\t-----------\r\n\t\u00a0\u00a0\u00a0 1681797\r\n\t\u00a0\r\n\t\u00a0\r\n\t(Primary)\r\n\tSQL> select scn_to_timestamp(1681797) from dual;\r\n\t\u00a0\r\n\tSCN_TO_TIMESTAMP(1681797)\r\n\t---------------------------------------------------------------------------\r\n\t07-MAY-15 03.00.05.000000000 PM\r\n\t\u00a0\r\n<\/pre>\n
http:\/\/www.oracledba.org\/11gR2\/dr\/11gR2_dataguard_RAC_to_RAC.html<\/pre>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard installation on Primary and Standby databases in Oracle 11g R2 architecture is explained using SQL*Plus and RMAN without using OEM. Operating system\u00a0 \u00a0: RedHat 5.9 Database Software : Oracle 11g R2 Cluster …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":34292,"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-34291","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nHow To Setup Physical Standby Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard\" \/>\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\/03\/15\/how-to-setup-physical-standby-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Setup Physical Standby Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-15T20:45:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-15T20:46:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"863\" \/>\n\t<meta property=\"og:image:height\" content=\"292\" \/>\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=\"20 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\/03\/15\/how-to-setup-physical-standby-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"How To Setup Physical Standby Database\",\"datePublished\":\"2022-03-15T20:45:56+00:00\",\"dateModified\":\"2022-03-15T20:46:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/\"},\"wordCount\":1083,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/\",\"name\":\"How To Setup Physical Standby Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg\",\"datePublished\":\"2022-03-15T20:45:56+00:00\",\"dateModified\":\"2022-03-15T20:46:09+00:00\",\"description\":\"In today's article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg\",\"width\":863,\"height\":292},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Setup Physical Standby Database\"}]},{\"@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":"How To Setup Physical Standby Database - Database Tutorials","description":"In today's article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard","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\/03\/15\/how-to-setup-physical-standby-database\/","og_locale":"en_US","og_type":"article","og_title":"How To Setup Physical Standby Database - Database Tutorials","og_description":"In today's article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard","og_url":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/","og_site_name":"Database Tutorials","article_published_time":"2022-03-15T20:45:56+00:00","article_modified_time":"2022-03-15T20:46:09+00:00","og_image":[{"width":863,"height":292,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg","type":"image\/jpeg"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"20 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"How To Setup Physical Standby Database","datePublished":"2022-03-15T20:45:56+00:00","dateModified":"2022-03-15T20:46:09+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/"},"wordCount":1083,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/","url":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/","name":"How To Setup Physical Standby Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg","datePublished":"2022-03-15T20:45:56+00:00","dateModified":"2022-03-15T20:46:09+00:00","description":"In today's article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-12.jpg","width":863,"height":292},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/15\/how-to-setup-physical-standby-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Setup Physical Standby Database"}]},{"@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\/34291","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=34291"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/34291\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/34292"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=34291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=34291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=34291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}