{"id":9433,"date":"2016-11-30T18:13:47","date_gmt":"2016-11-30T17:13:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/"},"modified":"2023-06-08T16:13:46","modified_gmt":"2023-06-08T14:13:46","slug":"creating-standby-database-with-dbvisit-8","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/","title":{"rendered":"Creating standby database with Dbvisit 8"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

The new version of Dbvisit standby is now released. In this blog we are going to see how to install dbvisit 8 and how to create a standby database.
\nFor the installation after downloading the software, just uncompress it and then run the install-dbvisit<\/span> command under the installer directory. The installation process is divided in 2 parts.
\n1- Core Components (Dbvisit Standby Cli, Dbvnet, Dbvagent) –On both servers
\n2- Dbvserver console installation. Just note that the console now needs to be installed only on one server.<\/p>\n

We will not show all outputs, more info for the installation can be found in my precedent blog<\/a> about upgrading dbvisit 7 to dbvisit 8
\n
\n[oracle@dbvisit1 installer]$ pwd
\n\/home\/oracle\/dbvisit\/dbvisit\/dbvisit\/installer
\n[oracle@dbvisit1 installer]$ ls
\ninstall-dbvisit
\n[oracle@dbvisit1 installer]$
\n[oracle@dbvisit1 installer]$ .\/install-dbvisit
\n-----------------------------------------------------------
\nWelcome to the Dbvisit software installer.
\n-----------------------------------------------------------
\nIt is recommended to make a backup of our current Dbvisit software
\nlocation (Dbvisit Base location) for rollback purposes.
\nInstaller Directory \/home\/oracle\/dbvisit\/dbvisit\/dbvisit
\n>>> Please specify the Dbvisit installation directory (Dbvisit Base).
\nThe various Dbvisit products and components - such as Dbvisit Standby,
\nDbvisit Dbvnet will be installed in the appropriate subdirectories of
\nthis path.
\nEnter a custom value or press ENTER to accept default [\/usr\/dbvisit]:
\n> \/u01\/app\/dbvisit
\nDBVISIT_BASE = \/u01\/app\/dbvisit
\n-----------------------------------------------------------
\nComponent Installer Version Installed Version
\n-----------------------------------------------------------
\nstandby 8.0.04.18184 not installed
\ndbvnet 2.0.04.18184 not installed
\ndbvagent 2.0.04.18184 not installed
\ndbvserver 2.0.04.18184 not installed
\n-----------------------------------------------------------
\nWhat action would you like to perform?
\n1 - Install component(s)
\n2 - Uninstall component(s)
\n3 - Terminate
\nYour choice: 1
\nWhich component do you want to install?
\n1 - Core Components (Dbvisit Standby Cli, Dbvnet, Dbvagent)
\n2 - Dbvisit Standby Core (Command Line Interface)
\n3 - Dbvnet (Dbvisit Network Communication)
\n4 - Dbvagent (Dbvisit Agent)
\n5 - Dbvserver (Dbvisit Central Console)
\n6 - Exit Installer
\nYour choice: 1
\n<\/code><\/p>\n

And then follow instructions.
\nAt the end of the proceesus we can start the different components: the dbvagent and the dbvserver<\/p>\n


\n[oracle@dbvisit1 installer]$ \/u01\/app\/dbvisit\/dbvagent\/dbvagent -d start
\n<\/code>
\n
\n[oracle@dbvisit1 installer]$ \/u01\/app\/dbvisit\/dbvnet\/dbvnet -d start
\n<\/code>
\n
\n[oracle@dbvisit1 installer]$ ps -ef|egrep 'dbvagent|dbvnet' | grep -v grep
\noracle 4064 1 0 10:46 ? 00:00:00 \/u01\/app\/dbvisit\/dbvagent\/dbvagent -d start
\noracle 4140 1 0 10:47 ? 00:00:00 \/u01\/app\/dbvisit\/dbvnet\/dbvnet -d start
\n[oracle@dbvisit1 installer]$
\n<\/code>
\nAfter core components installation, we can proceed with Dbvisit Standby Central console installation (dbvserver). Just launch again install-dbvisit command and follow instructions.
\n
\n[oracle@dbvisit1 installer]$ .\/install-dbvisit
\n-----------------------------------------------------------
\nWelcome to the Dbvisit software installer.
\n-----------------------------------------------------------
\nIt is recommended to make a backup of our current Dbvisit software
\nlocation (Dbvisit Base location) for rollback purposes.
\nInstaller Directory \/home\/oracle\/dbvisit\/dbvisit\/dbvisit
\n.....
\n.....
\nWhat action would you like to perform?
\n1 - Install component(s)
\n2 - Uninstall component(s)
\n3 - Terminate
\nYour choice: 1
\nWhich component do you want to install?
\n1 - Core Components (Dbvisit Standby Cli, Dbvnet, Dbvagent)
\n2 - Dbvisit Standby Core (Command Line Interface)
\n3 - Dbvnet (Dbvisit Network Communication)
\n4 - Dbvagent (Dbvisit Agent)
\n5 - Dbvserver (Dbvisit Central Console)
\n6 - Exit Installer
\nYour choice: 5
\n<\/code>
\nAt the end of the installation, We can now start dbserver
\n
\n[oracle@dbvisit1 installer]$ \/u01\/app\/dbvisit\/dbvserver\/dbvserver -d start
\n<\/code>
\n
\n[root@dbvisit1 ~]# netstat -taupen | grep dbvser
\ntcp 0 0 0.0.0.0:4433 0.0.0.0:* LISTEN 1000 37848 5348\/dbvserver
\n[root@dbvisit1 ~]#
\n<\/code>
\nWe should be able to connect to dbvserver console on port 4433, with admin user. The default password is admin
\n\"dbvserverconsole1\"<\/a>
\n\"dbvserverconsole2\"<\/a>
\nFor example using MANAGE USERS, we can change default admin password.
\nNow that dbvisit standby is installed on both server, the first thing is to test connectivity. For this we will use the command dbvctl<\/span> which is the main command of dbvisit 8. In dbvisit documentation you can find\u00a0The first command you need to be fimiliar with is the “dbvctl -h” command which will display the syntax and usage options for the Dbvisit Standby command line interface.<\/em> and it’s really true. The command dbvctl -f system_readiness<\/span> will be used.
\n
\n[oracle@dbvisit1 installer]$ \/u01\/app\/dbvisit\/standby\/dbvctl -f system_readiness
\nPlease supply the following information to complete the test.
\nDefault values are in [].
\nEnter Dbvisit Standby location on local server: [\/u01\/app\/dbvisit]:
\nYour input: \/u01\/app\/dbvisit
\nIs this correct? <Yes\/No> [Yes]:
\nEnter the name of the remote server: []: dbvisit2
\nYour input: dbvisit2
\nIs this correct? <Yes\/No> [Yes]:
\nEnter Dbvisit Standby location on remote server: [\/u01\/app\/dbvisit]:
\nYour input: \/u01\/app\/dbvisit
\nIs this correct? <Yes\/No> [Yes]:
\nEnter the name of a file to transfer relative to local install directory
\n\/u01\/app\/dbvisit: [standby\/doc\/README.txt]:
\nYour input: standby\/doc\/README.txt
\nIs this correct? <Yes\/No> [Yes]:
\nChoose copy method:
\n1) \/u01\/app\/dbvisit\/dbvnet\/dbvnet
\n2) \/usr\/bin\/scp
\nPlease enter choice [1] : 1
\nIs this correct? <Yes\/No> [Yes]:
\nEnter port for method \/u01\/app\/dbvisit\/dbvnet\/dbvnet: [7890]:
\nYour input: 7890
\nIs this correct? <Yes\/No> [Yes]:
\n-------------------------------------------------------------
\nTesting the network connection between local server and remote server dbvisit2.
\n-------------------------------------------------------------
\nSettings
\n========
\nRemote server =dbvisit2
\nDbvisit Standby location on local server =\/u01\/app\/dbvisit
\nDbvisit Standby location on remote server =\/u01\/app\/dbvisit
\nTest file to copy =\/u01\/app\/dbvisit\/standby\/doc\/README.txt
\nTransfer method =\/u01\/app\/dbvisit\/dbvnet\/dbvnet
\nport =7890
\n-------------------------------------------------------------
\nChecking network connection by copying file to remote server dbvisit2...
\n-------------------------------------------------------------
\nTrace file \/u01\/app\/dbvisit\/standby\/trace\/5589_dbvctl_system_readiness_201611291139.trc
\nFile copied successfully. Network connection between local and dbvisit2
\ncorrectly configured.
\n[oracle@dbvisit1 installer]$
\n<\/code>
\nIf everything is fine with the installation, now we can create a standby database using dbvctl. The configuration we use is the following:
\nPrimary Server : dbvisit1
\nStandby Server: dbvisit2
\nDatabase Instance : DBPRIMA ( We suppose that database is in archive mode and in force logging mode )
\nFirst Let\u2019s create Dbvisit Standby Database Configuration (DDC) file.The name of the DDC is generally the name of the database instance. The command dbvctl -o setup<\/span> is used.
\n
\n[oracle@dbvisit1 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -o setup
\n========================================================
\nDbvisit Standby Database Technology (8.0.04.18184)
\n=========================================================
\n=>dbvctl only needs to be run on the primary server.
\nIs this the primary server? <Yes\/No> [Yes]:
\nThe following Dbvisit Database configuration (DDC) file(s) found on this
\nserver:
\nDDC
\n===
\n1) Create New DDC
\n2) Cancel
\nPlease enter choice [] : 1
\nIs this correct? <Yes\/No> [Yes]:
\nEND USER LICENSE AGREEMENT
\nPLEASE READ THIS END USER LICENSE AGREEMENT (AGREEMENT) CAREFULLY BEFORE
\nDOWNLOADING THE LICENSED PRODUCT. BY CLICKING I AGREE BELOW, YOU ARE
\nREPRESENTING THAT YOU HAVE THE RIGHT AND AUTHORITY TO LEGALLY BIND YOURSELF
\n\u2026\u2026.
\n\u2026\u2026.
\nof it on future occasions. Headings are for reference purposes only and
\nhave no substantive effect.
\nContinue ? <Yes\/No> [No]: yes
\n=========================================================
\nDbvisit Standby setup begins.
\n=========================================================
\nThe following Oracle instance(s) have been found on this server:
\nSID ORACLE_HOME
\n=== ===========
\n1) DBPRIMA \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1
\n2) Enter own ORACLE_SID and ORACLE_HOME
\nPlease enter choice [] : 1
\nIs this correct? <Yes\/No> [Yes]:
\n=>ORACLE_SID will be: DBPRIMA
\n=>ORACLE_HOME will be: \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1
\n------------------------------------------------------------------------------
\nEnter the primary server name.
\nNote: The hostname is case sensitive on UNIX based systems.
\n=>SOURCE is [dbvisit1]:
\nYour input: dbvisit1
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is dbvisit1
\n------------------------------------------------------------------------------
\nPlease enter a filesystem directory that Dbvisit Standby use to store (archive) log files. This directory
\nis not the same as the database recovery area or archive destinations and should not be located in these
\nareas.
\n....
\nPlease ensure that this directory exists on
\n=>ARCHSOURCE is [\/u01\/app\/oracle\/dbvisit_arch\/DBPRIMA]: \/u01\/app\/archivedbvisit\/DBPRIMA
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is \/u01\/app\/archivedbvisit\/DBPRIMA
\n------------------------------------------------------------------------------
\nDo you want to use SSH to connect to the standby server? Note that if you are using SSH, passwordless SSH
\nauthentication between the hosts must already be configured. By default Dbvnet will be used.
\n=>USE_SSH is [N]:
\nYour input: N
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is N
\n------------------------------------------------------------------------------
\nEnter the standby database hostname.
\nIf the standby database will be Oracle RAC enabled:
\nEnter the the Virtual Hostname (linked to a Virtual IP) for standby database. This virtual hostname is
\n....
\nFor non-RAC configurations specify the standby database server name here.
\n=>DESTINATION is []: dbvisit2
\nYour input: dbvisit2
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is dbvisit2
\n------------------------------------------------------------------------------
\nSpecify the DBVNET or SSH port number on the standby server. The default value supplied is the dbvnet port
\n7890. If you specified the use of SSH, please specify the SSH port here.
\n=>NETPORT is [7890]:
\nYour input: 7890
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is 7890
\n------------------------------------------------------------------------------
\nEnter Dbvisit Standby installation directory on the standby server
\n=>DBVISIT_BASE_DR is [\/u01\/app\/dbvisit]:
\nYour input: \/u01\/app\/dbvisit
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is \/u01\/app\/dbvisit
\n------------------------------------------------------------------------------
\nEnter ORACLE_HOME directory on the standby server
\n=>ORACLE_HOME_DR is [\/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1]:
\nYour input: \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1
\n------------------------------------------------------------------------------
\nEnter DB_UNIQUE_NAME on the standby server
\n=>DB_UNIQUE_NAME_DR is [DBPRIMA]:
\nYour input: DBPRIMA
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is DBPRIMA
\n------------------------------------------------------------------------------
\nPlease enter the directory where Dbvisit Standby will transfer the (archive) log files to on standby
\nserver.
\n...
\nPlease ensure that this directory exists on the standby server
\n=>ARCHDEST is [\/u01\/app\/archivedbvisit\/DBPRIMA]:
\nYour input: \/u01\/app\/archivedbvisit\/DBPRIMA
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is \/u01\/app\/archivedbvisit\/DBPRIMA
\n------------------------------------------------------------------------------
\nEnter ORACLE_SID on the standby server
\n=>ORACLE_SID_DR is [DBPRIMA]:
\nYour input: DBPRIMA
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is DBPRIMA
\n------------------------------------------------------------------------------
\nEnter ASM instance name on the standby server, if your standby is using ASM. If you are not using ASM on
\nthe standby leave the value blank.
\n=>ORACLE_SID_ASM_DR is []:
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is null
\n------------------------------------------------------------------------------
\nPlease specify the name of the Dbvisit Database configuration (DDC) file.
\nThe DDC file is a plain text file that contains all the Dbvisit Standby settings.
\n=>ENV_FILE is [DBPRIMA]:
\nYour input: DBPRIMA
\nIs this correct? <Yes\/No> [Yes]:
\nChoice is DBPRIMA
\n------------------------------------------------------------------------------
\nBelow are the list of configuration variables provided during the setup process:
\nConfiguration Variable Value Provided
\n====================== ==============
\nORACLE_SID DBPRIMA
\nORACLE_HOME \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1
\nSOURCE dbvisit1
\nARCHSOURCE \/u01\/app\/archivedbvisit\/DBPRIMA
\nRAC_DR N
\nUSE_SSH N
\nDESTINATION dbvisit2
\nNETPORT 7890
\nDBVISIT_BASE_DR \/u01\/app\/dbvisit
\nORACLE_HOME_DR \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1
\nDB_UNIQUE_NAME_DR DBPRIMA
\nARCHDEST \/u01\/app\/archivedbvisit\/DBPRIMA
\nORACLE_SID_DR DBPRIMA
\nENV_FILE DBPRIMA
\nAre these variables correct? <Yes\/No> [Yes]:
\n>>> Dbvisit Database configuration (DDC) file DBPRIMA created.
\n>>> Dbvisit Database repository (DDR) DBPRIMA created.
\nRepository Version 8.0
\nSoftware Version 8.0
\nRepository Status VALID
\nPID:2330
\nTRACE:dbvisit_install.log
\n[oracle@dbvisit1 ~]$
\n<\/code>
\nThe DDC file we created will be used to create the standby database. But before we must enter the license key, otherwise we will have an error.Following command is used dbvctl -d DDC -l License_Key <\/span>
\n
\n[oracle@dbvisit1 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA -l 4jo6z-8aaai-u09b6-ijjq5-m1u6k-1uwpp-cmjfq
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 3835)
\ndbvctl started on dbvisit1: Tue Nov 29 14:12:08 2016
\n=============================================================
\n=>Update with license key: 4jo6z-8aaai-u09b6-ijjq5-m1u6k-1uwpp-cmjfq? <Yes\/No> [Yes]:
\n>>> Dbvisit Standby License
\nLicense Key : 4jo6z-8aaai-u09b6-ijjq5-m1u6k-1uwpp-cmjfq
\ncustomer_number : 1
\ndbname :
\nexpiry_date : 2016-12-29
\nproduct_id : 8
\nsequence : 1
\nstatus : VALID
\nupdated : YES
\n=============================================================
\ndbvctl ended on dbvisit1: Tue Nov 29 14:12:17 2016
\n=============================================================
\n[oracle@dbvisit1 ~]$
\n<\/code><\/p>\n

