Re: Exadata migration single-instance discussion

Hi Chris,

It is possible to clone a non-PDB database into a PDB, but with 80+ TB, I would not do that. I would create a standby database to minimize a downtime and then fail over to Exadata when it's time.

On 08/13/2018 02:35 PM, Chris Taylor wrote:
> Our current configuration:
>
> Source System:
> - 12.1.0.2
> - Not multi-tenant
> - Not RAC
> - 80+ TB
>
> Target System:
> - Exadata with 12.1.0.2 db_home
> - Multi-tenant
> - RAC
>
> Right now we're in the early phases of brain-storming how to migrate
> this DB and incur little downtime.
>
> Here's a thought (and question) I wanted to discuss:
>
> IF we want to use Standby and build the standby on Exadata (based on
> Oracle whitepapers), here's what I was thinking:
>
> - Build TARGET CDB and empty PDB on Exadata
> - do an RMAN full backup on SOURCE system to fast NAS-attached storage
> - On Exadata , use RMAN duplicate to duplicate using backup files
> directly to the empty PDB ?
>
> Basically, I'm curious how to do the RESTORE (duplicate or other)
> directly into a PDB on the Exadata?
>
> If I pre-build an empty PDB, I don't think that will work for an RMAN
> duplicate - but I guess an standard RMAN restore would work?
>
> If I don't pre-build an empty PDB, can I restore/duplicate the RMAN
> backup as an PDB?
>
> I'm a little confused on how to do the restore to a PDB I guess.
>
> (And we were told the CDB/PDB setup is the only supported setup on
> Exadata)
>
> Thanks,
> Chris
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


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