We're here to help!

Running standby on same host as primary (Testing/Education purpose only) - Standby version 8

Follow
Description

Having the primary and standby on the same host is not recommended for production. This article is provided for testing or training/educational purposes only. When running Dbvisit Standby in a production environment is is required that the primary and standby be located on different servers.

Steps Performed

Below are some steps that can assist in running Dbvisit Standby version 8 (latest version recommended), with the primary and standby databases on the same server. This is for educational/testing purpose only and not recommended for production.

Prerequisite: you should have already Oracle RDBMS installation in place with one instance running. In this example SID: DBVFOUR. 

1) Configure virtual adapters to host 2 databases

In order to be able to use dbvnet & dbvserver on sigle host you have to create virtual adapters on existing physical interface for each dbvisit base.

[root@czlin0104 ~]# ifconfig enp0s8:1 192.168.4.110
[root@czlin0104 ~]# ifconfig enp0s8:2 192.168.4.111

status will show (physical host IP: 192.168.4.104):

$ ifconfig -a

enp0s8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.4.104 netmask 255.255.0.0 broadcast 192.168.255.255
inet6 fe80::a00:27ff:fecf:3e7c prefixlen 64 scopeid 0x20<link>
ether 08:00:27:cf:3e:7c txqueuelen 1000 (Ethernet)
RX packets 60409 bytes 51471018 (49.0 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 15843 bytes 2609230 (2.4 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

enp0s8:1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.4.110 netmask 255.255.255.0 broadcast 192.168.4.255
ether 08:00:27:cf:3e:7c txqueuelen 1000 (Ethernet)

enp0s8:2: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.4.111 netmask 255.255.255.0 broadcast 192.168.4.255
ether 08:00:27:cf:3e:7c txqueuelen 1000 (Ethernet)

2) Configure /etc/hosts

$ vi /etc/hosts

File should contain entries for physical host + 2 virtual hosts

192.168.4.104 czlin0104
192.168.4.110 czlin0110
192.168.4.111 czlin0111

3) Configure listener.ora and tnsnames.ora in $ORACLE_HOME/network/admin and /etc/oratab

This step is optional. Each database will have its listener to be as close as possible to real environment.

listener.ora:

DBVFOUR=
(ADDRESS=(PROTOCOL=TCP)(HOST=czlin0110)(PORT=1521)) DBVFIVE=
(ADDRESS=(PROTOCOL=TCP)(HOST=czlin0110)(PORT=1521))

tnsnames.ora:

LISTENER_DBVFOUR=
(ADDRESS=(PROTOCOL=TCP)(HOST=czlin0110)(PORT=1521)) LISTENER_DBVSIX=
(ADDRESS=(PROTOCOL=TCP)(HOST=czlin0111(PORT=1521))
DBVFOUR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = czlin0110)(Port = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBVFOUR)
)
) DBVSIX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = czlin0111)(Port = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBVSIX)
)
)

oratab:

DBVFOUR:/u01/app/oracle/product/12.2.0.1/dbhome_1:N
DBVSIX:/u01/app/oracle/product/12.2.0.1/dbhome_1:N

4) Create directories for dbvisit installations

$ mkdir /usr/dbvisit_8.0.16_1 /usr/dbvisit_8.0.16_2
$ chown oracle:oinstall /usr/dbvisit* $ mkdir -p /u01/app/dbvisit_archdest/DBVFOUR /u01/app/dbvisit_archdest/DBVSIX

5) Configure user environment

Optional step. Add following to ~/.bash_profile:

echo
export ORAENV_ASK=NO if [ ! -z "$ORACLE_SID" ] then
. oraenv
else
export ORACLE_SID=DBVFOUR
. oraenv
fi unset ORAENV_ASK
export PATH=~:$PATH
export ORACLE_SID
echo ORACLE_SID is set to $ORACLE_SID
echo
umask 022
$ vi ~/4
export ORACLE_SID=DBFOUR
. ~/.bash_profile
$ vi ~/6
export ORACLE_SID=DBVSIX
. ~/.bash_profile

Now you can switch easily between primary (DBVFOUR) and standby (DBVSIX) instances by running . 4 or . 6 in cmd line

