/
new, setup

new, setup

dbvcli new {-t|--type} oracle [--OPTIONS] dbvcli setup {-t|--type} oracle [--OPTIONS]

Create a new Oracle Configuration

Option

Type

Description

Option

Type

Description

--name

string

new configuration name

--license

string

license key

--import

string

name of existing configuration (DDC) to import

--source-host

string

host name of source database

--source-db

string

name of source database (for detected source database)

--source-oracle-home

string

Oracle home directory on source host (for manual source database)

--source-sid

string

Oracle SID for source database (for manual source database)

--source-log-dir

string

archivelog staging location on source host

--source-rac1-host

string

host name for first RAC thread

--source-rac1-sid

string

Oracle SID for first RAC thread

--source-rac1-asm

Y or N

enable ASM for first RAC thread

--source-rac1-asm-instance

string

ASM instance for first RAC thread

--source-rac2-host

string

host name for second RAC thread

--source-rac2-sid

string

Oracle SID for second RAC thread

--source-rac2-asm

Y or N

enable ASM for second RAC thread

--source-rac2-asm-instance

string

ASM instance for second RAC thread

--source-rac3-host

string

host name for third RAC thread

--source-rac3-sid

string

Oracle SID for third RAC thread

--source-rac3-asm

Y or N

enable ASM for third RAC thread

--source-rac3-asm-instance

string

ASM instance for third RAC thread

--source-rac4-host

string

host name for fourth RAC thread

--source-rac4-sid

string

Oracle SID for fourth RAC thread

--source-rac4-asm

Y or N

enable ASM for fourth RAC thread

--source-rac4-asm-instance

string

ASM instance for fourth RAC thread

--source-rac5-host

string

host name for fifth RAC thread

--source-rac5-sid

string

Oracle SID for fifth RAC thread

--source-rac5-asm

Y or N

enable ASM for fifth RAC thread

--source-rac5-asm-instance

string

ASM instance for fifth RAC thread

--source-seha1-host

string

host name for first SEHA node

--source-seha1-asm

Y or N

enable ASM for first SEHA node

--source-seha1-asm-instance

string

ASM instance for first SEHA node

--source-seha2-host

string

host name for second SEHA node

--source-seha2-asm

Y or N

enable ASM for second SEHA node

--source-seha2-asm-instance

string

ASM instance for second SEHA node

--source-asm-host

string

host name for source ASM instance

--source-asm-port

string

port for source ASM instance

--source-asm-service

string

service name for source ASM instance

--source-asm-user

string

user name for source ASM instance

--source-asm-password

string

password for source ASM instance

--standby-host

string

host name for standby database

--standby-oracle-home

string

Oracle home directory on standby host

--standby-sid

string

Oracle SID for standby database

--standby-db

string

unique database name of standby database

--standby-asm

Y or N

enable automatic storage management (ASM) for the standby database

--standby-asm-instance

string

automatic storage management (ASM) instance for the standby database

--standby-dbvisit-dir

string

directory containing StandbyMP installation on standby host

--standby-log-dir

string

archivelog staging location on standby host

--standby-rac

Y or N

enable RAC for the standby database

--standby-rac1-host

string

host name for first RAC thread

--standby-rac1-sid

string

Oracle SID for first RAC thread

--standby-rac1-asm

Y or N

enable ASM for first RAC thread

--standby-rac1-asm-instance

string

ASM instance for first RAC thread

--standby-rac2-host

string

host name for second RAC thread

--standby-rac2-sid

string

Oracle SID for second RAC thread

--standby-rac2-asm

Y or N

enable ASM for second RAC thread

--standby-rac2-asm-instance

string

ASM instance for second RAC thread

--standby-rac3-host

string

host name for third RAC thread

--standby-rac3-sid

string

Oracle SID for third RAC thread

--standby-rac3-asm

Y or N

enable ASM for third RAC thread

--standby-rac3-asm-instance

