Troubleshooting
Problem
Oracle EXP-00091 Error When Export Database
Resolving The Problem
After FCM upgrade from 4.0 to 4.0.1, you may experience EXP-00091 errors during OPBackup which causes only OpenPages schema to be backed up. There is no ZIP file created at the end which is a problem.
The cause for this error is because statistics may not be useable although Export was able to export statistics. The statistics are questionable because one or more of the following happened during export:
A row error occurred
Client character set or NCHARSET (where you run the Export) does not match with the server (database character set)
A query clause was specified on export, only certain partitions or subpartitions were exported
A fatal error occurred while processing a table
A easy way of resolution -
export with option “STATISTICS=NONE”.
It’s pretty safe to say that if EXP-00091 is the only error message, the export’s row data is without any problems. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.
Also, set the NLS_LANG environment variable at the OS level, prior to the export session, to match your database character set. Syntax as follow, change the character set to your database’s character set.
export NLS_LANG=AL32UTF8
However setting the NLS_LANG to the character set of the database MAY be correct but IS often not correct. DO NOT assume that NLS_LANG needs to be the same as the database character set. THIS IS OFTEN NOT TRUE. So we would strongly suggust you try export with option “STATISTICS=NONE”.
What you should do is to replace all the
CONSISTENT=Y
to
STATISTICS=NONE
in op-sox-backup-recovery.xml
Historical Number
00000750
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21513313