数据库

位置:IT落伍者 >> 数据库 >> 浏览文章

对Oracle数据库进行容灾


发布日期:2022年06月24日
 
对Oracle数据库进行容灾
随着全球信息化时代的到来信息数据越来越成为企业关注的焦点即在各种自然灾害或者人为破坏的情况下如何保证生产数据的安全和关键业务的不中断运行传统的保护方法离线备份备份介质异地保存在一定程度上可以解决上述问题但为了能够对业务系统提供更高的实时性和可靠性保证关键业务x不中断应对激烈的市场竞争和提高客户满意度企业必须在IT系统围绕连续(BC)主题进行构建实施业务连续/容灾备份计划包括业务连续性高可用性管理容灾数据复制和恢复方案安全等下面就对数据复制技术做一个简单的介绍

根据数据复制运行的位置可以将数据复制方式分为以下四种

基于存储(StorageBased)代表厂商有EMC SRDFIBM PPRC/GDPS HP BusinessCopyHDS TrueCopy等特点对主机透明对应用系统的影响较小技术成熟有较多的成功案例但是投资较大对网络连接的要求也较高

基于服务器(Hostbased)代表厂商主要是Symantec公司的Veritas Volume Replicator (VVR)是存储卷的复制技术需要占用主机一定的系统资源

基于存储交换机(SANBased)运行于挂接在存储网络上的专用设备中代表厂商有CISCO的SANTapFalconStor IPStorTopio SANsafeDataCore SANsymphony Asynchronous Internet Mirroring (AIM)等

基于数据库/软件应用 :代表厂商有Oracle DataGuardQuest SharePlexIBMDB的远程Q复制SYBASE的复制服务器(Replication Server) 等这些技术都是对数据逻辑操作的复制属于逻辑数据复制而其它种复制的是数据卷中的数据变化属于物理数据复制典型的逻辑数据复制是通过数据库日志实现的优点是硬件投资小对生产系统的影响比较小对主备用系统的硬件平台没有选择性;可以在广域网范围内使用但它对数据库系统有严格的要求并且主备用系统必须使用相同的数据库版本

上面介绍的主要的各厂商方案和产品可以参见下图

本文主要介绍基于主机和逻辑卷的数据复制VVR

VERITAS的VVR(Veritas Volume Replicator)是用于有效的灾难恢复的数据复制软件可以连续对应用数据进行一个或者多个的拷贝保护具有的优点主要有高性能距离不限支持异构的存储和操作系统对数据的连续保护支持同步和异步复制

VVR系统架构如下图

VVR具有的系统特性如下

() 最高支持个远程节点可以通过基于IP的LAN或者WAN网络;

() 通过对逻辑卷的同步和异步复制模式保证数据的完整性和一致性;

() 确保备用节点和主节点的数据具有相同的写入顺序;

() 支持对网络带宽的管理和定义支持多链路的连接;

() 支持对备用节点的脱机操作以便在备用节点进行查询(例如DSS决策支持系统)或者数据备份;

() 易管理同时支持命令行和图形界面(VEA);

() 主备节点之间支持多种异构存储;

() 支持不同操作系统平台之间的复制;(注在本文中因为设计到Oracle数据库的复制所以主备操作系统必须同一类型比如必须都是Solaris平台版本完全相同的Oracle版本)

() 支持主流关系数据库系统包括OracleDBSybase和Informix数据文件的存放格式包括逻辑卷(裸设备)或者文件系统;

() 支持共享的集群环境中的逻辑卷复制比如Oracle RAC (Real Application Clusters) (注本文中采用的是单节点Oracle复制);

() 支持Veritas volume set;

() 支持PDC (Portable Data Container)环境的数据复制;

VVR数据复制系统主要由下面五个组件组成

■ Replicated Volume Group (RVG) 复制卷组

RVG是位于VxVM 磁盘组(DG)内的一组逻辑卷RVG隶属于磁盘组的一部分通过定义这些逻辑卷

应用对逻辑卷的写操作都可以保持以主节点上同样的顺序来写到备用节点上

