当前位置: 首页 > news >正文

Oracle升级回退:10.2.0.4 crs升级到11.2.0.4 回退方案

我们的文章会在微信公众号IT民工的龙马人生和博客网站( www.htz.pw )同步更新 ,欢迎关注收藏,也欢迎大家转载,但是请在文章开始地方标注文章出处,谢谢!
由于博客中有大量代码,通过页面浏览效果更佳。

Oracle升级回退:10.2.0.4 crs升级到11.2.0.4 回退方案

1,停数据库

$ srvctl stop instance  -d sol -i sol1 -o abort 
$ srvctl stop instance  -d sol -i sol2 -o abort

2,deconfig gi的信息

两个节点同时执行这个操作

# .//crs/install/rootcrs.pl -verbose -deconfig -force
Using configuration parameter file: crs/install/crsconfig_params
Network exists: 1/192.168.111.0/255.255.255.0/e1000g0, type static
VIP exists: /sol1-vip/192.168.111.48/192.168.111.0/255.255.255.0/e1000g0, hosting node sol1
VIP exists: /sol2-vip/192.168.111.49/192.168.111.0/255.255.255.0/e1000g0, hosting node sol2
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'sol1'
CRS-2673: Attempting to stop 'ora.crsd' on 'sol1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'sol1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'sol1'
CRS-2675: Stop of 'ora.oc4j' on 'sol1' failed
CRS-2679: Attempting to clean 'ora.oc4j' on 'sol1'
CRS-2681: Clean of 'ora.oc4j' on 'sol1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'sol1' has completed
CRS-2677: Stop of 'ora.crsd' on 'sol1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'sol1'
CRS-2673: Attempting to stop 'ora.crf' on 'sol1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'sol1'
CRS-2673: Attempting to stop 'ora.evmd' on 'sol1'
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'sol1'
CRS-2677: Stop of 'ora.mdnsd' on 'sol1' succeeded
CRS-2677: Stop of 'ora.crf' on 'sol1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'sol1' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'sol1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'sol1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'sol1'
CRS-2677: Stop of 'ora.cssd' on 'sol1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'sol1'
CRS-2677: Stop of 'ora.gipcd' on 'sol1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'sol1'
CRS-2677: Stop of 'ora.gpnpd' on 'sol1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'sol1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
updating /platform/i86pc/boot_archive
Removing Trace File Analyzer
Successfully deconfigured Oracle clusterware stack on this node

3,还原文件

两个节点都要执行

# mv /soft/backup.tar /
# tar -xvf backup.tar
x ./etc/init.d/init.cssd, 53790 bytes, 106 tape blocks
x ./etc/init.d/init.crs, 2236 bytes, 5 tape blocks
x ./etc/init.d/init.crsd, 4950 bytes, 10 tape blocks
x ./etc/init.d/init.evmd, 3232 bytes, 7 tape blocks
x ./var/opt/oracle, 0 bytes, 0 tape blocks
x ./var/opt/oracle/oraInst.loc, 58 bytes, 1 tape blocks
x ./var/opt/oracle/oprocd, 0 bytes, 0 tape blocks
x ./var/opt/oracle/oprocd/check, 0 bytes, 0 tape blocks
x ./var/opt/oracle/oprocd/stop, 0 bytes, 0 tape blocks
x ./var/opt/oracle/oprocd/fatal, 0 bytes, 0 tape blocks
x ./var/opt/oracle/scls_scr, 0 bytes, 0 tape blocks
x ./var/opt/oracle/scls_scr/sol1, 0 bytes, 0 tape blocks
x ./var/opt/oracle/scls_scr/sol1/oracle, 0 bytes, 0 tape blocks
x ./var/opt/oracle/scls_scr/sol1/oracle/cssfatal, 7 bytes, 1 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root, 0 bytes, 0 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/crsstart, 8 bytes, 1 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/cssrun, 37 bytes, 1 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/crsdboot, 37 bytes, 1 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/nooprocd, 0 bytes, 0 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/noclsmon, 0 bytes, 0 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/clsvmonpid, 5 bytes, 1 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/clsomonpid, 5 bytes, 1 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/cssfboot, 37 bytes, 1 tape blocks
x ./var/opt/oracle/scls_scr/sol1/root/daemonpid, 5 bytes, 1 tape blocks
x ./var/opt/oracle/ocr.loc, 61 bytes, 1 tape blocks
x ./var/opt/oracle/oratab, 720 bytes, 2 tape blocks
x ./etc/inittab, 1539 bytes, 4 tape blocks

4,还原ocr/vote

