expdp - RAC 11.2.0.4
OS= RHEL 6
DB: 11.2.0.4
Node:3
Configuration:
Two databases - DB_1 and DB_2
DB_1 resides on all 3 servers(server 1, 2, 3)
DB_2 resides only on 2 servers (server 2 and 3)
OS space available only on Server 1 for export:
1. created DP directory and GRANTed READ, WRITE ON DIRECTORy to job_admin user
2. syntax to run: expdp JOB_ADMIN/'password'@DB_2 DIRECTORY=DB_2_WKLY_DP_DIR DUMPFILE=expdp_DB_2_DB_$(date +%Y%m%d%H) FULL=Y LOGFILE=expdp_DB_2_$(date +%Y%m%d%H).log
3. I am trying to export data from DB_2 on the server 1 but it is failing. I think it is do with the directory or permission.
0