Table of Contents
This chapter briefly describes newly added and updated features in Tibero 7.1.
This section lists and briefly describes newly added features.
The following features have been added.
SQL Plan Management
Prevents performance degradation after an execution plan change.
JSON Type
Stores and processes JSON data.
Fine-Grained Auditing
Audits column- or row-level data that meets specific conditions in a table or view. The DBMS_FGA package supports this feature.
For more information, refer to "Chapter 5. User Management and Database Security" in Tibero Administrator's Guide.
Flashback Database
Rewinds the entire database to a specific point in time, without a backup/recovery operation.
Saves a significant amount of time taken normally for retrieving and recovering backup files to return to a specific point in time.
Generates certain files for writing records to return to an earlier point in time, therefore affects the database performance.
For more information, refer to "Chapter 11. Backup and Recovery" in Tibero Administrator's Guide.
Tibero Standby Cluster (TSC)
Snapshot Standby
Enables independent executions of DDL/DML statements from a certain point of time, while continuing to receive redo logs from a primary node to synchronize with it. When converting back to the primary node, however, all DDL/DML statements that have been executed will be rolled back.
Multi-Node Standby (Multi-Node TSC)
Ensures high availability between the primary and standby nodes. In read-only mode, queries are distributed across the nodes and this results in a greater query performance.
Cascade Standby (Cascade TSC)
Transfers redo logs from a standby to another standby, which reduces the network load on the primary node.
For more information, refer to "Chapter 13. Tibero Standby Cluster" in Tibero Administrator's Guide.
AWS QuickStarts
Ensures Observer availability.
Splitting Encryption Keys with HSM Devices
Stores wallet-managed keys to a Hardware Security Module (HSM).
The following HSM devices are supported.
D’Amo KMS (Penta Security)
Vormetric Data Security Manager (Thales)
Measuring and Recording Data for Cloud-Based Tibero Pricing
Records data for charging cloud license fees.
GOST Encryption Algorithm
Added GOST as a Tibero encryption algorithm.
OLTP Compression
Compresses tables where occur executions of typical DMLs instead of direct path Insert/Load, in an OLTP environment.
Index Prefix Compression
Effectively manages the space used by indexes by eliminating duplicate key columns within an index leaf block. You can use this feature when creating or re-creating an index by adding the COMPRESS N clause.
Geometry KNN Computation
Supports KNN computation.
TAS Disk Resizing
Expands the size of an existing disk used in TAS.
TAS Disk Repair Timer
Automatically drops a failed disk in TAS after a certain period of time.
tbascmd and DDL for Checking TAS Metadata Integrity
Added a tbascmd command and DDL to check the integrity of metadata about files and disks managed in TAS.
Prioritizing Log Flush in SSVR
Gives preference to log flush over any other jobs in SSVR.
GIS Geography Spatial Coordinates
Added different spatial coordinate systems and computations that include these coordinates.
New GIS Geometry Features
Added different types of spatial data including 2D and 3D as well as computations based on these types of data.
Label Security
Provides row-level data access controls based on associated labels for individual table rows and users.
In-Memory Column Store (IMCS)
Stores data in memory using a columnar format to optimize data scans on specific columns.
For more information, refer to Tibero IMCS Guide.
The following utilities have been added.
Recovery Manager Tool (RMGR)
The following utilities have been added to RMGR. For more information, refer to "Chapter 11. Backup and Recovery" in Tibero Administrator's Guide.
Provides compatibility for NetBackup, a backup/recovery solution by Veritas.
Supports online backup on a standby node, and thereby recovery on a primary node.
The following options have been added or modified.
| Option | Description |
|---|---|
| --interval | Adjusts time intervals in seconds for monitoring and displaying RMGR backup/recovery progress rate. |
| -v, --verbose | Displays the absolute path of each datafile during an RMGR backup/recovery operation. |
| -s, --silent | Displays no progress rate of each datafile during an RMGR backup/recovery operation. |
| -l, --log-level | Sets the logging level for the RMGR history on the client side. |
| -L | Sets the path to log files for the RMGR history on the client side. |
| -o | Specifies up to 16 distributed paths for backup/recovery operations. |
| -n | Specifies the NetBackup path for backup/recovery operations. |
| -d, --datafile | Specifies a datafile to back up or recover. |
| -T, --skip-tablespace | Specifies a tablespace not to back up or recover. |
| --skip-readonly | Excludes read-only tablespaces from backup/recovery targets. |
| --skip-offline | Excludes offline tablespaces from backup/recovery targets. |
| -a, --archive-only | Backs up latest archive log files instead of datafiles. |
| --from-seq | Specifies the first sequence of an archive log to back up. |
| --to-seq | Specifies the last sequence of an archive log to back up. |
| --thread | Specifies a redo thread for an archive log backup/recovery. |
| --arc-dest-force | Allows an archive log backup/recovery operation to continue even if no arbitrary archive log file is found in a specified location. |
| --delete-original | Deletes original files instead of backups after an archive log backup/recovery is complete. |
| --with-password-file | Backs up or recovers the password file as well, which is required to log in as the SYS user in MOUNT mode. |
| --no-rollback | Retains all files that have been backed up during a canceled/failed backup, instead of rolling them back. |
| --continue | Continues to recover backup files without importing them. |
| --for-standby | Backs up/recovers all datafiles for constructing a standby, and archive log files required for recovery, as well as online redo log files. |
| --recover-to | Restores first a backup set in a specified location, and then starts recovery. |
| --restore-only | Restores datafiles to back up without recovering them. |
| --restore-archive-only | Restores archive log files to back up without recovering them. |
| --wallet | Opens a wallet with a user-specified password, to recover an encrypted tablespace. |
| -b, --backup-set | Finds and retrieves first a specified backup set, before deleting or recovering the backup set. |
| --archivelog | Deletes actual archive log files, instead of the backups. |
| --cf-only | Deletes only data in control files, instead of the actual backup sets or the physical archive log files. |
| --sent-to-standby | Deletes archive logs after they have been transferred to a standby. |
| --switch | Instantly switches to backup datafiles from the original datafiles of the database. |
| --no-image-logging | Uses the block consistency check instead of the conventional image logging, for a backup operation. |
Gateway for Oracle 19c
Added the gateway for Oracle 19c.
ESRI Shapefile Conversion
Added tibero2shp, which converts tables into the shapefile format.
This section lists and briefly describes modified and improved key features.
The following features have been improved.
Default Character Set
Changed the default character set of Tibero to UTF8 from MSWIN949.
DBMS_SCHEDULER package
Improved the overall function of the DBMS_SCHEDULER package and added some of its detail features that were unsupported so far.
TAC Recovery Parallel Reconfiguration
Redistributes internal resources that are individually managed by each instance for clustering, when a Tibero Active Cluster (TAC) instance goes down or a new instance is added to the active cluster.
Modified so that multiple threads redistribute resources in parallel, to reduce the overall execution time. Previously, the resource redistribution operation was performed by a single thread.