Skip to Content
author's profile photo Former Member
0
Former Member

Backup restoration

Posted on Nov 30, 2007 at 05:04 AM 28 Views

Hi,

I have my Production Database <b>Oracle 8i</b>,SAP 4.6C Windows Server 2003.

Also one Test m/c on <b>Oracle 9i</b>,SAP 4.6C Windows Server 2003.

I do have Production offline backup taken by DB13.So is it possible to restore the Production backup in Test m/c ignoring this Oracle version mismatch?

Please reply asap its urgent.

Regards,

Mofizur

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 06:14 AM
    1

    Hi Mofizur

    As far as my lnowledge goes, restoration of adata onto a lower version from a higher version of Oracle is possible althought the vice versa is not possible.

    One simple way is to go to transfer the offline backup file and the back<SID>.log file and run the restore and recovery through SAPDBA utility. It will tell you of the status.

    Hope it helps.

    Lokesh Gupta

    Add a comment
    10|10000 characters needed characters exceeded

    • Eric Brunelle Former Member
      Nov 30, 2007 at 03:57 PM

      ok,

      you have already lost over 10 hours trying to use your ORacle 9 DB on Oracle 8 binaries.. this is enough.

      an upgrade to Oracle 9.2.0 binaries should take you less than 1 hour.

      you install 9.2.0, install patch for 9.2.0.6. then, you should be able to open you DB correctly. no need to upgrade the DB contents as it was already done.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.