Ola pessoal, como estao todos? Espero que bem, ha muito tempo nao falo com voces, mas voltei para terminar aquele artigo sobre atualizacao do Oracle RAC, espero que apreciem o trabalho em conjunto com o meu amigo Thiago Silva. Divirtam-se!!!ATUALIZANDO BINARIOSp { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }Demoreipara escrever essa ultima parte do artigo, eque esses ultimos meses estava super corridor, mas vamos para o queinteressa terminar essa Terceira e ultima parte do artigo. Antes deiniciar a atualizacao do Oracle, vamos aplicar o bundle patch nobinario do Oracle 11.2.0.2 com utilitario OPacth.p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }[oracle@ora-rac01binarios]$ srvctl stop database -d dath[oracle@ora-rac01binarios]$ srvctl status database -d dathAinstancia dath1 nao esta em execucao no no ora-rac01Ainstancia dath2 nao esta em execucao no no ora-rac02 [root@ora-rac02binarios]# ls16459322 16619893 bundle.xml p16742320_112020_Linux-x86-64.zip README.html README.txt[root@ora-rac02binarios]# opatch auto -oh /u01/app/oracle/product/11.2.0.2/db_1-olderverExecuting/u01/app/11.2.0.2/grid/perl/bin/perl/u01/app/oracle/product/11.2.0.2/db_1/OPatch/crs/patch11202.pl-patchdir / -patchn binarios -oh/u01/app/oracle/product/11.2.0.2/db_1 -paramfile/u01/app/11.2.0.2/grid/crs/install/crsconfig_paramsINCis /binarios/16459322/files/crs/install/u01/app/11.2.0.2/grid/crs/install/u01/app/11.2.0.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi/u01/app/11.2.0.2/grid/perl/lib/5.10.0/u01/app/11.2.0.2/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi/u01/app/11.2.0.2/grid/perl/lib/site_perl/5.10.0/u01/app/11.2.0.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi/u01/app/11.2.0.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi/u01/app/11.2.0.2/grid/perl/lib/5.10.0/u01/app/11.2.0.2/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi/u01/app/11.2.0.2/grid/perl/lib/site_perl/5.10.0/u01/app/11.2.0.2/grid/perl/lib/site_perl . opatchauto log file location is/u01/app/oracle/product/11.2.0.2/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2014-06-30_01-25-21.logDetectedOracle Clusterware installUsingconfiguration parameter file:/u01/app/11.2.0.2/grid/crs/install/crsconfig_paramsOPatch is bundled with OCM, Enter the absolute OCM response file path:/u01/app/11.2.0.2/grid/OPatch/ocm/bin/ocm.rsppatch//binarios/16459322/custom/server/16459322 apply successful forhome /u01/app/oracle/product/11.2.0.2/db_1patch//binarios/16619893 apply successful for home /u01/app/oracle/product/11.2.0.2/db_1cd$ORACLE_HOME/rdbms/adminsqlplus /nologSQL> CONNECT / ASSYSDBASQL> STARTUPSQL> @catbundle.sql psu applySQL>QUIT/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_DATH_APPLY_2014Jun30_01_44_15.logp { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }OBundle patch devera ser aplicado em todos os no do Rac, aposaplicar o patch no ultimo no, executei o script catbundle.sql nomeu ultimo no do Rac, conforme saida acima. Apos a aplicacao do Bundle Patch, fiz um backup via RMAN tambem. p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }[oracle@ora-rac01~]$ rman target /RecoveryManager: Release 11.2.0.2.0 - Production on Sun Mar 9 15:03:42 2014Copyright(c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connectedto target database: DATH (DBID=3788767579)RMAN>run {2>allocate channel d1 type disk;3>backup database tag 'BEFORE_UPGRADE';4>backup current controlfile tag 'BK_CF_BEFORE_UPGRADE';5>release channel d1;6>}usingtarget database control file instead of recovery catalogallocatedchannel: d1channeld1: SID=55 instance=dath2 device type=DISKStartingbackup at 09/03/2014 15:04:47channeld1: starting full datafile backup setchanneld1: specifying datafile(s) in backup setinputdatafile file number=00001name=+DATA/dath/datafile/system.256.841354699inputdatafile file number=00002name=+DATA/dath/datafile/sysaux.257.841354701inputdatafile file number=00005name=+DATA/dath/datafile/example.264.841354867inputdatafile file number=00003name=+DATA/dath/datafile/undotbs1.258.841354703inputdatafile file number=00006name=+DATA/dath/datafile/undotbs2.265.841355319inputdatafile file number=00004name=+DATA/dath/datafile/users.259.841354705channeld1: starting piece 1 at 09/03/2014 15:04:47channeld1: finished piece 1 at 09/03/2014 15:05:02piecehandle=+RECO/dath/backupset/2014_03_09/nnndf0_before_upgrade_0.292.841763087tag=BEFORE_UPGRADE comment=NONEchanneld1: backup set complete, elapsed time: 00:00:15Finishedbackup at 09/03/2014 15:05:02Startingbackup at 09/03/2014 15:05:03channeld1: starting full datafile backup setchanneld1: specifying datafile(s) in backup setincludingcurrent control file in backup setchanneld1: starting piece 1 at 09/03/2014 15:05:04channeld1: finished piece 1 at 09/03/2014 15:05:05piecehandle=+RECO/dath/backupset/2014_03_09/ncnnf0_bk_cf_before_upgrade_0.295.841763105tag=BK_CF_BEFORE_UPGRADE comment=NONEchanneld1: backup set complete, elapsed time: 00:00:01Finishedbackup at 09/03/2014 15:05:05StartingControl File and SPFILE Autobackup at 09/03/2014 15:05:05piecehandle=+RECO/dath/autobackup/2014_03_09/s_841763105.296.841763105comment=NONEFinishedControl File and SPFILE Autobackup at 09/03/2014 15:05:06releasedchannel: d1RMAN>list backup of database summary;Listof Backups===============Key TY LV S Device Type Completion Time #Pieces #CopiesCompressed Tag--------- -- - ----------- ------------------- ------- ------- -------------5 B F A DISK 04/03/2014 22:19:09 1 1 YES BKP_FULL10 B F A DISK 09/03/2014 15:04:58 1 1 NO BEFORE_UPGRADERMAN>p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255);