| Data Pump expdp to root directory [message #524113] |
Wed, 21 September 2011 21:46  |
 |
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
|
Member |
|
|
Test server expdp is ok, real server has many ora error, can you see help about this?
In my test server I had directory NFS_EXPORTS /home/oracle/exports, DATA_PUMP_DIR /home/oracle/admin/filtdb/dpdump/
drwxr-x--- 2 oracle oinstall 4096 9월 22 10:21 dpdump
drwxrwxrwx 2 root root 4096 9월 22 10:19 exports
and running expdp
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/app/product/11.2.0
export ORACLE_SID=filtdb
export PATH=$PATH:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/home/oracle/bin:/home/oracle/app/product/11.2.0/bin:/home/timesten/TimesTen/sfs/bin
expdp ***/****@** dumpfile=TM-`date '+%d%m%Y_%H%M%S'`.dmp directory=nfs_exports logfile=DATA_PUMP_DIR:TM-`date '+%d%m%Y_%H%M%S'`.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TM_EXPDP_FILTDB tables=TM_SFS_STUDY_INFO_JOB
. . exported "ORAASFS"."TO_SFS_STUDY_INFO_JOB" 0 KB 0 rows
Master table "ORAASFS"."TO_EXPDP_FILTDB" successfully loaded/unloaded
******************************************************************************
Dump file set for ORAASFS.TO_EXPDP_FILTDB is:
/home/oracle/exports/TO-22092011_111912.dmp
Job "ORAASFS"."TO_EXPDP_FILTDB" successfully completed at 11:20:08
In the real server
NFS_EXPORTS /home/oracle/exports DATA_PUMP_DIR /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/
drwxrwxrwx 2 root root 4096 Sep 22 11:08 exports
drwxrwxrwx 2 oracle oinstall 4096 Aug 9 02:00 log
and running expdp
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=filtdb1
export PATH=$PATH:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/u01/app/11.2.0/grid/bin:/u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin:/bin:/usr/bin:/home/oracle/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch:/u01/app/11.2.0/grid/bin:/opt/oracle.SupportTools:/opt/oracle.SupportTools/ibdiagtools:/opt/oracle.SupportTools/onecommand:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/kerberos/bin:/u01/app/oracle/product/11.2.0/dbhome_1/lib:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/bin:/usr/bin:/root/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch:/u01/app/11.2.0/grid/bin:/opt/oracle.SupportTools:/opt/oracle.SupportTools/ibdiagtools:/opt/oracle.SupportTools/onecommand:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/kerberos/bin
expdp ***/***/@***/ dumpfile=CUST-`date '+%d%m%Y_%H%M%S'`.dmp directory=asmexpdir logfile=DATA_PUMP_DIR:CUST-`date '+%d%m%Y_%H%M%S'`.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TM_EXPDP_FILTDB tables=TM_STUDY_INFO_JOB
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/home/oracle/exports/CONFIG-22092011_114326.dmp"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
[EDITED by LF: masked login credentials]
[Updated on: Thu, 22 September 2011 00:04] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Data Pump expdp to root directory [message #524349 is a reply to message #524321] |
Fri, 23 September 2011 03:50  |
|
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
|
Member |
|
|
I succeed with same log directory of default oracle log directory to my dumpfile directory.
expdp need more consistency to me, because last time I couldn't expdp and leave log file to other directory other than DATA_PUMP_DIR.
I still can't figure out why I can't expdp to /home/oracle/exports NFS_EXPORTS directory.
[oracle@fS]$ expdp ****/****@*****dumpfile=TAIC-`date '+%d%m%Y_%H%M%S'`.dmp directory=DATA_PUMP_DIR logfile=DATA_PUMP_DIR:TAIC-`date '+%d%m%Y_%H%M%S'`.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TAIC_EXPDP_FILTDB tables=TA_S6T_ALM_CD
Export: Release 11.2.0.2.0 - Production on Fri Sep 23 17:43:47 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "****"."TAIC_EXPDP_FILTDB": ****/********@****dumpfile=TAIC-23092011_174347.dmp directory=DATA_PUMP_DIR logfile=DATA_PUMP_DIR:TAIC-23092011_174347.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TAIC_EXPDP_FILTDB tables=TA_S6T_ALM_CD
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/COMMENT
. . exported "****"."TA_S6T_ALM_CD" 13.34 KB 116 rows
Master table "****"."TAIC_EXPDP_FILTDB" successfully loaded/unloaded
******************************************************************************
Dump file set for ****.TAIC_EXPDP_FILTDB is:
/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/TAIC-23092011_174347.dmp
Job "****"."TAIC_EXPDP_FILTDB" successfully completed at 17:43:50
[Updated on: Fri, 23 September 2011 04:01] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
