当前位置：Oracle研究中心 > 运维DBA >
【学习笔记】Oracle升级后回退 crs 11.2.0.4回退至10.2.0.4
时间:2016-10-20 19:56 来源:Oracle研究中心 作者:HTZ 点击: 次
天萃荷净
分享一篇关于Oracle RAC升级完后需要回退.crs 11.2.0.4回退至10.2.0.4的案例。
$ srvctl stop instance -d sol -i sol1 -o abort
$ srvctl stop instance -d sol -i sol2 -o abort
两个节点同时执行这个操作
# .//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
两个节点都要执行
# 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
# 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/votevol
dd if=/soft/ocrvol of=/dev/vx/rdsk/ocrvotedg/ocrvol
两边同时启动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
# 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/2013/09/04/10-2-0-4-crs%e5%8d%87%e7%ba%a7%e5%88%b011-2-0-4-%e5%9b%9e%e9%80%80%e6%96%b9%e6%a1%88.html | 认真就输
Oracle研究中心
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/votevol
dd 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/2013/09/04/10-2-0-4-crs%e5%8d%87%e7%ba%a7%e5%88%b011-2-0-4-%e5%9b%9e%e9%80%80%e6%96%b9%e6%a1%88.html | 认真就输
--------------------------------------ORACLE-DBA----------------------------------------
最权威、专业的Oracle案例资源汇总之【学习笔记】Oracle升级后回退 crs 11.2.0.4回退至10.2.0.4
本文由大师惜分飞原创分享，网址：http://www.oracleplus.net/arch/1018.html
