{"id":53320,"date":"2022-12-13T18:52:22","date_gmt":"2022-12-13T18:52:22","guid":{"rendered":"https:\/\/dbtut.com\/?p=53320"},"modified":"2022-12-14T14:09:56","modified_gmt":"2022-12-14T14:09:56","slug":"performing-switchover","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/","title":{"rendered":"Performing SwitchOver"},"content":{"rendered":"

In today’s article we will be learning how to Performing SwitchOver.<\/p>\n

1. First, we move the logs in our live database.<\/p>\n

(PRIMARY_1)<\/p>\n

\t[root@primary1 ~]# su - oracle\r\n\t[oracle@primary1 ~]$ sqlplus \/ as sysdba\r\n\t\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 18 15:40:54 2016\r\n\t\r\n\tCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\n\t\r\n\t\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\r\n\tSQL> alter system switch logfile;\r\n\t\r\n\tSystem altered.\r\n\t\r\n\tSQL> alter system switch logfile;\r\n\t\r\n\tSystem altered.\r\n\t\r\n<\/pre>\n
(PRIMARY_2)<\/p>\n
\t[root@primary2 ~]# su - oracle\r\n\t[oracle@primary2 ~]$ sqlplus \/ as sysdba\r\n\t\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 18 15:40:54 2016\r\n\t\r\n\tCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\n\t\r\n\t\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\r\n\tSQL> alter system switch logfile;\r\n\t\r\n\tSystem altered.\r\n\t\r\n\tSQL> alter system switch logfile;\r\n\t\r\n\tSystem altered.\r\n\t\r\n<\/pre>\n
2. We check the SWITCHOVER status of the primary database. The result of this operation should be “SESSION ACTIVE” or “TO STANDBY”.<\/p>\n
(PRIMARY_1)<\/p>\n
\tSQL> select switchover_status from v$database;\r\n\t\r\n\tSWITCHOVER_STATUS\r\n\t--------------------\r\n\tSESSIONS ACTIVE\r\n<\/pre>\n
3. We check the SWITCHOVER status of our standby database. The result of this operation should be “SESSION ACTIVE” or “NOT ALLOWED”.<\/p>\n
(STANDBY_1)<\/p>\n
\tSQL> select switchover_status from v$database;\r\n\t\r\n\tSWITCHOVER_STATUS\r\n\t--------------------\r\n\tNOT ALLOWED\r\n\t\r\n<\/pre>\n
We also check the status of our STANDBY database.<\/p>\n
SQL> set linesize 9000; \r\nSQL> select * from v$dataguard_stats;<\/pre>\n
\"\"<\/p>\n
4. Now we SWITCH our PRIMARY database to STANDBY.<\/p>\n
(PRIMARY_1)<\/p>\n
\tSQL> alter database commit to switchover to physical standby with session shutdown;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\tSQL> shutdown immediate;\r\n\tORA-01012: not logged on\r\n\t\r\n\tSQL> startup nomount;\r\n\tORACLE instance started.\r\n\t\r\n\tTotal System Global Area 6714322944 bytes\r\n\tFixed Size                  2265944 bytes\r\n\tVariable Size            1275071656 bytes\r\n\tDatabase Buffers         5419040768 bytes\r\n\tRedo Buffers               17944576 bytes\r\n\t\r\n\tSQL> alter database mount standby database;\r\n\t\r\n\tDatabase altered.\r\n<\/pre>\n
(PRIMARY_2)<\/p>\n
\tSQL> shutdown immediate;\r\n\tORA-03135: connection lost contact\r\n<\/pre>\n
5. It is necessary to DEFER the sending of logs for a while because the PRIMARY database is not up yet.<\/p>\n
(PRIMARY_1)<\/p>\n
\tSQL> alter system set log_archive_dest_state_2=defer;\r\n\t\r\n\tSystem altered.\r\n<\/pre>\n
6. Now we can set our STANDBY database to PRIMARY.<\/p>\n
(STANDBY_1)<\/p>\n
\tSQL> alter database commit to switchover to primary;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\tSQL> shutdown immediate;\r\n\tORA-01109: database not open\r\n\t\r\n\t\r\n\tDatabase dismounted.\r\n\tORACLE instance shut down.\r\n\t\r\n\tSQL> startup;\r\n\tORACLE instance started.\r\n\t\r\n\tTotal System Global Area 6714322944 bytes\r\n\tFixed Size                  2265944 bytes\r\n\tVariable Size            1275071656 bytes\r\n\tDatabase Buffers         5419040768 bytes\r\n\tRedo Buffers               17944576 bytes\r\n\tDatabase mounted.\r\n\tDatabase opened.\r\n\t\r\n\t\r\n\tSQL> select name, database_role, open_mode from gv$database;\r\n\t\r\n\t\r\n\tNAME      DATABASE_ROLE    OPEN_MODE\r\n\t--------- ---------------- --------------------\r\n\tPRIMARY   PRIMARY          READ WRITE\r\n<\/pre>\n
7. We can initialize our old PRIMARY database, our current STANDBY database, to the REDO LOG APPLY process.<\/p>\n
(PRIMARY_1)<\/p>\n
\tSQL> recover managed standby database using current logfile disconnect;\r\n\tMedia recovery complete.\r\n<\/pre>\n
8. If we want, we can open our STANDBY database (former primary) with READ ONLY MODE.<\/p>\n
(PRIMARY_1)<\/p>\n
\tSQL> recover managed standby database cancel;\r\n\tMedia recovery complete.\r\n\t\r\n\tSQL> alter database open;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\tSQL> recover managed standby database using current logfile disconnect;\r\n\tMedia recovery complete.\r\n<\/pre>\n
Let’s check the database we opened in READ ONLY MODE, is it really READ ONLY?<\/p>\n
\tSQL> select name, database_role, open_mode from gv$database;\r\n\t\r\n\t\r\n\tNAME      DATABASE_ROLE    OPEN_MODE\r\n\t--------- ---------------- --------------------\r\n\tPRIMARY   PHYSICAL STANDBY READ ONLY WITH APPLY\r\n<\/pre>\n
9. After the above process, let’s check the status of our PRIMARY and STANDBY databases.<\/p>\n
(PRIMARY_1)<\/p>\n
\t[root@primary1 ~]# su - oracle\r\n\t[oracle@primary1 ~]$ sqlplus \/ as sysdba\r\n\t\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 18 16:34:24 2016\r\n\t\r\n\tCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\n\t\r\n\t\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\r\n\tSQL> select name, database_role, open_mode from gv$database;\r\n\t\r\n\tNAME      DATABASE_ROLE    OPEN_MODE\r\n\t--------- ---------------- --------------------\r\n\tPRIMARY   PHYSICAL STANDBY READ ONLY WITH APPLY\r\n\tPRIMARY   PHYSICAL STANDBY READ ONLY WITH APPLY\r\n<\/pre>\n
(STANDBY_1)<\/p>\n
\t[root@standby1 ~]# su - oracle\r\n\t[oracle@standby1 ~]$ sqlplus \/ as sysdba\r\n\t\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 18 16:36:03 2016\r\n\t\r\n\tCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\n\t\r\n\t\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\r\n\tSQL> select name, database_role, open_mode from gv$database;\r\n\t\r\n\tNAME      DATABASE_ROLE    OPEN_MODE\r\n\t--------- ---------------- --------------------\r\n\tPRIMARY   PRIMARY          READ WRITE\r\n\tPRIMARY   PRIMARY          READ WRITE\r\n<\/pre>\n
10. Let’s check if the “LOG SHIPPING” operation between PRIMARY and STANDBY databases works correctly.<\/p>\n
Before INSERT, we check the status of the logs.<\/p>\n
(PRIMARY_1) (Standby)<\/p>\n
\tSQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;\r\n<\/pre>\n
\"\"<\/p>\n
I’m entering new data into the database.<\/p>\n
(STANDBY_1) (Primary)<\/p>\n
\t[root@standby1 ~]# su - oracle\r\n\t[oracle@standby1 ~]$ sqlplus \/ as sysdba\r\n\t\r\n\tSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 18 16:36:03 2016\r\n\t\r\n\tCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\n\t\r\n\t\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\r\n\tSQL> desc HR.JOBS;\r\n<\/pre>\n
\"\"<\/p>\n
\tSQL> select * from HR.JOBS;\r\n<\/pre>\n
\"\"<\/p>\n
\tSQL> insert into HR.JOBS values ('DBA','Oracle DBA',5000,50000);\r\n\t\r\n\t1 row created.\r\n\t\r\n\tSQL> commit;\r\n\t\r\n\tCommit complete.\r\n\t\r\n\t\r\n\tSQL> alter system switch logfile;\r\n\t\r\n\tSystem altered.\r\n\t\r\n\tSQL> alter system switch logfile;\r\n\t\r\n\tSystem altered.\r\n\t\r\n\t\r\n\tSQL> select thread#, sequence#, status from v$log;\r\n\t\r\n\t   THREAD#  SEQUENCE# STATUS\r\n\t---------- ---------- ----------------\r\n\t         1         98 CURRENT\r\n\t         1         97 INACTIVE\r\n\t         2         72 CURRENT\r\n\t         2         71 ACTIVE\r\n<\/pre>\n
After the INSERT, we check the log status.<\/p>\n
(PRIMARY_1) (Standby)<\/p>\n
\tSQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;\r\n<\/pre>\n
\"\"<\/p>\n
Now we can check if the data is coming to our standby database.<\/p>\n
\tSQL> select * from HR.JOBS;\r\n<\/pre>\n
\"\"<\/p>\n
11. As seen in the previous operation step, the SWITCHOVER operation has been completed successfully. Our PRIMARY database is now Standby, our STANDBY database is now Primary.<\/p>\n
12. The ALERT_LOG output when performing the SWITCHOVER operation is as follows.<\/p>\n
(PRIMARY_1)<\/p>\n
\tMon Apr 18 15:41:13 2016\r\n\talter database commit to switchover to physical standby with session shutdown\r\n\tALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 28015] (primary1)\r\n\tWaiting for all non-current ORLs to be archived...\r\n\tAll non-current ORLs have been archived.\r\n\tWaiting for all FAL entries to be archived...\r\n\tAll FAL entries have been archived.\r\n\tWaiting for potential Physical Standby switchover target to become synchronized...\r\n\tActive, synchronized Physical Standby switchover target has been identified\r\n\tSwitchover End-Of-Redo Log thread 1 sequence 91 has been fixed\r\n\tSwitchover End-Of-Redo Log thread 2 sequence 65 has been fixed\r\n\tSwitchover: Primary highest seen SCN set to 0x0.0x3bcb9c\r\n\tARCH: Noswitch archival of thread 1, sequence 91\r\n\tARCH: End-Of-Redo Branch archival of thread 1 sequence 91\r\n\tARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2\r\n\tARCH: Standby redo logfile selected for thread 1 sequence 91 for destination LOG_ARCHIVE_DEST_2\r\n\tArchived Log entry 269 added for thread 1 sequence 91 ID 0x681654f4 dest 1:\r\n\tARCH: Noswitch archival of thread 2, sequence 65\r\n\tARCH: End-Of-Redo Branch archival of thread 2 sequence 65\r\n\tARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2\r\n\tARCH: Standby redo logfile selected for thread 2 sequence 65 for destination LOG_ARCHIVE_DEST_2\r\n\tArchived Log entry 271 added for thread 2 sequence 65 ID 0x681654f4 dest 1:\r\n\tARCH: Archiving is disabled due to current logfile archival\r\n\tPrimary will check for some target standby to have received alls redo\r\n\tFinal check for a synchronized target standby. Check will be made once.\r\n\tLOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target\r\n\tActive, synchronized target has been identified\r\n\tTarget has also received all redo\r\n\tBackup controlfile written to trace file \/u01\/app\/oracle\/diag\/rdbms\/primary\/primary1\/trace\/primary1_ora_28015.trc\r\n\tClearing standby activation ID 1746294004 (0x681654f4)\r\n\tThe primary database controlfile was created using the\r\n\t'MAXLOGFILES 192' clause.\r\n\tThere is space for up to 188 standby redo logfiles\r\n\tUse the following SQL commands on the standby database to create\r\n\tstandby redo logfiles that match the primary database:\r\n\tALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;\r\n\tALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;\r\n\tALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;\r\n\tALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;\r\n\tALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 52428800;\r\n\tArchivelog for thread 1 sequence 91 required for standby recovery\r\n\tArchivelog for thread 2 sequence 65 required for standby recovery\r\n\tSwitchover: Primary controlfile converted to standby controlfile succesfully.\r\n\tMon Apr 18 15:41:20 2016\r\n\tReconfiguration started (old inc 4, new inc 6)\r\n\tList of instances:\r\n\t 1 (myinst: 1)\r\n\t Global Resource Directory frozen\r\n\t * dead instance detected - domain 0 invalid = TRUE\r\n\t Communication channels reestablished\r\n\t Master broadcasted resource hash value bitmaps\r\n\t Non-local Process blocks cleaned out\r\n\tMon Apr 18 15:41:20 2016\r\n\t LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\tMon Apr 18 15:41:20 2016\r\n\t LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\t Set master node info\r\n\t Submitted all remote-enqueue requests\r\n\t Dwn-cvts replayed, VALBLKs dubious\r\n\t All grantable enqueues granted\r\n\t Post SMON to start 1st pass IR\r\n\tMon Apr 18 15:41:20 2016\r\n\tInstance recovery: looking for dead threads\r\n\tProcess (ospid 6678) is suspended due to switchover to physical standby operation.\r\n\tSwitchover: Complete - Database shutdown required\r\n\tUSER (ospid: 28015): terminating the instance\r\n\tInstance terminated by USER, pid = 28015\r\n\tCompleted: alter database commit to switchover to physical standby with session shutdown\r\n\tShutting down instance (abort)\r\n\tLicense high water mark = 17\r\n\tMon Apr 18 15:41:22 2016\r\n\tInstance shutdown complete\r\n\tMon Apr 18 15:41:59 2016\r\n\tAdjusting the default value of parameter parallel_max_servers\r\n\tfrom 160 to 120 due to the value of parameter processes (150)\r\n\tMon Apr 18 15:42:00 2016\r\n\tStarting ORACLE instance (normal)\r\n\t************************ Large Pages Information *******************\r\n\tPer process system memlock (soft) limit = 32 KB\r\n\t\r\n\tTotal Shared Global Region in Large Pages = 0 KB (0%)\r\n\t\r\n\tLarge Pages used by this instance: 0 (0 KB)\r\n\tLarge Pages unused system wide = 0 (0 KB)\r\n\tLarge Pages configured system wide = 0 (0 KB)\r\n\tLarge Page size = 2048 KB\r\n\t\r\n\tRECOMMENDATION:\r\n\t  Total System Global Area size is 6434 MB. For optimal performance,\r\n\t  prior to the next instance restart:\r\n\t  1. Increase the number of unused large pages by\r\n\t at least 3217 (page size 2048 KB, total size 6434 MB) system wide to\r\n\t  get 100% of the System Global Area allocated with large pages\r\n\t  2. Large pages are automatically locked into physical memory.\r\n\t Increase the per process memlock (soft) limit to at least 6442 MB to lock\r\n\t 100% System Global Area's large pages into physical memory\r\n\t********************************************************************\r\n\tLICENSE_MAX_SESSION = 0\r\n\tLICENSE_SESSIONS_WARNING = 0\r\n\tInitial number of CPU is 4\r\n\tNumber of processor cores in the system is 4\r\n\tNumber of processor sockets in the system is 2\r\n\tPrivate Interface 'eth1:1' configured from GPnP for use as a private interconnect.\r\n\t  [name='eth1:1', type=1, ip=169.254.21.57, mac=00-50-56-94-6a-6c, net=169.254.0.0\/16, mask=255.255.0.0, use=haip:cluster_interconnect\/62]\r\n\tPublic Interface 'eth0' configured from GPnP for use as a public interface.\r\n\t  [name='eth0', type=1, ip=172.20.42.21, mac=00-50-56-94-20-e9, net=172.20.42.0\/24, mask=255.255.255.0, use=public\/1]\r\n\tPublic Interface 'eth0:1' configured from GPnP for use as a public interface.\r\n\t  [name='eth0:1', type=1, ip=172.20.42.23, mac=00-50-56-94-20-e9, net=172.20.42.0\/24, mask=255.255.255.0, use=public\/1]\r\n\tPublic Interface 'eth0:3' configured from GPnP for use as a public interface.\r\n\t  [name='eth0:3', type=1, ip=172.20.42.30, mac=00-50-56-94-20-e9, net=172.20.42.0\/24, mask=255.255.255.0, use=public\/1]\r\n\tPublic Interface 'eth0:4' configured from GPnP for use as a public interface.\r\n\t  [name='eth0:4', type=1, ip=172.20.42.31, mac=00-50-56-94-20-e9, net=172.20.42.0\/24, mask=255.255.255.0, use=public\/1]\r\n\tCELL communication is configured to use 0 interface(s):\r\n\tCELL IP affinity details:\r\n\t    NUMA status: non-NUMA system\r\n\t    cellaffinity.ora status: N\/A\r\n\tCELL communication will use 1 IP group(s):\r\n\t    Grp 0:\r\n\tPicked latch-free SCN scheme 3\r\n\tAutotune of undo retention is turned on.\r\n\tLICENSE_MAX_USERS = 0\r\n\tSYS auditing is disabled\r\n\tStarting up:\r\n\tOracle 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\tORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n\tSystem name:    Linux\r\n\tNode name:      primary1.hhuyanlab.local\r\n\tRelease:        2.6.18-348.el5\r\n\tVersion:        #1 SMP Wed Nov 28 21:22:00 EST 2012\r\n\tMachine:        x86_64\r\n\tVM name:        VMWare Version: 6\r\n\tUsing parameter settings in server-side pfile \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initprimary1.ora\r\n\tSystem parameters with non-default values:\r\n\t  processes                = 150\r\n\t  spfile                   = \"+DATA\/primary\/spfileprimary.ora\"\r\n\t  sga_target               = 6432M\r\n\t  control_files            = \"+DATA\/primary\/controlfile\/current.260.908830265\"\r\n\t  db_file_name_convert     = \"standby\"\r\n\t  db_file_name_convert     = \"primary\"\r\n\t  log_file_name_convert    = \"standby\"\r\n\t  log_file_name_convert    = \"primary\"\r\n\t  db_block_size            = 8192\r\n\t  compatible               = \"11.2.0.4.0\"\r\n\t  log_archive_dest_1       = \"LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary\"\r\n\t  log_archive_dest_2       = \"SERVICE=standby SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby\"\r\n\t  fal_server               = \"STANDBY\"\r\n\t  log_archive_config       = \"DG_CONFIG=(primary,standby)\"\r\n\t  log_archive_format       = \"%t_%s_%r.arc\"\r\n\t  log_archive_max_processes= 8\r\n\t  cluster_database         = TRUE\r\n\t  db_create_file_dest      = \"+DATA\"\r\n\t  db_recovery_file_dest    = \"+FRA\"\r\n\t  db_recovery_file_dest_size= 40G\r\n\t  standby_file_management  = \"AUTO\"\r\n\t  thread                   = 1\r\n\t  undo_tablespace          = \"UNDOTBS1\"\r\n\t  instance_number          = 1\r\n\t  remote_login_passwordfile= \"EXCLUSIVE\"\r\n\t  db_domain                = \"\"\r\n\t  dispatchers              = \"(PROTOCOL=TCP) (SERVICE=primaryXDB)\"\r\n\t  remote_listener          = \"primary-scan.hhuyanlab.local:1521\"\r\n\t  audit_file_dest          = \"\/u01\/app\/oracle\/admin\/primary\/adump\"\r\n\t  audit_trail              = \"DB\"\r\n\t  db_name                  = \"primary\"\r\n\t  open_cursors             = 300\r\n\t  pga_aggregate_target     = 2140M\r\n\t  diagnostic_dest          = \"\/u01\/app\/oracle\"\r\n\tCluster communication is configured to use the following interface(s) for this instance\r\n\t  169.254.21.57\r\n\tcluster interconnect IPC version:Oracle UDP\/IP (generic)\r\n\tIPC Vendor 1 proto 2\r\n\tMon Apr 18 15:42:07 2016\r\n\tPMON started with pid=2, OS id=29174\r\n\tMon Apr 18 15:42:07 2016\r\n\tPSP0 started with pid=3, OS id=29178\r\n\tMon Apr 18 15:42:08 2016\r\n\tVKTM started with pid=4, OS id=29183 at elevated priority\r\n\tVKTM running at (1)millisec precision with DBRM quantum (100)ms\r\n\tMon Apr 18 15:42:08 2016\r\n\tGEN0 started with pid=5, OS id=29189\r\n\tMon Apr 18 15:42:08 2016\r\n\tDIAG started with pid=6, OS id=29193\r\n\tMon Apr 18 15:42:09 2016\r\n\tDBRM started with pid=7, OS id=29197\r\n\tMon Apr 18 15:42:09 2016\r\n\tPING started with pid=8, OS id=29203\r\n\tMon Apr 18 15:42:09 2016\r\n\tACMS started with pid=9, OS id=29214\r\n\tMon Apr 18 15:42:09 2016\r\n\tDIA0 started with pid=10, OS id=29221\r\n\tMon Apr 18 15:42:09 2016\r\n\tLMON started with pid=11, OS id=29225\r\n\tMon Apr 18 15:42:09 2016\r\n\tLMD0 started with pid=12, OS id=29230\r\n\t* Load Monitor used for high load check\r\n\t* New Low - High Load Threshold Range = [3840 - 5120]\r\n\tMon Apr 18 15:42:09 2016\r\n\tLMS0 started with pid=13, OS id=29234 at elevated priority\r\n\tMon Apr 18 15:42:09 2016\r\n\tLMS1 started with pid=14, OS id=29246 at elevated priority\r\n\tMon Apr 18 15:42:09 2016\r\n\tRMS0 started with pid=15, OS id=29260\r\n\tMon Apr 18 15:42:09 2016\r\n\tLMHB started with pid=16, OS id=29266\r\n\tMon Apr 18 15:42:10 2016\r\n\tMMAN started with pid=17, OS id=29273\r\n\tMon Apr 18 15:42:10 2016\r\n\tDBW0 started with pid=18, OS id=29277\r\n\tMon Apr 18 15:42:10 2016\r\n\tLGWR started with pid=19, OS id=29281\r\n\tMon Apr 18 15:42:10 2016\r\n\tCKPT started with pid=20, OS id=29291\r\n\tMon Apr 18 15:42:10 2016\r\n\tSMON started with pid=21, OS id=29295\r\n\tMon Apr 18 15:42:10 2016\r\n\tRECO started with pid=22, OS id=29301\r\n\tMon Apr 18 15:42:10 2016\r\n\tRBAL started with pid=23, OS id=29305\r\n\tMon Apr 18 15:42:10 2016\r\n\tASMB started with pid=24, OS id=29309\r\n\tMon Apr 18 15:42:11 2016\r\n\tMMON started with pid=25, OS id=29313\r\n\tMon Apr 18 15:42:11 2016\r\n\tMMNL started with pid=26, OS id=29319\r\n\tMon Apr 18 15:42:11 2016\r\n\tstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\n\tNOTE: initiating MARK startup\r\n\tstarting up 1 shared server(s) ...\r\n\tStarting background process MARK\r\n\tMon Apr 18 15:42:11 2016\r\n\tMARK started with pid=28, OS id=29329\r\n\tNOTE: MARK has subscribed\r\n\tlmon registered with NM - instance number 1 (internal mem no 0)\r\n\tReconfiguration started (old inc 0, new inc 2)\r\n\tList of instances:\r\n\t 1 (myinst: 1)\r\n\t Global Resource Directory frozen\r\n\t* allocate domain 0, invalid = TRUE\r\n\t Communication channels reestablished\r\n\t Master broadcasted resource hash value bitmaps\r\n\t Non-local Process blocks cleaned out\r\n\t LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\t LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\t Set master node info\r\n\t Submitted all remote-enqueue requests\r\n\t Dwn-cvts replayed, VALBLKs dubious\r\n\t All grantable enqueues granted\r\n\t Post SMON to start 1st pass IR\r\n\t Submitted all GCS remote-cache requests\r\n\t Post SMON to start 1st pass IR\r\n\t Fix write in gcs resources\r\n\tReconfiguration complete\r\n\tMon Apr 18 15:42:12 2016\r\n\tLCK0 started with pid=31, OS id=29365\r\n\tStarting background process RSMN\r\n\tMon Apr 18 15:42:12 2016\r\n\tRSMN started with pid=32, OS id=29369\r\n\tORACLE_BASE from environment = \/u01\/app\/oracle\r\n\tMon Apr 18 15:42:13 2016\r\n\tALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=172.20.42.23)(PORT=1521))' SCOPE=MEMORY SID='primary1';\r\n\tMon Apr 18 15:42:25 2016\r\n\talter database mount standby database\r\n\tThis instance was first to mount\r\n\tMon Apr 18 15:42:25 2016\r\n\tNOTE: Loaded library: \/opt\/oracle\/extapi\/64\/asm\/orcl\/1\/libasm.so\r\n\tNOTE: Loaded library: System\r\n\tMon Apr 18 15:42:25 2016\r\n\tSUCCESS: diskgroup DATA was mounted\r\n\tMon Apr 18 15:42:25 2016\r\n\tNOTE: dependency between database primary and diskgroup resource ora.DATA.dg is established\r\n\tMon Apr 18 15:42:29 2016\r\n\tNSS2 started with pid=35, OS id=29543\r\n\tARCH: STARTING ARCH PROCESSES\r\n\tMon Apr 18 15:42:32 2016\r\n\tARC0 started with pid=36, OS id=29664\r\n\tARC0: Archival started\r\n\tARCH: STARTING ARCH PROCESSES COMPLETE\r\n\tARC0: STARTING ARCH PROCESSES\r\n\tMon Apr 18 15:42:33 2016\r\n\tARC1 started with pid=37, OS id=29684\r\n\tMon Apr 18 15:42:33 2016\r\n\tSuccessful mount of redo thread 1, with mount id 1746961569\r\n\tPhysical Standby Database mounted.\r\n\tLost write protection disabled\r\n\tMon Apr 18 15:42:34 2016\r\n\tARC2 started with pid=38, OS id=29688\r\n\tMon Apr 18 15:42:34 2016\r\n\tARC3 started with pid=39, OS id=29700\r\n\tMon Apr 18 15:42:34 2016\r\n\tARC4 started with pid=40, OS id=29709\r\n\tMon Apr 18 15:42:34 2016\r\n\tARC5 started with pid=41, OS id=29719\r\n\tMon Apr 18 15:42:34 2016\r\n\tARC6 started with pid=42, OS id=29724\r\n\tMon Apr 18 15:42:34 2016\r\n\tARC7 started with pid=43, OS id=29733\r\n\tARC1: Archival started\r\n\tARC2: Archival started\r\n\tARC3: Archival started\r\n\tARC4: Archival started\r\n\tARC5: Archival started\r\n\tARC6: Archival started\r\n\tARC4: Becoming the 'no FAL' ARCH\r\n\tARC5: Becoming the heartbeat ARCH\r\n\tARC5: Becoming the active heartbeat ARCH\r\n\tARC5: Becoming the active heartbeat ARCH\r\n\tCompleted: alter database mount standby database\r\n\tSUCCESS: diskgroup FRA was mounted\r\n\tNOTE: dependency between database primary and diskgroup resource ora.FRA.dg is established\r\n\tARC7: Archival started\r\n\tARC0: STARTING ARCH PROCESSES COMPLETE\r\n\tMon Apr 18 15:42:53 2016\r\n\tUsing STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST\r\n\tALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;\r\n\tMon Apr 18 15:43:12 2016\r\n\tDecreasing number of real time LMS from 2 to 0\r\n\tMon Apr 18 15:45:02 2016\r\n\tPrimary database is in MAXIMUM PERFORMANCE mode\r\n\tRFS[1]: Assigned to RFS process 736\r\n\tRFS[1]: Selected log 5 for thread 1 sequence 94 dbid 1746312952 branch 908830267\r\n\tMon Apr 18 15:45:04 2016\r\n\tRFS[2]: Assigned to RFS process 744\r\n\tRFS[2]: Selected log 6 for thread 1 sequence 93 dbid 1746312952 branch 908830267\r\n\tMon Apr 18 15:45:04 2016\r\n\tArchived Log entry 273 added for thread 1 sequence 93 ID 0x6820dc20 dest 1:\r\n\tMon Apr 18 15:45:55 2016\r\n\tALTER DATABASE RECOVER  managed standby database using current logfile disconnect\r\n\tAttempt to start background Managed Standby Recovery process (primary1)\r\n\tMon Apr 18 15:45:55 2016\r\n\tMRP0 started with pid=50, OS id=1997\r\n\tMRP0: Background Managed Standby Recovery process started (primary1)\r\n\tMon Apr 18 15:45:57 2016\r\n\tRFS[3]: Assigned to RFS process 2020\r\n\tRFS[3]: Opened log for thread 1 sequence 92 dbid 1746312952 branch 908830267\r\n\tArchived Log entry 274 added for thread 1 sequence 92 rlc 908830267 ID 0x6820dc20 dest 2:\r\n\t started logmerger process\r\n\tMon Apr 18 15:46:01 2016\r\n\tManaged Standby Recovery starting Real Time Apply\r\n\tParallel Media Recovery started with 4 slaves\r\n\tWaiting for all non-current ORLs to be archived...\r\n\tAll non-current ORLs have been archived.\r\n\tCompleted: ALTER DATABASE RECOVER  managed standby database using current logfile disconnect\r\n\tClearing online redo logfile 1 +DATA\/primary\/onlinelog\/group_1.261.908830267\r\n\tClearing online log 1 of thread 1 sequence number 94\r\n\tClearing online redo logfile 1 complete\r\n\tClearing online redo logfile 2 +DATA\/primary\/onlinelog\/group_2.262.908830267\r\n\tClearing online log 2 of thread 1 sequence number 94\r\n\tClearing online redo logfile 2 complete\r\n\tClearing online redo logfile 3 +DATA\/primary\/onlinelog\/group_3.266.908830663\r\n\tClearing online log 3 of thread 2 sequence number 65\r\n\tClearing online redo logfile 3 complete\r\n\tClearing online redo logfile 4 +DATA\/primary\/onlinelog\/group_4.267.908830665\r\n\tClearing online log 4 of thread 2 sequence number 64\r\n\tClearing online redo logfile 4 complete\r\n\tMon Apr 18 15:46:05 2016\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_1_seq_90.395.909502845\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_2_seq_63.394.909500431\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_2_seq_64.396.909502857\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_1_seq_91.397.909502877\r\n\tIdentified End-Of-Redo (switchover) for thread 1 sequence 91 at SCN 0x0.3bcb9c\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_2_seq_65.398.909502877\r\n\tIdentified End-Of-Redo (switchover) for thread 2 sequence 65 at SCN 0x0.3bcb9c\r\n\tResetting standby activation ID 0 (0x0)\r\n\tMedia Recovery End-Of-Redo indicator encountered\r\n\tMedia Recovery Continuing\r\n\tMedia Recovery Waiting for thread 2 sequence 66\r\n\tMon Apr 18 15:46:13 2016\r\n\tALTER DATABASE RECOVER  managed standby database cancel\r\n\tMRP0: Background Media Recovery cancelled with status 16037\r\n\tErrors in file \/u01\/app\/oracle\/diag\/rdbms\/primary\/primary1\/trace\/primary1_pr00_2156.trc:\r\n\tORA-16037: user requested cancel of managed recovery operation\r\n\tMon Apr 18 15:46:14 2016\r\n\tManaged Standby Recovery not using Real Time Apply\r\n\tRecovery interrupted!\r\n\tMon Apr 18 15:46:15 2016\r\n\tMRP0: Background Media Recovery process shutdown (primary1)\r\n\tManaged Standby Recovery Canceled (primary1)\r\n\tCompleted: ALTER DATABASE RECOVER  managed standby database cancel\r\n\talter database open\r\n\tAUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access\r\n\tThis instance was first to open\r\n\tPicked Lamport scheme to generate SCNs\r\n\tMon Apr 18 15:46:23 2016\r\n\tSMON: enabling cache recovery\r\n\tMon Apr 18 15:46:24 2016\r\n\tDictionary check beginning\r\n\tDictionary check complete\r\n\tDatabase Characterset is AL32UTF8\r\n\tNo Resource Manager plan active\r\n\tStarting background process GTX0\r\n\tMon Apr 18 15:46:25 2016\r\n\tGTX0 started with pid=50, OS id=2722\r\n\treplication_dependency_tracking turned off (no async multimaster replication found)\r\n\tPhysical standby database opened for read only access.\r\n\tCompleted: alter database open\r\n\tMon Apr 18 15:46:29 2016\r\n\tdb_recovery_file_dest_size of 40960 MB is 9.38% used. This is a\r\n\tuser-specified limit on the amount of space that will be used by this\r\n\tdatabase for recovery-related files, and does not reflect the amount of\r\n\tspace available in the underlying filesystem or ASM diskgroup.\r\n\tMon Apr 18 15:46:45 2016\r\n\tALTER DATABASE RECOVER  managed standby database using current logfile disconnect\r\n\tAttempt to start background Managed Standby Recovery process (primary1)\r\n\tMon Apr 18 15:46:45 2016\r\n\tMRP0 started with pid=56, OS id=2963\r\n\tMRP0: Background Managed Standby Recovery process started (primary1)\r\n\t started logmerger process\r\n\tMon Apr 18 15:46:51 2016\r\n\tManaged Standby Recovery starting Real Time Apply\r\n\tParallel Media Recovery started with 4 slaves\r\n\tWaiting for all non-current ORLs to be archived...\r\n\tAll non-current ORLs have been archived.\r\n\tMon Apr 18 15:46:51 2016\r\n\tMedia Recovery Waiting for thread 2 sequence 66\r\n\tCompleted: ALTER DATABASE RECOVER  managed standby database using current logfile disconnect\r\n\tMon Apr 18 15:47:39 2016\r\n\tReconfiguration started (old inc 2, new inc 4)\r\n\tList of instances:\r\n\t 1 2 (myinst: 1)\r\n\t Global Resource Directory frozen\r\n\t Communication channels reestablished\r\n\t Master broadcasted resource hash value bitmaps\r\n\t Non-local Process blocks cleaned out\r\n\tMon Apr 18 15:47:39 2016\r\n\t LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\tMon Apr 18 15:47:39 2016\r\n\t LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\t Set master node info\r\n\t Submitted all remote-enqueue requests\r\n\t Dwn-cvts replayed, VALBLKs dubious\r\n\t All grantable enqueues granted\r\n\t Submitted all GCS remote-cache requests\r\n\t Fix write in gcs resources\r\n\tReconfiguration complete\r\n\tMon Apr 18 15:47:59 2016\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_2_seq_66.401.909503279\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_1_seq_92.400.909503157\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_1_seq_93.399.909503105\r\n\tMedia Recovery Waiting for thread 1 sequence 94 (in transit)\r\n\tRecovery of Online Redo Log: Thread 1 Group 5 Seq 94 Reading mem 0\r\n\t  Mem# 0: +FRA\/primary\/onlinelog\/group_5.259.908899001\r\n\tMon Apr 18 15:48:39 2016\r\n\tIncreasing number of real time LMS from 0 to 2\r\n\tMon Apr 18 15:48:58 2016\r\n\tMedia Recovery Waiting for thread 2 sequence 67\r\n\tMon Apr 18 15:49:01 2016\r\n\tRFS[4]: Assigned to RFS process 5138\r\n\tRFS[4]: Opened log for thread 2 sequence 67 dbid 1746312952 branch 908830267\r\n\tArchived Log entry 276 added for thread 2 sequence 67 rlc 908830267 ID 0x6820dc20 dest 2:\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_2_seq_67.402.909503341\r\n\tMedia Recovery Waiting for thread 2 sequence 68\r\n\tMon Apr 18 15:49:03 2016\r\n\tPrimary database is in MAXIMUM PERFORMANCE mode\r\n\tRFS[5]: Assigned to RFS process 5163\r\n\tRFS[5]: Selected log 7 for thread 2 sequence 69 dbid 1746312952 branch 908830267\r\n\tMon Apr 18 15:49:03 2016\r\n\tRFS[6]: Assigned to RFS process 5169\r\n\tRFS[6]: Selected log 8 for thread 2 sequence 68 dbid 1746312952 branch 908830267\r\n\tMon Apr 18 15:49:04 2016\r\n\tArchived Log entry 277 added for thread 2 sequence 68 ID 0x6820dc20 dest 1:\r\n\tMedia Recovery Log +FRA\/primary\/archivelog\/2016_04_18\/thread_2_seq_68.403.909503343\r\n\tMedia Recovery Waiting for thread 2 sequence 69 (in transit)\r\n\tRecovery of Online Redo Log: Thread 2 Group 7 Seq 69 Reading mem 0\r\n\t  Mem# 0: +FRA\/primary\/onlinelog\/group_7.261.908899023\r\n\tMon Apr 18 15:49:07 2016\r\n\tRFS[1]: Selected log 6 for thread 1 sequence 95 dbid 1746312952 branch 908830267\r\n\tMon Apr 18 15:49:07 2016\r\n\tArchived Log entry 278 added for thread 1 sequence 94 ID 0x6820dc20 dest 1:\r\n\tMedia Recovery Waiting for thread 1 sequence 95 (in transit)\r\n\tRecovery of Online Redo Log: Thread 1 Group 6 Seq 95 Reading mem 0\r\n\t  Mem# 0: +FRA\/primary\/onlinelog\/group_6.260.908899009\r\n<\/pre>\n
(STANDBY_1)<\/p>\n
\tMon Apr 18 15:43:03 2016\r\n\talter database commit to switchover to primary\r\n\tALTER DATABASE SWITCHOVER TO PRIMARY (primary1)\r\n\tMaximum wait for role transition is 15 minutes.\r\n\tSwitchover: Media recovery is still active\r\n\tRole Change: Canceling MRP - no more redo to apply\r\n\tMon Apr 18 15:43:05 2016\r\n\tMRP0: Background Media Recovery cancelled with status 16037\r\n\tErrors in file \/u01\/app\/oracle\/diag\/rdbms\/standby\/primary1\/trace\/primary1_pr00_3844.trc:\r\n\tORA-16037: user requested cancel of managed recovery operation\r\n\tRecovery interrupted!\r\n\tMon Apr 18 15:43:07 2016\r\n\tMRP0: Background Media Recovery process shutdown (primary1)\r\n\tRole Change: Canceled MRP\r\n\tBackup controlfile written to trace file \/u01\/app\/oracle\/diag\/rdbms\/standby\/primary1\/trace\/primary1_ora_18083.trc\r\n\tSwitchOver after complete recovery through change 3918748\r\n\tOnline log +DATA\/standby\/onlinelog\/group_1.263.908900661: Thread 1 Group 1 was previously cleared\r\n\tOnline log +FRA\/standby\/onlinelog\/group_1.257.908900663: Thread 1 Group 1 was previously cleared\r\n\tOnline log +DATA\/standby\/onlinelog\/group_2.264.908900663: Thread 1 Group 2 was previously cleared\r\n\tOnline log +FRA\/standby\/onlinelog\/group_2.258.908900665: Thread 1 Group 2 was previously cleared\r\n\tOnline log +DATA\/standby\/onlinelog\/group_3.265.908900665: Thread 2 Group 3 was previously cleared\r\n\tOnline log +FRA\/standby\/onlinelog\/group_3.259.908900667: Thread 2 Group 3 was previously cleared\r\n\tOnline log +DATA\/standby\/onlinelog\/group_4.266.908900667: Thread 2 Group 4 was previously cleared\r\n\tOnline log +FRA\/standby\/onlinelog\/group_4.260.908900667: Thread 2 Group 4 was previously cleared\r\n\tStandby became primary SCN: 3918746\r\n\tSwitchover: Complete - Database mounted as primary\r\n\tCompleted: alter database commit to switchover to primary\r\n\tMon Apr 18 15:43:24 2016\r\n\tARC6: Becoming the 'no SRL' ARCH\r\n\tMon Apr 18 15:43:26 2016\r\n\tShutting down instance (immediate)\r\n\tShutting down instance: further logons disabled\r\n\tStopping background process MMNL\r\n\tStopping background process MMON\r\n\tLicense high water mark = 8\r\n\tAll dispatchers and shared servers shutdown\r\n\tALTER DATABASE CLOSE NORMAL\r\n\tORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...\r\n\tALTER DATABASE DISMOUNT\r\n\tShutting down archive processes\r\n\tArchiving is disabled\r\n\tMon Apr 18 15:43:29 2016\r\n\tARCH shutting down\r\n\tARC7: Archival stopped\r\n\tARCH shutting down\r\n\tMon Apr 18 15:43:29 2016\r\n\tARCH shutting down\r\n\tARC4: Archival stopped\r\n\tARC6: Archival stopped\r\n\tMon Apr 18 15:43:29 2016\r\n\tARCH shutting down\r\n\tMon Apr 18 15:43:29 2016\r\n\tARCH shutting down\r\n\tARC2: Archival stopped\r\n\tMon Apr 18 15:43:29 2016\r\n\tARCH shutting down\r\n\tARC5: Archival stopped\r\n\tARC1: Archival stopped\r\n\tMon Apr 18 15:43:29 2016\r\n\tARCH shutting down\r\n\tARC3: Archival stopped\r\n\tMon Apr 18 15:43:29 2016\r\n\tARCH shutting down\r\n\tARC0: Archival stopped\r\n\tMon Apr 18 15:43:31 2016\r\n\tNOTE: Deferred communication with ASM instance\r\n\tNOTE: deferred map free for map id 358\r\n\tMon Apr 18 15:43:31 2016\r\n\tNOTE: Deferred communication with ASM instance\r\n\tNOTE: deferred map free for map id 2\r\n\tMon Apr 18 15:43:32 2016\r\n\tNOTE: Deferred communication with ASM instance\r\n\tCompleted: ALTER DATABASE DISMOUNT\r\n\tMon Apr 18 15:43:38 2016\r\n\tARCH: Archival disabled due to shutdown: 1089\r\n\tShutting down archive processes\r\n\tArchiving is disabled\r\n\tMon Apr 18 15:43:39 2016\r\n\tStopping background process VKTM\r\n\tARCH: Archival disabled due to shutdown: 1089\r\n\tShutting down archive processes\r\n\tArchiving is disabled\r\n\tMon Apr 18 15:43:39 2016\r\n\tNOTE: force a map free for map id 27\r\n\tNOTE: force a map free for map id 25\r\n\tNOTE: force a map free for map id 23\r\n\tNOTE: force a map free for map id 21\r\n\tNOTE: force a map free for map id 19\r\n\tNOTE: force a map free for map id 17\r\n\tNOTE: force a map free for map id 15\r\n\tNOTE: force a map free for map id 13\r\n\tNOTE: force a map free for map id 26\r\n\tNOTE: force a map free for map id 24\r\n\tNOTE: force a map free for map id 22\r\n\tNOTE: force a map free for map id 20\r\n\tNOTE: force a map free for map id 18\r\n\tNOTE: force a map free for map id 16\r\n\tNOTE: force a map free for map id 14\r\n\tNOTE: force a map free for map id 12\r\n\tMon Apr 18 15:43:39 2016\r\n\tNOTE: Shutting down MARK background process\r\n\tMon Apr 18 15:43:41 2016\r\n\tfreeing rdom 0\r\n\tMon Apr 18 15:43:47 2016\r\n\tInstance shutdown complete\r\n\tMon Apr 18 15:44:00 2016\r\n\tAdjusting the default value of parameter parallel_max_servers\r\n\tfrom 160 to 120 due to the value of parameter processes (150)\r\n\tStarting ORACLE instance (normal)\r\n\t************************ Large Pages Information *******************\r\n\tPer process system memlock (soft) limit = 32 KB\r\n\t\r\n\tTotal Shared Global Region in Large Pages = 0 KB (0%)\r\n\t\r\n\tLarge Pages used by this instance: 0 (0 KB)\r\n\tLarge Pages unused system wide = 0 (0 KB)\r\n\tLarge Pages configured system wide = 0 (0 KB)\r\n\tLarge Page size = 2048 KB\r\n\t\r\n\tRECOMMENDATION:\r\n\t  Total System Global Area size is 6434 MB. For optimal performance,\r\n\t  prior to the next instance restart:\r\n\t  1. Increase the number of unused large pages by\r\n\t at least 3217 (page size 2048 KB, total size 6434 MB) system wide to\r\n\t  get 100% of the System Global Area allocated with large pages\r\n\t  2. Large pages are automatically locked into physical memory.\r\n\t Increase the per process memlock (soft) limit to at least 6442 MB to lock\r\n\t 100% System Global Area's large pages into physical memory\r\n\t********************************************************************\r\n\tLICENSE_MAX_SESSION = 0\r\n\tLICENSE_SESSIONS_WARNING = 0\r\n\tInitial number of CPU is 4\r\n\tNumber of processor cores in the system is 4\r\n\tNumber of processor sockets in the system is 2\r\n\tPrivate Interface 'eth1:1' configured from GPnP for use as a private interconnect.\r\n\t  [name='eth1:1', type=1, ip=169.254.25.7, mac=00-50-56-94-39-be, net=169.254.0.0\/16, mask=255.255.0.0, use=haip:cluster_interconnect\/62]\r\n\tPublic Interface 'eth0' configured from GPnP for use as a public interface.\r\n\t  [name='eth0', type=1, ip=172.20.42.25, mac=00-50-56-94-7e-f9, net=172.20.42.0\/24, mask=255.255.255.0, use=public\/1]\r\n\tPublic Interface 'eth0:1' configured from GPnP for use as a public interface.\r\n\t  [name='eth0:1', type=1, ip=172.20.42.27, mac=00-50-56-94-7e-f9, net=172.20.42.0\/24, mask=255.255.255.0, use=public\/1]\r\n\tPublic Interface 'eth0:3' configured from GPnP for use as a public interface.\r\n\t  [name='eth0:3', type=1, ip=172.20.42.33, mac=00-50-56-94-7e-f9, net=172.20.42.0\/24, mask=255.255.255.0, use=public\/1]\r\n\tPublic Interface 'eth0:4' configured from GPnP for use as a public interface.\r\n\t  [name='eth0:4', type=1, ip=172.20.42.32, mac=00-50-56-94-7e-f9, net=172.20.42.0\/24, mask=255.255.255.0, use=public\/1]\r\n\tCELL communication is configured to use 0 interface(s):\r\n\tCELL IP affinity details:\r\n\t    NUMA status: non-NUMA system\r\n\t    cellaffinity.ora status: N\/A\r\n\tCELL communication will use 1 IP group(s):\r\n\t    Grp 0:\r\n\tPicked latch-free SCN scheme 3\r\n\tWARNING: db_recovery_file_dest is same as db_create_online_log_dest_2\r\n\tAutotune of undo retention is turned on.\r\n\tLICENSE_MAX_USERS = 0\r\n\tSYS auditing is disabled\r\n\tStarting up:\r\n\tOracle 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\tORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n\tSystem name:    Linux\r\n\tNode name:      standby1.hhuyanlab.local\r\n\tRelease:        2.6.18-348.el5\r\n\tVersion:        #1 SMP Wed Nov 28 21:22:00 EST 2012\r\n\tMachine:        x86_64\r\n\tVM name:        VMWare Version: 6\r\n\tUsing parameter settings in server-side pfile \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initprimary1.ora\r\n\tSystem parameters with non-default values:\r\n\t  processes                = 150\r\n\t  spfile                   = \"+DATA\/standby\/parameterfile\/spfilestandby.ora\"\r\n\t  sga_target               = 6432M\r\n\t  control_files            = \"+DATA\/standby\/controlfile\/control01.ctl\"\r\n\t  control_files            = \"+FRA\/standby\/controlfile\/control02.ctl\"\r\n\t  db_file_name_convert     = \"standby\"\r\n\t  db_file_name_convert     = \"primary\"\r\n\t  log_file_name_convert    = \"primary\"\r\n\t  log_file_name_convert    = \"standby\"\r\n\t  db_block_size            = 8192\r\n\t  compatible               = \"11.2.0.4.0\"\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  fal_server               = \"PRIMARY\"\r\n\t  log_archive_config       = \"DG_CONFIG=(primary,standby)\"\r\n\t  log_archive_format       = \"%t_%s_%r.arc\"\r\n\t  log_archive_max_processes= 8\r\n\t  cluster_database         = TRUE\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_recovery_file_dest    = \"+FRA\"\r\n\t  db_recovery_file_dest_size= 40G\r\n\t  standby_file_management  = \"AUTO\"\r\n\t  thread                   = 1\r\n\t  undo_tablespace          = \"UNDOTBS1\"\r\n\t  instance_number          = 1\r\n\t  remote_login_passwordfile= \"EXCLUSIVE\"\r\n\t  db_domain                = \"\"\r\n\t  dispatchers              = \"(PROTOCOL=TCP) (SERVICE=primaryXDB)\"\r\n\t  remote_listener          = \"standby-scan.hhuyanlab.local:1521\"\r\n\t  audit_file_dest          = \"\/u01\/app\/oracle\/admin\/standby\/adump\"\r\n\t  audit_trail              = \"DB\"\r\n\t  db_name                  = \"primary\"\r\n\t  db_unique_name           = \"standby\"\r\n\t  open_cursors             = 300\r\n\t  pga_aggregate_target     = 2140M\r\n\t  diagnostic_dest          = \"\/u01\/app\/oracle\"\r\n\tCluster communication is configured to use the following interface(s) for this instance\r\n\t  169.254.25.7\r\n\tcluster interconnect IPC version:Oracle UDP\/IP (generic)\r\n\tIPC Vendor 1 proto 2\r\n\tMon Apr 18 15:44:13 2016\r\n\tPMON started with pid=2, OS id=19288\r\n\tMon Apr 18 15:44:14 2016\r\n\tPSP0 started with pid=3, OS id=19292\r\n\tMon Apr 18 15:44:15 2016\r\n\tVKTM started with pid=4, OS id=19300 at elevated priority\r\n\tVKTM running at (1)millisec precision with DBRM quantum (100)ms\r\n\tMon Apr 18 15:44:16 2016\r\n\tGEN0 started with pid=5, OS id=19306\r\n\tMon Apr 18 15:44:16 2016\r\n\tDIAG started with pid=6, OS id=19323\r\n\tMon Apr 18 15:44:17 2016\r\n\tDBRM started with pid=7, OS id=19335\r\n\tMon Apr 18 15:44:17 2016\r\n\tPING started with pid=8, OS id=19350\r\n\tMon Apr 18 15:44:17 2016\r\n\tACMS started with pid=9, OS id=19354\r\n\tMon Apr 18 15:44:18 2016\r\n\tDIA0 started with pid=10, OS id=19363\r\n\tMon Apr 18 15:44:18 2016\r\n\tLMON started with pid=11, OS id=19368\r\n\tMon Apr 18 15:44:19 2016\r\n\tLMD0 started with pid=12, OS id=19374\r\n\t* Load Monitor used for high load check\r\n\t* New Low - High Load Threshold Range = [3840 - 5120]\r\n\tMon Apr 18 15:44:19 2016\r\n\tLMS0 started with pid=13, OS id=19378 at elevated priority\r\n\tMon Apr 18 15:44:20 2016\r\n\tLMS1 started with pid=14, OS id=19384 at elevated priority\r\n\tMon Apr 18 15:44:21 2016\r\n\tRMS0 started with pid=15, OS id=19391\r\n\tMon Apr 18 15:44:21 2016\r\n\tLMHB started with pid=16, OS id=19397\r\n\tMon Apr 18 15:44:21 2016\r\n\tMMAN started with pid=17, OS id=19401\r\n\tMon Apr 18 15:44:22 2016\r\n\tDBW0 started with pid=18, OS id=19405\r\n\tMon Apr 18 15:44:22 2016\r\n\tLGWR started with pid=19, OS id=19409\r\n\tMon Apr 18 15:44:22 2016\r\n\tCKPT started with pid=20, OS id=19413\r\n\tMon Apr 18 15:44:23 2016\r\n\tSMON started with pid=21, OS id=19417\r\n\tMon Apr 18 15:44:23 2016\r\n\tRECO started with pid=22, OS id=19421\r\n\tMon Apr 18 15:44:23 2016\r\n\tRBAL started with pid=23, OS id=19425\r\n\tMon Apr 18 15:44:24 2016\r\n\tASMB started with pid=24, OS id=19429\r\n\tMon Apr 18 15:44:24 2016\r\n\tMMON started with pid=25, OS id=19433\r\n\tMon Apr 18 15:44:25 2016\r\n\tstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\n\tMon Apr 18 15:44:25 2016\r\n\tMMNL started with pid=26, OS id=19439\r\n\tNOTE: initiating MARK startup\r\n\tstarting up 1 shared server(s) ...\r\n\tStarting background process MARK\r\n\tMon Apr 18 15:44:26 2016\r\n\tMARK started with pid=28, OS id=19454\r\n\tNOTE: MARK has subscribed\r\n\tlmon registered with NM - instance number 1 (internal mem no 0)\r\n\tReconfiguration started (old inc 0, new inc 2)\r\n\tList of instances:\r\n\t 1 (myinst: 1)\r\n\t Global Resource Directory frozen\r\n\t* allocate domain 0, invalid = TRUE\r\n\t Communication channels reestablished\r\n\t Master broadcasted resource hash value bitmaps\r\n\t Non-local Process blocks cleaned out\r\n\t LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\t LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\t Set master node info\r\n\t Submitted all remote-enqueue requests\r\n\t Dwn-cvts replayed, VALBLKs dubious\r\n\t All grantable enqueues granted\r\n\t Post SMON to start 1st pass IR\r\n\t Submitted all GCS remote-cache requests\r\n\t Post SMON to start 1st pass IR\r\n\t Fix write in gcs resources\r\n\tReconfiguration complete\r\n\tMon Apr 18 15:44:28 2016\r\n\tLCK0 started with pid=32, OS id=19492\r\n\tStarting background process RSMN\r\n\tMon Apr 18 15:44:29 2016\r\n\tRSMN started with pid=33, OS id=19502\r\n\tORACLE_BASE from environment = \/u01\/app\/oracle\r\n\tNOTE: Loaded library: \/opt\/oracle\/extapi\/64\/asm\/orcl\/1\/libasm.so\r\n\tNOTE: Loaded library: System\r\n\tSUCCESS: diskgroup DATA was mounted\r\n\tMon Apr 18 15:44:31 2016\r\n\tNOTE: dependency between database standby and diskgroup resource ora.DATA.dg is established\r\n\tMon Apr 18 15:44:32 2016\r\n\tALTER DATABASE   MOUNT\r\n\tThis instance was first to mount\r\n\tMon Apr 18 15:44:33 2016\r\n\tSUCCESS: diskgroup FRA was mounted\r\n\tNOTE: dependency between database standby and diskgroup resource ora.FRA.dg is established\r\n\tMon Apr 18 15:44:34 2016\r\n\tALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=172.20.42.27)(PORT=1521))' SCOPE=MEMORY SID='primary1';\r\n\tMon Apr 18 15:44:38 2016\r\n\tNSS2 started with pid=34, OS id=19563\r\n\tMon Apr 18 15:44:41 2016\r\n\tSuccessful mount of redo thread 1, with mount id 1746983968\r\n\tDatabase mounted in Shared Mode (CLUSTER_DATABASE=TRUE)\r\n\tLost write protection disabled\r\n\tMon Apr 18 15:44:46 2016\r\n\tCompleted: ALTER DATABASE   MOUNT\r\n\tMon Apr 18 15:44:46 2016\r\n\tALTER DATABASE OPEN\r\n\tThis instance was first to open\r\n\tPicked broadcast on commit scheme to generate SCNs\r\n\tAssigning activation ID 1746983968 (0x6820dc20)\r\n\tLGWR: STARTING ARCH PROCESSES\r\n\tMon Apr 18 15:44:47 2016\r\n\tARC0 started with pid=37, OS id=19583\r\n\tARC0: Archival started\r\n\tLGWR: STARTING ARCH PROCESSES COMPLETE\r\n\tARC0: STARTING ARCH PROCESSES\r\n\tDestination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED\r\n\tDestination LOG_ARCHIVE_DEST_2 no longer supports SYNCHRONIZATION\r\n\tThread 1 advanced to log sequence 93 (thread open)\r\n\tMon Apr 18 15:44:49 2016\r\n\tARC1 started with pid=38, OS id=19590\r\n\tThread 1 opened at log sequence 93\r\n\t  Current log# 2 seq# 93 mem# 0: +DATA\/standby\/onlinelog\/group_2.264.908900663\r\n\t  Current log# 2 seq# 93 mem# 1: +FRA\/standby\/onlinelog\/group_2.258.908900665\r\n\tSuccessful open of redo thread 1\r\n\tMTTR advisory is disabled because FAST_START_MTTR_TARGET is not set\r\n\tMon Apr 18 15:44:49 2016\r\n\tARC2 started with pid=39, OS id=19594\r\n\tMon Apr 18 15:44:49 2016\r\n\tSMON: enabling cache recovery\r\n\tInstance recovery: looking for dead threads\r\n\tMon Apr 18 15:44:50 2016\r\n\tARC3 started with pid=40, OS id=19598\r\n\tMon Apr 18 15:44:50 2016\r\n\tRedo thread 2 internally disabled at seq 66 (CKPT)\r\n\tInstance recovery: lock domain invalid but no dead threads\r\n\tMon Apr 18 15:44:50 2016\r\n\tARC4 started with pid=41, OS id=19602\r\n\tMon Apr 18 15:44:50 2016\r\n\tARC5 started with pid=42, OS id=19606\r\n\tMon Apr 18 15:44:51 2016\r\n\tARC6 started with pid=43, OS id=19614\r\n\tARC1: Archival started\r\n\tARC2: Archival started\r\n\tMon Apr 18 15:44:51 2016\r\n\tARC7 started with pid=44, OS id=19619\r\n\tARC3: Archival started\r\n\tARC4: Archival started\r\n\tARC5: Archival started\r\n\tARC6: Archival started\r\n\tARC5: Becoming the 'no FAL' ARCH\r\n\tARC5: Becoming the 'no SRL' ARCH\r\n\tARC1: Becoming the heartbeat ARCH\r\n\tARC7: Archival started\r\n\tARC0: STARTING ARCH PROCESSES COMPLETE\r\n\tARC3: Archiving disabled thread 2 sequence 66\r\n\tArchived Log entry 134 added for thread 2 sequence 66 ID 0x0 dest 1:\r\n\tMon Apr 18 15:44:58 2016\r\n\tORACLE Instance primary1 - Cannot allocate log, archival required\r\n\tThread 1 cannot allocate new log, sequence 94\r\n\tAll online logs need archiving\r\n\tExamine archive trace files for archiving errors\r\n\t  Current log# 2 seq# 93 mem# 0: +DATA\/standby\/onlinelog\/group_2.264.908900663\r\n\t  Current log# 2 seq# 93 mem# 1: +FRA\/standby\/onlinelog\/group_2.258.908900665\r\n\tArchived Log entry 135 added for thread 1 sequence 92 ID 0x6820dc20 dest 1:\r\n\t******************************************************************\r\n\tLGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2\r\n\t******************************************************************\r\n\tMon Apr 18 15:45:02 2016\r\n\tminact-scn: Inst 1 is now the master inc#:2 mmon proc-id:19433 status:0x7\r\n\tminact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000\r\n\tLGWR: Standby redo logfile selected for thread 1 sequence 94 for destination LOG_ARCHIVE_DEST_2\r\n\tThread 1 advanced to log sequence 94 (LGWR switch)\r\n\t  Current log# 1 seq# 94 mem# 0: +DATA\/standby\/onlinelog\/group_1.263.908900661\r\n\t  Current log# 1 seq# 94 mem# 1: +FRA\/standby\/onlinelog\/group_1.257.908900663\r\n\tMon Apr 18 15:45:03 2016\r\n\t[19578] Successfully onlined Undo Tablespace 2.\r\n\tUndo initialization finished serial:0 start:785257034 end:785260614 diff:3580 (35 seconds)\r\n\tDictionary check beginning\r\n\tMon Apr 18 15:45:03 2016\r\n\tArchived Log entry 136 added for thread 1 sequence 93 ID 0x6820dc20 dest 1:\r\n\tDictionary check complete\r\n\tMon Apr 18 15:45:04 2016\r\n\tARC4: Standby redo logfile selected for thread 1 sequence 93 for destination LOG_ARCHIVE_DEST_2\r\n\tVerifying file header compatibility for 11g tablespace encryption..\r\n\tVerifying 11g file header compatibility for tablespace encryption completed\r\n\tMon Apr 18 15:45:04 2016\r\n\tSMON: enabling tx recovery\r\n\tDatabase Characterset is AL32UTF8\r\n\tNo Resource Manager plan active\r\n\tStarting background process GTX0\r\n\tMon Apr 18 15:45:13 2016\r\n\tGTX0 started with pid=50, OS id=19734\r\n\tMon Apr 18 15:45:14 2016\r\n\tStarting background process RCBG\r\n\tMon Apr 18 15:45:14 2016\r\n\tRCBG started with pid=52, OS id=19742\r\n\treplication_dependency_tracking turned off (no async multimaster replication found)\r\n\tStarting background process QMNC\r\n\tMon Apr 18 15:45:20 2016\r\n\tQMNC started with pid=51, OS id=19752\r\n\tLOGSTDBY: Validating controlfile with logical metadata\r\n\tLOGSTDBY: Validation complete\r\n\tMon Apr 18 15:45:27 2016\r\n\tDecreasing number of real time LMS from 2 to 0\r\n\tMon Apr 18 15:45:40 2016\r\n\tCompleted: ALTER DATABASE OPEN\r\n\tMon Apr 18 15:45:49 2016\r\n\tARC1: STARTING ARCH PROCESSES\r\n\tMon Apr 18 15:45:50 2016\r\n\tARC8 started with pid=61, OS id=19881\r\n\tARC8: Archival started\r\n\tARC1: STARTING ARCH PROCESSES COMPLETE\r\n\tMon Apr 18 15:45:55 2016\r\n\tdb_recovery_file_dest_size of 40960 MB is 9.38% used. This is a\r\n\tuser-specified limit on the amount of space that will be used by this\r\n\tdatabase for recovery-related files, and does not reflect the amount of\r\n\tspace available in the underlying filesystem or ASM diskgroup.\r\n\tMon Apr 18 15:45:55 2016\r\n\tStarting background process CJQ0\r\n\tMon Apr 18 15:45:56 2016\r\n\tCJQ0 started with pid=56, OS id=19898\r\n\tMon Apr 18 15:46:03 2016\r\n\tShutting down archive processes\r\n\tARCH shutting down\r\n\tARC8: Archival stopped\r\n\tMon Apr 18 15:48:40 2016\r\n\tReconfiguration started (old inc 2, new inc 4)\r\n\tList of instances:\r\n\t 1 2 (myinst: 1)\r\n\t Global Resource Directory frozen\r\n\t Communication channels reestablished\r\n\t Master broadcasted resource hash value bitmaps\r\n\t Non-local Process blocks cleaned out\r\n\tMon Apr 18 15:48:40 2016\r\n\t LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\tMon Apr 18 15:48:40 2016\r\n\t LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived\r\n\t Set master node info\r\n\t Submitted all remote-enqueue requests\r\n\t Dwn-cvts replayed, VALBLKs dubious\r\n\t All grantable enqueues granted\r\n\t Submitted all GCS remote-cache requests\r\n\t Fix write in gcs resources\r\n\tReconfiguration complete\r\n\tMon Apr 18 15:48:42 2016\r\n\tminact-scn: Master returning as live inst:2 has inc# mismatch instinc:0 cur:4 errcnt:0\r\n\tMon Apr 18 15:49:04 2016\r\n\tThread 1 cannot allocate new log, sequence 95\r\n\tCheckpoint not complete\r\n\t  Current log# 1 seq# 94 mem# 0: +DATA\/standby\/onlinelog\/group_1.263.908900661\r\n\t  Current log# 1 seq# 94 mem# 1: +FRA\/standby\/onlinelog\/group_1.257.908900663\r\n\tLGWR: Standby redo logfile selected for thread 1 sequence 95 for destination LOG_ARCHIVE_DEST_2\r\n\tThread 1 advanced to log sequence 95 (LGWR switch)\r\n\t  Current log# 2 seq# 95 mem# 0: +DATA\/standby\/onlinelog\/group_2.264.908900663\r\n\t  Current log# 2 seq# 95 mem# 1: +FRA\/standby\/onlinelog\/group_2.258.908900665\r\n\tMon Apr 18 15:49:08 2016\r\n\tArchived Log entry 145 added for thread 1 sequence 94 ID 0x6820dc20 dest 1:\r\n\tMon Apr 18 15:50:03 2016\r\n\tIncreasing number of real time LMS from 0 to 2\r\n\tMon Apr 18 15:50:27 2016\r\n\tStarting background process SMCO\r\n\tMon Apr 18 15:50:27 2016\r\n\tSMCO started with pid=60, OS id=20832\r\n<\/pre>\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article we will be learning how to Performing SwitchOver. 1. First, we move the logs in our live database. (PRIMARY_1) [root@primary1 ~]# su – oracle [oracle@primary1 ~]$ sqlplus \/ as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 18 15:40:54 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":53329,"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-53320","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nPerforming SwitchOver - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article we will be learning how to Performing SwitchOver. 1. We move the logs in our live database.\" \/>\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\/12\/13\/performing-switchover\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performing SwitchOver - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article we will be learning how to Performing SwitchOver. 1. We move the logs in our live database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-13T18:52:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-14T14:09:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png\" \/>\n\t<meta property=\"og:image:width\" content=\"682\" \/>\n\t<meta property=\"og:image:height\" content=\"273\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"31 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\/12\/13\/performing-switchover\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Performing SwitchOver\",\"datePublished\":\"2022-12-13T18:52:22+00:00\",\"dateModified\":\"2022-12-14T14:09:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/\"},\"wordCount\":281,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/\",\"name\":\"Performing SwitchOver - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png\",\"datePublished\":\"2022-12-13T18:52:22+00:00\",\"dateModified\":\"2022-12-14T14:09:56+00:00\",\"description\":\"In today's article we will be learning how to Performing SwitchOver. 1. We move the logs in our live database.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png\",\"width\":682,\"height\":273},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performing SwitchOver\"}]},{\"@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":"Performing SwitchOver - Database Tutorials","description":"In today's article we will be learning how to Performing SwitchOver. 1. We move the logs in our live database.","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\/12\/13\/performing-switchover\/","og_locale":"en_US","og_type":"article","og_title":"Performing SwitchOver - Database Tutorials","og_description":"In today's article we will be learning how to Performing SwitchOver. 1. We move the logs in our live database.","og_url":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/","og_site_name":"Database Tutorials","article_published_time":"2022-12-13T18:52:22+00:00","article_modified_time":"2022-12-14T14:09:56+00:00","og_image":[{"width":682,"height":273,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"31 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Performing SwitchOver","datePublished":"2022-12-13T18:52:22+00:00","dateModified":"2022-12-14T14:09:56+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/"},"wordCount":281,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/","url":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/","name":"Performing SwitchOver - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png","datePublished":"2022-12-13T18:52:22+00:00","dateModified":"2022-12-14T14:09:56+00:00","description":"In today's article we will be learning how to Performing SwitchOver. 1. We move the logs in our live database.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-13-214920.png","width":682,"height":273},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/13\/performing-switchover\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Performing SwitchOver"}]},{"@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\/53320","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=53320"}],"version-history":[{"count":4,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53320\/revisions"}],"predecessor-version":[{"id":53335,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53320\/revisions\/53335"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/53329"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=53320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=53320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=53320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}