DG_properties.ini 파일

다음은 여러 기본 및 대기 데이터베이스 환경에 대한 DG_properties.ini 파일의 예입니다.

예 1: Oracle RAC OCI DB 시스템이 포함된 Oracle RAC OCI DB 시스템

다음은 OCI(Oracle Cloud Infrastructure)의 두 Oracle RAC(Oracle Real Application Clusters) 데이터베이스 시스템, 기본 OCI DB 시스템 및 대기 OCI DB 시스템 사이에 Oracle Data Guard를 구성하기 위한 DG_properties.ini 파일의 예입니다.이 예제의 버전은 21c입니다. DG_properies.ini 파일은 primary와 standby에서 동일합니다. 가독성을 위해 설명이 잘립니다.
# Review and customize all the properties
########################################################################################################
# GENERAL PROPERTIES
########################################################################################################
export ORACLE_OSUSER=oracle
export ORACLE_OSGROUP=oinstall
export GRID_OSUSER=grid
export GRID_HOME=/u01/app/21.0.0.0/grid
export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export DB_NAME=DBTEST  # The database name (the value of db parameter db_name)
export SYS_USERNAME=sys
export RAC=YES  # Set to YES (if DB is a RAC) or to NO (if single instance DB) 
export PASSWORD_FILE_IN_ASM=YES  # Set to YES when the password file is placed in ASM (in case of RAC, it will always be placed in ASM).
export ADDITIONAL_STANDBY=NO     # Set to YES only if the primary db has another standby database already configured, and you are using
                                 the scripts to add a second standby.
#########################################################################################################
# PRIMARY ENV PROPERTIES
#########################################################################################################
export A_PORT=1521 # The primary listener's port (scan's listener port if RAC)
export A_SERVICE=DBTEST_PRI.subnet1.myvcnreg1.oraclevcn.com  # The default CDB service name in primary (format is 
<db_unique_name>.<primary_domain>) 
export A_DBNM=DBTEST_PRI # The DB UNIQUE NAME of primary DB

# For single instance (will be ignored if RAC=YES)
        export A_DB_IP=  # Provide the primary listener's IP. This needs to be reachable from the standby DB.

# For RAC (will be ignored if RAC=NO)
        # Specify the PRIMARY RAC's scan IPs and scan address name
        export A_SCAN_IP1=10.10.0.71
        export A_SCAN_IP2=10.10.0.145
        export A_SCAN_IP3=10.10.0.133
        export A_SCAN_ADDRESS=drdbracpri-scan.subnet1.myvcnreg1.oraclevcn.com
        # Provide the ORACLE_SID of the primary RAC instances
        export A_SID1=DBTEST1
        export A_SID2=DBTEST2
export A_FILE_DEST="+DATA"              # the value of db_create_file_dest db parameter in primary DB
export A_ONLINE_LOG_DEST1="+RECO"       # the value of db_create_online_log_dest_1 parameter in primary DB
export A_RECOVERY_FILE_DEST="+RECO"     # the value of db_recovery_file_dest parameter in primary DB

# Other properties required by primary setup script
export TDE_LOC=/opt/oracle/dcs/commonstore/wallets/tde/DBTEST_PRI    # The the TDE wallet folder in primary (where the .p12 file 
is located). Leave it EMPTY if TDE is not used.
export CREATE_PASSWORD_FILE=YES                                      # If password file already exists in primary and you do not 
want to override it, set this to NO.
export OUTPUT_WALLET_TAR=/tmp/PRIMARY_TDE_WALLET.GZ                  # Absolute file name for the output tar file that will be generated in 
primary, containing the primary TDE wallet.
export OUTPUT_PASWORD_TAR=/tmp/PRIMARY_PASSWORD_FILE.GZ              # Absolute file name for the output tar file that will be generated in 
primary, containing the primary password file.
########################################################################################################
# STANDBY ENV PROPERTIES
########################################################################################################
export B_PORT=1521  # The standby listener's port (scan's listener port if RAC)
export B_SERVICE=DBTEST_STBY.subnet1.myvcnreg2.oraclevcn.com   # The default CDB service name in standby (format is <db_unique_name>.<secondary_domain>)
export B_DBNM=DBTEST_STBY # The DB UNIQUE NAME of standby DB

# For single instance (will be ignored if RAC=YES)
        export B_DB_IP=      # Provide the primary listener's IP. This needs to be reachable from the standby DB

# For RAC (will be ignored if RAC=NO) 
        # Specify STANDBY RAC's scan IPs and scan address name
        export B_SCAN_IP1=10.20.0.242
        export B_SCAN_IP2=10.20.0.207
        export B_SCAN_IP3=10.20.0.136
        export B_SCAN_ADDRESS=drdbracstby-scan.subnet1.myvcnreg2.oraclevcn.com
        # Standby node's VIPs (provide the IPS, not the names)
        export B_VIP1=10.20.0.104
        export B_VIP2=10.20.0.102
        # Provide the ORACLE_SID of the standby RAC instances
        export B_SID1=DBTEST1
        export B_SID2=DBTEST2
        # (normally only needed in Exadata) Provide interconnect IPs if they must be specified in the parameter 
