分类： LINUX
2011-08-10 20:54:40
--数据库信息
[grid@node2 trace]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE node2
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE node2
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE node2
ora.OCR.dg ora....up.type 0/5 0/ ONLINE ONLINE node2
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE node2
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE node2
ora....ools.db ora....se.type 0/2 0/1 ONLINE ONLINE node2
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE node2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE node2
ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE node2
ora.node2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.node2.ons application 0/3 0/0 ONLINE ONLINE node2
ora.node2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE node2
ora.oc4j ora.oc4j.type 0/5 0/0 ONLINE ONLINE node2
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE node2
ora....ry.acfs ora....fs.type 0/5 0/ ONLINE ONLINE node2
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE node2
[grid@node2 trace]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node2
ora.OCR.dg
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node2
ora.gsd
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node2
ora.cvu
1 ONLINE ONLINE node2
ora.dbatools.db
1 ONLINE ONLINE node2 Open
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.scan1.vip
1 ONLINE ONLINE node2
备份ocrshare
ocr
data
#dd if=/dev/sde1 of=/data/backup/ocrdd.bak
#dd if=/dev/sdf1 of=/data/backup/datadd.bak
--bakckup
##
mkidr /data/backup
BK_DIR=/data/backup
cd $BK_DIR
#fdisk
fdisk -l >>$BK_DIR/fdisk.bak
#inittab
cat /etc/inittab >>$BK_DIR/inittab.bak
#fstab
cat /etc/fstab >>$BK_DIR/fstab.bak
#network
tar -cvf eth.tar /etc/sysconfig/network-scripts/ifcfg-eth*
#hosts.txt
cat /etc/hosts >>$BK_DIR/hosts.bak
#oracle /etc
tar -cvf inithas.tar /etc/init.d/*has*
tar -cvf rc3.d.tar /etc/rc3.d/*has*
tar -cvf rc5.d.tar /etc/rc3.d/*has*
tar -cvf etcoracel.tar /etc/oracle
tar -cvf loc.tar /etc/oraInst.loc
tar -cvf oratab.tar /etc/oratab
#owner
id grid >>$BK_DIR/owner.bak
cat /home/grid/.bash_profile >>$BK_DIR/owner.bak
id ora11g >>$BK_DIR/owner.bak
cat /home/ora11g/.bash_profile >>$BK_DIR/owner.bak
#u01
tar -cvf u01.tar /u01/*
注：
重建后的库/etc/rc.d/rc.nd/下面的链接,否则不能正常启动has
也可以再新库做链接,名称和指向和原库保持一致
u01目录包括了oracle和crs软件目录
--恢复
安装redhat 操作系统
安装所需包打上补丁
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \
compat-libstdc++-33 \
elfutils-libelf \
elfutils-libelf-devel \
gcc \
gcc-c++ \
glibc \
glibc-common \
glibc-devel \
glibc-headers \
ksh \
libaio \
libaio-devel \
libgcc \
libstdc++ \
libstdc++-devel \
make \
sysstat \
unixODBC \
unixODBC-devel
rpm -ivh cvuqdisk-1.0.9-1.rpm
(依据需要修改相关系统配置,保持和原库一致)
建立相关用户和组和原库保持一致
/usr/sbin/groupadd -g 505 oinstall
/usr/sbin/useradd -u 501 -g oinstall grid
/usr/sbin/useradd -u 502 -g oinstall ora11g
--恢复
1>#vi /etc/inittab
添加
h1:35:respawn:/etc/init.d/init.ohasd run >/dev/null 2>&1
2>
#tar -xvf inithas.tar
etc/init.d/init.ohasd
etc/init.d/ohasd
将文件copy到/etc/init.d/下
#tar -xvf rc3.d.tar
etc/rc3.d/K15ohasd
etc/rc3.d/S96ohasd
将文件中的/K15ohasd,S96ohasd链接移动到/etc/rc3.d/下
#tar -xvf rc5.d.tar
etc/rc3.d/S96ohasd
将文件中的/K15ohasd,S96ohasd链接移动到/etc/rc5.d/下
etc/rc3.d/S96ohasd
3>恢复网络ip配置
tar -xvf eth.tar /etc/sysconfig/network-scripts/ifcfg-eth*
将解压的文件移动到/etc/sysconfig/network-scripts/下覆盖
4>恢复hosts
将生产中的hosts文件覆盖到/etc/hosts
5>修改fstab
挂载磁盘
6>修改/dev/sd*中共享存储的权限
vi /etc/udev/rules.d/50-udev.rules
KERNEL=="sde*", OWNER="grid" GROUP="oinstall", MODE="0660"
KERNEL=="sdf*", OWNER="grid" GROUP="oinstall", MODE="0660"
7>
tar -xvf etcoracel.tar
/etc/oracle
tar -xvf loc.tar
/etc/oraInst.loc
tar -xvf oratab.tar
/etc/oratab
移动到原来的库一致的位置
8>修改grid和ora11g用户的.bash_profile
与原库保持一致
9>u01 oracle 和crs目录全部恢复到和原来的库路径一致
tar -xvf u01.tar
恢复ocr和data盘
#dd if=/data/backup/ocrdd.bak of=/dev/sde1
#dd if=/data/backup/datadd.bak of=/dev/sdf1
--重启主机
#reboot
[grid@node2 etc]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE node2
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE node2
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE node2
ora.OCR.dg ora....up.type 0/5 0/ ONLINE ONLINE node2
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE node2
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE node2
ora....ools.db ora....se.type 0/2 0/1 ONLINE ONLINE node2
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE node2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE node2
ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE node2
ora.node2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.node2.ons application 0/3 0/0 ONLINE ONLINE node2
ora.node2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE node2
ora.oc4j ora.oc4j.type 0/5 0/0 ONLINE ONLINE node2
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE node2
ora....ry.acfs ora....fs.type 0/5 0/ ONLINE OFFLINE
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE node2
[grid@node2 etc]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node2
ora.OCR.dg
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node2
ora.gsd
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node2
ora.registry.acfs
ONLINE OFFLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node2
ora.cvu
1 ONLINE ONLINE node2
ora.dbatools.db
1 ONLINE ONLINE node2 Open
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.scan1.vip
1 ONLINE ONLINE node2
