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
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
of course not
But, read about EXPORT with Cross platform TRANSPORTABLE TABLESPACES (If you are in 10g).
And why is that?Quote:
Originally Posted by pando
EXPORT/IMPORT works for you.
Quote:
Originally Posted by ixion
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..Quote:
Originally Posted by davey23uk
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.
Try it and let us know
thx
Tried it ... It failed.. for the following reason. I remembered it once I encountered the error.Quote:
Originally Posted by pando
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.
cant you restore the backup and open with resetlogs?
may be redo log would be created with 512 bytes block size