| Which way can I choose? [message #470146] |
Sun, 08 August 2010 21:25  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Next month, I've to move the DB from Sparc to Linux RHEL 5. The original DB is single on Sparc, the future will be RAC. However, in the Sparc Server, storage is full now, no backup, only archivelog.
$ df -h
Filesystem size used avail capacity Mounted on
/dev/md/dsk/d10 48G 4.5G 43G 10% /
/devices 0K 0K 0K 0% /devices
ctfs 0K 0K 0K 0% /system/contract
proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
swap 16G 1.2M 16G 1% /etc/svc/volatile
objfs 0K 0K 0K 0% /system/object
/platform/sun4u-us3/lib/libc_psr/libc_psr_hwcap2.so.1
48G 4.5G 43G 10% /platform/sun4u-us3/lib/libc_psr.so.1
/platform/sun4u-us3/lib/sparcv9/libc_psr/libc_psr_hwcap2.so.1
48G 4.5G 43G 10% /platform/sun4u-us3/lib/sparcv9/libc_psr.so.1
fd 0K 0K 0K 0% /dev/fd
swap 16G 88K 16G 1% /tmp
swap 16G 48K 16G 1% /var/run
/dev/dsk/c4t600A0B8000482FB20000045247E9D08Ad0s0
134G 125G 7.6G 95% /vnporadataSYSTEM
/dev/dsk/c4t600A0B8000482FB20000044C47E9CED8d0s0
134G 73G 60G 55% /vnprctl
/dev/dsk/c4t600A0B8000482FB20000044F47E9CF52d0s0
402G 384G 14G 97% /vnporadataUSERS
/dev/md/dsk/d30 71G 68G 2.2G 97% /u01
/dev/md/dsk/d40 118G 62G 55G 54% /u02
Someway I think about when I move this DB. And, wish you help me to choose the best way:
1- Original export (client - server), using another server contains the dumpfile. Example: Sparc -> export on Windows --> import on Linux.
2- Try to delete something on Sparc server, export one-by-one schema using DpDump, and import into Linux.
I can not using Transport tablespace, because of full storage!
Thank you very much!
|
|
|
|
|
|
|
|
|
|
| Re: Which way can I choose? [message #470150 is a reply to message #470149] |
Sun, 08 August 2010 22:32  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Yes!
The source DB is Sparc, and the target DB is RHEL 5 - HP, x86_64.
I think this is different Endian between them. So, I'm afraid about the header file, said you above, make me remember one experience when I convert the datafile using transportable from Sparc to HP Unix (Solaris_10 vs BE-10). One bug on HP (I am sorry, I did not resolve this problem, the HP's technician did) when I copied the datafile to, it's almost done when ftp, but, at the end of process, the BE OS put the error's log by Smitty manager on the window, showed me some thing about header of file.
So, in my case, assume I'm using dpdump (or rman backup) in external drive, that - the job finish on Sparc, then I bring it (external drive), plug in HP (RHEL 5), will the RHEL 5 (x64) can read the dumpfile (or backup file) normally?
Thank you!
|
|
|
|
|
|
| Re: Which way can I choose? [message #470152 is a reply to message #470151] |
Sun, 08 August 2010 22:45 |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
BlackSwan wrote on Mon, 09 August 2010 10:36expdp/impdp dump files are OS, architecture, & ENDIAN independent.
The only restriction involving expdp & impdp is that the lowest version of expdp must be used to create the dump file.
I'm sorry, but I do not understand your answer at all. May you clarify more?
Thank you!
[Updated on: Sun, 08 August 2010 22:48] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
