I have a shellscript that will run daily to perform housekeeping task that will export old data from the Oracle Database (for sending dump files to archiving department later). But I find that sometimes when I run expdp, it is successfully dump, while sometimes it throws me this error output
Export: Release 19.0.0.0.0 - Production on Mon May 13 13:54:39 2024
Version 19.17.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: nonexistent file or path [29434]
Despite the path is always still there.
Additional note: If I simultaneously run the command, it throws me error above, but if I set delay and wait for a while (like 30 seconds to 5 minutes or more), or rerun simotaniously until it can process, it can perform datapump as I want. (exaxtly the same command and params), sometimes I rerun the command until it can perform datapump.
I want to know the root cause what happens, also is there a way to check if it is ready to do datapump automatically via script (or intervalley) because I don't think it's a good idea in a long term if I need to access the server to rerun the failed command.