DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Suitable Backup/Restore method ...

  1. #1
    Join Date
    Nov 2000
    Posts
    101
    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.




  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Didn't get you. Why should you recover the database if the batch job crashed ?? Why not simply re-run that job?
    Or am I missing something?

    Sanjay

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    that probably would be the worst thing I have ever heard, recover a database when batch fails

    if we have to do that in our databases considering the vast amount of batch jobs we have and the size of databases we would be recovering databases all night if there is ever a crash

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width