different ways to upgrade, migrate & consolidate to oracle

Different Ways toUpgrade, Migrate & Consolidatewith Oracle Database 12c

Roy Swonger Mike DietrichSenior Director & PM Senior Principal TechnologistDatabase Upgrade & Utilities Database UpgradeOracle Corporation Oracle Corporation

Database Upgrade Group

Roy SwongerSenior Director Software Dev.

&

Product Management

Carol TagliaferriSenior Manager Software Dev.


Cindy LimPrincipal Member Technical Staff

Joseph ErredePrincipal Member Technical Staff

Eric WittenbergPrincipal Software Engineer

Mike DietrichSenior Principal Technologist

Agenda

� Supported Versions

� Database Upgrade Enhancements

� Plug into Oracle Multitenant


� Information and Resources

Supported Versions

2002

2003

2004

2005

2006

2007

2008

2009

2010

2011

2012

2013

2014

2015

2016

2017

2018

2019

2020

2021

2022

2023

2024

2025

Oracle 9.2Oracle 9.2(GA:(GA: Jul 2002)Jul 2002)

Oracle 10.1Oracle 10.1(GA:(GA: Jan 2004)Jan 2004)


JUL 2010JUL 2010JAN 2007JAN 2007

JAN 2012JAN 2012JAN 2009JAN 2009

today

JUL 2013JUL 2013JUL 2010JUL 2010 !


Oracle 11.1Oracle 11.1(GA:(GA: Aug 2007)Aug 2007)

Oracle 11.2Oracle 11.2(GA:(GA: Sep 2009)Sep 2009)

OracleOracle 12.112.1(GA:(GA: Jun 2013)Jun 2013)

Sustaining SupportSustaining Support

AUG 2015AUG 2015AUG 2012AUG 2012

JAN 2018JAN 2018JAN 2015JAN 2015

JUN 2021JUN 2021JUN 2018JUN 2018

Waived Extendend Waived Extendend Extendend SupportExtendend SupportPremier SupportPremier Support

Database Patch Set Roadmap

� Release Schedule of Current Database Releases Note.742060.1

1x1x 1x1x3x3x


11.1.0.711.2.0.211.2.0.311.2.0.4

12.1.0.2

Terminology: Upgrade vs. Migration

� Database Upgrade

– Dictionary only

– No data will be touched, changed or moved

� Migration

Move to new hardware, a new OS, another character set


– Move to new hardware, a new OS, another character set

Upgrade to Oracle Database 12c

Oracle9.2.0.8

Oracle10.1.0.5

Oracle10.2.0.5

Oracle11.1.0.7

Oracle ≥≥≥≥11.2.0.2

Oracle12.1.0.1


Oracle 10.1Oracle 10.1(GA:(GA: Jan 2004)Jan 2004)

≥≥≥≥11.2.0.211.2.0.29.2.0.89.2.0.8

≥≥≥≥11.2.0.211.2.0.210.1.0.510.1.0.5



Oracle 11.1Oracle 11.1(GA:(GA: Aug 2007)Aug 2007)

Oracle 11.2Oracle 11.2(GA:(GA: Sep 2009)Sep 2009)

DIRECTDIRECT≥≥≥≥11.2.0.211.2.0.2

DIRECTDIRECT11.1.0.711.1.0.7

DIRECTDIRECT10.2.0.510.2.0.5

Please note: This graph will apply to database upgrades only!

Upgrade/Migrate Older Oracle Releases

Oracle 8i

LessDowntime?

Oracle 5/6/7/8Near-ZeroDowntime?

exp/imp

Transportable


Oracle 9i

Oracle 10.1

Oracle 9.2

TransportableTablespaces

Golden Gate+

Upgrade Options to Oracle Database 12c

Oracle 11.1

LessDowntime?

Oracle 10.2 Near-ZeroDowntime?

LogicalStandby

Golden +

TransientStandby

expdp/impdp

catctl.pl

DBUA HWHW


Oracle 11.2.0.1/2

Oracle 11.2.0.3/4


StandbyGolden Gate+

Full Trans-portable Exp/Imp

