Release note_7.1
This chapter briefly describes newly added and updated features in Tibero 7.1.
New Features
This section lists and briefly describes newly added features.
DBMS Engine
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 "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.
It generates certain files for writing records to return to an earlier point in time, therefore affects the database performance.
For more information, refer to "Backup and Recovery" in Tibero Administrator's Guide.
TSC(Tibero Standby Cluster)
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 "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
GOST as a Tibero encryption algorithm is added.
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
A tbascmd command and DDL to check the integrity of metadata about files and disks managed in TAS are added.
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
– Stores data in memory using a columnar format to optimize data scans on specific columns.
For more information, refer to Tibero IMCS Guide.
Utilities
Recovery Manager Tool(RMGR)
The following utilities have been added to RMGR.
It provides compatibility for NetBackup, a backup/recovery solution by Veritas.
It supports online backup on a standby node, and thereby recovery on a primary node.
The following options have been added or modified.
--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.
For more information, refer to "Backup and Recovery" in Tibero Administrator's Guide.
gateway for oracle 19c
– Added Gateway for Oracle 19c.
ESRI shapefile Conversion
– Added tibero2shp, which converts tables into the shapefile format.
Updated Features
This section lists and briefly describes modified and improved key features.
DBMS Engine
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.
Last updated