cluster_interconnects. Leave them empty if cluster_interconnects is empty.
        export B_INTERCONNECT_IP1=
        export B_INTERCONNECT_IP2=

export B_FILE_DEST="+DATA"              # the value of db_create_file_dest db parameter in standby DB
export B_ONLINE_LOG_DEST1="+RECO"       # the value of db_create_online_log_dest_1 parameter in standby DB
export B_RECOVERY_FILE_DEST="+RECO"     # the value of db_recovery_file_dest parameter in standby DB

# Other properties required by the standby setup script
export INPUT_WALLET_TAR=/tmp/PRIMARY_TDE_WALLET.GZ  # Absolute file name for the input tar file that contains the 
primary TDE wallet.
export INPUT_PASWORD_TAR=/tmp/PRIMARY_PASSWORD_FILE.GZ  # Absolute file name for the input tar file that contains the 
primary password file.
export B_TDE_LOC=/opt/oracle/dcs/commonstore/wallets/tde/$B_DBNM  # Absolute path where the wallet files (.p12) 
will be created in standby hosts. Verify which is the value used by your system, it may differ. Leave it empty if TDE is not used.

예 2: OCI DB 시스템이 포함된 온프레미스 Oracle RAC Oracle RAC

다음은 하이브리드 환경에서 Oracle Data Guard를 구성하기 위한 DG_properties.ini 파일의 예입니다. 기본 온프레미스 Oracle Real Application Clusters(Oracle RAC)와 대기 OCI DB 시스템 Oracle RAC 버전 19c입니다.이 경우 일반 특성에 몇 가지 차이가 있습니다. Grid OS 유저가 primary 시스템과 standby 유저 간에 다르기 때문에 DG_properies.ini 파일은 primary 시스템과 standby 시스템에서 약간 다릅니다.

기본 온프레미스 Oracle RAC의 경우 DG_properies.ini

# Review and customize all the properties
########################################################################################################
# GENERAL PROPERTIES
########################################################################################################
export ORACLE_OSUSER=oracle
export ORACLE_OSGROUP=oinstall
export GRID_OSUSER=oracle
export GRID_HOME=/u01/app/19.0.0.0/grid
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export DB_NAME=DBTEST            # The database name (the value of db parameter db_name)
export SYS_USERNAME=sys
export RAC=YES                   # Set to YES (if DB is a RAC) or to NO (if single instance DB)
export PASSWORD_FILE_IN_ASM=YES  # Set to YES when the password file is placed in ASM (for RAC, it will always be placed in ASM).
export ADDITIONAL_STANDBY=NO  # Set to YES only if the primary db has another standby database already configured, and you're using the scripts to add a second standby.
#########################################################################################################
# PRIMARY ENV PROPERTIES
#########################################################################################################
export A_PORT=1521                        # The primary listener's port (scan's listener port if RAC)
export A_SERVICE=DBTEST_PRI.myonprem.example.com   # The default CDB service name in primary (format is <db_unique_name>.<primary_domain>)
export A_DBNM=DBTEST_PRI                  # The DB UNIQUE NAME of primary DB

# For single instance (will be ignored if RAC=YES)
        export A_DB_IP=   # Provide the primary listener's IP. This needs to be reachable from the standby DB.

# For RAC (will be ignored if RAC=NO)
        # Specify the PRIMARY RAC's scan IPs and scan address name
        export A_SCAN_IP1=10.133.57.204
        export A_SCAN_IP2=10.133.57.205
        export A_SCAN_IP3=10.133.57.206
        export A_SCAN_ADDRESS=primrac-scan.myonprem.example.com
        # Provide the ORACLE_SID of the primary RAC instances
        export A_SID1=DBTEST1
        export A_SID2=DBTEST2

export A_FILE_DEST="+DATAC1"              # the value of db_create_file_dest db parameter in primary DB
export A_ONLINE_LOG_DEST1="+DATAC1"       # the value of db_create_online_log_dest_1 parameter in primary DB
export A_RECOVERY_FILE_DEST="+RECOC1"     # the value of db_recovery_file_dest parameter in primary DB

