10204RAC裸设备升级112040汇总推荐文档

1、1020.4 RAC 裸设备升级112040项目ID :文件序号：文件编号：密级：总页数：19数据库升级11gR2方案版本拟制2013/10/25审核批准本文件所有权和解释权归所有,*书面许可，不得复制或向第三方公开。This document is the property of * and can be neither reproduced nor disclosed to a third party without a writtenauthorizati on.修订历史记录（A- 添加，M-修改，D-删除）1方案介绍目前现网数据库 Oracle 10.2.0.4 RAC 升级到11.2

2、.0.4方法主要有3种,一种是直接手工升级的方式，二种是通过dbua升级，即在现有生产环境中将数据库版本从10gr2升到11gr2，三种是采用异机迁移升级的方式实施，根据目前资源情况，我们计划采用第二种方式进行数据库升级。我们这里讲的是 Linux 5.5 10.2.0.4 RAC裸负备升级到11.2.0.4，dbua升级方式，针对 AIX平台有所不同。说明:迁移升级相对于直接升级的风险性相对较低,但是需要的硬件资源较多， 就目前硬件资源来说， 不能满足 迁移升级条件。2操作时间评估操作项目估算用时回退用时实际用时前期环境准备22CRS升级至y GRID325DB升级6393操作步骤4.对or

3、acle10g 环境备份1、 升级前须增加一个scan ip跟VIP同一网段。oralnventory、asm disk header、ocr、2、做安装前必须对原有 oracle 10g数据以及环境作备份，备份的内容有 votedisk、/etc/oratab、用户环境变量，Unset Oracle用户所有的环境变量 在安装11g GI之前备份10g CRS环境配置文件的操作步骤 1、disable服务器自动启动 CRS 以root用户执行：$CRS_HOME/bin/crsctl disable crs2、在/etc目录下新建/etc/10gcrs_bak目录作为备份文件存放的目录以roo

4、t用户登录cd /etc mkdir 10gcrs_bak3、将以下需要备份的文件和文件夹进行备份 以root用户登录，备份文件：Page 3 of 18cp -p /etc/inittab/etc/10gcrs_bak/inittabcp -p /etc/init.crs/etc/10gcrs_bak/init.crscp -p /etc/init.crsdcp -p /etc/init.cssdcp -p /etc/init.evmd/etc/10gcrs_bak/init.crsd/etc/10gcrs_bak/init.cssd/etc/10gcrs_bak/init.evmdcp -

5、p /etc/oratab/etc/10gcrs_bak/oratabcp -p /etc/oraInst.loc/etc/10gcrs_bak/oraInst.loccp -p /usr/local/bin/dbhome /etc/10gcrs_bak/dbhome cp -p /usr/local/bin/coraenv /etc/10gcrs_bak/coraenv cp -p /usr/local/bin/oraenv /etc/10gcrs_bak/oraenvcp -f /etc/oracle/etc/10gcrs_bakcp -f /oracle/product /oracle/

6、product_bak4.1创建文件系统、用户组创建文件系统，大小50GB，属主oracle:oinstall。id oracle uid=200(oracle) gid=200(oinstall) grou ps=200(oinstall),201(dba) group add -g 1020 asmadmin group add -g 1021 asmdba group add -g 1022 asm opergroup add -g 1032 oper usermod -g oinstall -G dba, op er,asmadmin,asmdba,asm oper oracle id

7、 oracle uid=200(oracle) gid=200(oinstall) grou ps=200(oinstall),201(dba),1020(asmadmin),1021(asmdba),1022(asm op er),1032(o per)-创建文件夹 rootrac1 # mkdir -p /oracle/a pp /11.2.4/grid rootrac1 # mkdir -p /oracle/a pp /11.2.4/db_1 rootrac1 # chown -R oracle:oinstall /oracle-禁用ntp服务 #service ntpd stop#ch

8、kconfig ntpd off #mv /etc/nt p. conf /etc/nt p.conf.orig #rm /var/run/nt pd.pid4.2停应用4.3停监听IsnrctI stop4.4停数据库NFS-开起flashback，需要共享盘，如果有存储更好，如果没有就用-查询是否有开起SQL select flashback_on from V$database;FLASHBACK ONNOSQL alter system set db_recovery_file_dest_size=200G scop e=both;SQL alter system set db_rec