6) Unzip dbvisit installation file and run installer in silent mode for /usr/dbvisit_8.0.16_1

Run the dbvisit installer:

tar -xzf dbvisit-standby8.0.16-el7.zip
cd ~/dbvisit/installer
./install-dbvisit --batch-install --dbvisit-base /usr/dbvisit_8.0.16_1 --components core \
--dbvnet-passphrase 123 --dbvagent-passphrase 123 \
--dbvnet-local-host czlin0110 \
--dbvagent-local-host czlin0110

7) Unzip dbvisit installation file and run installer in silent mode for /usr/dbvisit_8.0.16_2

Run the dbvisit installer. 

cd ~/dbvisit/installer
./install-dbvisit --batch-install --dbvisit-base /usr/dbvisit_8.0.16_2 --components all \
--dbvnet-passphrase 123 --dbvagent-passphrase 123 \
--dbvnet-local-host czlin0111 \
--dbvagent-local-host czlin0111

8) start core components from both dbvisit bases dbvisit_8.0.16_1 and dbvisit_8.0.16_2

cd /usr/8.0.16_1/dbvnet
./dbvnet -d start -i &
cd /usr/8.0.16_2/dbvnet
./dbvnet -d start -i &
cd /usr/8.0.16_1/dbvagent
./dbvagent -d start -i &
cd /usr/8.0.16_2/dbvagent
./dbvagent -d start -i &

NOTE: there is no way how to gracefully stop those processes and to stop them kill -9 command has to be used.

9) Startup dbvserver from 8.0.16_2

 

Optional step.

cd /usr/8.0.16_2/dbvserver
./dbvserver -d start

10) Create DDC file

Now we are ready to run the setupand create DDC file. Do this from /usr/dbvisit_8.0.16_1 base.

oracle@czlin0104 /usr/dbvisit_8.0.16_1/standby $ ./dbvctl -o setup

=========================================================
Dbvisit Standby Database Technology (8.0.16)
http://www.dbvisit.com
=========================================================

=>dbvctl only needs to be run on the primary server.

Is this the primary server? <Yes/No> [Yes]:
The following Dbvisit Database configuration (DDC) file(s) found on this
server:

DDC
===
1) Create New DDC
2) Cancel

Please enter choice [] : 1

Is this correct? <Yes/No> [Yes]:

...

Continue ? <Yes/No> [No]: y

=========================================================
Dbvisit Standby setup begins.
=========================================================
The following Oracle instance(s) have been found on this server:

SID ORACLE_HOME
=== ===========
1) DBVFOUR /u01/app/oracle/product/12.2.0.1/dbhome_1
2) Enter own ORACLE_SID and ORACLE_HOME
Please enter choice [] :
Please enter choice [] : 1

Is this correct? <Yes/No> [Yes]:
=>ORACLE_SID will be: DBVFOUR
=>ORACLE_HOME will be: /u01/app/oracle/product/12.2.0.1/dbhome_1

------------------------------------------------------------------------------
Enter the primary server name.
Note: The hostname is case sensitive on UNIX based systems.
=>SOURCE is [czlin0104]: czlin0110
Your input: czlin0110

Is this correct? <Yes/No> [Yes]:
Choice is czlin0110

------------------------------------------------------------------------------
Please enter a filesystem directory that Dbvisit Standby use to store (archive) log files. This directory is not the same as the database recovery area or archive destinations and should not be located in
these areas.
The ARCHSOURCE directory is located on the primary server and will become the ARCHDEST location when the primary database is converted to a standby database during a Graceful Switchover operation.
This directory will ONLY contain (archive) log files related to this database. It should not contain any other (non archive log) files.
Please ensure that this directory exists on

=>ARCHSOURCE is [/u01/app/oracle/dbvisit_arch/DBVFOUR]: /u01/app/oracle/dbvisit_arch/DBVFOUR
Your input: /u01/app/oracle/dbvisit_arch/DBVFOUR

Is this correct? <Yes/No> [Yes]:
Choice is /u01/app/oracle/dbvisit_arch/DBVFOUR

