Mar 03

IMPDP failing with ORA-39083 and ORA-14024

Sometimes, when your EXPDP takes so long (probably because you have huge partitioned tables), when you try to IMPDP somewhere later you may receive the error: ORA-39083: Object type INDEX failed to create with error: ORA-14024: number of partitions of LOCAL index must equal that of the underlying table This usually happens because the export of …

Continue reading

Mar 02

IMPDP failing with ORA-31625 and ORA-01031: insufficient privileges with Database Vault

Those days, I was having a lot of errors during my Import Datapump session in a Oracle 11g with Database Vault environment. As the schema was protected, first I did the overall check up making sure the user I was using to import had the DBA permission and I also gave it full access to …

Continue reading

Feb 28

How to delete the incarnations of an Oracle Database

In this article, I will talk about database incarnation and how to clean the old and obsoletes ones. It’s not intended to show you how to clean the incarnations on the recovery catalog, but from the database itself! Let’s start. Sometimes, after performing several database recoveries or “open resetlogs”, you can end up with so …

Continue reading

Feb 05

OCM 11g Preparation – Configure RMAN

This topic is very generic and have a very similar name with the topic “Configure Recovery Manager“. I don’t really understand the difference as RMAN is the abbreviation for Recovery Manager. What I would recommend you to study here is the RMAN binary syntax, that can receive many parameters, not only target, auxiliary and catalog: …

Continue reading

Feb 05

OCM 11g Preparation – Configure Recovery Manager

This topic is very generic and have a very similar name with the topic “Configure RMAN”. The best thing to study here is all the persistent RMAN configurations that you can set up and their values: Default Device for Backups: Disk or SBT Default Type for Backups: Backup Sets or Copies Channels Control File and …

Continue reading