Is Possible to restore HP-Unix Back files on Solaris Machine?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Is Possible to restore HP-Unix Back files on Solaris Machine?

Hybrid View

  1. #1
    Join Date
    Aug 2006
    Posts
    9

    Is Possible to restore HP-Unix Back files on Solaris Machine?

    I have taken off-line (cold) backup of oracle database which is on HP machine. I want to restore that backup on Solaris machine. Is it possible or not?

    Please suggest.

    Thanks
    Rakesh S

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    of course not

  3. #3
    Join Date
    Jun 2006
    Posts
    259
    Quote Originally Posted by pando
    of course not
    And why is that?

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    EXPORT/IMPORT works for you.
    "What is past is PROLOGUE"

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote Originally Posted by ixion
    And why is that?

    because he has a cold backup of a database and you know full well he wants to copy those onto the new os and make them work without doing anything.

    Now he didnt mention which version so lets not get into rman conversions etc etc

  6. #6
    Join Date
    Jun 2006
    Posts
    259

    Wink

    Quote Originally Posted by davey23uk
    because he has a cold backup of a database and you know full well he wants to copy those onto the new os and make them work without doing anything.

    Now he didnt mention which version so lets not get into rman conversions etc etc
    I guess I was looking for a more in depth answer other than cold back up..

    You still didn't answer the "why" part. Skip the rman conversions. etc...

    Here is my version of the "why" .... Its because the two platforms have different endianness. Plain and simple, so the block structures are differently formatted and would not be portable. Now if one knew the block structures, new which attributes were binary encoded big E vs little E, then a conversion could theoretically take place.

    Now in his case Solaris and HPUX are both big endian systems.

    I'm curious now, so I'll build and test his question later today.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Try it and let us know

    thx

  8. #8
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    But, read about EXPORT with Cross platform TRANSPORTABLE TABLESPACES (If you are in 10g).
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  9. #9
    The datafiles might have the sae block size problem.

  10. #10
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    what do u mean by endian? is it the same as indian

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