对于多数数据库系统来说都是由一些特定的进程完成对磁盘的写操作比如Oracle系统中的LOWR

和DBWR进程而这些写操作总是依照着一定顺序从而来保证实例恢复中数据的一致和完整比如

数据库变化通常在写入日志文件后才会写入数据文件所以当日志文件和数据文件属于要复制的不同

逻辑卷的时候它们必须被定义到同一组RVG中

每组RVG最多可以包括个数据卷

下面介绍SRL和RLINK它们也包括在RVG中

■ Storage Replicator Log (SRL)

SRL用于记录RVG中数据写操作的日志并循环被使用每个RVG包括一个SRL数据在写入RVG中的卷之前首先要写到主节点的SRL中

从VxVM的角度来看SRL是一个单独的卷因为所有的写操作首先要写到SRL中这个卷需要有较好的写性能所以多数情况下需要对这个卷进行条带化并且在不同的盘上mirror以保护数据同时数据卷和SRL卷最好分布在不同的物理磁盘上以得到更好的性能

不允许人工直接对SRL进行访问

■ Replication Link—RLINK

用于连接主RVG和备用RVG之间的一个链接一个主的RVG最多可以有个RLINK可以定义RLINK

的多个属性来调整数据复制的参数比如指定复制的网络

■ Data Change Map (DCM)

■ Replicated Data Set (RDS)

一个RDS包括了所有的主节点和备用节点的复制卷组(RVG)RDS不是一个具体存在的对象而是一个VVR复制技术中的一个概念

在异步模式下VVR的数据复制和数据流向

在同步模式下VVR的数据复制和数据流向

另外VVR是Veritas Volume Manager (VxVM)的一个单独的option需要单独的license

Veritas Volume Replicator 的安装

主备节点硬件和软件配置和版本如下

主节点 机器名lxsfrac

Sun Microsystems Sun Fire X Server

操作系统 solarisu x_

VVR版本: Veritas Volume Replicator GA

Oracle 版本 Oracle gR Enterprise Edition

磁盘阵列SAN/ HDS AMS

Public网卡eg 私有(复制)网卡eg

备用节点机器名lxsfrac

软硬件环境与主节点相同

两个节点分别安装VVR和vxfs安装方法相同以lxsfrac为例

放入安装介质一般Solaris都由vold进程自动mount CD

如果需要手工

mountmount–Fhsfs–oro/dev/dsk/ctds/cdrom

root@lxsfrac#cd/volume_replicator/

root@lxsfrac#ls

copyrightdocsinstallvvrpkgsrelease_notesscriptstoolsuninstallvvr

root@lxsfrac#lsl

total

rwrrrootrootDeccopyright

drwxrwxrxrootrootJun:docs

rwxrxrxrootrootAprinstallvvr

drwxrwxrxrootrootJun:pkgs

drwxrwxrxrootrootJun:release_notes

drwxrwxrxrootrootJun:scripts

drwxrwxrxrootrootJun:tools

rwxrxrxrootrootApruninstallvvr

root@lxsfrac#/installvvrlxsfrac

VeritasVolumeReplicatorInstallationProgram

Copyright(c)SymantecCorporationAllrightsreservedSymantectheSymantecLogoaretrademarksorregisteredtrademarksofSymantecCorporationoritsaffiliatesintheUSandothercountriesOthernamesmaybetrademarksoftheirrespectiveowners

TheLicensedSoftwareandDocumentationaredeemedtobecommercialcomputersoftwareandcommercialcomputersoftwaredocumentationasdefinedinFARSectionsandDFARSSection

Logsforinstallvvrarebeingcreatedin/var/tmp/installvvrmrkY

Initialsystemcheck:

CheckingVVRinstallationonlxsfracnotinstalled

Checkingarchitectureonlxsfraci

VeritasVolumeReplicatorInstallationProgram

Checkingsystemlicensing

Installinglicensingpackages

VVRisnotlicensedonlxsfrac

EnteraVVRlicensekeyforlxsfrac:******************

******************successfullyregisteredonlxsfrac

PermanentVVRlicenseregisteredonlxsfrac

