What are the Oracle Database 21c new features and enhancements for DBAs?
Database Vault, Syslog, the new SYS AUTO STS MODULE, and the two new DBA packages SYS. SYS.DBMS ACTIVITY and DBMS FLASHBACK ARCHIVE MIGRATE.
Database Vault: There's no need to disable Oracle Database Vault in every container before upgrading any longer! Before completing the update, we simply need to provide the DV PATCH ADMIN role to SYS. The Database Vault controls will function normally after the upgrade is completed. The DV PATCH ADMIN role can then be revoked from SYS. Alternatively, before the update, we can explicitly disable Oracle Database Vault in all containers, and then explicitly enable Oracle Database Vault in all containers after the upgrade.
OATS: A new concept in the Oracle Database is the Object Activity Tracking System.
Object Activity Tracking System (OATS) tracks the usage of various types of database objects. Usage includes operations such as access data manipulation or refresh.
The DBMS_ACTIVITY PL/SQL package contains functions and procedures for configuring Object Activity Tracking System (OATS) information collection and management. Data collected by OATS is used in analyses performed by automatic materialized views.
SYSLOG destination for common Unified Audit Policies:
Certain predefined columns of unified audit records from common unified audit policies can be written to the UNIX SYSLOG destination.
To enable this new feature we should set UNIFIED_AUDIT_COMMON_SYSTEMLOG which is a new CDB level init.ora parameter. This enhancement enables all audit records from common unified audit policies to be consolidated into a single destination. This feature is available only on UNIX platforms.
A new PL/SQL package called DBMS_FLASHBACK_ARCHIVE_MIGRATE enables the migration of Flashback Data Archive enabled tables from a database on any release (in which the package exists) to any database on any release (that supports Flashback Data Archive).
The package has 3 procedures:
– EXPORT exports the given Flashback Archive enabled base tables, their history and related tablespaces
– EXPORT_ANALYZE analyzes the given Flashback Archive enabled base tables, their history, and related tablespaces for self-containment using Transportable tablesapce checks
– IMPORT imports the Flashback Archive enabled base tables that were exported, their history, and related tablespaces
Here are the prerequisites:
Database version >= 11.2
If database version is 11.2, following conditions should be met:
shared_pool_size >= 500M
streams_pool_size >= 40M or
sga_target >= 2G
The DBMS_FLASHBACK_ARCHIVE_MIGRATE package must be compiled on both the source and target databases as SYS. The source file is located at ?/rdbms/admin/crefbamig.sql, using which the package can be created or compiled.
The export and import procedures must be executed as SYS. Since the package uses DBMS_DATAPUMP, DBMS_LOCK, DBMS_SYSTEM, DBMS_SQL, and DBMS_SCHEDULER PL/SQL packages, their security models are also applicable.