{"id":2385,"date":"2019-01-31T23:11:53","date_gmt":"2019-02-01T05:11:53","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2385"},"modified":"2026-02-07T15:08:06","modified_gmt":"2026-02-07T21:08:06","slug":"oracle-tidbits-january-2019-oratidbit","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2019\/2385\/","title":{"rendered":"Oracle Tidbits – January 2019 #oratidbit"},"content":{"rendered":"\n
\"\"
#oratidbit<\/figcaption><\/figure><\/div>\n\n\n\n

\u201cOracle *daily* TidBits<\/strong>\u201d (#oratidbit) published on Facebook<\/a>, Twitter, <\/a>and Google+<\/a> during weekdays in January 2019. Hope you find these helpful to learn something new or to remind you of its existence and use. <\/p>\n\n\n\n
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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).<\/td><\/tr>
#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)<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr>
#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.<\/td><\/tr><\/tbody><\/table>\n","protected":false},"excerpt":{"rendered":"

\u201cOracle *daily* TidBits\u201d (#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 … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":2175,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[27],"tags":[58],"class_list":["post-2385","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tidbits","tag-oratidbit"],"acf":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/04\/oratidbit.jpg?fit=273%2C91&ssl=1","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=2385"}],"version-history":[{"count":2,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2385\/revisions"}],"predecessor-version":[{"id":2391,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2385\/revisions\/2391"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media\/2175"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}