suchoudh

 Profile Answers by suchoudh 

• May 1st, 2008

 

D) NO

Reason :

We can use rman convert only for Os with same endian format.

Solaris is big endian and windows is small endian and hence rman convert will not work in this scenario. We will need to use transportable tablespace here.
Check note 413586.1

SQL> select PLATFORM_NAME, ENDIAN_FORMAT from V$TRANSPORTABLE_PLATFORM;

PLATFORM_NAME                            ENDIAN_FORMAT
---------------------------------------- --------------
Solaris[tm] OE (32-bit)                  Big
Solaris[tm] OE (64-bit)                  Big
Microsoft Windows IA (32-bit)            Little
Linux IA (32-bit)                        Little
AIX-Based Systems (64-bit)               Big
HP-UX (64-bit)                           Big
HP Tru64 UNIX                            Little
HP-UX IA (64-bit)                        Big
Linux IA (64-bit)                        Little
HP Open VMS                              Little
Microsoft Windows IA (64-bit)            Little
IBM zSeries Based Linux                  Big
Linux 64-bit for AMD                     Little
Apple Mac OS                             Big
Microsoft Windows 64-bit for AMD         Little
Solaris Operating System (x86)           Little
IBM Power Based Linux                    Big

This roughly translates as 3 thumb rules
1) Microsoft and linux are  little endian
2) IBM Soalris and Apple are  big endian
3) HP tru and open are little endian but 64 bit are BIG endian

jafar.labhai

 Profile Answers by jafar.labhai 

• Jul 24th, 2008

 

NO, Because here OS is different this cold backup can be used in solaris only.

vishnusivathej

 Profile Answers by vishnusivathej 

• Nov 25th, 2010

 

Yes we can use it... RMAN can convert the datafiles from little endian to big endian... The only exception is that both the databases have to use the same national character set and character set...

Amin

• Oct 14th, 2016

 

Yes, we can do it. Take logical backup of export datapump and import it into window NT system.

Vikas

• Jan 9th, 2018

 

NO, cross platform restore is only possible thru DATAPUMP or with transporatable tablepaces.