Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Full Database EXPDP/IMPDB of 11.2.0.4 ASM instance to 12c (12.1.0.2) ASM Instance

User_M3KZ4Jul 30 2017 — edited Sep 26 2017

Hello,

I have a OL 11gR2 ASM instance (11.2.0.4) that I want to do a full database logical export/import using expdp/impdp to a remote (new physical server) OL 12c (12.1.0.2) ASM instance. I will be doing the full db export on the 11g db instance using VERSION=12 clause and then using the 12c impdp utility to import the database.

Both instances have 3 disk groups but with different names. My question is about the ASM diskgroups.

How does Oracle do the import regarding the ASM diskgroups - does it drop the existing ASM diskgroups and create new ones?

I realize this is a logical export/import but do I have to do any manual configuration on the target 12c database before I

do the import using 12c impdp?

Thank you for your assistance in this matter.

This post has been answered by Raj Kushawaha on Jul 31 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2017

Added on Jul 30 2017

#database-key-features, #export-import-sql-loader-external-tables

13 comments

1,482 views