Oracle Tidbits – January 2019 #oratidbit

#oratidbit

Oracle *daily* TidBits” (#oratidbit) published on FacebookTwitter, 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.