GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery

 Print  |  
Question:  You can take a coldbackup from solaris and use it on windows NT?

A) Yes
B) Yes, if RMAN backup performed from NT server
C) Yes, after running RMAN convert
D) No




May 05, 2008 10:23:57 #1
 suchoudh   Member Since: May 2008    Total Comments: 2 

RE: You can take a coldbackup from solaris and use it on windows NT?A) YesB) Yes, if RMAN backup performed from NT serverC) Yes, after running RMAN convertD) No
 

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

     

 

Back To Question