Thanks for the question, Ramishah.
Asked: April 27, 2017 - 4:00 pm UTC
Last updated: April 28, 2017 - 1:25 am UTC
Version: 11G
Viewed 1000+ times
You Asked
Hey Tom
I am really hoping you can help me with this, I have can not find anything related to this anywhere.
We have a daily export .dmp from a Linux PROD DB. We want to import that in a windows new DB .
I have tried creating a DB w/ DBCA and using the most recent .dmp to import. However, it keeps giving me errors.
I have pasted a portion of the logfile from the import.
The PROD DB is a ODA with 2 nodes and ASM.
mport: Release 11.2.0.3.0 - Production on Thu Apr 20 13:30:58 2017
;;;
Import: Release 11.2.0.3.0 - Production on Thu Apr 20 13:30:58 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": sys/******** AS SYSDBA full=y directory=data_pump_dir dumpfile=1.dmp logfile=1.log;
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-31684: Object type TABLESPACE:"UNDOTBS2" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file '+DATA/d7io01/datafile/d7iprd_data.dbf'
ORA-17502: ksfdcre:4 Failed to create file +DATA/d7io01/datafile/d7iprd_data.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Failing sql is:
CREATE TABLESPACE "D7IPRD_DATA" DATAFILE '+DATA/d7io01/datafile/d7iprd_dat
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file '+DATA/d7io01/datafile/d7iprd_index.dbf'
ORA-17502: ksfdcre:4 Failed to create file +DATA/d7io01/datafile/d7iprd_index.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
and Connor said...
The errors are suggesting we cannot find the ASM diskgroup under the new windows db.
If you are not intending to use ASM, then either use the REMAP_DATAFILE clause, or simply precreate your tablespaces, and then run the import. Doing "impdp sqlfile=x.sql" is an easy of way seeing all the DDL in the file, and you can easily extract those that create tablespaces and customise accordingly.
You'll still get warnings about tablespaces already existing, but that shouldnt be an issue.
Is this answer out of date? If it is, please let us know via a Comment