------------------------------------------------------------------------------
Do you want to use SSH to connect to the standby server? Note that if you are using SSH, passwordless SSH authentication between the hosts must already be configured. By default Dbvnet will be used.
=>USE_SSH is [N]:
Your input: N

Is this correct? <Yes/No> [Yes]:
Choice is N

------------------------------------------------------------------------------
Enter the standby database hostname.

If the standby database will be Oracle RAC enabled:
Enter the the Virtual Hostname (linked to a Virtual IP) for standby database. This virtual hostname is attached to a VIP that will be able to move between the RAC nodes. Dbvisit Standby will only run on the
server where this virtual hostname (VIP) resource is running.
The Virtual Hostname (and VIP) should be configured as a resouce in clusterware and must be enabled and started on one of the nodes before yo continue with the setup. If you are not using a Virtual Hostname
(Highly Recommended), Dbvisit Standby can only be configured to run on one dedicated node in the RAC configuration - specify the hosts name here if you do not have a Virtual Hostname (attached to VIP) for
the cluster configured.
For non-RAC configurations specify the standby database server name here.

=>DESTINATION is []: czlin0111
Your input: czlin0111

Is this correct? <Yes/No> [Yes]:
Choice is czlin0111

------------------------------------------------------------------------------
Specify the DBVNET or SSH port number on the standby server. The default value supplied is the dbvnet port 7890. If you specified the use of SSH, please specify the SSH port here.
=>NETPORT is [7890]:
Your input: 7890

Is this correct? <Yes/No> [Yes]:
Choice is 7890

------------------------------------------------------------------------------
Enter Dbvisit Standby installation directory on the standby server
=>DBVISIT_BASE_DR is [/usr/dbvisit_8.0.16_1]: /usr/dbvisit_8.0.16_2
Your input: /usr/dbvisit_8.0.16_2

Is this correct? <Yes/No> [Yes]:
Choice is /usr/dbvisit_8.0.16_2

------------------------------------------------------------------------------
Enter ORACLE_HOME directory on the standby server
=>ORACLE_HOME_DR is [/u01/app/oracle/product/12.2.0.1/dbhome_1]:
Your input: /u01/app/oracle/product/12.2.0.1/dbhome_1

Is this correct? <Yes/No> [Yes]:
Choice is /u01/app/oracle/product/12.2.0.1/dbhome_1

------------------------------------------------------------------------------
Enter DB_UNIQUE_NAME on the standby server
=>DB_UNIQUE_NAME_DR is [DBVFOUR]: DBVSIX
Your input: DBVSIX

Is this correct? <Yes/No> [Yes]:
Choice is DBVSIX

------------------------------------------------------------------------------
Please enter the directory where Dbvisit Standby will transfer the (archive) log files to on standby server. This directory is not the same as the database recovery area or archive destinations and should
not be located in these areas.
This directory should ONLY contain (archive) log files related to this database. It should not contain any other (non archive log) files.
Please ensure that this directory exists on the standby server

=>ARCHDEST is [/u01/app/oracle/dbvisit_arch/DBVFOUR]: /u01/app/oracle/dbvisit_arch/DBVSIX
Your input: /u01/app/oracle/dbvisit_arch/DBVSIX

Is this correct? <Yes/No> [Yes]:
Choice is /u01/app/oracle/dbvisit_arch/DBVSIX

------------------------------------------------------------------------------
Enter ORACLE_SID on the standby server
=>ORACLE_SID_DR is [DBVFOUR]: DBVSIX
Your input: DBVSIX

Is this correct? <Yes/No> [Yes]:
Choice is DBVSIX

------------------------------------------------------------------------------
Enter ASM instance name on the standby server, if your standby is using ASM. If you are not using ASM on the standby leave the value blank.
=>ORACLE_SID_ASM_DR is []:

Is this correct? <Yes/No> [Yes]:
Choice is null

------------------------------------------------------------------------------
Please specify the name of the Dbvisit Database configuration (DDC) file.
The DDC file is a plain text file that contains all the Dbvisit Standby settings.
=>ENV_FILE is [DBVFOUR]: DBVFOUR
Your input: DBVFOUR

Is this correct? <Yes/No> [Yes]:
Choice is DBVFOUR

------------------------------------------------------------------------------


Below are the list of configuration variables provided during the setup process:

