6、在B机导入datavg的VG信息
# importvg datavg
0516-082 lqueryvg: Unable to access a special device file.
Execute redefinevg and synclvodm to build correct environment.
0516-082 lqueryvg: Unable to access a special device file.
Execute redefinevg and synclvodm to build correct environment.
0516-1140 importvg: Unable to read the volume group descriptor area
on specified physical volume.
# importvg -y datavg hdisk2
# lspv
hdisk0 00c9ea74d434de8f rootvg active
hdisk1 00c9ea742f1766a9 rootvg active
hdisk2 00c9eb6472209e77 datavg
hdisk3 00c9eb643dc0f744 datavg
hdisk4 00c9eb643dc15113 datavg
hdisk5 00c9eb643dc1649f datavg
7、在A机导入datavg的VG信息
# importvg -y datavg hdisk2
datavg
0516-783 importvg: This imported volume group is concurrent capable.
Therefore, the volume group must be varied on manually.
# lspv
hdisk0 00c9eb642f01d1db rootvg active
hdisk1 00c9eb64d4336974 rootvg active
hdisk2 00c9eb6472209e77 datavg
hdisk3 00c9eb643dc0f744 datavg
hdisk4 00c9eb643dc15113 datavg
hdisk5 00c9eb643dc1649f datavg
8、在A机与B机更改ORACLE相关设备的属主
这一步一开始是不知道的,在上面步骤完成后启动hacmp,发现两个节点的datavg卷组已经共享了,但oracle数据库死活启动不起来,查看alert日志发现有
Errors in file /oracle/product/10.2.0/admin/his/bdump/his1_mrp0_1024144.trc:
ORA-01110: data file 18: '/dev/rftelogdata001'
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: '/dev/rftelogdata001'
再一看这些数据文件的属主发现全变为root:system了,于是才有了此步
# ls -l /dev/rlv*
crw-rw---- 1 root system 49, 64 Sep 06 17:15 /dev/rlvaccdata001
crw-rw---- 1 root system 49, 6 Sep 06 17:14 /dev/rlvaccdata002
crw-rw---- 1 root system 49, 7 Sep 06 17:14 /dev/rlvaccdata003
A机、B机
chown -R oracle:dba /dev/rlv*
chown -R oracle:dba /dev/rVOT*
chown -R oracle:dba /dev/rOCR*
chown -R oracle:dba /dev/racc*
chown -R oracle:dba /dev/rtivoli*
chown -R oracle:dba /dev/rhdisk*
chown -R oracle:dba /dev/rfte*
9、启动HACMP
A机、B机
smitty clstart
# lspv
hdisk0 00c9eb642f01d1db rootvg active
hdisk1 00c9eb64d4336974 rootvg active
hdisk2 00c9eb6472209e77 datavg concurrent
hdisk3 00c9eb643dc0f744 datavg concurrent
hdisk4 00c9eb643dc15113 datavg concurrent
hdisk5 00c9eb643dc1649f datavg concurrent
10、启动RAC CRS并检查数据库并启动同步
A、B两节点
/oracle/product/10.2.0/crs_1/bin/crsctl start crs
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.his.db application OFFLINE OFFLINE
ora....s1.inst application OFFLINE OFFLINE
ora....s2.inst application OFFLINE OFFLINE
ora....01.lsnr application ONLINE ONLINE his01
ora.his01.gsd application ONLINE ONLINE his01
ora.his01.ons application ONLINE ONLINE his01
ora.his01.vip application ONLINE ONLINE his01
ora....02.lsnr application ONLINE ONLINE his02
ora.his02.gsd application ONLINE ONLINE his02
ora.his02.ons application ONLINE ONLINE his02
ora.his02.vip application ONLINE ONLINE his02
# su - oracle
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 6 17:45:05 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
idle> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
idle> startup mount
ORACLE instance started.
Total System Global Area 1.6777E+10 bytes
Fixed Size 2113472 bytes
Variable Size 1.1560E+10 bytes
Database Buffers 5200936960 bytes
Redo Buffers 14663680 bytes
Database mounted.
idle> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.
idle> select recovery_mode from v$archive_dest_status where dest_id=2;
RECOVERY_MODE
-----------------------
MANAGED REAL TIME APPLY
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞9
添加新评论12 条评论
2016-04-15 10:17
2012-05-25 15:31
2011-11-16 23:16
2011-11-09 11:23
2011-11-09 10:15
2011-10-31 09:13
2011-10-26 14:11
2011-10-19 16:51
2011-10-13 10:38
2011-09-29 22:56
2011-09-29 16:03
2011-09-26 00:36