RMAN Inc Bck

+

catctl.pl

Migration Options to Oracle Database 12c

Oracle 11.1

LessDowntime?

Oracle 10.2 Near-ZeroDowntime?

Golden +

Logical

expdp/impdp

SQL*Loader

CTAS, COPY


Oracle 11.2.0.1/2

Oracle 11.2.0.3/4

Golden Gate+

Full Trans-portable Exp/Imp

RMAN Inc Bck

+


StandbySQL*Loader

TDB Only sameEndianness

Agenda






� preupgrd.sql

� Executes pre-upgrade checks

� Runs in source environment

New Pre-Upgrade Script

Upgrade SQL Automation


� Runs in source environment

� Generates fixup scripts

– preupgrade_fixups.sql

– postupgrade_fixups.sql

� MOS Note:884522.1

� catctl.pl

� Runs database upgrade in parallel

� Up to 40% faster upgrade

New Parallel Upgrade

Faster Upgrade – Less Downtime

catctl.plcatctl.pl

script3.sqlscript3.sqlscript2.sqlscript2.sqlscript1.sqlscript1.sql

catctl.pl

script3.sqlscript2.sqlscript1.sql


� Up to 40% faster upgrade

� Used and proven by selected Oracle Database 11g customers

script4.sqlscript4.sql









script4.sql

script5.sql

script6.sql

script6.sql

script7.sql

script8.sql

script9.sql

script10.sql

script11.sql

New Parallel Upgrade

Faster Upgrade – Less Downtime

$> $ORACLE_HOME/perl/bin/perl catctl.pl -n 8 catupgrd.sql


“The new parallel upgrade script promises to drastically reduce downtime due to planned maintenance. We saw a 37% improvement over the previous upgrade process in our environment.”


Harald StefanLeiter DatenbankenPayback GmbH

process in our environment.”

� Pre-Upgrade Automation

� Parallel Upgrade

� RMAN Integration

Database Upgrade Assistant

Simplified Upgrade


� RMAN Integration

� Guaranteed Restore Points

� Activity and Alert Log

� Mass Upgrades

� Grid Infrastructure Upgrades

� RAC Database Upgrades

EM Cloud Control

Enterprise Manager Mass and RAC Upgrades


� RAC Database Upgrades

� Standby Database Upgrades

Agenda






Oracle Multitenant – Implementation

� Multitenant container database

– Administration from CDB

� A CDB can contain one ormany pluggable databases

– Data and code in PDBs

CDB1CDB1

PDB$SEEDPDB$SEED

PDB1PDB1 PDB2PDB2 PDB3PDB3


– Data and code in PDBs

– Applications connect to PDBs

� Simple and fast provisioning,cloning, plugin, patching andupgrade CDB2CDB2

PDB$SEEDPDB$SEED

PDB1PDB1

Oracle Multitenant – Behind the scenes

� One SGA

� One set of background processes

� One SPFILE


CDBCDB

PDB$SEEDPDB$SEED

PDB1PDB1 PDB2PDB2 PDB3PDB3

Redo Control Flashbackspfile

Plug into Oracle Multitenant

� Roads to Pluggable Databases

� Creation of a new PDB

� Cloning a PDB

� Upgrade and plugin as PDB



� Full Transportable Export/Import

Creation of a New Pluggable Database

� Fast provisioning from PDB$SEED

– PDB_FILE_NAME_CONVERT

� Import data with impdpCDB

PDB$SEED

CDBCDB

PDB$SEEDPDB$SEED

PDB1PDB1create pluggable database PDB1admin user adm1 identified by pwd;

i

m

p


impdp

– Dump file or NETWORK_LINK

– imp for ≤ Oracle 9i

p

d

p




� Cloning a PDB





Cloning of a Pluggable Database

� Fast cloning of a PDB

– Local:

– Remote:

CDB1CDB1

PDB$SEEDPDB$SEED

PDB1PDB1 PDB2PDB2

create pluggable database

PDB2 from PDB1;


– Remote:

� Planned for a future patch set or release

CDB2CDB2

PDB$SEEDPDB$SEED

PDB1PDB1

