探索Oracle之数据库升级六
11.2.0.4.3 Upgrade12c(12.2.0.1)
一、前言：
Oracle 12c发布距今已经一年有余了，其最大亮点是一个可以插拔的数据库(PDB)，这是在之前版本没有的；但是如果我们要将以前版本的数据库升级到12c来，那么也应顺其自然的将其变成一个pdb，那么我们的工作不仅包含了数据库软件的升级，同时也包含如何将一个NO-CDB的数据库plug to CDB none。
二、升级要求:
三、升级前准备:
3.1、查看数据库版本及补丁信息
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 ? Production SQL> show parameter name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cell_offloadgroup_name string db_file_name_convert string db_name string woo db_unique_name string woo global_names boolean FALSE instance_name string woo lock_name_space string log_file_name_convert string processor_group_name string service_names string woo SQL> set pagesize 500 SQL> set line 300 SQL> col comp_name format a40 SQL> col comp_name format a35 SQL> col version format a15 SQL> col status format a7 SQL> select comp_name,version,status from dba_registry; COMP_NAME VERSION STATUS ----------------------------------- --------------- ------- Oracle Enterprise Manager 11.2.0.4.0 VALID OWB 11.2.0.3.0 VALID Oracle Application Express 3.2.1.00.12 VALID OLAP Catalog 11.2.0.4.0 VALID Spatial 11.2.0.4.0 VALID Oracle Multimedia 11.2.0.4.0 VALID Oracle XML Database 11.2.0.4.0 VALID Oracle Text 11.2.0.4.0 VALID Oracle Expression Filter 11.2.0.4.0 VALID Oracle Rules Manager 11.2.0.4.0 VALID Oracle Workspace Manager 11.2.0.4.0 VALID Oracle Database Catalog Views 11.2.0.4.0 VALID Oracle Database Packages and Types 11.2.0.4.0 VALID JServer JAVA Virtual Machine 11.2.0.4.0 VALID Oracle XDK 11.2.0.4.0 VALID Oracle Database Java Packages 11.2.0.4.0 VALID OLAP Analytic Workspace 11.2.0.4.0 VALID Oracle OLAP API 11.2.0.4.0 VALID 18 rows selected. [oracle@db01 OPatch]$ ./opatch lspatches 18522509;Database Patch Set Update : 11.2.0.4.3 (18522509)
3.2、备份数据库
[oracle@db01 Phycal]$ pwd
/DBBackup/Phycal
[oracle@db01 Phycal]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 20 04:41:01 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: WOO (DBID=4199532651)
RMAN> run{
2> allocate channel chan_name type disk;
3> backup database format '/DBBackup/Phycal/WOO%U.bak' TAG before_upgrade;
4> BACKUP CURRENT CONTROLFILE;
5> }
using target database control file instead of recovery catalog
allocated channel: chan_name
channel chan_name: SID=28 device type=DISK
Starting backup at 20-NOV-14
channel chan_name: starting full datafile backup set
channel chan_name: specifying datafile(s) in backup set
input datafile file number=00001 name=/DBData/woo/woo/system01.dbf
input datafile file number=00002 name=/DBData/woo/woo/sysaux01.dbf
input datafile file number=00003 name=/DBData/woo/woo/undotbs01.dbf
input datafile file number=00004 name=/DBData/woo/woo/users01.dbf
channel chan_name: starting piece 1 at 20-NOV-14
channel chan_name: finished piece 1 at 20-NOV-14
piece handle=/DBBackup/Phycal/WOO0apo2ar4_1_1.bak tag=BEFORE_UPGRADE comment=NONE
channel cha