【脚本共享2015】用PXE方法从裸机批量推Oracle 11gR2 RAC成套环境，并用Shell脚本在推出的RAC节点上批量部署32个Oracle11gR2 RAC备份恢复案例场景的方法

主机

操作系统

外网IP

内网IP

主机名

PXE推送端主机

RedHat Enterprise Linux 6.1 x86_64（或其他6系Enterprise Linux和5系Enterprise Linux）

192.168.0.254

无

server1.example.com

PXE被推送端主机之Oracle 11gR2 RAC环境共享磁盘主机

RedHat Enterprise Linux 6.1（或其他6系Enterprise Linux）

192.168.0.50+x

（x取值范围1到39)

172.31.118.50+x

（x取值范围1到39)

station50+x.example.com

（x取值范围1到39)

PXE被推送端主机之Oracle 11gR2 RAC环境节点主机（第一台）

Oracle Enterprise Linux 5.4（或其他5系Enterprise Linux）

IP：192.168.0.x

VIP：192.168.0.200+x

SCAN-VIP1：192.168.0.100+x

SCAN-VIP2： 192.168.0.150+x

（x取值范围1到39)

172.31.118.x

（x取值范围1到39)

stationx.example.com

（x取值范围1到39)

PXE被推送端主机之Oracle 11gR2 RAC环境节点主机（第二台）

同上

IP：192.168.0.1+x

VIP：192.168.0.201+x

SCAN-VIP3：192.168.0.101+x

（x取值范围1到39)

172.31.118.1+x

（x取值范围1到39)

station1+x.example.com

（x取值范围1到39)

[root@server1 ~]# ./bcp-install

…...
SHOULD COPY CDROM/DVDROM of LINUX INSTALLATION into /var/ftp/pub:(y/n)

所需软件

存放路径

Oracle Enterprise Linux 5.4 iso镜像文件

/usr/sbin/botang-config-push.d/softwarefiles/Lrhel5/IMAGES/issue.iso

RedHat Enterprise Linux 6.1iso 镜像文件

/usr/sbin/botang-config-push.d/softwarefiles/Lrhel6/IMAGES/issue.iso

linux_11gR2_database_1of2.zip

/usr/sbin/botang-config-push.d/softwarefiles/O11g/DATABASES/linux_11gR2_database_1of2.zip

linux_11gR2_database_2of2.zip

/usr/sbin/botang-config-push.d/softwarefiles/O11g/DATABASES/linux_11gR2_database_2of2.zip

linux_11gR2_grid.zip

/usr/sbin/botang-config-push.d/softwarefiles/O11g/DATABASES/linux_11gR2_grid.zip

osb-10.3.0.3.0_linux32.zip

/usr/sbin/botang-config-push.d/softwarefiles/O10g/TAPE/osb-10.3.0.3.0_linux32.zip

文件名

内容

/usr/sbin/workstation.list2

3-00:07:E9:5C:44:1F

3-00:16:EC:06:6C:15

4-00:07:E9:0F:74:BC

4-00:16:EC:0B:EA:FE

…...

53-00:1A:A0:09:28:62

53-00:E0:50:1A:00:37

…...

/usr/sbin/workstation.list

3-00:07:E9:5C:44:1F

4-00:16:EC:0B:EA:FE

…...

53-00:1A:A0:09:28:62

…...

自动生成的：

/etc/dhcp/dhcpd.conf和/etc/dhcpd.conf

# Stock gls /etc/dhcpd.conf for RH300 and other classes

# : dhcpd.conf,v 1.1.2.2 2007/11/19 03:08:34 mcurry Exp $

ddns-update-style none;

subnet 192.168.0.0 netmask 255.255.255.0 {

class "virtual" {

match if substring (hardware, 1, 3) = 00:16:3e;

}

# The following lines are standard all of the time.

option routers 192.168.0.254;

option subnet-mask 255.255.255.0;

option domain-name "example.com";

option domain-name-servers 192.168.0.254;

default-lease-time 21600;

max-lease-time 43200;

# Assign IPs 61-80 to Xen domUs

pool {

allow members of "virtual";

range 192.168.0.101 192.168.0.189;

}

# Assign IPs 1-20 for classroom systems unless

# static IPs are assigned below

pool {

deny members of "virtual";

range 192.168.0.1 192.168.0.89;

}

# The following lines are examples of kickstart

# directives.

filename "/var/ftp/pub/workstation.cfg";

# filename "/kickstart/virt_worstation.cfg";

# see /root/README.vcracker for details about virt_workstation.cfg

next-server server1.example.com;

# The following four lines provide an example of an IP

# address bound to a specific MAC.

#

#

#

# Workstation 192.168.0.1-192.168.0.50

host station3 {

hardware ethernet 00:07:E9:5C:44:1F;

fixed-address 192.168.0.3;

}

host station4 {

hardware ethernet 00:16:EC:0B:EA:FE;

fixed-address 192.168.0.4;

}

......

host station53 {

hardware ethernet 00:1A:A0:09:28:62;

fixed-address 192.168.0.53;

}

…...

}

