Oracle Database upgrade and migration methods : including Oracle 12c Release 2 /: including Oracle 12c Release 2. (2017)
- Record Type:
- Book
- Title:
- Oracle Database upgrade and migration methods : including Oracle 12c Release 2 /: including Oracle 12c Release 2. (2017)
- Main Title:
- Oracle Database upgrade and migration methods : including Oracle 12c Release 2
- Further Information:
- Note: Y V Ravikumar, K M Krishnakumar, Nassyam Basha.
- Authors:
- Ravikumar, Y. V
Krishnakumar, K. M
Basha, Nassyam - 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 ExecutionAt 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. … (more)
- Publisher Details:
- United States : Apress
- Publication Date:
- 2017
- Copyright Date:
- 2017
- Extent:
- 1 online resource
- Subjects:
- 005.74
Computer science
Database management
COMPUTERS -- Databases -- General
Database management
Computer Science
Database Management
Data Storage Representation
Information Storage and Retrieval
Computers -- System Administration -- Storage & Retrieval
Data mining
Information retrieval
Information storage and retrieva
Computers -- Database Management -- General
Databases
Electronic books - Languages:
- English
- ISBNs:
- 9781484223284
1484223284 - Related ISBNs:
- 9781484223277
1484223276 - Notes:
- Note: Online resource; title from PDF title page (Library Ideas, viewed Mar. 10, 2017).
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.353626
- Ingest File:
- 01_312.xml