数据库升级（11.2.0.3-11.2.0.4）

胡欢

2500

21页

22次

2019-09-11

10墨值下载

数据库升级文档(11.2.0.3升级到11.2.0.4)

系统环境检查

[oracle@PYBiz /home/oracle]$ sqlplus -v

SQL*Plus: Release 11.2.0.3.0 Production

Linux版本：

[oracle@PYBiz /home/oracle]$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.5 (Santiago)

[oracle@PYBiz /home/oracle]$ uname -a

Linux oracleupgradetest 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64

x86_64 x86_64 GNU/Linux

Oracle版本：

[oracle@PYBiz /home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 25 23:25:42 2019

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME

---------

PYBIZ

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 – Production

SQL> col comp_name for a35

SQL> col version for a20

SQL> col name for a20

SQL> set linesize 1000

SQL> set pagesize 1000

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

COMP_NAME VERSION STATUS

----------------------------------- -------------------- --------------------------------------------

OWB 11.2.0.3.0 VALID

Oracle Application Express 3.2.1.00.12 VALID

Oracle Enterprise Manager 11.2.0.3.0 VALID

检查升级条件

数据库升级

2019

年

月

日

8:38

分区数据库升级（11.2.0.3-11.2.0.4）的第 1 页

Oracle Enterprise Manager 11.2.0.3.0 VALID

OLAP Catalog 11.2.0.3.0 VALID

Spatial 11.2.0.3.0 VALID

Oracle Multimedia 11.2.0.3.0 VALID

Oracle XML Database 11.2.0.3.0 VALID

Oracle Text 11.2.0.3.0 VALID

Oracle Expression Filter 11.2.0.3.0 VALID

Oracle Rules Manager 11.2.0.3.0 VALID

Oracle Workspace Manager 11.2.0.3.0 VALID

Oracle Database Catalog Views 11.2.0.3.0 VALID

Oracle Database Packages and Types 11.2.0.3.0 VALID

JServer JAVA Virtual Machine 11.2.0.3.0 VALID

Oracle XDK 11.2.0.3.0 VALID

Oracle Database Java Packages 11.2.0.3.0 VALID

OLAP Analytic Workspace 11.2.0.3.0 VALID

Oracle OLAP API 11.2.0.3.0 VALID

SQL> SELECT name, value FROM v$parameter WHERE name = 'compatible';

--------------------

NAME VALUE

Compatible 11.2.0.0.0

利用rman或者expdp对数据库全备

[oracle@PYBiz /home/oracle]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 25 23:37:07 2019

connected to target database: PYBIZ (DBID=3305572884)

RMAN> backup database plus archivelog delete input format '/home/bak/full_%U.dbf';

报错：（原因是我将归档关闭了）

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/25/2019 23:39:16

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

从理论上来说不需要，但是noachivelog 时rman 只能备份mount 状态下的database.

所以，在实际应用中，为了达到能用热备份，还是要求db处于achivelog

EXPDP:

Expdp huhuan directory=expdp dumpfile=pybiz0725.dmp schemas=PYBiz logfile=0725.log

RMAN:

关闭数据库：

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

关闭监听：

[oracle@PYBiz /home]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 26-JUL-2019 00:28:23

Connecting to

关闭数据库和监听

分区数据库升级（11.2.0.3-11.2.0.4）的第 2 页

of 21

10墨值下载

oracle 安装部署方案特别推荐

关注

评论