Tuesday, 10 September 2024

Datapump with Remote Directory

Goal - Create Datapump backups on remote directory

CREATE DIRECTORY using the Remote Location
SQL> create directory xxtest as '\\ORADBAPP\xx_test';
Directory created.

Try an export backup

expdp system/oracle123 directory=xxtest dumpfile=scot.dmp logfile=scott.log schemas=scott
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=xxtest dumpfile=scot.dmp logfile=scott.log schemas=scott
Processing object type SCHEMA_EXPORT/USER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CREATE_OBJECT_ROWS [USER]
USER:"SCOTT"
ORA-39155: error expanding dump file name "\\ORADBAPP\XX_TEST\SCOT.DMP"
ORA-48128: opening of a symbolic link is disallowed
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 12630
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPF$FILE", line 9793
ORA-06512: at "SYS.KUPF$FILE_INT", line 1211
ORA-06512: at "SYS.KUPF$FILE", line 9734
ORA-06512: at "SYS.KUPW$WORKER", line 11341
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
00007FFE8596A8C0     33543  package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FFE8596A8C0     12651  package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FFE8596A8C0     11612  package body SYS.KUPW$WORKER.CREATE_OBJECT_ROWS
00007FFE8596A8C0     15278  package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS
00007FFE8596A8C0      3917  package body SYS.KUPW$WORKER.UNLOAD_METADATA
00007FFE8596A8C0     13746  package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FFE8596A8C0      2439  package body SYS.KUPW$WORKER.MAIN
00007FFE87214BA8         2  anonymous block
KUPW: Object row index into parse items is: 1
KUPW: Parse item count is: 4
KUPW: In function CHECK_FOR_REMAP_NETWORK
KUPW: Nothing to remap
KUPW: In procedure BUILD_OBJECT_STRINGS - non-base info
KUPW: In procedure BUILD_SUBNAME_LIST with USER:SCOTT.SCOTT
KUPW: In function NEXT_PO_NUMBER
KUPW: PO number assigned: 2
KUPF$FILE.WRITE_LOB
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-39155: error expanding dump file name "\\ORADBAPP\XX_TEST\SCOT.DMP"
ORA-06512: at "SYS.KUPF$FILE", line 9793
ORA-48128: opening of a symbolic link is disallowed
ORA-06512: at "SYS.KUPF$FILE_INT", line 1211
ORA-06512: at "SYS.KUPF$FILE", line 9734
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at Tue Sep 10 10:24:35 2024 elapsed 0 00:00:24

FIX - 
ALTER SYSTEM  SET "_disable_directory_link_check" =true  SCOPE=SPFILE;
shut immediate
startup
expdp system/oracle123 directory=xxtest dumpfile=scotty.dmp logfile=scotty.log schemas=scott
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02":  system/******** directory=xxtest dumpfile=scotty.dmp logfile=scotty.log schemas=scott
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:
  \\ORADBAPP\XX_TEST\SCOTTY.DMP
Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at Tue Sep 10 10:30:28 2024 elapsed 0 00:01:07


 

No comments:

Post a Comment