upgrade/migrate to oracle 12c: live and uncensored!

Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |

Upgrade / Migrate to Oracle Database 12c Live and Uncensored!

Roy Swonger Senior Director & Product Manager Database Upgrade & Utilities Oracle Corporation

Upgrade and Migrate to Oracle 12c - Live and Uncensored!

Mike Dietrich Master Product Manager Database Upgrade Oracle Corporation

Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |

Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Upgrade and Migrate to Oracle 12c - Live and Uncensored! 2


$> whoami

3

20 years w/Oracle Previously with DEC Rdb

11+ years managing Data Pump Database Upgrade SQL*Loader Transportable Tablespaces


Roy Swonger


6 years RDBMS Core & Mission Critical Support

5.5 years Technology Presales for DataGuard, Upgrades

>7.5 years ST Upgrade Development Team

50% Reference Projects

50% Workshops Worldwide

+ x% Development

Work

$> whoami

4

Mike Dietrich Master Product Manager Database Upgrades & Migrations

MikeDietrichDE

http://blogs.oracle.com/UPGRADE



Upgrade and Migrate to Oracle Database 12c - Live

1

2

3

Upgrade

Migrate

Wrap Up

5 Upgrade and Migrate to Oracle 12c - Live and Uncensored!


Supported Versions

2007

2008

2009

2010

2011

2012

2013

2014

2015

2016

2017

2018

2019

2020

2021

2022

2023

2024

2025

Oracle 10.1 (GA: Jan 2004)

Oracle 10.2 (GA: Jul 2005)

Oracle 11.1 (GA: Aug 2007)

Oracle 11.2 (GA: Sep 2009)

Oracle 12.1 (GA: Jun 2013)

Oracle 12.2 (GA: xxx 2016)

today


Premier Support Waived Extended Support Paid Extended Support Sustaining Support

Jan 2009 Jan 2012

Jul 2010 Jul 2013

Aug 2012 Aug 2015

Jan 2015

Jun 2018 Jun 2021

Dec 2020 May 2017


Direct Upgrade to Oracle Database 12c


Oracle 9.2.0.8

Oracle 10.1.0.5

Oracle 10.2.0.5

Oracle 11.1.0.7

Oracle 11.2.0.2

Oracle 12.1.0.2


Oracle 10.1 (GA: Jan 2004)


Oracle 11.1 (GA: Aug 2007)

Oracle 11.2 (GA: Sep 2009)

DIRECT 11.2.0.2

DIRECT 11.1.0.7

DIRECT 10.2.0.5

11.2.0.2 9.2.0.8

11.2.0.2 10.1.0.5

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


preupgrd.sql

Executes pre-upgrade checks

Runs in source environment

Generates fixup scripts

– preupgrade_fixups.sql

– postupgrade_fixups.sql

MOS Note:884522.1

New Pre-Upgrade Script

Upgrade SQL Automation


https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=ANNOUNCEMENT&id=884522.1


40% Faster Upgrades in Oracle Database 12c



catctl.pl

Runs database upgrade in parallel

Up to 40% faster upgrade

Used and proven by selected Oracle Database 11g global customers

– Telco billing

– >100 SAP systems

– Large DWH

New Parallel Upgrade

Faster Upgrade – Less Downtime

catctl.pl

script3.sql script2.sql script1.sql

script4.sql

script5.sql

script6.sql

script6.sql

script7.sql

script8.sql

script9.sql

script10.sql

script11.sql



Daniel Overby Hansen Chief Software Developer, Environment Operation SimCorp A/S - Denmark

“We experienced very few problems and in general the upgrades were very fast.

We were able to upgrade almost all of our 200+ database instances to Database 12c with a downtime of only 30-40 minutes (and that includes some of the pre- and post-tasks).

I have been upgrading Oracle databases since 9i to 10g, and this has been the best release (measured on how easy upgrading is) so far."



Time Zone Adjustment

Manual task post upgrade

Requires restart

Script in MOS Note:1509653.1

Patch in MOS Note:412160.1


Oracle Database Release

Default Time Zone Version

10.2.0.3 – 11.1.0.7 DST V4

11.2.0.1 DST V11

11.2.0.2 - 11.2.0.4 DST V14

12.1.0.1, 12.1.0.2 DST V18

Most recent time zone file: DST V24

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=1509653.1





1

2

3

Upgrade

Migrate

Wrap Up



Concept Transportable Tablespaces

75TB 75TB

Self Contained?

Read Only

expdp "'"sys/sys as sysdba"'" …

TRANSPORT_TABLESPACES=TS1,TS2 …

impdp "'"sys/sys as sysdba"'"…

TRANSPORT_DATAFILES=…

Read Write

TTS feature available since Oracle 8i

Cross platform support since Oracle 10g



Upgrade/Migration: Transportable Tablespaces

DESTINATION Database 12.1.0.2

SYSTEM

SYSAUX

UNDO

TEMP

SCOTT

HUGO

VIEWS

CODE

PRIVS

SOURCE Database 11.2.0.4

SYSTEM

SYSAUX

UNDO

TEMP

SCOTT

HUGO

VIEWS

CODE

PRIVS

Read Only

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



Full Transportable Export/Import with Copies

DESTINATION Database 12.1.0.2

SCOTT

HUGO

SOURCE Database 11.2.0.4

VIEWS

CODE

PRIVS

SCOTT

HUGO

SYSTEM

SYSAUX

UNDO

TEMP

SYSTEM

SYSAUX

UNDO

TEMP

VIEWS

CODE

PRIVS

Data Pump

Read Only

Upgrade and Migrate to Oracle 12c - Live and Uncensored 17


Full Transportable Export/Import

Create a fresh database/PDB

CDB

PDB$ SEED

PDB1

DB1

Database Link

impdp oow/passwd@PDB1

NETWORK_LINK=DB1 VERSION=12 FULL=Y

TRANSPORTABLE=ALWAYS METRICS=Y

LOGFILE=oow_dir:src112fullimp.log

TRANSPORT_DATAFILES='/oradata/ts1.dbf' …

Read Only

impdp Create database link to source

Tablespaces read-only – downtime!

Copy datafiles to destination

Run impdp on NETWORK_LINK




1

2

3

Upgrade

Migrate

Wrap Up



Try the Upgrade: Hands On Lab





Download Slides from the Database Upgrade Blog





Related Talks

How to Upgrade Hundreds and Thousands of Databases in a reasonable amout of time Wednesday, Moscone South 102, 12:15pm

Deep Dive: More Data Pump Performance Tips and Tricks Thursday, Moscone South 305, 9:30am


Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal 24

Classroom Training

Learning Subscription

Live Virtual Class

Training On Demand

Keep Learning with Oracle University

education.oracle.com

Cloud

Technology

Applications

Industries