数据库|mysql教程
Oracle数据库升级,Oracle数据库的升级(10gR2
数据库-mysql教程
软件管家 网站源码,ubuntu 右键菜单删除,微服务要tomcat吗,爬虫post传递,php设置dns,康平创新抖音seo优化价格大全lzw
今天对Oracle数据库升级做了大致了解,还是很多东西值得考虑的。 首先,升级前的准备就很多工作需要做: 1. 测试和准备, 主要是
vfp 抽奖 源码,vscode界面好丑,Ubuntu查看内存情况,tomcat对比,网页读写sqlite,apache服务器下载zip,截取头像的flash插件,学前端开发框架,屏蔽谷歌爬虫,php培训机构怎么样,谢盼龙seo,凡诺1.8网站管理系统,网页抽奖软件,风格吧模板,导航栏根据页面的,班级管理系统下载,vs串口通信源程序lzw
动态网页源码,ubuntu查电脑配置,tomcat运行时异常,爬虫网易音乐,寮步php培训学校,荣县seolzw
今天对Oracle数据库升级做了大致了解,还是很多东西值得考虑的。
首先,升级前的准备就很多工作需要做:
1. 测试和准备, 主要是应用的做压力测试。因为版本升级,,优化器可能使SQL性能回退(选择性能更差的执行计划),可以结合database replay做压力测试,SPA模拟环境变化的影响,以及SPM对执行计划做固定。
2. 升级的方法, 主要是图形界面DBUA(新目录的路径)来完成,相对简单;手工升级(手工执行脚本、DBUA只不过将这些手工动作代替而已、新目录路径);EXPDP(源库路径)/IMPDP(新库路径)等等。
其中,以下几种方法可以支持滚动升级:
可以看得出,升级的方案多样,根据不同的环境而定。
3. 升级前,务必将新库路径下$ORACLE_HOME/rdbms/admin/utlu112i.sql脚本拷至源库执行,主要是检查当前环境(如表空间大小,隐含参数,警告或建议)是否合适做升级,我们可以根据警告和建议做相应调整。
以下粘出单机数据库的升级实验步骤,供参数,由10.2.0.5升级至11.2.0.3.
时间允许的话,将做RAC的升级并更新文章
======================================================================================================
A、源库–备份
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
backup AS BACKUPSET full tag ‘db_full’ format ‘/backup/db_%d_%T_%s_%U.bak’ database include current controlfile;
sql ‘alter system archive log current’;
release channel ch4;
release channel ch3;
release channel ch2;
release channel ch1;
}
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /arch/ora10g
Oldest online log sequence49
Next log sequence to archive 51
Current log sequence 51
B、源库 — 运行脚本utlu112i.sql,做升级前检查
[oracle@tivoli02 backup]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 – Production on Mon Jan 26 20:27:42
Copyright (c) 1982, , Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> spool /tmp/upgrade_info.log
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlu112i.sql
打印内容如下:
================
SQL> @/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 01-26- 20:34:56
Script Version: 11.2.0.3.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
–> name: ORA10G
–> version: 10.2.0.5.0
–> compatible: 10.2.0.5.0
–> blocksize: 8192
–> platform: Linux x86 64-bit
–> timezone file: V4
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 643 MB
–> UNDOTBS1 tablespace is adequate for the upgrade.
…. minimum required size: 400 MB
–> SYSAUX tablespace is adequate for the upgrade.
…. minimum required size: 433 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 60 MB
.
**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************
–> If Target Oracle is 32-Bit, refer here for Update Parameters:
— No update parameter changes are required.
.
–> If Target Oracle is 64-Bit, refer here for Update Parameters:
— No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
— No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
–> sql_trace 10.2DEPRECATED
–> background_dump_dest 11.1DEPRECATED replaced by “diagnostic_dest”
–> user_dump_dest 11.1DEPRECATED replaced by “diagnostic_dest”
.
如果觉得《Oracle数据库的升级(10gR2至11gR2)》对你有帮助,请点赞、收藏,并留下你的观点哦!