Configuration Variable Value Provided
====================== ==============
ORACLE_SID DBVFOUR
ORACLE_HOME /u01/app/oracle/product/12.2.0.1/dbhome_1

SOURCE czlin0110
ARCHSOURCE /u01/app/oracle/dbvisit_arch/DBVFOUR
RAC_DR N
USE_SSH N
DESTINATION czlin0111
NETPORT 7890
DBVISIT_BASE_DR /usr/dbvisit_8.0.16_2
ORACLE_HOME_DR /u01/app/oracle/product/12.2.0.1/dbhome_1
DB_UNIQUE_NAME_DR DBVSIX
ARCHDEST /u01/app/oracle/dbvisit_arch/DBVSIX
ORACLE_SID_DR DBVSIX
ENV_FILE DBVFOUR

Are these variables correct? <Yes/No> [Yes]:

>>> Dbvisit Database configuration (DDC) file DBVFOUR created.

>>> Dbvisit Database repository (DDR) DBVFOUR created.
Repository Version 8.3
Software Version 8.3
Repository Status VALID


Do you want to enter license key for the newly created Dbvisit Database configuration (DDC) file? <Yes/No> [Yes]:

Enter license key and press Enter: []: 4jo6z-8aaai-u09b6-ijjnn-owozp-1h6dj-0kwef
>>> Dbvisit Standby License
License Key : 4jo6z-8aaai-u09b6-ijjnn-owozp-1h6dj-0kwef
customer_number : 1
dbname :
expiry_date : 2017-10-12
product_id : 8
sequence : 1
status : VALID
updated : YES

PID:12918
TRACE:dbvisit_install.log

12) Create custom files for hostnames and modify DDC file to use them

echo -e '#!/bin/bash 
echo czlin0110' > /usr/dbvisit_8.0.16_1/standby/host_czlin0110.sh \
chmod +x /usr/dbvisit_8.0.16_1/standby/host_czlin0110.sh

echo -e '#!/bin/bash
echo czlin0111' > /usr/dbvisit_8.0.16_2/standby/host_czlin0110.sh \
chmod +x /usr/dbvisit_8.0.16_2/standby/host_czlin0110.sh

vi /usr/dbvisit_8.0.16_1/standby/conf/dbv_DBVFOUR.env
HOSTNAME_CMD = host_czlin0110.sh

 

13) Create standby database

Create standby database as follows. Note, that you will need to use different temporary location (in this example /usr/tmp and /tmp) and you will have to edit / create few parameters. Make sure, that OMF is not used

oracle@czlin0104 /usr/dbvisit_8.0.16_1/standby $ ./dbvctl -d DBVFOUR --csd

>>> Running pre-checks please wait... done
What would you like to do:
1 - Create standby database (and optionally save settings in template)
2 - Restart the uncompleted creation of standby database
3 - Create standby database using existing template (previously saved)
4 - Help
5 - Terminate processing
Please enter your choice [2]: 1

-------------------------------------------------------------------------------
Answer Yes to transfer the datafiles directly to the standby server (not
recommended for large database or slow networks)
Note tablespaces will be placed in backup mode for direct copy.
Answer No (recommended) to create an RMAN backup of primary datafiles in a
temporary location and transfer the backup to the standby server

=>Do you want to copy database files directly to the standby server? [N]:
Your input: N

Is this correct? <Yes/No> [Yes]:

-------------------------------------------------------------------------------

=>Do you want to use TRANSPORTABLE MEDIA to transfer the database backup to the
standby server? Transportable media is an external device such as a USB drive
that is first plugged into the primary server and then manually transferred to
the standby site and plugged into the standby server to continue the process.
It can be used for large databases or slow networks.
Specifying No means the network will be used to transfer the database backup.
[N]:
Your input: N

Is this correct? <Yes/No> [Yes]:

-------------------------------------------------------------------------------
A temporary location must be specified on czlin0110 where the database will be
backed up to first.
This location must be big enough to hold RMAN backup of the whole database
(1.57GB).

=>Specify the location on this server: [/usr/tmp]:
Your input: /usr/tmp

Is this correct? <Yes/No> [Yes]:

-------------------------------------------------------------------------------
A temporary location must be specified on czlin0111 where the database backup
will be copied to before moving to specified locations.

=>Specify location on remote server: [/usr/tmp]: /tmp
Your input: /tmp

Is this correct? <Yes/No> [Yes]:

-------------------------------------------------------------------------------

=>Do you want to use an existing standby spfile rather than create a new one
from scratch? [N]:
Your input: N

Is this correct? <Yes/No> [Yes]:

The following oracle database parameters will be set in the standby database pfile or spfile:
-------------------------------------------------------------------------------
SID NAME VALUE

* archive_lag_target 0
* audit_file_dest /u01/app/oracle/admin/DBVFOUR/adump
* compatible 12.2.0
* control_files /u01/app/oracle/oradata/DBVFOUR/control01.ctl,/u01/app/oracle/fast_recovery_area/DBVFOUR/control02.ctl
* db_block_size 8192
* db_lost_write_protect TYPICAL
* db_name DBVFOUR
* db_recovery_file_dest /u01/app/oracle/fast_recovery_area
* db_recovery_file_dest_size 8232370176
* db_unique_name DBVSIX
* diagnostic_dest /u01/app/oracle
* dispatchers (PROTOCOL=TCP) (SERVICE=DBVFOURXDB)
* instance_mode READ-WRITE
* log_archive_dest /u01/app/oracle/fast_recovery_area
* log_archive_format %t_%s_%r.dbf
* nls_language AMERICAN
* nls_territory AMERICA
* open_cursors 300
* pga_aggregate_target 387973120
* processes 300
* remote_login_passwordfile EXCLUSIVE
* sga_target 1048576000
* spfile OS default
* undo_tablespace UNDOTBS1

-------------------------------------------------------------------------------
What would you like to do:
1 - Proceed with creating the standby database
2 - Edit oracle database parameters for the standby database pfile/spfile
3 - Terminate processing
Please enter your choice [1]: 2

WARNING: Do NOT use single or double quotes to enclose parameter values!
Separate multiple values with a comma. If a comma is part of a value, escape it
with a backslash.
If a comma is part of a value, escape it with a backslash.

=>Enter full parameter name: []: control_files
Leave blank to create Oracle Managed Control File(s) if creating of OMF files
is enabled
1 - Remove from the standby parameter file
(parameter will be set to default value)
2 - New value in the standby parameter file

=>Please enter your choice: []: 2

=>Enter new value (leave blank to set to null) []: /u01/app/oracle/oradata/DBVSIX/control01.ctl,/u01/app/oracle/fast_recovery_area/DBVSIX/control02.ctl
Validating ... please wait

The following oracle database parameters will be set in the standby database pfile or spfile:
-------------------------------------------------------------------------------
SID NAME VALUE

* archive_lag_target 0
* audit_file_dest /u01/app/oracle/admin/DBVFOUR/adump
* compatible 12.2.0
* control_files /u01/app/oracle/oradata/DBVSIX/control01.ctl,/u01/app/oracle/fast_recovery_area/DBVSIX/control02.ctl
* db_block_size 8192
* db_lost_write_protect TYPICAL
* db_name DBVFOUR
* db_recovery_file_dest /u01/app/oracle/fast_recovery_area
* db_recovery_file_dest_size 8232370176
* db_unique_name DBVSIX
* diagnostic_dest /u01/app/oracle
* dispatchers (PROTOCOL=TCP) (SERVICE=DBVFOURXDB)
* instance_mode READ-WRITE
* log_archive_dest /u01/app/oracle/fast_recovery_area
* log_archive_format %t_%s_%r.dbf
* nls_language AMERICAN
* nls_territory AMERICA
* open_cursors 300
* pga_aggregate_target 387973120
* processes 300
* remote_login_passwordfile EXCLUSIVE
* sga_target 1048576000
* spfile OS default
* undo_tablespace UNDOTBS1

-------------------------------------------------------------------------------
What would you like to do:
1 - Proceed with creating the standby database
2 - Edit oracle database parameters for the standby database pfile/spfile
3 - Terminate processing
Please enter your choice [1]: 2

