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.
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.
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.
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.
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.
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