Doyouwanttoenteranotherlicensekeyforlxsfrac?[ynq](n)

VeritasVolumeReplicatorInstallationProgram

Checkinginstalledpackagesonlxsfrac

VeritasVolumeReplicatorInstallationProgram

VVRcanbeinstalledwithoutoptionalpackagestoconservediskspace

Additionalpackagesaretypicallyinstalledtosimplifyfutureupgrades

)RequiredVeritasVolumeReplicatorpackagesMBrequired

)AllVeritasVolumeReplicatorpackagesMBrequired

)StorageFoundationEnterprisepackagesMBrequired

Selectthepackagestobeinstalledonallsystems?[q?]()

VeritasVolumeReplicatorInstallationProgram

ThefollowingVVRpackageswillbeinstalled:

VRTSperlVeritasPerlRedistribution

VRTSvlicVeritasLicensing

VRTSicscoSymantecCommonInfrastructure

VRTSpbxSymantecPrivateBranchExchange

VRTSsmfSymantecServiceManagementFramework

VRTSatSymantecProductAuthenticationService

VRTSobcVeritasEnterpriseAdministratorCoreService

VRTSobVeritasEnterpriseAdministratorService

VRTSobguiVeritasEnterpriseAdministrator

VRTSccgVeritasEnterpriseAdministratorCentralControlGrid

VRTSmhVeritasStorageFoundationManagedHostbySymantec

VRTSaaVeritasEnterpriseAdministratorActionAgent

VRTSsptVeritasSoftwareSupportTools

SYMClmaSymantecLicenseInventoryAgent

VRTSvxvmVeritasVolumeManagerBinaries

VRTSdsaVeritasDatacenterStorageAgent

VRTSfsproVeritasFileSystemManagementServicesProvider

VRTSvmmanVeritasVolumeManagerManualPages

VRTSvmdocVeritasVolumeManagerDocumentation

Press[Return]tocontinue:

ntinued:

VRTSdcliVeritasDistributedCommandLineInterface

VRTSallocVeritasVolumeManagerIntelligentStorageProvisioning

VRTSvmproVeritasVolumeManagerManagementServicesProvider

VRTSddlprVeritasDeviceDiscoveryLayerServicesProvider

VRTSvrproVeritasVolumeReplicatorClientExtensionandProviderfor

VeritasEnterpriseAdministrator

VRTSvcsvrVeritasClusterServerAgentsforVVR

VRTSjreVeritasJavaRuntimeEnvironmentRedistribution

VRTSjreVeritasJavaRuntimeEnvironmentRedistribution

VRTSwebVeritasJavaWebServer

VRTSvrwVeritasVolumeReplicatorWebConsole

VRTSvrdocVeritasVolumeReplicatorDocumentation

Press[Return]tocontinue:

CheckingforanyAPdriverissuesonlxsfracNone

AcopyofapreviousVxVMconfigurationispresentonthesystemlxsfrac

DoyouwanttorestoreandreusethepreviousVxVMconfigurationofsystemlxsfrac[ynq?](y)n

VeritasVolumeReplicatorInstallationProgram

InstallingVVR:%■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

Installationcompletedsuccessfullyonallsystems

ItisoptionaltoconfigureVVRnowIfyouchoosetoconfigureVVRlateryoucaneitherdosomanuallyorruntheinstallvvrconfigurecommandTheproductinstallationscriptscanbefoundin/opt/VRTS/installdirectory

AreyoureadytoconfigureVVR?[ynq](y)

TheenclosurebasednamingschemeisafeatureofVeritasVolumeManagerItallowsonetoreferencedisksusingasymbolicnamethatismoremeaningfulthantheoperatingsystemsnormaldeviceaccessnameThissymbolicnameistypicallyderivedfromthearrayname

Doyouwanttosetuptheenclosurebasednamingscheme?[ynq?](n)y

VeritasVolumeReplicatorInstallationProgram

VeritasVolumeManagerdefaultdiskgroupnameconfiguration:

ManyVeritasVolumeManagercommandsaffectthecontentsorconfigurationofadiskgroupSuchcommandsrequirethattheuserspecifyadiskgroupThisisaccomplishedbyusingthegoptionofacommandorsettingtheVXVM_DEFAULTDGenvironmentvariableAnalternativetothesetwomethodsforsomecommandsistoconfigurethenameofthedefaultdiskgroupofasystem

Note:ThedefaultdiskgroupfeatureisnotavailablewiththeDCLIvxadm(M)andvxquery(M)commandsWhenusingthesecommandsarequireddiskgroupmustbeexplicitlyidentifiedusingthegoption

Doyouwanttosetupadefaultdiskgroupforeachsystem?[ynq?](y)n

VeritasVolumeReplicatorInstallationProgram

FollowingarethedefaultportsthatwillbeusedbyVVRonlxsfrac:

PortforVVRheartbeatcommunication:

Portforvradminddaemon:

Portforvxrsyncddaemon:

Portsfordatareplication:AnonymousPorts

TheportsindicatedforVVRheartbeatsandvradmindareIANAassigned

TheportsettingsshouldbeidenticalforsystemsthatwillbepartofthesameReplicatedDataSetTheyshouldalsobeidenticalforallthesystemsinacluster

DoyouwanttochangeanyoftheVVRportsonlxsfrac?[ynq](n)

VeritasVolumeReplicatorInstallationProgram

VVRStatisticsCollectionTool

TheVVRadministrativedaemonvradmindcancollectandmaintainvarious

statisticswhicharehelpfulinsolvingVVRperformanceissuesThis

collectioncanbetunedusingafewtunableslikethefrequencyfor

gatheringthestatisticsandthenumberofdaysforwhichthecollected

statisticsshouldbepreservedafterwhichtheearlierstatisticsare

automaticallydeleted

ThefrequencyofVVRstatisticscollectiononlxsfracissettoperseconds

DoyouwanttochangethefrequencyofVVRstatisticscollectiononlxsfrac?[ynq](n)

ThemaximumnumberofdaysforwhichVVRstatisticscanberetainedissettoonlxsfrac

DoyouwanttochangethemaximumnumberofdaysforretainingVVRstatisticsonlxsfrac?[ynq](n)

VeritasVolumeReplicatorInstallationProgram

ConfigurationofVVRtunables(Fortheadvanceduser)

DoyouwanttoviewormodifyVVRtunablesonlxsfrac?[ynq?](n)

VeritasVolumeReplicatorInstallationProgram

VerifytheinstallsystemsFullyQualifiedHostnames

Queryingfullyqualifieddomainnameofhostlxsfracfail

Press[Return]tocontinue:

UnabletofindFQHNforlxsfrac!

EnterthefullyqualifiedhostnameoflxsfracorQUITtoquitinstall

Enterthefullyqualifiedhostname:lxsfrac

VeritasVolumeReplicatorInstallationProgram

Choosehowthisinstallwillbemanaged

Thisproductcanconfiguredoneofthetwofollowingways:

*StorageFoundationManagementServermanagedhost(Recommended)

*Standalonehost

PrerequisitesforStorageFoundationManagementServermanagedhost:

*AStorageFoundationManagementServer(SFMS)isconfigured

*SFMSshouldbecurrentlyrunningandfullyoperational

*AuthenticationBrokerthatisusedbySFMSshouldberunning

Thefollowinginformationwouldberequestedduringconfiguration:

*ThehostnameoftheSFMS

*PreviouslysetSFMSagentaccountpassword

Therearenoprerequisitesfordeployingasastandalonehost

EnablingStorageFoundationManagementServermanagementsimplifiesandimprovesmanagementofthecomplexdatacenter

resourcesreducingplannedandunplanneddowntime

EnableStorageFoundationManagementServerManagement?[ynq](y)n

VeritasVolumeReplicatorInstallationProgram

VerifytheinstallsystemsFullyQualifiedHostnames

ConfiguringVEAinSTANDALONEmodeonlxsfracok

Configuringgridnodeonlxsfracok

Registeringgridnodeonlxsfracok

Configuringactionagentonlxsfracok

