Oracle Database upgrade and migration methods : including Oracle 12c Release 2 /: including Oracle 12c Release 2. (2017)

• Record Type: Book
• 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 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.
• 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.