Home » RDBMS Server » Backup & Recovery » RMAN CROSS PLATFORM DUPLICATE (ORACLE 10.2.0.3.0)
RMAN CROSS PLATFORM DUPLICATE [message #345509] Wed, 03 September 2008 22:09 Go to next message
n.dba
Messages: 6
Registered: September 2008
Location: NJ
Junior Member
I have do database cloning from one server to another i.e. solaris to linux.i had seen rman duplicate is the best practise for the same host. but i m not able to find out for different platforms.my situation is like....i have to clone my production database that is on solaris to new linux box which is have only linux o/s on it. no database yet.i was searching for proper steps for such a situation but not found yet.if somebody passed with same situation then please let me know.

[Updated on: Wed, 03 September 2008 22:10]

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345528 is a reply to message #345509] Thu, 04 September 2008 00:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
You can use TRANSPORT tablespace option.
or EXPORT / IMPORT is database size is not big.

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345647 is a reply to message #345509] Thu, 04 September 2008 06:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If they are same endians, yes.
But still, I would not do duplication. For duplication RMAN requires the same OS in both nodes.
We used transportable features to migrate 2tb database from windows to linux using RMAN (just copied the files).
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm#CHDFHBFI

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345712 is a reply to message #345647] Thu, 04 September 2008 10:24 Go to previous messageGo to next message
macdba
Messages: 27
Registered: May 2005
Location: US
Junior Member
As Mahesh said, if they are having the same endian format and on 10g you can transfer the volumes. But as far as SUN to Linux is concerned, SUN is on BIG endian format and Linux on LITTLE. You can not convert the endian format for these volumes from SUN to Linux.
Only option left is logically migrate the database either using export/import, etl tool, sql loader, shareplex, streams etc

regards
--Mak

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345717 is a reply to message #345509] Thu, 04 September 2008 10:36 Go to previous messageGo to next message
n.dba
Messages: 6
Registered: September 2008
Location: NJ
Junior Member
Yes mahesh you are right regarding ENDIAN format..i m posting below for solaris and linux both.PLATFORM_ID
For Solaris
-----------
PLATFORM_NAME
--------------------------------------------------------------------------------
ENDIAN_FORMAT
--------------
2
Solaris[tm] OE (64-bit)
Big

For linuxPLATFORM_ID
-----------
PLATFORM_NAME
--------------------------------------------------------------------------------
ENDIAN_FORMAT
--------------
13
Linux 64-bit for AMD
Little

which of the best practise would solve my problem

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345727 is a reply to message #345717] Thu, 04 September 2008 11:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you read the previous message by Macdba?
>>which of the best practise would solve my problem
Already answered.
If the volume of data is low or
endidans will not match export import is the preferred method.

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345737 is a reply to message #345727] Thu, 04 September 2008 12:13 Go to previous messageGo to next message
n.dba
Messages: 6
Registered: September 2008
Location: NJ
Junior Member
can i get same copies of my prod db including Rman backup.if yes please let me know. can you sure me if i go with DATAGUARD.

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345747 is a reply to message #345737] Thu, 04 September 2008 12:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure I understand your question.
Why would you want to "bring" the backups over?
It is of no worth as the OS hosting the databases hosting the database has changed.
In other words, backups created in Solaris are not useful in linux.

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345766 is a reply to message #345509] Thu, 04 September 2008 14:21 Go to previous messageGo to next message
n.dba
Messages: 6
Registered: September 2008
Location: NJ
Junior Member
i got the point....yes you are right. and in the mean time i have done with exp/imp. thanks a lot for your suggestion ..it really worked out. thanks

Report message to a moderator

Re: RMAN CROSS PLATFORM DUPLICATE [message #345790 is a reply to message #345766] Thu, 04 September 2008 16:22 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Even with different endian formats, you can still consider RMAN's CONVERT DATAFILE or TABLESPACE for your conversion.

Report message to a moderator

Previous Topic: About downloaded Oracle 10.2 from Internet
Next Topic: Restore database from Backup.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 23:15:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.