9、overy_file_dest=/flashback/ scop e=both;SQL shutdown immediateSQL start up mountSQL alter database archivelog;SQL alter database flashback on;SQL alter database open;SQL select flashback_on from V$database;1020.4 RAC 裸设备升级112040FLASHBACK ONYES-创建数据库还原点，这点很重要，如果升级失败可以 flashback升级前。create restore po i

10、nt up11pre guarantee flashback database;4.5设置环境变量-设置Oracle用户环境变量，因为是11g R2 RAC升级，如果创建Grid用户，升级会报错.所以我们只需要配置Oracle用户.为了让Oracle用户轻松切换不同的环境变量，我们先创建一个基本的环境变量把共通点列在里面，然后在我们在创建 grid_env和db_env两个文件来存放异同点，方便切换.-以grid用户登录，编辑Profile配置文件，添加配置信息如下: oraclerac1 $ cp .bash_ profile .11bash_ profileoraclerac1 $ vi

11、.11bash _p rofile # Oracle SettingsTMP=/t mp;export TMP TMP DIR=$T MP;export TMP DIRORACLE_HOSTNAME=nydba-test1;export ORACLE_HOSTNAMEORACLE_BASE=/oracle/a pp;export ORACLE_BASEGRID_HOME=/oracle/a pp /11.2.4/grid;export GRID_HOMEDB_HOME=$ORACLE_BASE/11.2.4/db_1;export DB_HOMEORACLE_HOME=$DB_HOME;exp

12、ort ORACLE_HOMEORACLE_SID=centerdb1;export ORACLE_SIDORACLE_TERM=xterm;export ORACLE_TERMBASE_ PATH=/usr/sbin:$ PATH;export BASE _P ATHP ArH=$ORACLE_HOME/bin:$BASE_ PA TH;export PATHLD_LIBRARY_PA TH=$ORACLE_HOME/lib:/lib:/usr/lib;export LD_LIBRARY_PA THCLASS PATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$

13、ORACLE_HOME/rdbms/jlib;export CLASS PATHPage 5 of 18if $USER = oracle ; thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fi fi alias gnd_env=. /home/oracle/gnd_env alias db env=. /home/oracle/db env export DIS PLAY=192.168.182.60:0.0 -vi grid_env 女口下所示:ORACLE_

14、SID=+ASM1;export ORACLE_SIDORACLE_HOME=$GRID_HOME;export ORACLE_HOMEP ATHuWORACLEHOME/binMBASEPA TH;export PATHLD_LIBRARY_PA TH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PA THCLASS PATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export CLASS PATH -vi db env 如下所示：ORACLE_SID=ce

15、nterdb1; export ORACLE_SID ORACLE_HOME=$DB_HOME;export ORACLE_HOMEP ArH=$ORACLE_HOME/bin:$BASE_ PA TH;export PATHLD_LIBRARY_PA TH=$ORACLE_HOME/lib:/lib:/usr/lib;export LD_LIBRARY_PA THCLASS PATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export NLS_LANG=american_america.UTF8 export C

16、LASS PATH4.6升级前检查是否满足升级条件./runcluvfy.sh stage -pre crsinst -upgrade -n nydba-test1,nydba-test2 -rolling -src_crshome /oracle/crs -dest_crshome/oracle/a pp/11.2.4/grid -dest_vers ion 11.2.0.4.0 -fix up -fix up dir /home/oracle/fix up scri pt -verbose 1020.4 RAC 裸设备升级1120404.7使用Oracle用户进行安装升级首先应用新的环境变

17、量，切换到grid_env进行安装.oraclerac1 $ source .11bash_ profile oraclerac1 $ grid_e nv oraclerac1 t mp$ echo $ORACLE_HOME/oracle/a pp/11.2.4/gridoraclerac1 tm p$ echo $ORACLE SID +ASM1ORACLE*4.8升级CRSDownload Software Up datesP age 11 of 18Download Software UpdatesY f f f f战pp忡 Software UpdatesFnst 1 atio n 0

18、匚 tionrnsta latic n TynetZIu-er CTfificuraT： jn-if 1 I LoLation：匚IEck:Dowiload soflware updates forthis installaTlon. Software updates consist of re匚ommended updates To the installer system requiremeni checks, pitchset upd&ies (P5UsX and othtr recommendtd patches.Select one of the following options:

19、_i Use My Oracle Support credentials for doutnloac)I riiroz Ser ncs二ewiUfi ir- fi.f/Use pre-dovunloadtd software update?ini.十HI I UHI.II皆 I *1 Skip software updates匚 a nceJ-这里选择第三项 ：Up grade Oracle Grid In frastucture or Oracle Automatic Storage Man ageme ntOracle Grid Infrastructure - Betting up Gr

