政府一个项目,原来是IBM P550主机加HDS磁盘柜,后来因磁盘年限已久,更换成EMC磁盘柜。
上面运行oracle 10g 数据库 .
查看数据库情况时,发现数据库为裸设备。存储之间的数据如何进行处理尼?
经过分析,采用dd 命令进行搞定。
(1) 查看数据文件,然后再进行创建新的VG 与LV。
然后再:exportvg datavg
再 import data2vg
然后再将LV更名:
最后再授权:
mklv -y'bak_system' -t jfs2 datavg02 10
mklv -y'bak_index' -t jfs2 datavg02 10
mklv -y'bak_temp' -t jfs2 datavg02 10
mklv -y'bak_user' -t jfs2 datavg02 1
mklv -y'bak_tools' -t jfs2 datavg02 1
mklv -y'bak_undotable' -t jfs2 datavg02 10
mklv -y'bak_contfile01' -t jfs2 datavg02 1
mklv -y'bak_contfile02' -t jfs2 datavg02 1
mklv -y'bak_contfile03' -t jfs2 datavg02 1
mklv -y'bak_log01' -t jfs2 datavg02 1
mklv -y'bak_log02' -t jfs2 datavg02 1
mklv -y'bak_log11' -t jfs2 datavg02 1
mklv -y'bak_log12' -t jfs2 datavg02 1
mklv -y'bak_log21' -t jfs2 datavg02 1
mklv -y'bak_log22' -t jfs2 datavg02 1
mklv -y'bak_work01' -t jfs2 datavg02 20
mklv -y'bak_work02' -t jfs2 datavg02 20
mklv -y'bak_work03' -t jfs2 datavg02 20
mklv -y'bak_work04' -t jfs2 datavg02 20
mklv -y'bak_work05' -t jfs2 datavg02 20
mklv -y'bak_work06' -t jfs2 datavg02 20
mklv -y'bak_work07' -t jfs2 datavg02 20
mklv -y'bak_work08' -t jfs2 datavg02 20
备份数据以后,就可以dd 命令。
dd if=/dev/rsystem of=/dev/rbak_system bs=8192k
dd if=/dev/rindex of=/dev/rbak_index bs=8192k
dd if=/dev/rtemp of=/dev/rbak_temp bs=8192k
dd if=/dev/ruser of=/dev/rbak_user bs=8192k
dd if=/dev/rtools of=/dev/rbak_tools bs=8192k
dd if=/dev/rundotable of=/dev/rbak_undotable bs=8192k
dd if=/dev/rcontfile01 of=/dev/rbak_contfile01 bs=8192k
dd if=/dev/rcontfile02 of=/dev/rbak_contfile02 bs=8192k
dd if=/dev/rcontfile03 of=/dev/rbak_contfile03 bs=8192k
dd if=/dev/rlog01 of=/dev/rbak_log01 bs=8192k
dd if=/dev/rlog02 of=/dev/rbak_log02 bs=8192k
dd if=/dev/rlog11 of=/dev/rbak_log11 bs=8192k
dd if=/dev/rlog12 of=/dev/rbak_log12 bs=8192k
dd if=/dev/rlog21 of=/dev/rbak_log21 bs=8192k
dd if=/dev/rlog22 of=/dev/rbak_log22 bs=8192k
dd if=/dev/rwork01 of=/dev/rbak_work01 bs=8192k
dd if=/dev/rwork02 of=/dev/rbak_work02 bs=8192k
dd if=/dev/rwork03 of=/dev/rbak_work03 bs=8192k
dd if=/dev/rwork04 of=/dev/rbak_work04 bs=8192k
dd if=/dev/rwork05 of=/dev/rbak_work05 bs=8192k
dd if=/dev/rwork06 of=/dev/rbak_work06 bs=8192k
dd if=/dev/rwork07 of=/dev/rbak_work07 bs=8192k
dd if=/dev/rwork08 of=/dev/rbak_work08 bs=8192k
chlv -n'system' bak_system
chlv -n'index' bak_index
chlv -n'temp' bak_temp
chlv -n'user' bak_user
chlv -n'tools' bak_tools
chlv -n'undotable' bak_undotable
chlv -n'contfile01' bak_contfile01
chlv -n'contfile02' bak_contfile02
chlv -n'contfile03' bak_contfile03
chlv -n'log01' bak_log01
chlv -n'log02' bak_log02
chlv -n'log11' bak_log11
chlv -n'log12' bak_log12
chlv -n'log21' bak_log21
chlv -n'log22' bak_log22
chlv -n'work01' bak_work01
chlv -n'work02' bak_work02
chlv -n'work03' bak_work03
chlv -n'work04' bak_work04
chlv -n'work05' bak_work05
chlv -n'work06' bak_work06
chlv -n'work07' bak_work07
chlv -n'work08' bak_work08
chown oracle:dba rsystem
chown oracle:dba rindex
chown oracle:dba rtemp
chown oracle:dba ruser
chown oracle:dba rtools
chown oracle:dba rundotable
chown oracle:dba rcontfile01
chown oracle:dba rcontfile02
chown oracle:dba rcontfile03
chown oracle:dba rlog01
chown oracle:dba rlog02
chown oracle:dba rlog11
chown oracle:dba rlog12
chown oracle:dba rlog21
chown oracle:dba rlog22
chown oracle:dba rwork01
chown oracle:dba rwork02
chown oracle:dba rwork03
chown oracle:dba rwork04
chown oracle:dba rwork05
chown oracle:dba rwork06
chown oracle:dba rwork07
chown oracle:dba rwork08