Dear All,

We are a Banking Software Company. We have the following scenarios.

There will be multiple EOD(End of Day i.e. Batch Jobs) will be running. Suppose, if one EOD crashed, the second EOD or other operations should not be affected.

Typically, if the EOD is crashed we will have to shutdown the Oracle Database and do the Recovery. If i do this, i can get back only the before first EOD crash DATA. By using EXPORT/IMPORT i can get back other EOD's and other operations data. Since, we are using XMLTYPE for our tables. The EXPORT/IMPORT is failed for XMLTYPE. Oracle confirmed it is BUG. And Oracle said, it will be resolved it in the 9.2.0.2.0 version.
Now, the requirement is without EXPORT/IMPORT is there any other way to get back First EOD data and Second EOD & Other operations DATA. We are using Oracle 9.2.0.1.0.


Could U help on this issue.


Thanks
gandhi
OCP-DBA.