Registeringactionagentonlxsfracok

RegisteringStorageAgentonlxsfracok

DoyouwanttostartVeritasVolumeReplicatorprocessesnow?[ynq](y)

VeritasVolumeReplicatorInstallationProgram

StartingVVR:%■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■

Startupcompletedsuccessfullyonallsystems

Youdeclinedtosetupthenameofthedefaultdiskgroupforlxsfrac

Installationlogfilessummaryfileandresponsefilearesavedat:

/opt/VRTS/install/logs/installvvrmrkY

ToenableDynamicMultiPathing(DMP)MPxIOmustbedisabledRefertotheStorageFoundationReleaseNotesforfurtherdetailsondisablingMPxIO

检查vradmindeamon

root@lxsfrac#psef|grepvrad|grepvgrep

root::?:/usr/sbin/vradmind

安装VeritasFileSystem安装过程略

root@lxsfrac#cdfile_system/

root@lxsfrac#lsl

total

rwrrrootrootDeccopyright

drwxrwxrxrootrootJun:docs

rwxrxrxrootrootAprinstallfs

drwxrwxrxrootrootJun:pkgs

drwxrwxrxrootrootJun:release_notes

drwxrwxrxrootrootJun:scripts

rwxrxrxrootrootApruninstallfs

root@lxsfrac#/installfslxsfrac

Veritas Volume Replicator VVR的配置

两个节点上都需要做

修改两个节点的/etc/hosts

lxsfrac

lxsfrac

lxsfracpriv

lxsfracpriv

分别创建私有网络(专有)建议数据复制使用专用网络

root@lxsfrac # ifconfig eg plumb netmask up

root@lxsfrac # ifconfig eg plumb netmask up

root@lxsfrac # ping

is alive

创建相同名称的磁盘组(含有最少两个磁盘)相同名称数据卷oravol创建复制日志卷(SRL)

分别在本地安装Oracle gR(安装Oracle过程略)

root@lxsfrac # vxdg init oradg AMS_WMS_ AMS_WMS_

root@lxsfrac # vxassist g oradg make oravol g

root@lxsfrac # vxedit g oradg set user=oracle group=dba mode= oravol

root@lxsfrac # vxassist g oradg make srl m

在备用节点上修改配置文件/etc/vx/vras/rdg让其包含主节点上的disk group ID

(这里是lxsfrac)当创建备用RVG时这个文件用来对主节点的授权

可以通过vxprint –l来得到disk group ID

root@lxsfrac # vi /etc/vx/vras/rdg

………

lxsfrac

/etc/vx/vras/rdg lines characters

在主节点上

创建vxfs文件系统

mount F vxfs o largefiles /dev/vx/dsk/oradg/oravol /oracle

chown oracle:dba /oracle

切换到oracle用户使用dbca建库并且所有数据文件选择/oracle目录

创建Primary RVG

root@lxsfrac # vradmin g oradg createpri ora_rvg oravol srl

其中的oravol是要复制的数据卷列表当多于一个时用逗号隔开

创建Secondary RVG

root@lxsfrac # vradmin g oradg addsec ora_rvg lxsfracpriv lxsfracpriv

设置复制方式为异步

root@lxsfrac # vradmin g oradg set ora_rvg lxsfracpriv synchronous=off

开始复制

root@lxsfrac#vradmingoradgastartrepora_rvg

MessagefromPrimary:

VxVMVVRvxrlinkWARNINGVAttachingrlinktononemptyrvgAutosyncwillbeperformed

VxVMVVRvxrlinkINFOVSecondarydatavolumesdetectedwithrvgora_rvgasparent:

VxVMVVRvxrlinkINFOVoravol:len=primary_datavol=oravol

VxVMVVRvxrlinkINFOVAutosyncoperationhasstarted

root@lxsfrac#

root@lxsfrac#vradmingoradgfstartrepora_rvg

VxVMVVRvradminINFOVReplicationtoSecondaryhostlxsfracprivalreadystarted

检查相关信息和状态显示数据复制过程可以通过使用i参数指定interval