20、id Infrastructure - Step 2 of 9Select Installation OptionORAO-E qqg DATABASE I ITYTT平丫丫丫7Dowiload Software UedgtesInstallation OptionInnallalicin TypejLmie厂匚 onfigurationI代Tall LocationsPrerequisite ChecksSummaryInstall ProductFinishSelea any of the folio湖ng 泊巩社II茁Ion optionsO Instil I and Configure

21、 Oracle Grid Infraitructure for i iluiterO Corifigure Oracle Gnd Infrastructure for a 垃andalone Server JJpgrade Oracle Grid Infrastructure or Oracle Automatic Storage Managemienit曾 O Install Oracle irid Infrastructure Softy胞鳥 Only J i in stall Cancel j ”JiSOracle Grid Infrastructure - Setting up Gri

22、d Infrastructure - Step 3 of 9Select Product LanguagesORACLE qqg DATABASE I I(-fTTT7InstalMon OptionProduct LanguagesOperating Svstem Groupsml：rif卩rerequisi*e ChucksSummaryIrstall ProductFinishSelea thE languagEi in Mith your product run.期 ailab It La怦ages:ArabicBengaliBrazilian Portuguese Bulgarian

23、Canadian FrenchCat al anCroatianCzechDanishDutchEgyptianEnglish Untfd Kirigdom) EstonianFifiniJh French Crm anGretk Hebrew Hungarian IcelsridicIndone 引耳 nCancelI | |fleeted Languages; EnglishLL 暨 iT-以上有图片没有保存，主要是检查没有问题就可以一直下一步。3Page 15 of 18Install ProductORACLE qqg DATABASE I IDo. nir ad Sof；曲re Up

24、datesProduc? 7 nguagesNoce 沏Eon-Progress；L.片! I * 尸.5*LHecULr LuniryuiitripLt76$CAhJ Infai-maTionASM Monitor Passwor-dOperating System 匚5”口：Scripts to be executed：AInstall珀icin I acai ionPrerequisi-p花：卜 ummajyInstall ProductFinishjjumb&r|ytnpt Lor at ionINodes/orai:le/app/11.2.0FgndJrooujpgacl&.5h r

25、achrat?dtd Jed Jed 花d zled zledress3The following confjgurartion scriprts reed to be executed as the root user in each new cluster node. Each script in the lit below is followed by a lit of nodes.To execuie The configuraTion scripis:1. Open a ternninal window2 Log In as root?. Run the scripts In eac

26、h cluster node4. Return to this window and click OtC to contirue:耳stalablaRun the script on the local node first. After suecessful compleTion, you car run the script in parallel on all the other nodes, except a rode you designate as the last node. When all the nodes except the last node are done suc

27、cessfully run The scrip! on the last node.HelpOK匚ant&l -ROOT执行，升级完之后检查 Qcr和votedisk还是使用裸设备的.oraclerac1 $ ocrcheckStatus of Oracle Cluster Registry is as follows :Version:3Total space (kbytes):517828Used sp ace (kbytes):6212Available space (kbytes):511616ID:1423844012Device/File Name:/dev/raw/raw1Dev

28、ice/File Name:/dev/raw/raw2Device/File in tegrity check succeededDisk Croup NameOCR2d10.2.0.4 RAC裸设备升级11.2.0.4.0Cluster registry in tegrity check succeededDevice/File not con figuredoraclerac1 $ crsctl query css votedisk0.0/dev/raw/raw30.0/dev/raw/raw40.0/dev/raw/raw5located1 votedisk(s).-这里把CRS迁移到G