option space PXE;

class "PXE" {

match if substring(option vendor-class-identifier, 0, 9) = "PXEClient";

option vendor-encapsulated-options 01:04:00:00:00:00:ff;

option boot-size 0x1;

filename "pxelinux.0";

option tftp-server-name "server1.example.com";

option vendor-class-identifier "PXEClient";

vendor-option-space PXE;

}

[root@server1 ~]#bcp

…...

RAC11grhel5none

RAC11grhel6shareddisknone

Your Choice: RAC11grhel6shareddisknone

…...

PUSH CLASSROM MACHINE(c) OR PUSH VIRTUAL MACHINE1(v1) OR PUSH VIRTUAL MACHINE2(v2): (c or v1 or v2) c

Input is: "c". Are you sure ?(y/n)y

Want rewrite MBR( for before rhel6 should answer "n" ): y

[root@server1 ~]#bcp

…...

RAC11grhel5none

RAC11grhel6shareddisknone

Your Choice: RAC11grhel5none

…...

PUSH CLASSROM MACHINE(c) OR PUSH VIRTUAL MACHINE1(v1) OR PUSH VIRTUAL MACHINE2(v2): (c or v1 or v2) c

Input is: "c". Are you sure ?(y/n)y

Want rewrite MBR( for before rhel6 should answer "n" ): y

[root@station34 ~]# cd /stage/mhvtl-1.2/kernel/

[root@station34 kernel]# make

make -C /lib/modules/2.6.18-164.el5/build SUBDIRS=/stage/mhvtl-1.2/kernel modules

make[1]: Entering directory `/usr/src/kernels/2.6.18-164.el5-i686'

Building modules, stage 2.

MODPOST

make[1]: Leaving directory `/usr/src/kernels/2.6.18-164.el5-i686'

[root@station34 kernel]# service mhvtl start

vtllibrary process PID is 21614

vtllibrary process PID is 21633

[root@station34 ~]# lsscsi -g

[1:0:0:0] mediumx STK L700 0102 - /dev/sg8

[1:0:1:0] tape IBM ULT3580-TD5 0102 /dev/st0 /dev/sg0

[1:0:2:0] tape IBM ULT3580-TD5 0102 /dev/st1 /dev/sg1

[1:0:3:0] tape IBM ULT3580-TD4 0102 /dev/st2 /dev/sg2

[1:0:4:0] tape IBM ULT3580-TD4 0102 /dev/st3 /dev/sg3

[1:0:8:0] mediumx STK L80 0102 - /dev/sg9

[1:0:9:0] tape STK T10000B 0102 /dev/st4 /dev/sg4

[1:0:10:0] tape STK T10000B 0102 /dev/st5 /dev/sg5

[1:0:11:0] tape STK T10000B 0102 /dev/st6 /dev/sg6

[1:0:12:0] tape STK T10000B 0102 /dev/st7 /dev/sg7

[root@station34 stage]# ./osb.sh

/dev/sg8

/dev/sg9

/dev/sg0

/dev/sg1

/dev/sg2

/dev/sg3

/dev/sg4

/dev/sg5

/dev/sg6

/dev/sg7

Oracle Secure Backup 10.3.0.3.0

Warning: auto-login failed - login token has expired

login: admin

Password:

…...

OSB-CATALOG-MF write 7 days keep 14 days

RMAN-DEFAULT content manages reuse

sexample content manages reuse

station34 content manages reuse

[oracle@station34 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 29 10:20:18 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name ORCL are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station33)' CONNECT 'sys/oracle_4U@rdbq1';

CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station34)' CONNECT 'sys/oracle_4U@rdbq2';

CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station33)' CONNECT 'sys/oracle_4U@rdbq1';

CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station34)' CONNECT 'sys/oracle_4U@rdbq2';

CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station33)' CONNECT 'sys/oracle_4U@rdbq1';

CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station34)' CONNECT 'sys/oracle_4U@rdbq2';

CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station33)' CONNECT 'sys/oracle_4U@rdbq1';

CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station34)' CONNECT 'sys/oracle_4U@rdbq2';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

[root@station34 stage]# ntpq

ntpq> peer

remote refid st t when poll reach delay offset jitter

==============================================================================

*station83.examp .INIT. 16 u - 1024 0 0.000 0.000 0.000

ntpq>

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

# export ORACLE_BASE=/u01/app/grid

# export ORACLE_HOME=/u01/app/11.2.0/grid

# export ORACLE_SID=+ASM2

# export TNS_ADMIN=$ORACLE_HOME/network/admin

export NLS_LANG=american_america.AL32UTF8

export ORACLE_TERM=xterm

export EDITOR=vi

export PATH=$ORACLE_HOME/bin:$PATH

