Goal - Create Datapump backups on remote directory
CREATE DIRECTORY using the Remote LocationSQL> 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=scottConnected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionStarting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=xxtest dumpfile=scot.dmp logfile=scott.log schemas=scottProcessing object type SCHEMA_EXPORT/USERORA-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 disallowedORA-06512: at "SYS.DBMS_SYS_ERROR", line 105ORA-06512: at "SYS.KUPW$WORKER", line 12630ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105ORA-06512: at "SYS.KUPF$FILE", line 9793ORA-06512: at "SYS.KUPF$FILE_INT", line 1211ORA-06512: at "SYS.KUPF$FILE", line 9734ORA-06512: at "SYS.KUPW$WORKER", line 11341----- PL/SQL Call Stack -----object line objecthandle number name00007FFE8596A8C0 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION00007FFE8596A8C0 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR00007FFE8596A8C0 11612 package body SYS.KUPW$WORKER.CREATE_OBJECT_ROWS00007FFE8596A8C0 15278 package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS00007FFE8596A8C0 3917 package body SYS.KUPW$WORKER.UNLOAD_METADATA00007FFE8596A8C0 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS00007FFE8596A8C0 2439 package body SYS.KUPW$WORKER.MAIN00007FFE87214BA8 2 anonymous blockKUPW: Object row index into parse items is: 1KUPW: Parse item count is: 4KUPW: In function CHECK_FOR_REMAP_NETWORKKUPW: Nothing to remapKUPW: In procedure BUILD_OBJECT_STRINGS - non-base infoKUPW: In procedure BUILD_SUBNAME_LIST with USER:SCOTT.SCOTTKUPW: In function NEXT_PO_NUMBERKUPW: PO number assigned: 2KUPF$FILE.WRITE_LOBKUPW: 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 9793ORA-48128: opening of a symbolic link is disallowedORA-06512: at "SYS.KUPF$FILE_INT", line 1211ORA-06512: at "SYS.KUPF$FILE", line 9734Job "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 immediatestartup
expdp system/oracle123 directory=xxtest dumpfile=scotty.dmp logfile=scotty.log schemas=scottConnected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionStarting "SYSTEM"."SYS_EXPORT_SCHEMA_02": system/******** directory=xxtest dumpfile=scotty.dmp logfile=scotty.log schemas=scottProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAMaster table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded******************************************************************************Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:\\ORADBAPP\XX_TEST\SCOTTY.DMPJob "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