And then we can proceed with the standby database creation using the command dbvctl -d DDC –csd <\/span>
\n
\n[oracle@dbvisit1 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA --csd
\n>>> Running pre-checks please wait... done
\nWhat would you like to do:
\n1 - Create standby database (and optionally save settings in template)
\n2 - Help
\n3 - Terminate processing
\nPlease enter your choice [1]: 1
\n-------------------------------------------------------------------------------
\nAnswer Yes to transfer the datafiles directly to the standby server (not
\nrecommended for large database or slow networks)
\nNote tablespaces will be placed in backup mode for direct copy.
\nAnswer No (recommended) to create an RMAN backup of primary datafiles in a
\ntemporary location and transfer the backup to the standby server
\n=>Do you want to copy database files directly to the standby server? [N]: y
\nYour input: Y
\nIs this correct? <Yes\/No> [Yes]: yes
\nThe following oracle database parameters will be set in the standby database pfile or spfile:
\n-------------------------------------------------------------------------------
\nSID NAME VALUE
\n* audit_file_dest \/u01\/app\/oracle\/admin\/DBPRIMA\/adump
\n* compatible 12.1.0.2.0
\n* control_files \/u01\/app\/oracle\/oradata\/DBPRIMA\/control01.ctl,\/u01\/app\/oracle\/fast_recovery_area\/DBPRIMA\/control02.ctl
\n* db_block_size 8192
\n* db_domain
\n* db_name DBPRIMA
\n* db_recovery_file_dest \/u01\/app\/oracle\/fast_recovery_area
\n* db_recovery_file_dest_size 10485760000
\n* db_unique_name DBPRIMA
\n* diagnostic_dest \/u01\/app\/oracle
\n* dispatchers (PROTOCOL=TCP) (SERVICE=DBPRIMAXDB)
\n* log_archive_format %t_%s_%r.dbf
\n* open_cursors 300
\n* pga_aggregate_target 304087040
\n* processes 300
\n* remote_login_passwordfile EXCLUSIVE
\n* sga_target 912261120
\n* spfile OS default
\n* undo_tablespace UNDOTBS1
\n-------------------------------------------------------------------------------
\nWhat would you like to do:
\n1 - Proceed with creating the standby database
\n2 - Edit oracle database parameters for the standby database pfile\/spfile
\n3 - Terminate processing
\nPlease enter your choice [1]: 1
\n......
\n=>Create standby database template for DBPRIMA using provided answers? [Y]:
\nYour input: 1
\nIs this correct? <Yes\/No> [Yes]:
\n-------------------------------------------------------------------------------
\n=>Continue with creating a standby database? (If No processing will terminate,
\nthe saved template will be available for future use) [Y]:
\nIs this correct? <Yes\/No> [Yes]:
\n>>> dbvctl will now run a pre-flight check for standby database creation. An attempt will
\nbe made to create a standby (s)pfile using oracle standby database parameters, followed
\nby trying to start the standby instance. If this step fails, then please double-check
\nthe following items before re-running dbvctl again:
\n1) Review the standby database parameters you have supplied and provide valid values
\nunless a template is used.
\n2) Recreate the template to provide valid values for standby database parameters if a
\ntemplate is used.
\n>>> Running pre-flight check for standby creation, please wait... done
\n>>> Total database size for DBPRIMA is 1.57GB
\n>>> Creating standby control file... done
\n>>> Transferring datafiles from dbvisit1 to dbvisit2...
\nTransferring \/u01\/app\/oracle\/oradata\/DBPRIMA\/system01.dbf...
\nTransferring \/u01\/app\/oracle\/oradata\/DBPRIMA\/sysaux01.dbf... done
\nTransferring \/u01\/app\/oracle\/oradata\/DBPRIMA\/undotbs01.dbf... done
\nTransferring \/u01\/app\/oracle\/oradata\/DBPRIMA\/users01.dbf... done
\n>>> Restoring standby control files... done
\n>>> Starting standby database DBPRIMA on dbvisit2 mount... done
\n>>> Restoring datafiles on dbvisit2...
\n>>> Renaming standby redo logs and tempfiles on dbvisit2... done
\n>>> Performing checkpoint and archiving logs... done
\n>>> Finishing standby database creation... done
\n>>> Standby database created.
\nTo complete creating standby database please run dbvctl on the primary server first,
\nthen on the standby server, to ensure the standby database is in sync with the primary
\ndatabase.
\nPID:3915
\nTRACE:3915_dbvctl_csd_DBPRIMA_201611291413.trc
\n<\/code>
\nLet\u2019s now run dbvctl -d DDC <\/span> on the primary server to send all archived logs and on the standby server to apply all archived logs.
\n
\n[oracle@dbvisit1 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 4354)
\ndbvctl started on dbvisit1: Tue Nov 29 14:24:11 2016
\n=============================================================
\n>>> Obtaining information from standby database (RUN_INSPECT=Y)... done
\n>>> Sending heartbeat message... skipped
\nPerforming a log switch...
\n>>> Transferring Log file(s) from DBPRIMA on dbvisit1 to dbvisit2 for thread 1:
\nthread 1 sequence 29 (o1_mf_1_29_d3v083x6_.arc)
\n=============================================================
\ndbvctl ended on dbvisit1: Tue Nov 29 14:24:16 2016
\n=============================================================
\n[oracle@dbvisit1 ~]$
\n<\/code>
\n
\n[oracle@dbvisit2 DBPRIMA]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 8665)
\ndbvctl started on dbvisit2: Tue Nov 29 14:25:07 2016
\n=============================================================
\n>>> Sending heartbeat message... skipped
\n>>> Applying Log file(s) from dbvisit1 to DBPRIMA on dbvisit2:
\nthread 1 sequence 29 (1_29_926978008.arc)
\n=============================================================
\ndbvctl ended on dbvisit2: Tue Nov 29 14:25:09 2016
\n=============================================================
\n[oracle@dbvisit2 DBPRIMA]$
\n<\/code>
\nWe can check the sync status with dbvctl -d DDC -i <\/span>
\n
\n[oracle@dbvisit1 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA -i
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 4420)
\ndbvctl started on dbvisit1: Tue Nov 29 14:26:11 2016
\n=============================================================
\nDbvisit Standby log gap report for DBPRIMA thread 1 at 201611291426:
\n-------------------------------------------------------------
\nDestination database on dbvisit2 is at sequence: 29.
\nSource database on dbvisit1 is at log sequence: 30.
\nSource database on dbvisit1 is at archived log sequence: 29.
\nDbvisit Standby last transfer log sequence: 29.
\nDbvisit Standby last transfer at: 2016-11-29 14:24:16.
\nArchive log gap for DBPRIMA: 0.
\nTransfer log gap for DBPRIMA: 0.
\nStandby database time lag (DAYS-HH:MI:SS): +0:01:37.
\n=============================================================
\ndbvctl ended on dbvisit1: Tue Nov 29 14:26:12 2016
\n=============================================================
\n[oracle@dbvisit1 ~]$
\n<\/code><\/p>\n

