RE: duplicate pdb from backup

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 24 Dec 2020 22:17:46 -0500
Message-ID: <003301d6da6c$85322ef0$8f968cd0$_at_rsiz.com>



My understanding is that you can do plugin across platforms as long as they are the same endian, but you need to use RMAN if you are changing endian. That matches this document: https://docs.oracle.com/en/cloud/cloud-at-customer/exadata-cloud-at-customer/exacc/mig-unplugging-plugging-pdb.html#GUID-A10B0819-0EC0-4B1D-B4BA-7A570CCF9A9F  

So to me the hiccup regarding cloning unplugged plugins is only losing the original recovery thread due to the unplug, plug back in bit on the original. I wouldn’t expect plugin/unplug to convert endian and it makes sense to me that requires RMAN and they only build that complication into the comprehensive Recovery Management tool. I’m not sure what you are suggesting Oracle should have that it does not have.  

Does sql server do cross endian restores? I’ve never really used sql server other than trivially, so that is an actual rather than rhetorical question. I wasn’t aware that it ran on any big endian platforms, but I’ve never really looked.  

I don’t think Oracle will mind if I copy/paste their list:

SELECT PLATFORM_ID, PLATFORM_NAME, ENDIAN_FORMAT   FROM V$TRANSPORTABLE_PLATFORM   ORDER BY PLATFORM_ID;  

PLATFORM_ID PLATFORM_NAME                            ENDIAN_FORMAT


----------- ---------------------------------------- --------------
1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 3 HP-UX (64-bit) Big 4 HP-UX IA (64-bit) Big 5 HP Tru64 UNIX Little 6 AIX-Based Systems (64-bit) Big 7 Microsoft Windows IA (32-bit) Little 8 Microsoft Windows IA (64-bit) Little 9 IBM zSeries Based Linux Big 10 Linux IA (32-bit) Little 11 Linux IA (64-bit) Little 12 Microsoft Windows x86 64-bit Little 13 Linux x86 64-bit Little 15 HP Open VMS Little 16 Apple Mac OS Big 17 Solaris Operating System (x86) Little 18 IBM Power Based Linux Big 19 HP IA Open VMS Little 20 Solaris Operating System (x86-64) Little 21 Apple Mac OS (x86-64) Little

Has there been trouble plugging in the backup of an unplugged PDB cross platform as long as the endians match? I missed that if so, but I have not tested it.  

mwf  

From: Mladen Gogala [mailto:gogala.mladen_at_gmail.com] Sent: Thursday, December 24, 2020 8:11 PM To: Mark W. Farnham; oracle-l_at_freelists.org Subject: Re: duplicate pdb from backup  

Hi Mark,

Not just that. Backup is also a thing with SQL Server. I backed up my Windows 2012 AdventureWorks 2014 database and restored it to OL 7 SQL Server database without any problems. In other words, the tenant backup should also include a platform conversion.

On 12/24/20 5:52 PM, Mark W. Farnham wrote:

Something like “Create unplugged copy of <pdb name> [as <new pdb name>]”  

making an unplugged copy of a pdb without unplugging it would be really useful, especially if that means it does NOT reset the recovery thread in the original. (This suggestion was made pretty much as soon as it was realized that the recovery thread was reset). In that mode, the pluggable copy would not be something you could roll forward, since it would be a new recovery thread wherever you plugged it back in.  

--

Mladen Gogala
Database Consultant
http://mgogala.byethost5.com

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 25 2020 - 04:17:46 CET

Original text of this message