export LANG=en_US

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

# export ORACLE_BASE=/u01/app/oracle

# export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

# export ORACLE_SID=RDBQ2

# export ORACLE_UNQNAME=RDBQ

# export TNS_ADMIN=$ORACLE_HOME/network/admin

export NLS_LANG=american_america.AL32UTF8

export ORACLE_TERM=xterm

export EDITOR=vi

export PATH=$ORACLE_HOME/bin:$PATH

export LANG=en_US

[oracle@station33 stage]$ cat /usr/bin/rac-sshd.sh

#!/bin/bash

# ssh-keygen, 192.168.0.33->, oracle@192.168.0.33->

echo "KEY GEN......"

sleep 1

echo

echo

ssh 192.168.0.33 ssh-keygen -t dsa

ssh 192.168.0.34 ssh-keygen -t dsa

echo

echo

# selfconnect, station33->, oracle@station33->

echo "SELF CONNECT......"

sleep 1

echo

echo

ssh station33 cat /home/$USER/.ssh/id_dsa.pub >> /home/$USER/.ssh/authorized_keys

echo

echo

# conterpartconnet, station33.example.com-> , oracle@station33.example.com->

echo "CONTERPART CONNECT......"

sleep 1

echo

echo

scp station34.example.com:/home/$USER/.ssh/id_dsa.pub /tmp/conterpartconnectoracle

ssh station33.example.com cat /tmp/conterpartconnectoracle >> /home/$USER/.ssh/authorized_keys

echo

echo

# TEST

echo "TEST......"

sleep 1

echo

echo

ssh station33 exit

ssh station34 exit

ssh station33.example.com exit

ssh station34.example.com exit

echo

echo

# 192.168.0.34->, oracle@192.168.0.34->

echo "SCP TO CONTERPART ......"

sleep 1

echo

echo

scp /home/$USER/.ssh/known_hosts $USER@192.168.0.34:/home/$USER/.ssh/known_hosts

scp /home/$USER/.ssh/authorized_keys $USER@192.168.0.34:/home/$USER/.ssh/authorized_keys

echo

echo

[oracle@station33 stage]$ rac-sshd.sh

[root@station33 ~]# crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.DATA.dg ora....up.type ONLINE ONLINE station33

ora.FRA.dg ora....up.type ONLINE ONLINE station33

ora....ER.lsnr ora....er.type ONLINE ONLINE station33

ora....N1.lsnr ora....er.type ONLINE ONLINE station34

ora....N2.lsnr ora....er.type ONLINE ONLINE station33

ora....N3.lsnr ora....er.type ONLINE ONLINE station33

ora.asm ora.asm.type ONLINE ONLINE station33

ora.eons ora.eons.type ONLINE ONLINE station33

ora.gsd ora.gsd.type ONLINE ONLINE station33

ora....network ora....rk.type ONLINE ONLINE station33

ora.oc4j ora.oc4j.type ONLINE ONLINE station33

ora.ons ora.ons.type ONLINE ONLINE station33

ora.rdbq.db ora....se.type ONLINE ONLINE station33

ora....ry.acfs ora....fs.type ONLINE ONLINE station33

ora.scan1.vip ora....ip.type ONLINE ONLINE station34

ora.scan2.vip ora....ip.type ONLINE ONLINE station33

ora.scan3.vip ora....ip.type ONLINE ONLINE station33

ora....SM1.asm application ONLINE ONLINE station33

ora....33.lsnr application ONLINE ONLINE station33

ora....n33.gsd application ONLINE ONLINE station33

ora....n33.ons application ONLINE ONLINE station33

ora....n33.vip ora....t1.type ONLINE ONLINE station33

ora....SM2.asm application ONLINE ONLINE station34

ora....34.lsnr application ONLINE ONLINE station34

ora....n34.gsd application ONLINE ONLINE station34

ora....n34.ons application ONLINE ONLINE station34

ora....n34.vip ora....t1.type ONLINE ONLINE station34

####

#### 0 Subprograms Begin

### 0.1 Normal Structure Begin

###

# sub_getting has $1 $2

sub_getting() {

echo " "

echo "---------------------------------------------- LAB $1 ----------------------------------------------"

echo " $2"

echo "---------------------------------------------- LAB $1 ----------------------------------------------"

echo " "

echo " "

echo "******************"

echo "你的主机信息如下："

echo "******************"

ifconfig eth0 | head -n2 | tail -n1 | cut -f 2 -d : | cut -f 1 -d ' '

echo " "

hostname

echo " "

uname -a

echo " "

echo " "

}

sub_detecting() {

/u01/app/11.2.0/grid/bin/crs_stat -t

v_dbname=`cat /home/oracle/dbname | tr -d [:blank:]`

if [ -f /u01/app/11.2.0/grid/dbs/hc_+ASM1.dat ]

then

su - oracle -c "sqlplus /nolog" <