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?

  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
    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/

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

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

  6. #6
    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

  7. #7
    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.

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

    thx

  9. #9
    Join Date
    Jun 2006
    Posts
    259
    Quote Originally Posted by pando
    Try it and let us know

    thx
    Tried it ... It failed.. for the following reason. I remembered it once I encountered the error.
    the redo log file format for HPUX oracle is a 1k block size, however the logfile block size for solaris is 512 bytes. I think if the redo block sizes were the same then this might have been a possiblity.

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    cant you restore the backup and open with resetlogs?

    may be redo log would be created with 512 bytes block size

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