root@lxsfrac#vxrvggoradggetrlinksora_rvg

rlk_lxsfracpriv_ora_rvg

root@lxsfrac#vxrlinkgoradgstatusrlk_lxsfracpriv_ora_rvg

FriNov::

VxVMVVRvxrlinkINFOVRlinkrlk_lxsfracpriv_ora_rvgisinAUTOSYNCKbytesremaining

root@lxsfrac#vxrlinkgoradgstatusrlk_lxsfracpriv_ora_rvg

FriNov::

VxVMVVRvxrlinkINFOVRlinkrlk_lxsfracpriv_ora_rvgisinAUTOSYNCKbytesremaining

root@lxsfrac#vxrlinkgoradgstatusrlk_lxsfracpriv_ora_rvg

FriNov::

VxVMVVRvxrlinkINFOVRlinkrlk_lxsfracpriv_ora_rvgisinAUTOSYNCKbytesremaining

root@lxsfrac#vxrlinkgoradgstatusrlk_lxsfracpriv_ora_rvg

FriNov::

VxVMVVRvxrlinkINFOVRlinkrlk_lxsfracpriv_ora_rvgisuptodate

可以手工进行gracefully切换

root@lxsfrac#umount/oracle

root@lxsfrac#vradmingoradgmigrateora_rvglxsfracpriv

VxVMVVRvradminWARNINGVMakesureapplicationsusingPrimarydatavolumesarestopped

vradmin:Continuewithmigrate(y/n)?y

root@lxsfrac#

下面我们就在上面搭建好的VVR环境中对容灾数据进行切换测试

在下面测试中主节点为lxsfrac备用节点为lxsfrac

======================================显示主备节点状态=================================

root@lxsfrac#vradmingoradglrepstatusora_rvg

ReplicatedDataSet:ora_rvg

Primary:

Hostname:lxsfracpriv

RVGname:ora_rvg

DGname:oradg

RVGstate:enabledforI/O

Datavolumes:

VSets:

SRLname:srl

SRLsize:M

Totalsecondaries:

Secondary:

Hostname:lxsfracpriv

RVGname:ora_rvg

DGname:oradg

RlinkfromPrimary:rlk_lxsfracpriv_ora_rvg

RlinktoPrimary:rlk_lxsfracpriv_ora_rvg

Configuredmode:asynchronous

Latencyprotection:off

SRLprotection:autodcm

Datastatus:inconsistent

Replicationstatus:resyncinprogress(autosync)

Currentmode:asynchronous

Loggingto:DCM(containsKbytes)(autosync)

TimestampInformation:N/A

BandwidthLimit:N/A

====================================显示replicationlink状态=================================

root@lxsfrac#vxrlinkgoradgstatusrlk_lxsfracpriv_ora_rvg

MonNov::

VxVMVVRvxrlinkINFOVRlinkrlk_lxsfracpriv_ora_rvgisuptodate

====================================在主节点插入试验数据:================================

oracle@lxsfrac$sysdba

SQL*Plus:ReleaseProductiononMonNov::

Copyright(c)OracleAllrightsreserved

Connectedto:

OracleDatabasegEnterpriseEditionReleaseProduction

WiththePartitioningOLAPandDataMiningoptions

SQL>createtabletest(avarchar())tablespaceusers;

Tablecreated

SQL>insertintotestvalues();

rowcreated

SQL>commit;

Commitcomplete

SQL>insertintotestvalues();

rowcreated

SQL>

SQL>

SQL>commit;

Commitcomplete

======================================立即异常关闭oracle和操作系统============================

root@lxsfrac#psef|egrepora_|asm_|grepvgrep|grepvcrs|awk{print$}|xargskill

root@lxsfrac#

root@lxsfrac#psef|grepora

root::?:/opt/VRTSobc/pal/bin/vxpalaStorageAgentx

