OraFAQ Forum: Server Utilities » Is there a way to import different database dump into a RAC database

Home » RDBMS Server » Server Utilities » Is there a way to import different database dump into a RAC database (11.2.0.3 SE, SLES 11 SP3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is there a way to import different database dump into a RAC database [message #626363]

Mon, 27 October 2014 05:24

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Hi all,

I've a dump file dumped from A RAC database with ORACLE_UNQNAME=orcl, i need to import them into a RAC database with ORACLE_UNQNAME=nowatz

my parameter file is as follow


FULL=Y
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=full_export.dmp
LOGFILE=impdp_full_20141027_1740.log
JOB_NAME=impdp_full

partial log file is as follow


CREATE TABLESPACE "UAT" DATAFILE '+DATA/orcl/datafile/uat_001.dbf' SIZE 2097152 AU
TOEXTEND ON NEXT 2097152 MAXSIZE 52428800 LOGGING ONLINE PERMANENT BLOCKSIZE 819
2 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS  SEGMENT
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file '+DATA/orcl/datafile/respos_001.dbf'
ORA-17502: ksfdcre:4 Failed to create file +DATA/orcl/datafile/respos_001.dbf
ORA-15173: entry 'orcl' does not exist in directory '/'

Is there a way to resolve the above errors other than these two solutions:

create a directory orcl at the root of Diskgroup DATA
rename the database nowatz into orcl.

thanks a lot!

Report message to a moderator