WARNING: Do NOT use single or double quotes to enclose parameter values!
Separate multiple values with a comma. If a comma is part of a value, escape it
with a backslash.
If a comma is part of a value, escape it with a backslash.

=>Enter full parameter name: []: audit_file_dest
1 - Remove from the standby parameter file
(parameter will be set to default value)
2 - New value in the standby parameter file

=>Please enter your choice: []: 2

=>Enter new value (leave blank to set to null) []: /u01/app/oracle/admin/DBVSIX/adump
Validating ... please wait

The following oracle database parameters will be set in the standby database pfile or spfile:
-------------------------------------------------------------------------------
SID NAME VALUE

* archive_lag_target 0
* audit_file_dest /u01/app/oracle/admin/DBVSIX/adump
* compatible 12.2.0
* control_files /u01/app/oracle/oradata/DBVSIX/control01.ctl,/u01/app/oracle/fast_recovery_area/DBVSIX/control02.ctl
* db_block_size 8192
* db_lost_write_protect TYPICAL
* db_name DBVFOUR
* db_recovery_file_dest /u01/app/oracle/fast_recovery_area
* db_recovery_file_dest_size 8232370176
* db_unique_name DBVSIX
* diagnostic_dest /u01/app/oracle
* dispatchers (PROTOCOL=TCP) (SERVICE=DBVFOURXDB)
* instance_mode READ-WRITE
* log_archive_dest /u01/app/oracle/fast_recovery_area
* log_archive_format %t_%s_%r.dbf
* nls_language AMERICAN
* nls_territory AMERICA
* open_cursors 300
* pga_aggregate_target 387973120
* processes 300
* remote_login_passwordfile EXCLUSIVE
* sga_target 1048576000
* spfile OS default
* undo_tablespace UNDOTBS1

-------------------------------------------------------------------------------
What would you like to do:
1 - Proceed with creating the standby database
2 - Edit oracle database parameters for the standby database pfile/spfile
3 - Terminate processing
Please enter your choice [1]: 2

WARNING: Do NOT use single or double quotes to enclose parameter values!
Separate multiple values with a comma. If a comma is part of a value, escape it
with a backslash.
If a comma is part of a value, escape it with a backslash.

=>Enter full parameter name: []: instance_name

=>Enter new value (leave blank to set to null) []: DBVSIX
Validating ... please wait

The following oracle database parameters will be set in the standby database pfile or spfile:
-------------------------------------------------------------------------------
SID NAME VALUE

* archive_lag_target 0
* audit_file_dest /u01/app/oracle/admin/DBVSIX/adump
* compatible 12.2.0
* control_files /u01/app/oracle/oradata/DBVSIX/control01.ctl,/u01/app/oracle/fast_recovery_area/DBVSIX/control02.ctl
* db_block_size 8192
* db_lost_write_protect TYPICAL
* db_name DBVFOUR
* db_recovery_file_dest /u01/app/oracle/fast_recovery_area
* db_recovery_file_dest_size 8232370176
* db_unique_name DBVSIX
* diagnostic_dest /u01/app/oracle
* dispatchers (PROTOCOL=TCP) (SERVICE=DBVFOURXDB)
* instance_mode READ-WRITE
* instance_name DBVSIX
* log_archive_dest /u01/app/oracle/fast_recovery_area
* log_archive_format %t_%s_%r.dbf
* nls_language AMERICAN
* nls_territory AMERICA
* open_cursors 300
* pga_aggregate_target 387973120
* processes 300
* remote_login_passwordfile EXCLUSIVE
* sga_target 1048576000
* spfile OS default
* undo_tablespace UNDOTBS1

-------------------------------------------------------------------------------
What would you like to do:
1 - Proceed with creating the standby database
2 - Edit oracle database parameters for the standby database pfile/spfile
3 - Terminate processing
Please enter your choice [1]: 2

WARNING: Do NOT use single or double quotes to enclose parameter values!
Separate multiple values with a comma. If a comma is part of a value, escape it
with a backslash.
If a comma is part of a value, escape it with a backslash.

=>Enter full parameter name: []: lock_name_space

=>Enter new value (leave blank to set to null) []: DBVSIX
Validating ... please wait

