7. Oracle 数据库12c更新迁移与整合
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
to Oracle Database 12c
Mike Dietrich
Database Upgrade and Utilities
Oracle Corporation
Database Upgrade Development Group
Roy Swonger
Senior Director Software Dev.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
13
Command Line Creation of a CDB
Upgrade, Migrate and Consolidate to Oracle Database 12c
7
Caution!! ☺
▪ Many of the well known concepts will get changed
– Around 150 pages new documentation in the Administrator’s Guide
Upgrade, Migrate and Consolidate to Oracle Database 12c
12
Creation of a CDB
▪ Two options:
– DBCA ▪ Highly recommended
– Command line CREATE DATABASE
▪ Not recommend as all options will have to be created
Principal Member Technical Staff
Eric Wittenberg
Principal Software Engineer
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
– Data dictionary – Common user – By default there's no user data in the root
PDB$SEED
OBJ$
TAB$
SOURCE$
CDB$ROOT
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
5
Upgrade, Migrate & Consolidate
▪ Introduction to Multitenant Environments ▪ Roads to Pluggable Databases ▪ Working with Pluggable Databases ▪ Wrap Up
▪ -u Username and optionally password ▪ -d Directory containing the script to execute (default: current directory) ▪ -e Echo on ▪ -s Spools the output of every script ▪ -l Directory to write logfiles into (default: current directory) ▪ -b Base name for logfiles (mandatory option)
(GA: Jul 2002)
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)
JAN 2007
JUL 2010
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
9
Implementation
▪ Multitenant container database => CDB
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
14
CDB-PDB: Who's who?
▪ After CDB creation:
PDB$ SEED
PDB
PDB
PDB
PDB
CDB
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
10
Containers
▪ Consolidation ▪ Reduce maintenance ▪ Simplified and fast provisioning, cloning and migration ▪ Option is called Oracle Multitenant
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
6
Multitenant Environment – The Concept!
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
4
Is It Time To Upgrade?
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
▪ Information about all PDBs in the CDB's data dictionary
– PDB$SEED
▪ Template from which to create PDBs
▪ PDB, CDB$ROOT and PDB$SEED all are called containers
3
2025 2024 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002
Lifetime Support Policy
today
Oracle 9.2
CREATE DATABASE cdb12 [...]
ENABLE PLUGGABLE DATABASE SEED FILE_NAME_CONVERT=('/oradata/cdb12/','/oradata/pdbseed/')
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE […]
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
1
Upgrade, Migrate & Consolidate
&
Product Management
Carol Tagliaferri
Senior Manager Software Dev.
Mike Dietrich
Senior Principal Technologist
Cindy Lim
Principal Member Technical Staff
Joseph Errede
– DBA administers on the CDB level
▪ A CDB contains always a PDB$SEED and in addition zero, one, or many pluggable databases (PDBs)
– Applications will connect to the PDBs – Up to 252 PDBs in one CDB
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
8
The earth is still a sphere ☺
▪ What's in a CDB?
– PDBs
PDB$SEED
PDB
PDB
PDB
PDB
▪ Pluggable databases
CDB$ROOT
▪ Contain data and code
– CDB$ROOT
▪ Schemas, objects etc available to all PDBs
JAN 2009
JAN wk.baidu.com012
JUL 2010
JUL 2013
AUG 2012
AUG 2015
JAN 2015
JAN 2018
JUN 2018
today
Premier Support
Waived Extended Support Extended Support
JUN 2021
Sustaining Support
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
11
Behind the scenes
▪ One SGA, one set of background processes, and one spfile
▪ You don't have to use pluggable databases ... yet ▪ Oracle Database 12c non-CDB works as expected
– But you can also use the new features – and this will require changing old habits
▪ Scripts have to be started via catcon.pl:
$> perl catcon.pl -u SYS -d $ORACLE_HOME/rdbms/admin -e -s -b catalog catdb.sql
– catdb.sql will run all scripts for all options – Most useful catcon.pl options:
– Benefit due to resource sharing
▪ Applications connect to a PDB
Redo Control Flashback
spfile
PDB$SEED
PDB
PDB
PDB
PDB
CDB$ROOT
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Mike Dietrich
Database Upgrade and Utilities
Oracle Corporation
Database Upgrade Development Group
Roy Swonger
Senior Director Software Dev.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
13
Command Line Creation of a CDB
Upgrade, Migrate and Consolidate to Oracle Database 12c
7
Caution!! ☺
▪ Many of the well known concepts will get changed
– Around 150 pages new documentation in the Administrator’s Guide
Upgrade, Migrate and Consolidate to Oracle Database 12c
12
Creation of a CDB
▪ Two options:
– DBCA ▪ Highly recommended
– Command line CREATE DATABASE
▪ Not recommend as all options will have to be created
Principal Member Technical Staff
Eric Wittenberg
Principal Software Engineer
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
– Data dictionary – Common user – By default there's no user data in the root
PDB$SEED
OBJ$
TAB$
SOURCE$
CDB$ROOT
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
5
Upgrade, Migrate & Consolidate
▪ Introduction to Multitenant Environments ▪ Roads to Pluggable Databases ▪ Working with Pluggable Databases ▪ Wrap Up
▪ -u Username and optionally password ▪ -d Directory containing the script to execute (default: current directory) ▪ -e Echo on ▪ -s Spools the output of every script ▪ -l Directory to write logfiles into (default: current directory) ▪ -b Base name for logfiles (mandatory option)
(GA: Jul 2002)
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)
JAN 2007
JUL 2010
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
9
Implementation
▪ Multitenant container database => CDB
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
14
CDB-PDB: Who's who?
▪ After CDB creation:
PDB$ SEED
PDB
PDB
PDB
PDB
CDB
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
10
Containers
▪ Consolidation ▪ Reduce maintenance ▪ Simplified and fast provisioning, cloning and migration ▪ Option is called Oracle Multitenant
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
6
Multitenant Environment – The Concept!
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
4
Is It Time To Upgrade?
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
▪ Information about all PDBs in the CDB's data dictionary
– PDB$SEED
▪ Template from which to create PDBs
▪ PDB, CDB$ROOT and PDB$SEED all are called containers
3
2025 2024 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002
Lifetime Support Policy
today
Oracle 9.2
CREATE DATABASE cdb12 [...]
ENABLE PLUGGABLE DATABASE SEED FILE_NAME_CONVERT=('/oradata/cdb12/','/oradata/pdbseed/')
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE […]
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
1
Upgrade, Migrate & Consolidate
&
Product Management
Carol Tagliaferri
Senior Manager Software Dev.
Mike Dietrich
Senior Principal Technologist
Cindy Lim
Principal Member Technical Staff
Joseph Errede
– DBA administers on the CDB level
▪ A CDB contains always a PDB$SEED and in addition zero, one, or many pluggable databases (PDBs)
– Applications will connect to the PDBs – Up to 252 PDBs in one CDB
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
8
The earth is still a sphere ☺
▪ What's in a CDB?
– PDBs
PDB$SEED
PDB
PDB
PDB
PDB
▪ Pluggable databases
CDB$ROOT
▪ Contain data and code
– CDB$ROOT
▪ Schemas, objects etc available to all PDBs
JAN 2009
JAN wk.baidu.com012
JUL 2010
JUL 2013
AUG 2012
AUG 2015
JAN 2015
JAN 2018
JUN 2018
today
Premier Support
Waived Extended Support Extended Support
JUN 2021
Sustaining Support
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Upgrade, Migrate and Consolidate to Oracle Database 12c
11
Behind the scenes
▪ One SGA, one set of background processes, and one spfile
▪ You don't have to use pluggable databases ... yet ▪ Oracle Database 12c non-CDB works as expected
– But you can also use the new features – and this will require changing old habits
▪ Scripts have to be started via catcon.pl:
$> perl catcon.pl -u SYS -d $ORACLE_HOME/rdbms/admin -e -s -b catalog catdb.sql
– catdb.sql will run all scripts for all options – Most useful catcon.pl options:
– Benefit due to resource sharing
▪ Applications connect to a PDB
Redo Control Flashback
spfile
PDB$SEED
PDB
PDB
PDB
PDB
CDB$ROOT
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.