“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in January 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.
| #oratidbit #goldengate Oracle Database 18c and later support replication of identity columns using Golden Gate. It requires usage of the Integrated Extract and Integrated Replicat or Integrated Parallel Replicat. |
| #oratidbit #goldengate The Classic Extract (capture) is deprecated as of Oracle GoldenGate 18c (18.1.0). There will be no further enhancements to the Classic Capture (Extract) process. |
| #oratidbit #goldengate Oracle GoldenGate Veridata compares one set of data to another and identifies data that is out-of-sync, and allows you to repair any data that is found out-of-sync (while data sources are online). |
| #oratidbit The RMAN block change tracking file can be enabled on an Oracle Active Data Guard standby that is using multi-instance Redo Apply in 18c (18.1.0) |
| #oratidbit #oracleatp #oraclecloud The default data and temporary tablespaces for the Autonomous Transaction Processing database are configured automatically. Adding, removing, or modifying tablespaces is not allowed. |
| #oratidbit #oracleatp #oraclecloud Compression is not enabled by default on Autonomous Transaction Processing instance, but ATP honors a compression clause if compression is specified on a table. |
| #oratidbit A Global Data Services configuration and its global services are created and managed using the GDSCTL command-line interface, which is similar to the SRVCTL command-line interface used to manage an Oracle RAC database and its services. |
| #oratidbit To enable secure communication between Oracle Analytics Cloud and Oracle Autonomous Data Warehouse Cloud, upload trusted SSL certificates from Oracle Autonomous Data Warehouse Cloud to Oracle Analytics Cloud. |
| #oratidbit “dbms_xdb_config.setglobalportenabled(TRUE)” enables global port for EM Express which enables you to use EM Express to connect to all of the PDBs in the CDB using the HTTPS port for the CDB. |
| #oratidbit Using the EM Express Performance Hub you can view performance statistics for a standby database in an Oracle Active Data Guard environment. Only real-time data for the standby database can be viewed in the Performance Hub. |
| #oratidbit Optimizer Statistics Advisor is built-in diagnostic software that analyzes the quality of statistics and statistics-related tasks. The advisor task runs automatically in the maintenance window. |
| #oratidbit An on-premise database can be duplicated to Oracle Cloud using the DUPLICATE PLUGGABLE DATABASE command in 18c. Similarly, you can duplicate a database in Oracle Cloud as an on-premise database. |
| #oratidbit #exadata Starting with Oracle Exadata System 19.1.0, Database Machine provides automated, cloud-scale performance monitoring including CPU, memory, file system, IO, and network. This feature combines AI, real-world performance experience, and best practices. |
| #oratidbit #db18c DBMS_PDB.EXPORTRMANBACKUP procedure exports the RMAN backup information that belongs to a pluggable database to its dictionary before unplug so that pre-plugin backups can be used. Use for non-CDB to PDB migration. Not needed for PDB relocation. |
| #oratidbit A PDB snapshot is a named copy of a PDB at a specific point in time. When a PDB is enabled for PDB snapshots, you can create up to eight snapshots of it. The set of snapshots is called a snapshot carousel. |
| #oratidbit The Oracle Database password file in ORACLE_BASE allows Oracle home to be used as a static repository of database files enabling the Oracle home to be configured in read-only mode and used as a software image that can be shared across multiple database servers. |
| #oratidbit Passwords in database links are encrypted in #db18c. Oracle Data Pump handles the export and import of these passwords. Import operations from older versions and export operations to older versions can still be used. |
| #oratidbit #db18c The DataPump Import DATA_OPTIONS parameter CONTINUE_LOAD_ON_FORMAT_ERROR option. If DataPump encounters a stream format error when loading table data, attempts to skip forward to find the start of the next row and continue loading data from that location. |
| #oratidbit #db18c The DATA_OPTIONS parameter of the DBMS_DATAPUMP.SET_PARAMETER procedure option KU$_DATAOPT_CONT_LOAD_ON_FMT_ERR tells DataPump to continue loading data from the next row if it encounters stream format errors in the table data. |
| #oratidbit In Oracle Database 18c, RMAN preserves the PDB backup history for PDBs, even if it is moved from one CDB to another. Use syntax RESTORE/RECOVER PLUGGABLE DATABASE <pdb> FROM PREPLUGIN BACKUP. |