Now it\u2019s time to import our configuration in our graphical console. For this let\u2019s use MANAGE HOSTS
\n\"hosts\"<\/a><\/p>\n

And then add hosts using the option NEW
\n\"hosts2\"<\/a><\/p>\n

Fill info and click on CREATE NEW HOST
\n\"hosts3\"<\/a>
\nAfter we add all hosts
\n\"hosts4\"<\/a><\/p>\n

We can now import our standby configuration using the MANAGE CONFIGURATIONS tab.
\n\"config1\"<\/a><\/p>\n

Using IMPORT
\n\"config2\"<\/a>
\n\"config3\"<\/a><\/p>\n

Now we can manage our configuration either by command line using dbvctl or by using the graphical console. In a next blog we will talk about how to do a SWITCHOVER and a FAILOVER<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw The new version of Dbvisit standby is now released. In this blog we are going to see how to install dbvisit 8 and how to create a standby database. For the installation after downloading the software, just uncompress it and then run the install-dbvisit command under the installer directory. The installation process […]<\/p>\n","protected":false},"author":27,"featured_media":9443,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[998],"type_dbi":[],"class_list":["post-9433","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-dbvisit-standby-version-8"],"acf":[],"yoast_head":"\nCreating standby database with Dbvisit 8 - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating standby database with Dbvisit 8\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw The new version of Dbvisit standby is now released. In this blog we are going to see how to install dbvisit 8 and how to create a standby database. For the installation after downloading the software, just uncompress it and then run the install-dbvisit command under the installer directory. The installation process […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-30T17:13:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-08T14:13:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1175\" \/>\n\t<meta property=\"og:image:height\" content=\"571\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Creating standby database with Dbvisit 8\",\"datePublished\":\"2016-11-30T17:13:47+00:00\",\"dateModified\":\"2023-06-08T14:13:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/\"},\"wordCount\":533,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png\",\"keywords\":[\"Dbvisit Standby Version 8\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/\",\"name\":\"Creating standby database with Dbvisit 8 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png\",\"datePublished\":\"2016-11-30T17:13:47+00:00\",\"dateModified\":\"2023-06-08T14:13:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png\",\"width\":1175,\"height\":571},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating standby database with Dbvisit 8\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Creating standby database with Dbvisit 8 - dbi Blog","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:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/","og_locale":"en_US","og_type":"article","og_title":"Creating standby database with Dbvisit 8","og_description":"By Mouhamadou Diaw The new version of Dbvisit standby is now released. In this blog we are going to see how to install dbvisit 8 and how to create a standby database. For the installation after downloading the software, just uncompress it and then run the install-dbvisit command under the installer directory. The installation process […]","og_url":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/","og_site_name":"dbi Blog","article_published_time":"2016-11-30T17:13:47+00:00","article_modified_time":"2023-06-08T14:13:46+00:00","og_image":[{"width":1175,"height":571,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Creating standby database with Dbvisit 8","datePublished":"2016-11-30T17:13:47+00:00","dateModified":"2023-06-08T14:13:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/"},"wordCount":533,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png","keywords":["Dbvisit Standby Version 8"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/","url":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/","name":"Creating standby database with Dbvisit 8 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png","datePublished":"2016-11-30T17:13:47+00:00","dateModified":"2023-06-08T14:13:46+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbvserverconsole1-1.png","width":1175,"height":571},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/creating-standby-database-with-dbvisit-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating standby database with Dbvisit 8"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9433"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9433\/revisions"}],"predecessor-version":[{"id":25684,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9433\/revisions\/25684"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9443"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9433"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}