在RAC环境中如何管理日志(redologfile)组

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

在RAC环境中如何管理日志(redologfile)组

Tuesday,2004-09-1411:52Eygle 
    
 
 原文连接:

http://www.eygle.com/faq/How.To.Mangement.redologfile.in.RAC.Raw.htm

本文简单介绍在RAC裸设备环境下如何管理日志文件(redologfile)

本文环境:9iRAC+VCS4.0+VxVM4.0+9.0+SunFire210

1.首先可以查看当前裸设备情况

#vxprintDiskgroup:oradgTYNAMEASSOCKSTATELENGTHPLOFFSSTATETUTIL0PUTIL0dgoradgoradg------dmoradg01c2t0d2s2-244143872----vctlfile1genENABLED204800-ACTIVE--plctlfile1-01ctlfile1ENABLED204800-ACTIVE--sdoradg01-13ctlfile1-01ENABLED2048000---vctlfile2genENABLED204800-ACTIVE--plctlfile2-01ctlfile2ENABLED204800-ACTIVE--sdoradg01-14ctlfile2-01ENABLED2048000---vredo101genENABLED204800-ACTIVE--plredo101-01redo101ENABLED204800-ACTIVE--sdoradg01-04redo101-01ENABLED2048000---vredo102genENABLED204800-ACTIVE--plredo102-01redo102ENABLED204800-ACTIVE--sdoradg01-05redo102-01ENABLED2048000---vredo103genENABLED204800-ACTIVE--plredo103-01redo103ENABLED204800-ACTIVE--sdoradg01-06redo103-01ENABLED2048000---vredo201genENABLED204800-ACTIVE--plredo201-01redo201ENABLED204800-ACTIVE--sdoradg01-07redo201-01ENABLED2048000---vredo202genENABLED204800-ACTIVE--plredo202-01redo202ENABLED204800-ACTIVE--sdoradg01-08redo202-01ENABLED2048000---vredo203genENABLED204800-ACTIVE--plredo203-01redo203ENABLED204800-ACTIVE--sdoradg01-09redo203-01ENABLED2048000---vspfilegenENABLED204800-ACTIVE--plspfile-01spfileENABLED204800-ACTIVE--sdoradg01-12spfile-01ENABLED2048000---vsrvcfggenENABLED1024000-ACTIVE--plsrvcfg-01srvcfgENABLED1024000-ACTIVE--sdoradg01-15srvcfg-01ENABLED10240000---vsystemgenENABLED1638400-ACTIVE--plsystem-01systemENABLED1638400-ACTIVE--sdoradg01-01system-01ENABLED16384000---vtempgenENABLED2048000-ACTIVE--pltemp-01tempENABLED2048000-ACTIVE--sdoradg01-02temp-01ENABLED20480000---vundo11genENABLED16777216-ACTIVE--plundo11-01undo11ENABLED16777216-ACTIVE--sdoradg01-10undo11-01ENABLED20480000---sdoradg01-17undo11-01ENABLED147292162048000---vundo21genENABLED2048000-ACTIVE--plundo21-01undo21ENABLED2048000-ACTIVE--sdoradg01-11undo21-01ENABLED20480000---vusersgenENABLED16777216-ACTIVE--plusers-01usersENABLED16777216-ACTIVE--sdoradg01-03users-01ENABLED20480000---sdoradg01-16users-01ENABLED147292162048000---

2.分配新的裸设备并设置相应的权限

这一步需要以root身份执行

 

#vxassist-goradg-Ugenmakeredo104100m
#vxassist-goradg-Ugenmakeredo105100m
#vxedit-goradgsetuser=oRAClemode=644redo104
#vxedit-goradgsetuser=oRAClemode=644redo105

 

3.重新规划redologfile组

$sqlplus"/assysdba"SQL*Plus:Release9.2.0.4.0-ProductiononTueSep1410:02:472004Copyright(c)1982,2002,ORACleCorporation.Allrightsreserved.Connectedto:ORACle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththeRealApplicationClustersoptionJServerRelease9.2.0.4.0-ProductionSQL>setlinesize120SQL>select*fromv$log;GROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST_CHANGE#FIRST_TIM-------------------------------------------------------------------------------------------116313524288001NOACTIVE319385514-SEP-04216312524288001NOINACTIVE319169114-SEP-04516314524288001NOCURRENT319604114-SEP-043217104857601NOCURRENT301631014-SEP-044216104857601NOINACTIVE161919813-SEP-04SQL>alterdatabaseaddlogfilethread1group6('/dev/vx/rdsk/oradg/redo104')size90M;Databasealtered.SQL>alterdatabaseaddlogfilethread1group7('/dev/vx/rdsk/oradg/redo105')size90M;Databasealtered.SQL>select*fromv$log;GROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST_CHANGE#FIRST_TIM-------------------------------------------------------------------------------------------116316524288001NOINACTIVE320041514-SEP-04216315524288001NOINACTIVE319823314-SEP-04516317524288001NOACTIVE320262114-SEP-04616318943718401NOCURRENT320481114-SEP-04710943718401YESUNUSED03217104857601NOCURRENT301631014-SEP-044216104857601NOINACTIVE161919813-SEP-047rowsselected.SQL>alterdatabasedroplogfilegroup5;Databasealtered.SQL>alterdatabaseaddlogfilethread1group5('/dev/vx/rdsk/oradg/redo103')size90M;Databasealtered.....SQL>select*fromv$log;GROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST_CHANGE#FIRST_TIM-------------------------------------------------------------------------------------------116327943718401NOINACTIVE323853414-SEP-04216329943718401NOCURRENT324641714-SEP-04510943718401YESUNUSED0616328943718401NOACTIVE324248214-SEP-04716326943718401NOINACTIVE323459714-SEP-043217104857601NOCURRENT301631014-SEP-044216104857601NOINACTIVE161919813-SEP-047rowsselected.1
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>