| Description |
1 online resource |
|
text file PDF rda |
| Note |
Includes index. |
| Contents |
At a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Foreword; Chapter 1: Getting Started; Why Are Database Upgrades Necessary?; New Innovations; Bug Fixes; Supporting Environment; Certification; Database Support Level; Benefits of a Database Upgrade; Hurdles That Affect the Database Upgrade Decision; Types of Database Upgrade; Things to Consider Before Upgrading; Engineers Involved in the Upgrade Activity; Database Administrator; Storage Administrator; System Administrator; Network Administrator; Solution Architect. |
|
Application Team Upgrade Compatibility Matrix; Best Practices for a Database Upgrade; Database Migration; Situations That Demand a Migration; Things to Consider Before Migration; What This Book Covers; Summary; Chapter 2: Database Upgrade Methods; Oracle Binary Relinking; Relinking Process; Known Issues; Database Upgrade Methods; The Database Upgrade Assistant; Prerequisites for the DBUA; Upgrade Compatibility Matrix; Pre-upgrade Checks; Activities Performed by the DBUA; Best Practices with the DBUA; Upgrade Steps; Sample Restore Script; 12c DBUA New Features. |
|
Use Flashback and Guarantee Restore Point DBUA Upgrade Steps; Pre-upgrade Steps; Upgrade Steps; Post-upgrade Steps; How to Make Sure the Upgrade Is Successful; Limitations; Known Issues; DBUA in Silent Mode; Comparison Between 11g R2 DBUA and 12c R1 DBUA; Database Manual Upgrade; Pre-upgrade Tasks; Pre-upgrade Script Execution; Execution Method; 12c Pre-upgrade Execution Method; Pre-upgrade Fixup Script; Post-upgrade Fixup Script; Recommended Steps for the Source Database; Database Backup; Statistics Collection; Time Zone Version; Datafile Status; CONNECT Role. |
|
Database Link with PasswordMaterialized Views; Disable Database Vault; Sysaux Tablespace; Disable Cron or Scheduled Jobs; Sys and System Tablespace; Recycle Bin; Outstanding Distributed Transactions; Flash Recovery Area; Audit User and Roles; Creating Flashback Restore Point; Authenticated SSL Users; Hidden/Underscore Parameters; PSU Patches Installation; Upgrade Steps; If Datafiles Stay in the Same Location After the Upgrade; If the Datafiles Location Is Different from the Source; Execute the Upgrade Script; 12c Upgrade Script Execution; Parallelism; Phases; Post-upgrade Steps. |
|
Upgrade the Time Zone After the Database Upgrade Upgrade Statistics Table; Enable Database Vault; Upgrade Externally Authenticated SSL Users; Enable Hidden Parameter; Comparison Between 11g R2 and 12c R1; Traditional Export/Import; Compatibility Version Matrix; Upgrade Steps; Data Pump; Parallel; Network_link; Remap Datafile; Estimate_only; Version; Stop and Reattach the Job; Upgrade Steps; Transportable Tablespace; Things to Consider; Prerequisites to Perform Transportable Tablespace; Upgrade Steps; Limitations; Advantages; Database Upgrade Using Oracle GoldenGate. |
| Summary |
Learn all of the available upgrade and migration methods in detail to move to Oracle Database version 12c. You will become familiar with database upgrade best practices to complete the upgrade in an effective manner and understand the Oracle Database 12c patching process. So it's time to upgrade Oracle Database to version 12c and you need to choose the appropriate method while considering issues such as downtime. This book explains all of the available upgrade and migration methods so you can choose the one that suits your environment. You will be aware of the practical issues and proactive measures to take to upgrade successfully and reduce unexpected issues. With every release of Oracle Database there are new features and fixes to bugs identified in previous versions. As each release becomes obsolete, existing databases need to be upgraded. Oracle Database Upgrade and Migration Methods explains each method along with its strategy, requirements, steps, and known issues that have been seen so far. This book also compares the methods to help you choose the proper method according to your constraints. Also included in this book: Pre-requisite patches and pre-upgrade steps Patching to perform changes at the binary and database level to apply bug fixes What You Will Learn: Understand the need and importance of database upgrading and migration Be aware of the challenges associated with database upgrade decision making Compare all upgrade/migration methods Become familiar with database upgrade best practices and recommendations Understand database upgrade concepts in high availability and multi-tenant environments Know the database downgrade steps in case the upgraded database isn't compatible with the environment Discover the features and benefits to the organization when it moves from the old database version to the latest database version Understand Oracle 12c patching concepts Who This Book Is For: Core database administrators, solution architects, business consultants, and database architects. |
|
If ітѫs time to upgrade Oracle Database to version 12c, you will need to choose the appropriate method while considering issues such as downtime. This book explains all of the available upgrade and migration methods so you can choose the one that suits your environment. -- Edited summary from book. |
| Subject |
Oracle (Computer file)
|
|
Oracle (Computer file) |
|
Database management.
|
|
Information Storage and Retrieval |
|
Computer Science. |
|
Database Management. |
|
Data Storage Representation. |
|
Information Storage and Retrieval. |
|
Bases de données -- Gestion. |
|
Data mining. |
|
Information retrieval. |
|
Databases. |
|
Database management |
| Added Author |
Krishnakumar, K. M., author.
|
|
Basha, Nassyam, author.
|
| In: |
Springer eBooks |
| Other Form: |
Print version: Ravikumar, Y.V. Oracle Database upgrade and migration methods. [United States] : Apress, 2017 9781484223277 1484223276 (OCoLC)958460731 |
| ISBN |
9781484223284 (electronic bk.) |
|
1484223284 (electronic bk.) |
|
(print) |
|
9781484223291 (print) |
|
1484223292 |
| Standard No. |
10.1007/978-1-4842-2328-4 doi |
|
More Resources