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
The datafiles might have the sae block size problem.
what do u mean by endian? is it the same as indian :D
It is Datafile byte ordering - OS feature.Quote:
Originally Posted by yxez
If the OS is developed in in India... then May be it can be indian.. :)Code:SQL> select * from v$transportable_platform ;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- ---------------------------------------- --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
7 Microsoft Windows IA (32-bit) Little
10 Linux IA (32-bit) Little
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
5 HP Tru64 UNIX Little
4 HP-UX IA (64-bit) Big
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- ---------------------------------------- --------------
9 IBM zSeries Based Linux Big
13 Linux 64-bit for AMD Little
16 Apple Mac OS Big
12 Microsoft Windows 64-bit for AMD Little
15 rows selected.
have you heard of google?Quote:
Originally Posted by yxez
I tried that, however the system datafile needed recovery which it was not able to perform since it required the redo log and couldn't read it.Quote:
Originally Posted by pando
The datafiles would not have the issue. Since typically they are set by the pfile parameter block_size and since the advent of multiple block sizes in the db this is most likely a dynamically determined item since it is stored in the file header of each data file.Quote:
Originally Posted by jhmartin
However, there might be differences in block layout based upon the Platform.