Skip to main content

Search

Welcome to Tibero GTS!

Tibero 7.1 Release Notes [2022.02]

Tibero 7.1

New Features

DBMS Engine

The following features have been added.

SQL Plan Management

  • SQL Plan Management feature has been added to prevent performance degradation caused by execution plan changes.

JSON Type

  • JSON type has been added to store and process JSON data.

Fine-grained Auditing (FGA)

  • Supports monitoring data at the column or row level in tables or views that meet specific conditions.

  • Provided through the DBMS_FGA package.

Note: For details, refer to โ€œChapter 5 User Management and Database Securityโ€ in the โ€œTibero Administrator Guide.โ€

Flashback Database Feature

  • Allows the entire database to be reverted to a specific past point without backup/recovery processes.

  • Can reduce recovery time compared to typical backup/recovery methods.

  • However, it generates specific files for this feature during normal operation, which may cause performance degradation.

Note: For details, refer to โ€œChapter 11 Backup and Recoveryโ€ in the โ€œTibero Administrator Guide.โ€

TSC (Tibero Standby Cluster)

  • Provides Snapshot Standby feature

    • Maintains synchronization with Primary while allowing independent DDL/DML operations from a specific point in time.

Utilities

The following features have been added.

Recovery Manager Tool (RMGR)

  • Supports integration with NetBackup

  • Allows online backup on standby node, enabling recovery of Primary node using this

  • Added/changed the following option features

DescriptionOption
Set output interval for RMGR backup/recovery progress (in seconds)--interval
Output absolute path of each data file-v, --verbose
Do not output progress-s, --silent
Set client RMGR log level-l, --log-level
Do not rollback if cancel/fail occurs during backup--no-rollback
Perform recovery only without fetching backup files--continue
Backup/recovery including data files/archive logs/online redo log files for standby setup--for-standby
Restore backup set to a specified path and perform recovery--recover-to
Fetch data files only without performing recovery--restore-only
Fetch archive logs only without performing recovery--restore-archive-only
Open WALLET for encrypted tablespace recovery--wallet
Search and fetch based on specified backup set-b, --backup-set
Physically delete archive logs (when not backed up)--archivelog
Delete information only from control file without deleting physical files--cf-only
Delete archive logs that have been sent to standby--sent-to-standby
Immediately switch backup data files to datafile for use--switch
Backup using block consistency check method--no-image-logging
ESRI Shapefile Conversion Feature

  • Added utility tibero2shp to convert tables into shpfile format

Gateway for Oracle 19c

  • Added Gateway for Oracle 19c

Changed Features

DBMS Engine

The following features have been improved.

Default Character Set

  • The default character set of Tibero has been changed from MSWIN949 to UTF8.

DBMS_SCHEDULER Feature Support

  • Overall feature improvements and support for some previously unsupported functions

TAC Recovery Parallel Reconfiguration

  • Improved clustering resource redistribution logic when TAC configured instances go down or new instances join

  • Performance improved from single-threaded to multi-threaded parallel execution