Overview

This document explains the parameters related to TSC (Tibero Standby Cluster).

Method

1. LOG_REPLICATION_DEST_1

   This parameter sets the connection information of the Standby database and the log transfer method in TSC.
   TSC allows you to configure from 1 to 9 Standby DBs, and you should set LOG_REPLICATION_DEST_1 and onwards as needed.
   Among the connection information, the port number is set by default to LISTENER_PORT+4.

   The detailed information for the LOG_REPLICATION_DEST_1 parameter is as follows.

   Category	Description
   Type	String
   Default Value	""
   Attributes	Optional, Adjustable, Dynamic, System
   How to Set	Set in the TIP file and restart, or change with the ALTER statement.
   Syntax	- TIP file LOG_REPLICATION_DEST_1 = <ip_1>:<port_1> {LGWR SYNC | LGWR ASYNC | ARCH ASYNC} - ALTER statement ALTER SYSTEM SET LOG_REPLICATION_DEST_1 = <ip_1>:<port_1> {LGWR SYNC | LGWR ASYNC | ARCH ASYNC}

    

   Below is a description of the available SYNC modes.

   Category	Description
   LGWR SYNC	When LGWR writes the Redo log to disk, it also sends the Redo log to the Standby DB through LNW.
   LGWR ASYNC	LNW directly reads the online Redo log file periodically and sends it to Standby. (Default: 1 second)
   ARCH ASYNC	When a log switch occurs and ARCH creates an archive log, it notifies LNW, which then reads the archive log file and sends it to Standby.

    

   Below is an example of configuring Standby DB information and log transfer method.

   -- Edit tip file
   # vi $TB_HOME/config/$TB_SID.tip
   
   -- If the Standby DB's IP address is 192.169.20.82, PORT number is 8629, and SYNC mode is LGWR SYNC
   LOG_REPLICATION_DEST_1="192.169.20.82:8629 LGWR SYNC"

    

2. LOG_REPLICATION_MODE

   This parameter sets the Primary operation mode.

   The detailed information for the LOG_REPLICATION_MODE parameter is as follows.

   Category	Description
   Type	String
   Default Value	"UNPROTECTED" (Available values: {UNPROTECTED | PROTECTION | AVAILABILITY | PERFORMANCE})
   Attributes	Optional, Adjustable, Dynamic, System
   How to Set	Set in the TIP file and restart, or change with the ALTER statement.
   Syntax	- TIP file LOG_REPLICATION_MODE = {PROTECTION | AVAILABILITY | PERFORMANCE} - ALTER statement ALTER SYSTEM SET LOG_REPLICATION_MODE = {PROTECTION | AVAILABILITY | PERFORMANCE}

    

   Below is a description of the Primary DB operation modes.

   Category	Description
   PROTECTION	Synchronizes the Redo logs of the Primary DB and Standby DB. will not proceed further.
   AVAILABILITY	Synchronizes the Redo logs of the Primary DB and Standby DB. If the Redo log is not transferred to the Standby DB due to a network failure, the Primary DB does not shut down and continues operation. The Primary DB does not complete the Commit until the Commit is completed on the Standby DB. If the Standby DB is in an Unavailable state, it will temporarily become inconsistent, and when the Standby DB becomes Available again, it will automatically synchronize.
   PERFORMANCE	Provides the lowest level of protection for the Primary DB data. When a transaction is performed on the Primary DB, it is applied asynchronously to the Standby DB. In other words, the Primary DB does not wait until the data is committed to the Standby DB.

    

3. STANDBY_ENABLE_LOG_RECOVERY

   This parameter is set to allow synchronization to Standby even when some Primary nodes are down in a TAC-TSC configuration.

   The detailed information for the STANDBY_ENABLE_LOG_RECOVERY parameter is as follows.

   Category	Description
   Type	Boolean
   Default Value	N (Available values: Y, N)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set in the TIP file and restart.
   Syntax	- TIP file STANDBY_ENABLE_LOG_RECOVERY = {Y|N}

    

4. STANDBY_ENABLE_TAC_MULTINODE

   This parameter is set when configuring a multinode TSC in a TAC-TSC configuration.

   The detailed information for the STANDBY_ENABLE_TAC_MULTINODE parameter is as follows.

   Category	Description
   Type	Boolean
   Default Value	N (Available values: Y, N)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set in the TIP file and restart.
   Syntax	- TIP file STANDBY_ENABLE_TAC_MULTINODE = {Y|N}

    

5. STANDBY_ENABLE_CASCADING

   This parameter is set to allow LNW to send Redo logs in Recovery mode.

   The detailed information for the STANDBY_ENABLE_CASCADING parameter is as follows.

   Category	Description
   Type	Boolean
   Default Value	N (Available values: Y, N)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set in the TIP file and restart.
   Syntax	- TIP file STANDBY_ENABLE_CASCADING = {Y|N}

    

6. STANDBY_FILE_NAME_CONVERT

   This parameter is set to provide path conversion information when the directory path of the Standby where the Primary's backup is placed is different from the original.

   The detailed information for the STANDBY_FILE_NAME_CONVERT parameter is as follows.

   Category	Description
   Type	String
   Default Value	""
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set in the TIP file and restart.
   Syntax	- TIP file STANDBY_FILE_NAME_CONVERT = <Primary absolute path, Standby absolute path>

    

7. STANDBY_FLUSH_WAIT

   This parameter sets whether to send an ack message to the Primary server after flushing the Redo log on the Standby server.

   The detailed information for the STANDBY_FLUSH_WAIT parameter is as follows.

   Category	Description
   Type	String
   Default Value	Y (Available values: Y, N)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set in the TIP file and restart, or change with the ALTER statement.
   Syntax	- TIP file STANDBY_FLUSH_WAIT = {Y|N} - ALTER statement ALTER SYSTEM SET STANDBY_FLUSH_WAIT = {Y|N}

    

8. STANDBY_LOG_ARCHIVE_DEST

   This parameter sets the absolute path for the Standby archive log.

   The detailed information for the STANDBY_LOG_ARCHIVE_DEST parameter is as follows.

   Category	Description
   Type	String
   Default Value	""
   Attributes	Optional, Adjustable, Dynamic, System
   How to Set	Set in the TIP file and restart, or change with the ALTER statement.
   Syntax	- TIP file STANDBY_LOG_ARCHIVE_DEST = <set path> - ALTER statement ALTER SYSTEM SET STANDBY_LOG_ARCHIVE_DEST = <set path>

    

9. STANDBY_USE_OBSERVER

   This parameter is set when using Observer on Standby.

   The detailed information for the STANDBY_USE_OBSERVER parameter is as follows.

   Category	Description
   Type	Boolean
   Default Value	N (Available values: Y, N)
   Attributes	Optional, Adjustable, Static, System
   How to Set	Set in the TIP file and restart.
   Syntax	- TIP file STANDBY_USE_OBSERVER = {Y|N}