Oracle 19c - 手动升级 Oracle 12.x, 18c Container database (CDB) 到 Oracle 19c (19.x) 的完整核对清单

章芋文

1883

11页

16次

2019-12-20

5墨值下载

Copyright (c) 2019, Oracle. All rights reserved. Oracle Confidential.
Oracle 19c -   Oracle 12.x, 18c Container database (CDB)   Oracle 19c (19.x) 
 (Doc ID 2610728.1)
 
   19c CDB 
  Step 1:   CDB / PDB 
  Step 2:  /  
  Step 3 
  Step 3.1   Preupgrade 
  Step 3.2 
  Step 3.3   Oracle 
  Step 3.4   SYS   SYSTEM 
  Step 3.5 
  Step 3.6 
  Step 3.7   TIMESTAMP WITH TIMEZONE 
  Step 3.8  media recovery
  Step 3.9 
  Step 3.10   Outstanding Distributed Transactions 
  Step 3.11   12.2   Oracle Database Vault 
  Step 3.12 
  Step 3.13 Schema-Only   EXPIRED 
  Step 3.14   Transparent Encryption Oracle 
  Step  3.15 
  Step 3.16 Network Utility 
  Step 3.17 
  Step 3.18   cron job
  Step 3.19 
 
  Step 4  Oracle Home
  Step 5 
  Step 6 
:
Oracle Database - Enterprise Edition -   12.1.0.2   19.3.0.0.0 [  12.1   18]

12c 18c CDB Oracle 19c

19c CDB

Oracle 19c

11.2.0.4 19c

12.1.0.2 19c

12.2.0.1 19c

18.1 19c

Oracle 12.1.0.2 19c

12.1.0.2 19c

Step 1: CDB / PDB

CDB PDB Oracle /

Doc Id 556610.1 - Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)

dbupgdiag.sql SQL

db_upg_diag_<sid>_<timestamp>.log

sys system schema

Oracle PSU Proactive Bundle Patch / RU Refer Doc Id -

2118136.2

before/after DDL

CLUSTER_DATABASE FALSE

TRUE

pre-upgrade preupgrade.jar preupgrade log

Doc ID 1406586.1 - How to Handle Materialized Views When You Upgrade or Clone a Database

of 11

5墨值下载

19c oracle 升级迁移方案

关注

评论