29、RID，建一个 DG。Create Disk GroupRedundancyRedundancy is achieved by Storing multiple copies of The data on different failurE groups. Normal rEdundancy needs disks from at lean two different failure groups, and high redundancy from it ltt three different failurs groups.r.ii High 11 Normal h , ExTeiTial (

30、None)Select Membtr Disks(X ShowEligibk ShowAIIQuorum failure groups art us#d to stort volirg flies n txt ended clusters and do not contain ary user dat4. They re quirt ASM compatibility of 11.2 or hightr.厂Disk P虫hHeader StatusDisk NameSi2e (ME)Quorum/clev/raw/rawCANDIDATE1013厂Note: If you do not see

31、 the disks 4hkh you believe are available, checkthe DiskDIscovery Path and re ad/write permissions on the disks. The Disk Discovery Pbth m its set of disks considered for discoveryChange Disk Discovery PathDisk Discovery Path:匚lick on the ShowAdvanced Options button to changt the disk group anribuHf

32、is. Disk Group compatibility attributes miy need to b modified based on the usage of dbk group for different versions of databases or Cluster File Systems.ShowvAdvanced OptionsOK 11 CancelHelp I-迁移OCR至q ASM rootrac1 bin# ./ocrc onfig -add +ocr rootrac1 bin# ./ocrc onfig -delete /dev/raw/raw1 rootrac

33、1 bin# ./ocrc onfig -delete /dev/raw/raw2 oraclerac1 $ ocrcheckStatus of Oracle Cluster Registry is as follows : Versio n5178286236Total space (kbytes)Used space (kbytes)Available sp ace (kbytes) :511592ID:1423844012Device/File Name :+ocrDevice/File in tegrity check succeededDevice/File not con figu

34、redDevice/File not con figuredDevice/File not con figuredDevice/File not con figuredCluster registry in tegrity check succeededLogical corr up tio n check byp assed due to non-p rivileged user-迁移 VOTEING DISK 至U ASMoraclerac1 $ crsctl rep lace votedisk +ocrCRS-4256: Up dati ng the p rofileSuccessful

35、 addition of vot ing disk 4d0798b6cd214fb1bf8b201b69497a20.Successful deletion of vot ing disk 24837164cd2aef11ff7dfe4c65ee3ba9. Successfully rep laced vot ing disk group with +ocr.CRS-4256: Up dati ng the p rofileCRS-4266: Vot ing file(s) successfully rep laced oraclerac1 $ crsctl query css votedis

36、k# STATE File Un iversal IdFile Name Disk group 1. ONLINE 4d0798b6cd214fb1bf8b201b69497a20 (/dev/raw/raw6) OCRLocated 1 vot ing disk(s).到此,我们已经把裸设备上的 OCR和VOTEING DISK迁移到了 ASM中,接下来就是最后升级 DB.4.9升级DB-停数据库srvctl stop database -d cen terdb-开始安装运行./runinstaller-中间图片省掉，如果不出问题都是下一步，只说重点1020.4 RAC 裸设备升级11204

37、0P age # of 18T Orad Database llgi Release 2 Installer - InstdUbg database - Step 1 of 11Configure SecuritY UpdatesORACLe “gDATABASE I IConfigure Security UpdatesProvide your email address to be informed of iecurity issues, install the product and initio* configuration manager, W电wdetails.Dovm! I Qa

38、ri Software UpEmail:TTT平ns(i atiL n C pNo -tZri：t nss at c-i Op*ior(?nstall TypeTyp cal I rstal ition-rertquL- te Creeps-urriii arvnsti 1 f r. dULiNri;-Easierfaryou if you use your My Oracle Support email addrtss/username.I I I wish to receive security updates via My Oracle Support.O Tie厂r SV - dCan

39、cel -下一步很重要， Degree of Parallelism是你跑脚本的并行数，这根据服务器CPU个数来定，这里最好先10这样跑脚本就很快，不然要几个小时。10.2.0.4 RAC 裸设备升级 11.2.0.4.0Page 17 of 18E5Database Upgrade Assistant, Step 1 of 3: Upgrade Options二jnl 凶Upgrade process will invalidate objects in the database Oracle recommerds re匚mpiling of invalid objects as a par

40、t of upgrade.Eased on the number of CPUs Oracle has set the following default degree of parallelism. Parallel recompilatior reduces the recompilation time.IRecompile invalid otijects at the end of upgradeDegree of Paraiieilsnn: 匕Oracle recommends upgrading Time sone version and TIMES?AMP WITH TIME Z

41、ONE dara of the database. Oracle */ill handle semantic errors automatically. If errors occur durino the timezone upgrade, you may need to restore the database from the backup.炉蚯6面5匸|击offv五s订n哥石5皿一苛丽pi亦斤H亍帀己?帀7巨01石祜L -1严二；a萨nCancel J Help Jg Eack Next 1020.4 RAC 裸设备升级112040-到这里DB就升级完成，如果中间跑脚本岀错，那就要详细

42、检查。-最后检查是否有失效对象。select alter |object_t yp e| |ow ner|.|object_ name| comp ile; from dba_objects awhere (a.ow ner, a.object_ name) in(select owner, object_ name from dba_objects )and a.status = INVALID;LoradeOnydbatcst2 product.$crs_stat -tVTargetStaleNameTypeR/RAF/KTora.ER. Isnrora. . . . er. type0/

43、50/OMLINEONLINEnydba-lesllor a.HlIsnrra. er. type0/50/0ONLINEONLINEnydba-lesl2ora.OCR, dsQra.,. up. type0/50/OHLINE0 肛 INEnydba-testlora.asmora. asm. lype0/50/OHLIHEONLINEnydba-tesllora.erdb. dbora. . . . se. type1/20/1OMLINEONLINEnydba-lesllra.cvura. cvu. type0/50/0ONLINEONLINEnydba-tesl2ra.gsdora.

44、 gsd. type0/50/OFFLINEOFFLINEora.workora. . . . rk. type0/50/OHLINEONLINEnydba-tesllora.SMI. asmapplication0/50/0ONLINEONLINEnydba-lesllor a.TlIsnrapplication0/50/0ONLINEONLINEnydba-tesllra.,.stL gsdapplication0/50/0OFFLINEOFFLINEora.sll. onsapplication0/30/0ONLINEONLINEnydba-tesllora.stl. vipora. .

45、 . . tl. type0/01/0OHLINEONLINEnydba-tesllor a.SH2 asmapplication0/50/0ONLINEONLINEnydbatesl2ra.,.T2. Isnrapplication0/50/0ONLINEONLINEnydba-tesl2ra.st 2. gsdapplication0/50/0OFFLINEOFFLINEora.st2. onsapplication0/30/0ONLINEONLINEnydba-lesl2or a.vipra. * .tl. type0/00/0ONLINEONLINEnydbates-t2ra.oc4j

46、口ra. oc4j. type0/10/2ONLINEONLINEnydba-tesllora.onsora. ons. type0/30/ONLINEONLINEnydba-tesllor a.ry. acfsora. . . . fs. type0/50/OHLINEONLINEnydb且-test 1or a.scanl. vipora, * * ip, type0/00/0OHLIHEONLINEnydbates-t2-通过gv视图可以看到为11.2.0.4.0oracleracl bin$ 12G. 15. nydba-tesllckgvinstceINETANCENOEHOET_H

47、AMEVEREIOHSTARTUP._TIMESTATUSIPARALLELcenterdblnydba-testl11.2.0.4. 02013-10-24 17:21:33OPEN】fEScenterdbSnylba-test2IL 2,0.4.0013-10-24 17:13:08OPEN1fES4.10启应用进行测试4.11应用检查5.回退方案:当升级过程失败，都需要进行回退，但是由于在升级的不同阶段，回退方案不同，可分为如下几种情况-整个升级完成后还是使用裸设备，如果你原来就是 然你可以把数据库迁移到ASM进行管理。-可以通过ocrcheck检查OCR使用的是+ocrASM就可以直接

48、升级到 ASM ,只是CRS迁移到了 ASM，当1、GRID INFRASTRUCTURE OUI 安装失败P age 21 of 18在这种情况下，未执行脚本，未对ocr的信息进行更改，所以只需查看oralnventory是否被更改，如果被更改则执行以下步骤回退，如果未更改orainventory则直接删除NEW_ORACLE_HOME 即可。export ORACLE_HOME=$OLD_HOME# detach failed NEW HOME:$OLD_HOME/oui/bin/runInstaller -detachHome -silent -local ORACLE_HOME=$NE

49、W_HOME # confirm $NEW_HOME is removed from central inventory:$OLD_HOME/OP atch/o patch lsinventory -all# remove files in failed NEW_HOME manually/bin/rm -rf $NEW_HOMEunset ORACLE HOME2、当执行 rootupgrade.sh 失败1、# $NEW_HOME/crs/install/rootcrs.pl -downgrade -force如果两个节点均未成功执行，则跳过上一条命令2、# $NEW_HOME/crs/install/rootcrs