# su - oracle
Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
$ dd if=/soft/votevol of=/dev/vx/rdsk/ocrvotedg/votevol 
dd: /dev/vx/rdsk/ocrvotedg/votevol: open: No such file or directory
dd if=/soft/votevol of=/dev/vx/rdsk/ocrvotedg/votevoldd  if=/soft/ocrvol of=/dev/vx/rdsk/ocrvotedg/ocrvol

5,启动crs

两边同时启动crs

/etc/init.d/init.crs start
# hostname
sol1
# crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy# crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy

6,查看资源

# crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.sol.db     application    OFFLINE   OFFLINE               
ora....l1.inst application    OFFLINE   OFFLINE               
ora....l2.inst application    OFFLINE   OFFLINE               
ora....L1.lsnr application    ONLINE    ONLINE    sol1        
ora.sol1.gsd   application    ONLINE    ONLINE    sol1        
ora.sol1.ons   application    ONLINE    ONLINE    sol1        
ora.sol1.vip   application    ONLINE    ONLINE    sol1        
ora....L2.lsnr application    ONLINE    ONLINE    sol2        
ora.sol2.gsd   application    ONLINE    ONLINE    sol2        
ora.sol2.ons   application    ONLINE    ONLINE    sol2        
ora.sol2.vip   application    ONLINE    ONLINE    sol2  # hares -online ora1 -sys sol1
# hares -online ora1 -sys sol2# hares -state
#Resource               Attribute             System     Value
cssd                    State                 sol1       ONLINE
cssd                    State                 sol2       ONLINE
cvm_clus                State                 sol1       ONLINE
cvm_clus                State                 sol2       ONLINE
cvm_vxconfigd           State                 sol1       ONLINE
cvm_vxconfigd           State                 sol2       ONLINE
ocrvote_voldg_ocrvotedg State                 sol1       ONLINE
ocrvote_voldg_ocrvotedg State                 sol2       ONLINE
ora1                    State                 sol1       ONLINE
ora1                    State                 sol2       ONLINE
ora_priv                State                 sol1       ONLINE
ora_priv                State                 sol2       ONLINE
oradata_mnt             State                 sol1       ONLINE
oradata_mnt             State                 sol2       ONLINE
oradata_voldg           State                 sol1       ONLINE
oradata_voldg           State                 sol2       ONLINE
vxfsckd                 State                 sol1       ONLINE
vxfsckd                 State                 sol2       ONLINE

资源全部正常,回退相当的方便。

------------------作者介绍-----------------------
姓名:黄廷忠
个人博客: (http://www.htz.pw)
CSDN地址: (https://blog.csdn.net/wwwhtzpw)
博客园地址: (https://www.cnblogs.com/www-htz-pw)

http://www.jsqmd.com/news/38652/

相关文章:

  • 精度、正确率、召回率的简单理解
  • 西林瓶粉末灌装机:舟山备件更换快,紧急可加急发货
  • .NET 10性能突破:持续优化才是质变关键
  • MySql批量导入csv文件
  • win1125h2使用和优化技巧
  • 植物大战僵尸经典版下载教程:重新体验最纯粹的塔防乐趣
  • rsync安装部署
  • PG预写式日志解码的艺术与应用
  • 5 CSRF 攻击防范
  • 湘潭西林瓶灌装机:料位监测,智能提醒加料
  • 对比m3node 时序数据库和influx/tsdb/greptime/VictoriaMetrics
  • 11.12记录-机器学习
  • 个人工作版(Linux)
  • 烟台西林瓶灌装加塞机:合规21 CFR Part 11,数据加密与审计追踪完善
  • CF710F String Set Queries
  • 使用 Ansible 实现 Apache NiFi 集群扩容
  • 多智能体设计模式和智能体框架,你会了么?
  • YL-51单片机开发板配套资料
  • 神经网络中激活函数的作用
  • 2025年耙式真空干燥机优质厂家权威推荐榜单:耙式干燥机/ZB系列耙式真空干燥机/真空耙式干燥机源头厂家精选
  • 2025年庭院美化设计与花园设计标杆企业推荐:北京陌上景观工程,首层庭院设计/屋顶庭院设计/别墅庭院设计/定义个性化户外生活新标准
  • 【原理到实战】实验异质性分析
  • 习题解析之:输出 n 以内的所有素数
  • Docker最新学习
  • 最近学习到的一些基础知识
  • 新手入门常用的Dos命令
  • 2025年重庆吊装搬运公司权威推荐榜单:工厂搬迁/搬运/搬运设备源头公司精选
  • 基于LMS与RLS的自适应回声消除滤波
  • 2025年气密门窗实力厂家权威推荐榜单:折叠门窗/折叠门窗/断桥铝门窗源头厂家精选
  • 到底是用vue2还是vue3好?