Sometimes the small enhancements in a new Oracle release save a lot of effort needed in previous versions to reach the same goal. For me, this applies also to the Data Pump enhancement I am going to blog about, which allows the usage of INCLUDE and EXCLUDE in the same operation.
Continue readingCategory: Oracle
Alles Rund um das Datenbanksystem von Oracle.
Installation of sample schemas in Oracle 12c and higher
To demonstrate the features of the database, Oracle provides a list of sample schemas, which can be installed in the database. This blog post provides an overview of the existing sample schemas and summarizes the necessary steps to install them.
Continue readingOracle 21c: Dedicated Grid Infrastructure resource for a PDB
Starting with Oracle 21c, a PDB is registered as dedicated resource in the Grid Infrastructure.
Continue readingInstallation of Oracle Audit Vault Server 20.1
With this blog post, I am trying something new for me. I will install Oracle Audit Vault Server 20.1 as a virtual machine using Oracle VirtualBox. This blog post will be the first of a multipart series of posts around the topic of the Oracle Audit Vault and Database Firewall 20.1 (AVDF)
Continue readingAnalyze raw trace files with SQL Developer
Since version 1.5 the Oracle SQL Developer has the capability to view and analyze raw trace files in an interactive way. In this blog post, I will demonstrate how to use this very unknown feature.
Continue readingCleanup of TEMPORARY segments
In this short blog post, I will explain how to get rid of TEMPORARY segments in a permanent tablespace.
Continue readingUpgrade FreeNAS 9.x to 11.x using web console
For my Oracle RAC deployments I use FreeNAS to provide shared storage to my cluster nodes. In this blog post I will show, how to upgrade an existing FreeNAS 9.x installation to an 11.x release.
Continue readingKeep RMAN Auxiliary Instance after failure
In this blog post, I will demonstrate how to keep an automatically created RMAN Auxiliary Instance after a failure occurred.
Continue readingORA-65118 during RESTORE FOREIGN DATAFILE/TABLESPACE
Starting with 12c Transportable Tablespaces can be combined with incremental backups to reduce the amount of time required to copy the Datafiles from the source to the target location. To do this RESTORE FOREIGN DATAFILE resp. TABLESPACE commands were introduced for RMAN. In this blog post, I will show an issue when a backup of an 11.2.0.4 database is used as a source and a 19c PDB is used as target.
Continue readingGenerate DBMS_DATAPUMP script using Data Pump trace
Starting with Oracle 10g, Data Pump can be used to export and import database objects using command-line tools expdp and impdp. Calls of these tools are mapped to the Data Pump API within the database. This blog post will demonstrate how to generate DBMS_DATAPUMP calls based on an expdp/impdp execution.
Continue reading