3
数据库升级(11.2.0.3-11.2.0.4)
1459
21页
18次
墨值10
数据库升级文档(11.2.0.3升级到11.2.0.4)
系统环境检查
1.
[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
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
Copyright (c) 1982, 2011, Oracle. All rights reserved.
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
检查升级条件
2.
数据库升级
2019
7
30
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对数据库全备
3.
[oracle@PYBiz /home/oracle]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 25 23:37:07 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
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
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to
关闭数据库和监听
4.
分区 数据库升级(11.2.0.3-11.2.0.4) 的第 2
of 21
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部