The following oracle database parameters will be set in the standby database pfile or spfile:
-------------------------------------------------------------------------------
SID NAME VALUE

* archive_lag_target 0
* audit_file_dest /u01/app/oracle/admin/DBVSIX/adump
* compatible 12.2.0
* control_files /u01/app/oracle/oradata/DBVSIX/control01.ctl,/u01/app/oracle/fast_recovery_area/DBVSIX/control02.ctl
* db_block_size 8192
* db_lost_write_protect TYPICAL
* db_name DBVFOUR
* db_recovery_file_dest /u01/app/oracle/fast_recovery_area
* db_recovery_file_dest_size 8232370176
* db_unique_name DBVSIX
* diagnostic_dest /u01/app/oracle
* dispatchers (PROTOCOL=TCP) (SERVICE=DBVFOURXDB)
* instance_mode READ-WRITE
* instance_name DBVSIX
* lock_name_space DBVSIX
* log_archive_dest /u01/app/oracle/fast_recovery_area
* log_archive_format %t_%s_%r.dbf
* nls_language AMERICAN
* nls_territory AMERICA
* open_cursors 300
* pga_aggregate_target 387973120
* processes 300
* remote_login_passwordfile EXCLUSIVE
* sga_target 1048576000
* spfile OS default
* undo_tablespace UNDOTBS1

-------------------------------------------------------------------------------
What would you like to do:
1 - Proceed with creating the standby database
2 - Edit oracle database parameters for the standby database pfile/spfile
3 - Terminate processing
Please enter your choice [1]: 2

WARNING: Do NOT use single or double quotes to enclose parameter values!
Separate multiple values with a comma. If a comma is part of a value, escape it
with a backslash.
If a comma is part of a value, escape it with a backslash.

=>Enter full parameter name: []: db_file_name_convert

=>Enter new value (leave blank to set to null) []: /oracle/app/oracle/oradata/DBVFOUR,/oracle/app/oracle/oradata/DBVSIX
Validating ... please wait

The following oracle database parameters will be set in the standby database pfile or spfile:
-------------------------------------------------------------------------------
SID NAME VALUE

* archive_lag_target 0
* audit_file_dest /u01/app/oracle/admin/DBVSIX/adump
* compatible 12.2.0
* control_files /u01/app/oracle/oradata/DBVSIX/control01.ctl,/u01/app/oracle/fast_recovery_area/DBVSIX/control02.ctl
* db_block_size 8192
* db_file_name_convert /oracle/app/oracle/oradata/DBVFOUR,/oracle/app/oracle/oradata/DBVSIX
* db_lost_write_protect TYPICAL
* db_name DBVFOUR
* db_recovery_file_dest /u01/app/oracle/fast_recovery_area
* db_recovery_file_dest_size 8232370176
* db_unique_name DBVSIX
* diagnostic_dest /u01/app/oracle
* dispatchers (PROTOCOL=TCP) (SERVICE=DBVFOURXDB)
* instance_mode READ-WRITE
* instance_name DBVSIX
* log_archive_dest /u01/app/oracle/fast_recovery_area
* log_archive_format %t_%s_%r.dbf
* nls_language AMERICAN
* nls_territory AMERICA
* open_cursors 300
* pga_aggregate_target 387973120
* processes 300
* remote_login_passwordfile EXCLUSIVE
* sga_target 1048576000
* spfile OS default
* undo_tablespace UNDOTBS1
-------------------------------------------------------------------------------
What would you like to do:
1 - Proceed with creating the standby database
2 - Edit oracle database parameters for the standby database pfile/spfile
3 - Terminate processing
Please enter your choice [1]:
Validating oracle database parameters... please wait
=>SUCCEEDED

-------------------------------------------------------------------------------

=>Create standby database template for DBVSIX using provided answers? [Y]:
Your input: 1

Is this correct? <Yes/No> [Yes]:

-------------------------------------------------------------------------------

=>Continue with creating a standby database? (If No processing will terminate,
the saved template will be available for future use) [Y]:
Your input: 1

Is this correct? <Yes/No> [Yes]:

>>> dbvctl will now run a pre-flight check for standby database creation. An attempt will
be made to create a standby (s)pfile using oracle standby database parameters, followed
by trying to start the standby instance. If this step fails, then please double-check
the following items before re-running dbvctl again:

