Oracle10G在linux上的安装和迁移
以下都是安装过程中的记录。
Oracle10G raw方式在linux ES5安装过程记录 ................................................................... 1
系统环境 ........................................................................................................................... 1 系统查看 ........................................................................................................................... 1 空间分配 ........................................................................................................................... 2 创建裸设备 ....................................................................................................................... 3 安装软件包 ....................................................................................................................... 5 ORACLE安装前的配置 .................................................................................................. 6 安装oracle软件和数据库 ............................................................................................... 7 oracle10G版本10.2.0.1.0升级为10.2.0.4.0 .......................................................................... 8
安装升级包 ....................................................................................................................... 8 数据库升级 ....................................................................................................................... 8 RMAN备份和还原 .................................................................................................................. 9
数据库RMAN备份 ......................................................................................................... 9 RMAN恢复(从文件系统到裸设备) ............................................................................. 11 ASM实例配置和迁移 ........................................................................................................... 13
ASM实例安装 ............................................................................................................... 13 连接ASM实例 .............................................................................................................. 16 ASM修改参数和新增磁盘 ........................................................................................... 17 RAW迁移到ASM ......................................................................................................... 19 ASM磁盘组管理 ........................................................................................................... 21
Oracle10G raw方式在linux ES5安装过程记录 系统环境
Vmware7，linuxES5，oracle10GR2版本号10.2.0.1
系统查看
1.内存：grep MemTotal /proc/meminfo
2.swap：grep SwapTotal /proc/meminfo 或者 cat /proc/swaps 或者 swapon -s 或者 free
注：新增swap： dd if=/dev/zero of=swapfile bs=1024 count=1000000 //增加1G mkswap swapfile swapon /tmp/swapfile
停止：swapoff /tmp/swapfile 启动时加载:
1
在/etc/fstab文件中，加入下行： /tmp/swapfile swap swap defaults 0 0
3.df -k /tmp
修改主机名：vi /etc/sysconfig/network
修改selinux：vi /etc/sysconfig/selinux 设置为disabled
ln -s 源文件 目标文件 -s 是 symbolic的意思。 例：ln -s /lib/lsb /usr/lj
即：在usr目录下建立指向/lib/lsb目录的lj文件。
空间分配
Sda为 10G 已经安装linux系统 sdb,sdc,sdd均为 2G,sde为 5G fdisk /dev/sdb fdisk /dev/sdc fdisk /dev/sdd fdisk /dev/sde
创建PV
pvcreate /dev/sdb1 pvcreate /dev/sdc1 pvcreate /dev/sdd1 pvcreate /dev/sde1
创建VG
vgcreate vg_fs /dev/sdb1 /dev/sdc1 vgcreate vg_ora /dev/sdd1 /dev/sde1 vgdisplay
创建LV 用来挂载文件系统
[root@SMART ~]# lvcreate -L 600M -n lv_tmp vg_fs [root@SMART ~]# lvcreate -L 2800M -n lv_ora vg_fs
mkfs -t ext3 /dev/vg_fs/lv_ora mkfs -t ext3 /dev/vg_fs/lv_tmp
[root@SMART /]# mkdir /oracle [root@SMART vg_fs]# groupadd dba
[root@SMART vg_fs]# useradd -g dba oracle [root@SMART vg_fs]# passwd oracle
2
[root@SMART vg_fs]#chown -R oracle:dba /oracle [root@SMART vg_fs]#chmod -R 750 /oracle
[root@SMART vg_fs]# mount /dev/vg_fs/lv_ora /oracle [root@SMART vg_fs]# mount /dev/vg_fs/lv_tmp /tmp vi /etc/fstab //加入自动mount的条目 mount –a检查下是否正常 df –m 查看空间 扩展LV
[root@SMART vg_fs]# lvextend -L +600M /dev/vg_fs/lv_tmp [root@SMART vg_fs]# resize2fs /dev/vg_fs/lv_ tmp //使用resize2fs命令重新加载逻辑卷的大小才能生效
VG扩展
[root@SMART oradata]# pvcreate /dev/sdf1
Physical volume \[root@SMART oradata]# vgextend vg_ora /dev/sdf1
创建裸设备
[root@SMART ~]# lvcreate -L 500M -n system01dbf vg_ora Logical volume \
[root@SMART ~]# lvcreate -L 500M -n sysaux01dbf vg_ora Logical volume \
[root@SMART ~]# lvcreate -L 500M -n undotbs01dbf vg_ora Logical volume \
[root@SMART ~]# lvcreate -L 500M -n users01dbf vg_ora Logical volume \
[root@SMART ~]# lvcreate -L 500M -n temp01dbf vg_ora Logical volume \
[root@SMART ~]# lvcreate -L 51M -n redolog01 vg_ora Rounding up size to full physical extent 52.00 MB Logical volume \
[root@SMART ~]# lvcreate -L 52M -n redolog02 vg_ora Logical volume \
[root@SMART ~]# lvcreate -L 32M -n controlfile01 vg_ora Logical volume \
[root@SMART ~]# lvcreate -L 32M -n controlfile02 vg_ora Logical volume \
[root@SMART ~]#vi /etc/sysconfig/rawdevices /dev/raw/raw1 /dev/vg_ora/controlfile02 /dev/raw/raw2 /dev/vg_ora/controlfile01 /dev/raw/raw3 /dev/vg_ora/redolog02 /dev/raw/raw4 /dev/vg_ora/redolog01
3
/dev/raw/raw5 /dev/vg_ora/temp01dbf /dev/raw/raw6 /dev/vg_ora/users01dbf /dev/raw/raw7 /dev/vg_ora/undotbs01dbf /dev/raw/raw8 /dev/vg_ora/sysaux01dbf /dev/raw/raw9 /dev/vg_ora/system01dbf
[root@SMART vg_ora]# service rawdevices restart [root@SMART raw]# chown oracle:dba raw* [root@SMART raw]# chmod 660 raw*
为了防止系统重新启动后/dev/raw/raw*的权限变回root,编辑rc.local使得系统启动时自动执行权限修改，如下
[root@SMART vg_ora]# vi /etc/rc.local 在文件中加入
chmod 660 /dev/raw/raw1 chmod 660 /dev/raw/raw2 chmod 660 /dev/raw/raw3 chmod 660 /dev/raw/raw4 chmod 660 /dev/raw/raw5 chmod 660 /dev/raw/raw6 chmod 660 /dev/raw/raw7 chmod 660 /dev/raw/raw8 chmod 660 /dev/raw/raw9
chown oracle:dba /dev/raw/raw1 chown oracle:dba /dev/raw/raw2 chown oracle:dba /dev/raw/raw3 chown oracle:dba /dev/raw/raw4 chown oracle:dba /dev/raw/raw5 chown oracle:dba /dev/raw/raw6 chown oracle:dba /dev/raw/raw7 chown oracle:dba /dev/raw/raw8 chown oracle:dba /dev/raw/raw9
[root@SMART raw]# su - oracle [oracle@SMART ~]$ pwd /home/oracle
建立软连接指向裸设备,主要是为了dba_data_files显示数据文件名称,而不是/dev/raw/raw*,便于查看：
[oracle@SMART ~]$ln -s /dev/raw/raw9 /oracle/orcl/system01.dbf [oracle@SMART ~]ln -s /dev/raw/raw8 /oracle/orcl/sysaux01.dbf [oracle@SMART ~]ln -s /dev/raw/raw6 /oracle/orcl/users01.dbf [oracle@SMART ~]ln -s /dev/raw/raw5 /oracle/orcl/temp01.dbf [oracle@SMART ~]ln -s /dev/raw/raw7 /oracle/orcl/undotbs01.dbf
4
[oracle@SMART ~]ln -s /dev/raw/raw4 /oracle/orcl/redo01.log [oracle@SMART ~]ln -s /dev/raw/raw3 /oracle/orcl/redo02.log [oracle@SMART ~]ln -s /dev/raw/raw2 /oracle/orcl/control01.ctl [oracle@SMART ~]ln -s /dev/raw/raw1 /oracle/orcl/control02.ctl
编辑裸设备映射文件，安装数据库选择该文件
[oracle@SMART ~]$ vi orcl_raw.conf system=/oracle/orcl/system01.dbf sysaux=/oracle/orcl/sysaux01.dbf users=/oracle/orcl/users01.dbf temp=/oracle/orcl/temp01.dbf
undotbs1= /oracle/orcl/undotbs01.dbf redo1_1=/oracle/orcl/redo01.log redo1_2=/oracle/orcl/redo02.log
control1=/oracle/orcl/control01.ctl control2=/oracle/orcl/control02.ctl
[oracle@SMART ~]$ vi .bash_profile
export DBCA_RAW_CONFIG=/home/oracle/orcl_raw.conf
安装软件包
[root@SMART ~]# mkdir -p /mnt/cdrom
[root@SMART ~]# mount -o loop /dev/cdrom /mnt/cdrom [root@SMART ~]# cd /mnt/cdrom/ Server 根据官方文档redhat4需安装以下软件包： binutils-2.15.92.0.2-13.EL4 compat-db-4.1.25-9
compat-libstdc++-296-2.96-132.7.2 control-center-2.8.0-12 gcc-3.4.3-22.1.EL4
gcc-c++-3.4.3-22.1.EL44 glibc-2.3.4-2.9
glibc-common-2.3.4-2.9
gnome-libs-1.4.1.2.90-44.1 libstdc++-3.4.3-22.1
libstdc++-devel-3.4.3-22.1 make-3.80-5
pdksh-5.2.14-30 sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2 setarch-1.6-1
在REDHAT ES5上实际安装包
5