RE: Rman restore from big endian to little endian - possible?

Thanks John! I think we'll go with a solution similar to this unless the company opts to pay for Oracle's cloud based service.

The database is just a little over one TB in size.

Jay Miller
Sr. Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Kelly Sent: Thursday, May 11, 2017 5:08 PM
To: oracle-l_at_freelists.org
Subject: Re: Rman restore from big endian to little endian - possible?

Hi Jay,

This is old school, but I suggest you build yourself an ARC (Aging RMAN Computer). Like Noah, the ARC
can save the day, although it really depends on the size of the rman backups. If we are not talking
hundreds of TB, I would obtain a small oracle/sun solaris server that can run Oracle 10 reasonably well,
sufficient to perform an rman restore and datapump export. These can be purchased on Ebay or other service
suppliers like liquidtechnology - just google used sun hardware. Purchase a couple of new SAS drives that meet the server specs, in case a drive goes bad and store them with the machine. Build out Solaris and Oracle
on the server , test the rman restore. Then write it up and place the docs on the server, print out a copy of the docs and tape 'em to the server and store everything with the backups. Don't forget to include a copy of the
OS media, the Oracle binaries and of course the passwords to the server. Most of the sun mid-size servers are
small enough to get by without server room cooling. I have two in my basement running on 110 all the time
with no issues. Yep, its a bit outside the box, but its a fairly cheap solution and as long as 110 electricity is still available it should be good for 10 or even 20 years

Cheers,

j

On 5/11/17 3:45 PM, Jay.Miller_at_tdameritrade.com wrote:
> I think I already know the answer to this but thought it worth checking if anyone has come up with a solution.
>
> We have an old 10g database running on big endian Solaris on Fujitsu. It, along with the hardware, is due to be retired soon.
>
> We've been taking rman backups for 10+ years and maybe 2x a year need to do an RMAN restore to another server of some random point in the past 7 years. Our directive is to find a way to do this restore to Red Hat Linux since we're getting rid of all our Solaris servers. I didn't realize we had an endianness problem until we got 10g on Red Hat 4 successfully installed along with an older netbackup agent and tried restoring the controlfile (getting all the older versions took quite a while). At which point it was "Duh! "
>
> Is there any way to perform such a restore or am I, as I suspect, out of luck?
>
>
> TIA,
> Jay Miller
> Sr. Oracle DBA
> --
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwIC-g&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=LAy6P1PzwRtrEFmGsbTHPrZfcdEY7rGuHLNV8XalXCw&s=7Jf7EYzkIGfDAUtZlKEXbdOjqF1WpEzmWbGHB-KKATk&e=
>
>
>

--
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwIC-g&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=LAy6P1PzwRtrEFmGsbTHPrZfcdEY7rGuHLNV8XalXCw&s=7Jf7EYzkIGfDAUtZlKEXbdOjqF1WpEzmWbGHB-KKATk&e= 


--
http://www.freelists.org/webpage/oracle-l