Muutke küpsiste eelistusi

Oracle Database 12c Release 2 Multitenant [Pehme köide]

, ,
  • Formaat: Paperback / softback, 416 pages, kõrgus x laius x paksus: 226x188x25 mm, kaal: 590 g, 100 Illustrations
  • Ilmumisaeg: 16-Oct-2016
  • Kirjastus: McGraw-Hill Education
  • ISBN-10: 1259836096
  • ISBN-13: 9781259836091
Teised raamatud teemal:
Oracle Database 12c Release 2 MultitenantSuurem pilt
  • Formaat: Paperback / softback, 416 pages, kõrgus x laius x paksus: 226x188x25 mm, kaal: 590 g, 100 Illustrations
  • Ilmumisaeg: 16-Oct-2016
  • Kirjastus: McGraw-Hill Education
  • ISBN-10: 1259836096
  • ISBN-13: 9781259836091
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781259836091.html
Märksõnad:

Master the multitenant features of Oracle Database 12c

Maintain a scalable, highly available enterprise computing platform and dramatically reduce complexity by learning to leverage the powerful new multitenant tools and cloud enhancements available in Oracle Database 12c. You will get hands-on, detailed coverage of key areas such as installation, creation, configuration, and day-to-day administration.

Oracle Database 12c Release 2 Multitenant teaches, step-by-step, how to implement and manage multitenant configurations across IT frameworks of all types and sizes. Special attention is given to new features built for both public and private clouds, including Database as a Service (DBaaS) functionality and cloud-based security. Advanced topics are also fully explained, including backup and recovery, data guard, flashback, and resource manager.

 

·       Provides targeted best practices and tips for effective administration

·       Offers start-to finish coverage of both simple and complex installations

·       Authored by a team of Oracle Masters with a combined 40+ years of experience

