EXP-00002: error in writing to export file
EXP-00002: error in writing to export fileerror closing export file
EXP-00000: Export terminated unsuccessfully
It was because crontab did not know anything about the ulimits of user "Oracle". It was using the default ulimit value and when it hit the 2GB size limit, my export errored out. I've edited my crontab entry to use the .profile file to set the environment, before it ran my export and it worked fine.
The crontab entry was modified as below.
# +---------------------------------------------------------+------------------------+
# | Daily FULL database export for DB TEST1 | Daily at 12:00 AM |
# +---------------------------------------------------------+------------------------+
00 00 * * * (./home/oracle/.profile; /oracle/app/admin/scripts/daily_export.sh TEST1 >/tmp/export_TEST1.log 2>&1)
Hope this helps.
-- Vish.
1 comment:
Wonderful goods from you, man. I've understand your stuff previous to and you're just too great.
I really like what you have acquired here, certainly
like what you're saying and the way in which you say it. You make it enjoyable and you still take care of to keep it sensible. I can't wait to read much more from you.
This is actually a tremendous website.
My webpage - luxe vakantiewoningen frankrijk huren ()
Post a Comment