string

ASM instance for third RAC thread

--standby-rac4-host

string

host name for fourth RAC thread

--standby-rac4-sid

string

Oracle SID for fourth RAC thread

--standby-rac4-asm

Y or N

enable ASM for fourth RAC thread

--standby-rac4-asm-instance

string

ASM instance for fourth RAC thread

--standby-rac5-host

string

host name for fifth RAC thread

--standby-rac5-sid

string

Oracle SID for fifth RAC thread

--standby-rac5-asm

Y or N

enable ASM for fifth RAC thread

--standby-rac5-asm-instance

string

ASM instance for fifth RAC thread

--standby-seha

Y or N

enable SEHA for the standby database

--standby-seha1-host

string

host name for first SEHA node

--standby-seha1-asm

Y or N

enable ASM for first SEHA node

--standby-seha1-asm-instance

string

ASM instance for first SEHA node

--standby-seha2-host

string

host name for second SEHA node

--standby-seha2-asm

Y or N

enable ASM for second SEHA node

--standby-seha2-asm-instance

string

ASM instance for second SEHA node

--standby-asm-host

string

host name for standby ASM instance

--standby-asm-port

string

port for standby ASM instance

--standby-asm-service

string

service name for standby ASM instance

--standby-asm-user

string

user name for standby ASM instance

--standby-asm-password

string

password for standby ASM instance

[oracle@nzel91 bin]$ ./dbvcli -t oracle new Connecting to the Control Center at nzel92.oraclekiwi.co.nz:4433 ✓ Source Database 1/2 Select the host containing the source database. Source Host: (•) nzel91.oraclekiwi.co.nz ( ) nzel92.oraclekiwi.co.nz Listing existing configurations on host nzel91.oraclekiwi.co.nz ✓ Import or Create Configuration Prompt Skipped (Using Import or Create: ) Source Database 2/2 Select the source database. Source Database: ( ) FREE (•) new19c ( ) Manual entry Source Database Manual Entry 1/2 Prompt Skipped (Using Source Oracle Home: /u01/app/oracle/19c) Source Database Manual Entry 2/2 Prompt Skipped (Using Source SID: new19c) Standby Host Select the host for the standby database. Standby Host: ( ) nzel91.oraclekiwi.co.nz (•) nzel92.oraclekiwi.co.nz Archived Log Staging Locations 1/2 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 Source Log Directory: > /u01/app/oracle/dbvisit_arch/orcl19c Archived Log Staging Locations 2/2 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 Standby Log Directory: > /u01/app/oracle/dbvisit_arch/orcl19c Standby Database Configuration 1/4 Enter ORACLE_SID on the standby server Standby SID: > new19c Standby Database Configuration 2/4 Enter ORACLE_HOME directory on the standby server Standby ORACLE_HOME: > /u01/app/oracle/19c Standby Database Configuration 3/4 Enter DB_UNIQUE_NAME on the standby server Standby Database Name: > NEW19C Standby Database Configuration 4/4 Enter the ASM instance name for the standby database, if using ASM. Standby ASM Instance Name: (•) Not using ASM ( ) Manual Entry Standby Installation Configuration Prompt Skipped (Using Dbvisit StandbyMP Installation Directory: /usr/dbvisit/standbymp) Configuration Name Enter the name for this Configuration. This is how the configuration will be identified in the Control Center. Configuration Name: > NEW19C License Key Enter a license key for this configuration. License Key: > 4jo70-qwp4l-7gplh-g1ep1-9tc6d-0o4j0-o7efw New configuration NEW19C was created successfully. Configuration NEW19C (nzel91.oraclekiwi.co.nz -> nzel92.oraclekiwi.co.nz) ┌───────────────┐┌───────────────┐ │ ││ │ │ Primary ││ Standby │ │ ││ │ │ ONLINE ││ NOT PRESENT │ │ ││ │ └───────────────┘└───────────────┘