# Other properties required by primary setup script
export TDE_LOC=/u01/app/oracle/admin/DBTEST/wallet       # The the TDE wallet folder in primary (where the .p12 file is located). 
Leave it EMPTY if TDE is not used.
export CREATE_PASSWORD_FILE=YES                         # If password file already exists in primary and you do not want to 
override it, set this to NO.
export OUTPUT_WALLET_TAR=/tmp/PRIMARY_TDE_WALLET.GZ     # Absolute file name for the output tar file that will be generated in 
primary, containing the primary TDE wallet.
export OUTPUT_PASWORD_TAR=/tmp/PRIMARY_PASSWORD_FILE.GZ  # Absolute file name for the output tar file that will be generated in 
primary, containing the primary password file.
########################################################################################################
# STANDBY ENV PROPERTIES
########################################################################################################
export B_PORT=1521                                   # The standby listener's port (scan's listener port if RAC)
export B_SERVICE=DBTEST_OCIDR.subnet1phx.vcnphx.oraclevcn.com    # The default CDB service name in standby (format is 
<db_unique_name>.<secondary_domain>)
export B_DBNM=DBTEST_OCIDR                                               # The DB UNIQUE NAME of standby DB

# For single instance (will be ignored if RAC=YES)
        export B_DB_IP=   # Provide the primary listener's IP. This needs to be reachable from the standby DB

# For RAC (will be ignored if RAC=NO)
        # Specify STANDBY RAC's scan IPs and scan address name
        export B_SCAN_IP1=100.70.127.142
        export B_SCAN_IP2=100.70.127.168
        export B_SCAN_IP3=100.70.127.172
        export B_SCAN_ADDRESS=hydrdb-scan.dev3db1phx.databasede3phx.oraclevcn.com 
        # Standby node's VIPs (provide the IPS, not the names)
        export B_VIP1=100.70.127.134
        export B_VIP2=100.70.127.135
        # Provide the ORACLE_SID of the standby RAC instances
        export B_SID1=DBTEST1
        export B_SID2=DBTEST2
        # (normally only needed in Exadata) Provide interconnect IPs if they must be specified in the parameter 
cluster_interconnects. Leave them empty if cluster_interconnects
is empty.
        export B_INTERCONNECT_IP1=
        export B_INTERCONNECT_IP2=

export B_FILE_DEST="+DATA"              # the value of db_create_file_dest db parameter in standby DB
export B_ONLINE_LOG_DEST1="+DATA"       # the value of db_create_online_log_dest_1 parameter in standby DB
export B_RECOVERY_FILE_DEST="+RECO"     # the value of db_recovery_file_dest parameter in standby DB

# Other properties required by the standby setup script
export INPUT_WALLET_TAR=/tmp/PRIMARY_TDE_WALLET.GZ              # Absolute file name for the input tar file that contains the 
primary TDE wallet.
export INPUT_PASWORD_TAR=/tmp/PRIMARY_PASSWORD_FILE.GZ          # Absolute file name for the input tar file that contains the 
primary password file.
export B_TDE_LOC=/opt/oracle/dcs/commonstore/wallets/tde/$B_DBNM    # Absolute path where the wallet files (.p12) 
will be created in standby hosts. Verify which is the value used by your system, it may differ. Leave it  empty if TDE is not used.     
대기 OCI DB 시스템의 경우 DG_properies.ini
# Review and customize all the properties
########################################################################################################
# GENERAL PROPERTIES
########################################################################################################
export ORACLE_OSUSER=oracle
export ORACLE_OSGROUP=oinstall
export GRID_OSUSER=grid
export GRID_HOME=/u01/app/19.0.0.0/grid
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle

export DB_NAME=CDB11   # The database name (the value of db parameter db_name)
export SYS_USERNAME=sys

export RAC=YES   # Set to YES (if DB is a RAC) or to NO (if single instance DB)
export PASSWORD_FILE_IN_ASM=YES   # Set to YES when the password file is placed in ASM (in case of RAC, it will 
always be placed in ASM).
export ADDITIONAL_STANDBY=NO   # Set to YES only if the primary db has another standby database already  configured, and you are using the scripts to add a second standby.
#########################################################################################################
# PRIMARY ENV PROPERTIES
#########################################################################################################
..
(rest of the file is same than the DG_properties.ini of primary)

예 3: 단일 데이터베이스를 사용하는 단일 데이터베이스

다음은 하이브리드 환경에서 Oracle Data Guard를 구성하기 위한 DG_properties.ini 파일의 예입니다. 기본 단일 데이터베이스와 대기 단일 데이터베이스, RDBMS(관계형 데이터베이스 관리 시스템) 버전 18c와 Grid 버전 19c입니다.이 예제에서 데이터베이스는 Transparent Data Encryption (TDE) 암호화를 사용하지 않으며 암호 파일이 Oracle ASM(Oracle Automatic Storage Management)에 없습니다.
# Review and customize all the properties
########################################################################################################
# GENERAL PROPERTIES
########################################################################################################
export ORACLE_OSUSER=oracle
export ORACLE_OSGROUP=oinstall
export GRID_OSUSER=grid
export GRID_HOME=/u01/app/19.0.0.0/grid
export ORACLE_HOME=/u01/app/oracle/product/18.0.0.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle

