Dbvisit 8 - Create Standby DB
===
###### tags: `DBVISIT`,`ORACLE`, `STANDBY`


## <font color="#0000dd">一. DBVISIT 軟體安裝 (primary & standby)</font><br />
### **1. 解壓縮 dbvisit_standby8.0.24_linux.zip <font color="#dd0000">(primary & standby)</font><br />**
> [oracle@hisdb kvm_tmp_vol]$ ls -lrts
> total 76532
> -rw-r--r-- 1 oracle oinstall 74562519 Feb 21 15:38 dbvisit-standby8.0.24-linux.zip
> drwx------ 2 root root 65536 Feb 24 01:50 lost+found
> drwxr-xr-x 2 root root 20480 Mar 13 14:43 initiallog
>
> [oracle@hisdb kvm_tmp_vol]$ unzip dbvisit-standby8.0.24-linux.zip
> Archive: dbvisit
> standby8.0.24 linux.zip
> inflating: dbvisit standby8.0.24 linux.tar

### **2. 解壓縮 dbvisit-standby8.0.24-linux.tar <font color="#dd0000">(primary & standby)</font><br />**
> [oracle@hisdb kvm_tmp_vol]$ tar -vxof dbvisit-standby8.0.24-linux.tar
> [oracle@hisdb kvm_tmp_vol]$ cd dbvisit/installer/
> [oracle@hisdb installer]$ chmod u+x install dbvisit
> [oracle@hisdb installer]$ ls
> total 2856
> rwxr xr x 1 oracle oinstall 2835536 Oct 11 12:20 install-dbvisit

### **3. 開始安裝 Dbvisit 軟體 <font color="#dd0000">(primary & standby)</font><br />**
> [oracle@hisdb installer]$ ./install-dbvisit
>
> ------------------------------------------
> Welcome to the Dbvisit software installer.
> ------------------------------------------
> It is recommended to make a backup of our current Dbvisit software
> location (Dbvisit Base loca tion) for rollback purposes.
>
> Installer Directory /kvm_repos/kvm_tmp_vol/dbvisit
>
> >>>Please specify the Dbvisit
> installation directory (Dbvisit Base).
> The various Dbvisit products and components such as Dbvisit Standby,
> Dbvisit Dbvnet will be installed in the appropriate subdirectories of
> this path.
>
> Enter a custom value or press ENTER to accept default [/usr/dbvisit]:

### **4. 啟動 Dbvagent <font color="#dd0000">(primary & standby)</font><br />**
> [oracle@hisdb dbvagent]$ ls lrt
> total 5568
> drwxr-x--- 2 oracle oinstall 4096 Mar 13 15:53 tmp
> drwxr-x--- 2 oracle oinstall 4096 Mar 13 15:53 log
> drwxr-x--- 2 oracle oinstall 4096 Mar 13 15:53 doc
> -rwxr-xr-x 1 oracle oinstall 5672960 Mar 13 15:53 dbvagent
> drwxr-x--- 2 oracle oinstall 4096 Mar 13 15:53 conf
> [oracle@hisdb dbvagent]$ pwd
> /usr/dbvisit/dbvagent
> [oracle@hisdb dbvagent]$ ./dbvagent -d start
> Dbvagent daemon started.
> [oracle@hisdb dbvagent]$ ps -ef |grep dbv
> oracle 9607 1 0 15:57 ? 00:00:00 ./dbvagent d start
> oracle 10670 36754 0 15:57 pts/3 00:00:00 grep dbv
### **5. 啟動 Dbvnet <font color="#dd0000">(primary & standby)</font><br />**
> [oracle@hisdb dbvnet]$ ./dbvnet -d start
> Dbvnet daemon started.
### **6. 測試連線 <font color="#dd0000">(primary & standby)</font><br />**
> [oracle@hisdb ~]$ cd /usr/dbvisit/standby/
> [oracle@hisdb standby]$ ./dbvctl -f system_readiness
> Please supply the following information to complete the test.
> Default values are in [].
> Enter Dbvisit Standby location on local server: [/usr/dbvisit]:
> Your input: /usr/dbvisit
> Is this correct? <Yes/No> [Yes]:
> Enter the name of the remote server: []: emrdb
> Your input: emrdb
> Is this correct? <Yes/No> [Yes]:
> Enter Dbvisit Standby location on remote server: [/usr/dbvisit]:
> Your input: /usr/dbvisit
> Is this correct? <Yes/No> [Yes]:
> Enter the name of a file to transfer relative to local install directory
> /usr/dbvisit: [standby/doc/README.txt]:
> Your input: standby/doc/README.txt
> Is this correct? <Yes/No> [Yes]:
> Choose copy method:
> 1) /usr/dbvisit/dbvnet/dbvnet
> 2) /usr/bin/scp
> Please enter choice [1] :
> Is this correct? <Yes/No> [Yes]:
> Enter port for metho
> d /usr/dbvisit/dbvnet/dbvnet: [7890]:
> Your input: 7890
> Is this correct? <Yes/No> [Yes]:
> ----------------------------------------------------------------------------
> Testing the network connection between local server and remote server emrdb.
> ----------------------------------------------------------------------------
> Settings
> ========
> Remote server =emrdb
> Dbvisit Standby location on local server =/usr/dbvisit
> Dbvisit Standby location on remote server =/usr/dbvisit
> Test file to copy file to copy =/usr/dbvisit/standby/doc/README.txt=/usr/dbvisit/standby/doc/README.txt
> Transfer method =/usr/dbvisit/dbvnet/dbvnet=/usr/dbvisit/dbvnet/dbvnet
> port =7890
> ---------------------------------------------------------------------
> Checking network connection by copying file to remote server emrdb...
> ---------------------------------------------------------------------
> Trace file /usr/dbvisit/standby/trace/3474_dbvctl_f_system_readiness_201903221156.trc/usr/dbvisit/standby/trace/3474_dbvctl_f_system_readiness_201903221156.trc
> File copied successfully. Network connection between local and emrdb correctly configured.
## <font color="#0000dd">二.安裝 DBVSERVER (Central Console)</font><br />
### **1. 設定使用者以服務方式登入**
### **2. 點選安裝 Dbvisit**

### **3. 點選下一步開始安裝精靈**
### **4. 點選我同意授權**
### **5. 選擇欲安裝 components**
### **6. 選填安裝路徑**
### **7. 選擇 owner**
### **8. 填入作業系統密碼**
### **9. 開啟 dbvserver 服務**
### **10. 開啟 Central Console GUI (192.168.1.99:4433)**

## <font color="#0000dd">三.設定 DBVISIT Standby</font><br />
### **1. 建立 primary host 資訊**
### **2. 建立 standby host 資訊**
### **3. host 資訊建立完成**
### **4. 點選編輯 DDC file**
### **5. 點選新建立**
### **6. 填入資訊與 license key**
### **7. 點選建立 standby DB**
### **8. 建立完成**
### **9. 點選 DATABASE ACTIONS**
### **10. 點選測試 gap report ,send log ,apply log**
### **11. 測試成功**