oracle::?:oracleracg(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle::pts/:bash

oracle::pts/:sqlplus/assysdba

root::pts/:grepora

root@lxsfrac#

root@lxsfrac#poweroff

从系统日志/var/tmp/messages可以查看到相关信息

Nov::lxsfracpoweroff:[IDauthcrit]poweroffedbyroot

=======================================在备用节点进行接管=======================================

root@lxsfrac#vradmingoradgmigrateora_rvglxsfracpriv

VxVMVVRvradminWARNINGVMakesureapplicationsusingPrimarydatavolumesarestopped

vradmin:Continuewithmigrate(y/n)?y

MessagefromHostlxsfracpriv:

VxVMVVRvradminERRORVSecondaryora_rvgdoesnothaveanactivePrimary

root@lxsfrac#

root@lxsfrac#vradmingoradgtakeoverora_rvg

root@lxsfrac#date

MonNov::CST

root@lxsfrac#vxprinthtqgoradg

dgoradgdefaultdefaultlxsfrac

dmAMS_WMS_AMS_WMS_auto

dmAMS_WMS_AMS_WMS_auto

rvora_rvgENABLEDACTIVEprimarysrl

rlrlk_lxsfracpriv_ora_rvgora_rvgENABLEDACTIVElxsfracprivoradgrlk_lxsfracpriv_ora_rvg

voravolora_rvgENABLEDACTIVESELECTfsgen

ploravoloravolENABLEDACTIVECONCATRW

sdAMS_WMS_oravolAMS_WMS_AMS_WMS_ENA

ploravoloravolENABLEDACTIVELOGONLYCONCATRW

sdAMS_WMS_oravolAMS_WMS_LOGAMS_WMS_ENA

ploravoloravolENABLEDACTIVELOGONLYCONCATRW

sdAMS_WMS_oravolAMS_WMS_LOGAMS_WMS_ENA

vsrlora_rvgENABLEDACTIVESELECTSRL

plsrlsrlENABLEDACTIVECONCATRW

sdAMS_WMS_srlAMS_WMS_AMS_WMS_ENA

root@lxsfrac#

================================启动备用节点Oracle数据库并检查数据完整========================

root@lxsfrac#mountFvxfs/dev/vx/dsk/oradg/oravol/oracle

root@lxsfrac#

root@lxsfrac#suoracle

SunMicrosystemsIncSunOSGenericJanuary

oracle@lxsfrac$sysdba

SQL*Plus:ReleaseProductiononMonNov::

Copyright(c)OracleAllrightsreserved

Connectedtoanidleinstance

SQL>startup

ORACLEinstancestarted

TotalSystemGlobalAreabytes

FixedSizebytes

VariableSizebytes

DatabaseBuffersbytes

RedoBuffersbytes

Databasemounted

Databaseopened

SQL>select*fromtest;

A

================================ 显示数据正常 ===========================

在第二个节点vxdg import oradg

然后recover

直到两个节点vxprint htqg oradg都正常ENABLED/ACTIVE

错误V我遇到了两次一次是在createpri一次在addsec原因是主备的DCM默认都需要mirror所以所在的磁盘组都最少包括两块磁盘(或LUN)通过vxdg g oradg adddisk another_disk解决

root@lxsfrac # vradmin g oradg createpri ora_rvg \ >systemsysauxtempusersexamplectlfilectlfilectlfileredoredoredoundospfile\

>srl

MessagefromPrimary:

VxVMvxassistERRORVCannotallocatespaceforblocklog

root@lxsfrac#vradmingoradgaddsecora_rvglxsfracprivlxsfracpriv

MessagefromHostlxsfracpriv:

VxVMvxassistERRORVCannotallocatespaceforblocklog

检查vvr后台进程

root@lxsfrac#psef|grepvrad|grepvgrep

root::?:/usr/sbin/vradmind

如果进程状态不对使用下面语句来手工启动

/etc/initd/vrasvradmindshstart

可以看到vradmin是随系统自启动的

root@lxsfrac#find/etc/rc*name*vr*print

/etc/rcd/Kvrasvradmind

/etc/rcd/Kvrasvradmind

/etc/rcd/Svradmind

/etc/rcSd/Kvrasvradmind

               

上一篇:Linux+Oracle数据库系统启动能有多快?

下一篇:在Oracle9iisqlplus中使用替换变量