export DB_NAME=ORCL  # The database name (the value of db parameter db_name)
export SYS_USERNAME=sys

export RAC=NO   # Set to YES (if DB is a RAC) or to NO (if single instance DB)
export PASSWORD_FILE_IN_ASM=NO # Set to YES when the password file is placed in ASM (for RAC, it will always be placed in ASM).
export ADDITIONAL_STANDBY=NO   # Set to YES only if the primary db has another standby database already configured, and you're using
the scripts to add a second standby.
#########################################################################################################
# PRIMARY ENV PROPERTIES
#########################################################################################################
export A_PORT=1521  # The primary listener's port (scan's listener port if RAC)
export A_SERVICE=ORCL_PRI.primarydomain.example.com  # The default CDB service name in primary (format is 
<db_unique_name>.<primary_domain>) 
export A_DBNM=ORCL_PRI   # The DB UNIQUE NAME of primary DB

# For single instance (will be ignored if RAC=YES)
export A_DB_IP=10.10.10.10   # Provide the primary listener's IP. This needs to be reachable from the 
standby DB.

# For RAC (will be ignored if RAC=NO)
    # Specify the PRIMARY RAC's scan IPs and scan address name
    export A_SCAN_IP1=
    export A_SCAN_IP2=
    export A_SCAN_IP3=
    export A_SCAN_ADDRESS=
    # Provide the ORACLE_SID of the primary RAC instances
    export A_SID1=
    export A_SID2=

export A_FILE_DEST="+DATA"              # the value of db_create_file_dest db parameter in primary DB
export A_ONLINE_LOG_DEST1="+DATA"       # the value of db_create_online_log_dest_1 parameter in primary DB
export A_RECOVERY_FILE_DEST="+RECO"     # the value of db_recovery_file_dest parameter in primary DB

# Other properties required by primary setup script
export TDE_LOC=   # The the TDE wallet folder in primary (where the .p12 file is located). Leave it EMPTY if TDE is not 
used.
export CREATE_PASSWORD_FILE=YES                             # If password file already exists in primary and you do not want to 
override it, set this to NO.
export OUTPUT_WALLET_TAR=/tmp/PRIMARY_TDE_WALLET.GZ         # Absolute file name for the output tar file that will be generated in 
primary, containing the primary TDE wallet.
export OUTPUT_PASWORD_TAR=/tmp/PRIMARY_PASSWORD_FILE.GZ     # Absolute file name for the output tar file that will be 
generated in primary, containing the primary password file.

########################################################################################################
# STANDBY ENV PROPERTIES
########################################################################################################
export B_PORT=1521                                    # The standby listener's port (scan's listener port if RAC)
export B_SERVICE=ORCL_STBY.standbydomain.example.com  # The default CDB service name in standby (format is 
<db_unique_name>.<secondary_domain>)
export B_DBNM=ORCL_STBY                               # The DB UNIQUE NAME of standby DB

# For single instance (will be ignored if RAC=YES)
export B_DB_IP=10.20.20.20                            # Provide the primary listener's IP. This needs to be reachable from the 
standby DB

# For RAC (will be ignored if RAC=NO) 
    # Specify STANDBY RAC's scan IPs and scan address name
    export B_SCAN_IP1=
    export B_SCAN_IP2=
    export B_SCAN_IP3=
    export B_SCAN_ADDRESS=
    # Standby node's VIPs (provide the IPS, not the names)
    export B_VIP1=
    export B_VIP2=
    # Provide the ORACLE_SID of the standby RAC instances
    export B_SID1=
    export B_SID2=
    # (normally only needed in Exadata) Provide interconnect IPs if they must be specified in the parameter 
cluster_interconnects. Leave them empty if cluster_interconnects is empty.
        export B_INTERCONNECT_IP1=
        export B_INTERCONNECT_IP2=

export B_FILE_DEST="+DATA"              # the value of db_create_file_dest db parameter in standby DB
export B_ONLINE_LOG_DEST1="+DATA"       # the value of db_create_online_log_dest_1 parameter in standby DB
export B_RECOVERY_FILE_DEST="+RECO"     # the value of db_recovery_file_dest parameter in standby DB

# Other properties required by the standby setup script
export INPUT_WALLET_TAR=/tmp/PRIMARY_TDE_WALLET.GZ     # Absolute file name for the input tar file that contains the 
primary TDE wallet.
export INPUT_PASWORD_TAR=/tmp/PRIMARY_PASSWORD_FILE.GZ # Absolute file name for the input tar file that contains the 
primary password file.
export B_TDE_LOC=   # Absolute path where the wallet files (.p12) will be created in standby hosts. Verify which is 
the value used by your system, it may differ. Leave it empty if TDE is not used.