create pluggable database

PDB1 from PDB1@CDB1;




� Cloning a PDB





Upgrade and Plugin as PDB

� Database upgrade

� Start database read-only

� Create XML description file

� Shutdown database

CDB

PDB$SEED

CDBCDB

PDB$SEEDPDB$SEED

PDB1PDB1

exec DBMS_PDB.DESCRIBE('PDB1.xml');


� Shutdown database

� Plugin database

� Sanity operations DB1DB1

create pluggable database PDB1

using ('PDB1.xml') nocopy tempfile reuse;

start ?/rdbms/admin/noncdb_to_pdb.sql

PDB1PDB1

xmlxml




� Cloning a PDB





Traditional Transportable Tablespaces

DESTINATION Database 11.2.0.3SOURCE Database 10.2.0.4

Rebuild meta information(views, synonyms, trigger, roles etc)


DESTINATION Database 11.2.0.3

SYSTEM

SYSAUX

UNDO

TEMP

APP

HUGO

VIEWSVIEWS

CODECODE

PRIVSPRIVS

SOURCE Database 10.2.0.4

SYSTEM

SYSAUX

UNDO

TEMP

APP

HUGO

VIEWSVIEWS

CODECODE

PRIVSPRIVS

Read Only

Full Transportable Export/Import

� Combining:

– Transportable Tablespaces with

– Data Pump taking care on all meta information with optional

– RMAN incremental backups to decrease downtime


� This works:

– Cross platform

– With or without Oracle Multitenant

– Source can be Oracle 11.2.0.3

– Target must be at least Oracle 12.1.0.1

Full Transportable Export/Import with Copies




APP

HUGO

SOURCE Database 11.2.0.3VIEWSVIEWS

CODECODE

PRIVSPRIVS

APP

HUGO

SYSTEM

SYSAUX

UNDOTEMP

SYSTEM

SYSAUX

UNDOTEMP

VIEWSVIEWS

CODECODE

PRIVSPRIVS

Data Pump

Read Only

Full Transportable Export/Import with Backups


Convert and apply Convert and apply backupsbackups



APP

HUGO

SOURCE Database 11.2.0.3VIEWSVIEWS

CODECODE

PRIVSPRIVS

APP

HUGO

SYSTEM

SYSAUX

UNDOTEMP

SYSTEM

SYSAUX

UNDOTEMP

VIEWSVIEWS

CODECODE

PRIVSPRIVS

Data Pump

Read Only

Full Transportable Export/Import

� Create a fresh database/PDB

CDB

PDB$SEED

CDBCDB

PDB$SEEDPDB$SEED

PDB1PDB1

Database Link

impdp� Create database link to source

� Tablespaces read-only – downtime!

� Copy datafiles to destination

� Run impdp on NETWORK_LINK


DB1DB1

impdp oow/passwd@PDB1

NETWORK_LINK=DB1 VERSION=12 FULL=Y

TRANSPORTABLE=ALWAYS METRICS=Y

LOGFILE=oow_dir:src112fullimp.log

TRANSPORT_DATAFILE='/oradata/ts1.dbf' …

Read Only

� Run impdp on NETWORK_LINK

Agenda






Summary

� Upgrade to Oracle Database 12c

– Now parallel and faster

– Detailed checks and fixup scripts



– Many options


– Simplifies Transportable Tablespaces

– Works cross platform

– Minimal downtime with RMAN

Resources

� http://OTN.oracle.com/goto/upgradeTech White Paper:

– Upgrade to Oracle Database 12c

� http://OTN.oracle.com/goto/datapump


� http://OTN.oracle.com/goto/datapumpTech White Paper:

– Full Transportable Export-Import

Resources

� Download the slides from:

– blogs.oracle.com/UPGRADE

� Discuss your upgrade at our demo booth:

– Moscone South - SL-007


– Moscone South - SL-007

� What's New with Oracle Data Pump 12c

– Wednesday, Sep 25, 1:15 PM - 2:15 PM -Moscone South – 306

�Thank You Very Much!!

different ways to upgrade, migrate & consolidate to oracle

Documents