1) Review the standby database parameters you have supplied and provide valid values
unless a template is used.
2) Recreate the template to provide valid values for standby database parameters if a
template is used.

>>> Running pre-flight check for standby creation, please wait... done

>>> Total database size for DBVFOUR is 1.57GB
>>> Backing up primary database...

Backing up datafile 1... done
Backing up datafile 2... done
Backing up datafile 3... done
Backing up datafile 4... done
Backing up datafile 5... done
Backing up datafile 6... done
Backing up datafile 7... done
Backing up datafile 8... done

>>> Creating standby control file... done

>>> Transferring backup from czlin0110 to czlin0111...

Transferring /usr/tmp/dbv_DBVFOUR_csd_dbf_1_8rsef93f_1_1.rman... done
Transferring /usr/tmp/dbv_DBVFOUR_csd_dbf_2_8tsef93o_1_1.rman... done
Transferring /usr/tmp/dbv_DBVFOUR_csd_dbf_3_8vsef949_1_1.rman... done
Transferring /usr/tmp/dbv_DBVFOUR_csd_dbf_4_91sef94r_1_1.rman... done
Transferring /usr/tmp/dbv_DBVFOUR_csd_dbf_5_93sef94u_1_1.rman... done
Transferring /usr/tmp/dbv_DBVFOUR_csd_dbf_6_95sef951_1_1.rman... done
Transferring /usr/tmp/dbv_DBVFOUR_csd_dbf_7_97sef955_1_1.rman... done
Transferring /usr/tmp/dbv_DBVFOUR_csd_dbf_8_99sef958_1_1.rman... done

>>> Restoring standby control files... done

>>> Starting standby database DBVSIX on czlin0111 mount... done

>>> Catalog backup of primary database... done

>>> Restoring datafiles on czlin0111...

Restoring datafile 1... done
Restoring datafile 2... done
Restoring datafile 3... done
Restoring datafile 4... done
Restoring datafile 5... done
Restoring datafile 6... done
Restoring datafile 7... done
Restoring datafile 8... done

>>> Renaming standby redo logs and tempfiles on czlin0111... done

>>> Performing checkpoint and archiving logs... done

>>> Completing standby database creation... done

>>> Standby database created.

14) Run dbvctl on primary and standby "server"

Run dbvctl commands in both dbvisit bases to verify, that standby database is working

20:29:35 oracle@czlin0104 /usr/dbvisit_8.0.16_1/standby $ ./dbvctl -d DBVFOUR
=============================================================
Dbvisit Standby Database Technology (8.0.16_unreleased_191_g27edae92_DS_926) (pid 30803)
dbvctl started on czlin0110: Thu Sep 14 20:29:43 2017
=============================================================

>>> Obtaining information from standby database (RUN_INSPECT=Y)... done
Thread: 1 Archive log gap: 1. Transfer log gap: 1

Note FORCE_LOGGING is disabled in the primary database.

>>> Transferring Log file(s) from DBVFOUR on czlin0110 to czlin0111 for thread 1:

thread 1 sequence 10 (o1_mf_1_10_dvoln8bb_.arc)

=============================================================
dbvctl ended on czlin0110: Thu Sep 14 20:29:46 2017
=============================================================



20:29:35 oracle@czlin0104 /usr/dbvisit_8.0.16_2/standby $ ./dbvctl -d DBVFOUR
=============================================================
Dbvisit Standby Database Technology (8.0.16_unreleased_191_g27edae92_DS_926) (pid 30895)
dbvctl started on czlin0111: Thu Sep 14 20:29:51 2017
=============================================================


>>> Applying Log file(s) from czlin0110 to DBVSIX on czlin0111:

thread 1 sequence 10 (1_10_954706225.arc)
Last applied log(s):
thread 1 sequence 10

Next SCN required for recovery 7489934 generated at 2017-09-14:20:29:28 +02:00.
Next required log thread 1 sequence 11

=============================================================
dbvctl ended on czlin0111: Thu Sep 14 20:29:53 2017
=============================================================



 

Have more questions? Submit a request

Comments