Introduction xix
Part I What Multitenant Means
1 Introduction to Multitenant
3(32)
History Lesson: A New Era in IT
4(6)
The Road to Multitenant
5(1)
Schema Consolidation
6(3)
Table Consolidation
9(1)
Server Consolidation
9(1)
Virtualization
10(1)
Multiple Databases Managed by One Instance
10(1)
Summary of Consolidation Strategies
10(1)
The System Dictionary and Multitenant Architecture
11(16)
The Past: Non-CDB
11(3)
Multitenant Containers
14(2)
Multitenant Dictionaries
16(4)
Working with Containers
20(7)
What Is Consolidated at CDB Level
27(6)
Data and Metadata at CDB Level
30(3)
Summary
33(2)
2 Creating the Database
35(36)
Creating a Container Database (CDB)
36(19)
What About OMF?
36(2)
CDB Creation Options
38(17)
Creating a Pluggable Database
55(12)
Create a New PDB from PDB$SEED
56(3)
Create a New PDB Using the Local Clone Method
59(1)
Create a PDB Using SQL Developer
60(5)
Create a PDB Using the DBCA
65(1)
Create a PDB Using Cloud Control
66(1)
Using the catcon.pl Script
67(2)
Summary
69(2)
3 Single-Tenant, Multitenant, and Application Containers
71(16)
Multitenant Architecture Is Not an Option
72(2)
Non-CDB Deprecation
72(1)
Noncompatible Features
73(1)
Single-Tenant in Standard Edition
74(3)
Data Movement
75(1)
Security
75(1)
Consolidation with Standard Edition 2
76(1)
Single-Tenant in Enterprise Edition
77(2)
Flashback PDB
77(1)
Maximum Number of PDBs
78(1)
Using the Multitenant Option
79(5)
Application Containers
80(3)
Consolidation with Multitenant Option
83(1)
Summary
84(3)
Part II Multitenant Administration
4 Day-to-Day Management
87(32)
Choosing a Container to Work With
88(1)
Managing the CDB
89(3)
Create the Database
90(1)
Database Startup and Shutdown
90(1)
Drop the Database
90(1)
Modify the Entire CDB
91(1)
Modify the Root
92(1)
Managing PDBs
92(8)
Create a New PDB
92(1)
Open and Close a PDB
93(4)
View the State of PDBs
97(1)
View PDB Operation History
97(1)
Run SQL on Multiple PDBs
97(1)
Modify the PDB
98(1)
Drop a PDB
99(1)
Patching and Upgrades
100(13)
Upgrade CDB
101(10)
Plugging In
111(1)
Patching
112(1)
Using CDB-Level vs. PDB-Level Parameters
113(5)
CDB SPFILE
114(1)
PDB SPFILE Equivalent
114(2)
SCOPE=MEMORY
116(1)
Alter System Reset
116(1)
ISPDB_MODIFIABLE
116(1)
Container=ALL
116(1)
DB_UNIQUE_NAME
117(1)
Summary
118(1)
5 Networking and Services
119(20)
Oracle Net
120(1)
The Oracle Net Listener
120(1)
The LREG Process
121(2)
Networking: Multithreaded and Multitenant
123(2)
Service Names
125(9)
Default Services and Connecting to PDBs
125(4)
Creating Services
129(5)
Create a Dedicated Listener for a PDB
134(3)
Summary
137(2)
6 Security
139(30)
Users, Roles, and Permissions
140(15)
Common or Local?
140(1)
What Is a User?
141(1)
CONTAINER=CURRENT
142(2)
CONTAINER=COMMON
144(2)
Local Grant
146(1)
Common Grant
147(1)
Conflicts Resolution
148(2)
Keep It Clear and Simple
150(1)
CONTAINER_DATA
151(2)
Roles
153(1)
Proxy Users
153(2)
Lockdown Profiles
155(3)
Disable Database Options
155(1)
Disable Alter System
156(2)
Disable Features
158(1)
PDB Isolation
158(1)
PDB OS CREDENTIALS
158(1)
PATH- PREFIX
158(1)
CREAT-E_FILE_DEST
159(1)
Transparent Data Encryption
159(6)
Setting Up TDE
159(5)
Plug and Clone with TDE
164(1)
TDE Summary
165(1)
Summary
165(4)
Part III Backup, Recovery, and Database Movement
7 Backup and Recovery
169(30)
Back to Basics
170(5)
Hot vs. Cold Backups
170(3)
RMAN: The Default Configuration
173(1)
RMAN Backup Redundancy
174(1)
The SYSBACKUP Privilege
174(1)
CDB and PDB Backups
175(8)
CDB Backups
176(4)
PDB Backups
180(3)
Do Not Forget Archive Logs!
183(1)
Recovery Scenarios
183(6)
Instance Recovery
184(1)
Restore and Recover a CDB
184(3)
Restore and Recover a PDB
187(2)
RMAN Optimization Considerations
189(4)
The Data Recovery Advisor
193(1)
Block Corruption
193(1)
Using Cloud Control for Backups
194(3)
Back Up to the Cloud
195(2)
Summary
197(2)
8 Flashback and Point-in-time Recovery
199(28)
Pluggable Database Point-in-Time
200(6)
Recover PDB Until Time
201(3)
Where Is the UNDO?
204(1)
Summary of 12.1 PDBPITR
205(1)
Local UNDO in 12.2
206(5)
Database Properties
207(1)
Create Database
207(1)
Changing UNDO Tablespace
208(1)
Changing UNDO Mode
209(2)
Shared or Local UNDO?
211(1)
PDB Point-in-Time Recovery in 12.2
211(2)
PDBPITR in Shared UNDO Mode
211(1)
PDBPITR in Local UNDO Mode
212(1)
Flashback PDB
213(8)
Flashback Logging
213(2)
Flashback with Local UNDO
215(1)
Flashback in Shared UNDO
216(1)
Restore Points at the CDB and PDB Levels
216(3)
Clean Restore Point
219(2)
Resetlogs
221(1)
Flashback and PITR
222(3)
When Do You Need PITR or Flashback?
222(1)
Impact on the Standby Database
223(2)
Auxiliary Instance Cleanup
225(1)
Summary
225(2)
9 Moving Data
227(32)
Grappling with PDB File Locations
228(1)
Plugging In and Unplugging
229(10)
Unplug and Plug In a PDB
230(1)
An Unplugged Database Stays in the Source
231(1)
What Exactly Is in the XML File?
232(3)
Check Compatibility for Plug-In
235(2)
Plug In a PDB as Clone
237(1)
PDB Archive File
238(1)
Cloning
239(8)
Cloning a Local PDB
240(2)
Cloning a Remote PDB
242(5)
Application Container Considerations
247(1)
Converting Non-CDB Database
247(4)
Plug In a Non-CDB
248(2)
Cloning a Non-CDB
250(1)
Moving PDBs to the Cloud
251(1)
Triggers on PDB Operations
252(1)
Full Transportable Export/Import
253(2)
Transportable Tablespaces
255(1)
Summary
256(3)
Part IV Advanced Multitenant
10 Oracle Database Resource Manager
259(30)
Resource Manager Basics
260(5)
Key Resource Manager Terminologies
261(2)
Resource Manager Requirements
263(1)
Resource Manager Levels
264(1)
The CDB Resource Plan
265(12)
Resource Allocation and Utilization Limits
265(2)
Default and Autotask Directives
267(2)
Creating a CDB Resource Plan
269(8)
The PDB Resource Plan
277(4)
Creating a PDB Resource Plan
278(3)
Enable or Disable a PDB Resource Plan
281(1)
Removing a PDB Resource Plan
281(1)
Manage PDB Memory and I/O via Initialization Parameters
281(2)
PDB Memory Allocations
282(1)
Limit PDB I/O
282(1)
Instance Caging
283(1)
Instance Caging to Resource Manager
283(1)
Monitoring Resource Manager
284(2)
Viewing the Resource Plan and Plan Directives
285(1)
Monitoring PDBs Managed by Resource Manager
285(1)
Summary
286(3)
11 Data Guard
289(30)
Active Data Guard Option
291(1)
Creating a Physical Standby
291(17)
Duplicate with RMAN
292(12)
Create a Standby with Cloud Control
304(4)
Managing a Physical Standby in a Multitenant Environment
308(7)
Creating a New PDB on the Source
309(2)
Removing PDB from Source
311(1)
Changing the Subset
312(2)
Cloud Control
314(1)
Standby in the Cloud
315(3)
Summary
318(1)
12 Sharing Data Across PDBs
319(26)
Database Links
320(2)
Sharing Common Read-Only Data
322(2)
Transportable Tablespaces
322(1)
Storage Snapshots and Copy on Write
323(1)
Cross-PDB Views
324(19)
Simple User Tables
325(4)
Consolidated Data
329(14)
Cross-Database Replication
343(1)
Summary
343(2)
13 Logical Replication
345(20)
Oracle LogMiner
347(1)
Obsolete Features
348(1)
Oracle CDC
348(1)
Oracle Streams
348(1)
Oracle Advanced Replication
349(1)
Oracle GoldenGate
349(12)
Multitenant Support in Oracle GoldenGate
349(10)
Big Data Adapters
359(2)
Oracle XStream
361(1)
Logical Standby
362(1)
Use in Upgrade
362(1)
Other Third-Party Options
363(1)
Dbvisit Replicate
363(1)
Dell SharePlex
363(1)
Summary
364(1)
Index 365
Anton Els is Vice President of Product Development at Dbvisit Software Limited. Els has over 15 years of experience with Oracle technology, with a particular focus on Oracle Database, Backup and Recovery, Standby Databases, Oracle Linux and Virtualization. Els is an Oracle ACE, Oracle Certified Master (OCM) Oracle Database 11g, Oracle Certified Professional (OCP) Oracle Database 8i to 12c, Oracle Certified Expert (OCE) Oracle Real Application Clusters 11g and Grid Infrastructure Administrator and Red Hat 5, RHSA and Oracle Solaris 10 SCSA. Els regularly presents at Collaborate, NZOUG, and LAOTN.





Frank Pachot, Oracle ACE, is an Oracle Technology Leader and Senior Consultant at dbi services with over 20 years of experience with Oracle technology. Pachot is a regular presenter at Oracle OpenWorld, Collaborate, DOAG, SOUG, and UKOUG and an active member of the SOUG and DOAG user groups. He is an Oracle Certified Master (OCM) Oracle Database 11g, Oracle Certified Professional (OCP) Oracle Database 8i to 12c, Oracle Certified Expert (OCE) Oracle Database 12c: Performance Management and Tuning, and holds an Oracle Exadata Database Machine 2014 Implementation Essentials certification.