Cargando…

Oracle Database upgrade and migration methods : including Oracle 12c Release 2 /

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 upgrad...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Ravikumar, Y. V (Autor), Krishnakumar, K. M. (Autor), Basha, Nassyam (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [United States] : Apress, 2017.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.