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: Backup & Recovery
Keep 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 readingNeue Data Pump Features in Oracle 12c
Dieser Blogeintrag zeigt die neuen Features und Verbesserungen von Data Pump mit der Veröffentlichung des Releases 12c Release 1.
Continue readingSicherung der Flash/Fast Recovery Area auf Disk
Ziel Dieser Blogeintrag beschäftigt sich mit dem Recovery Manager Kommando BACKUP RECOVERY AREA und zeigt die Unterschiede bei der Sicherung der Flash/Fast Recovery Area unter Oracle 10g und 11g.
Continue reading