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

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </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)

本文环境:9i RAC+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=o RAClemode=644redo104
#vxedit-goradgsetuser=o RAClemode=644redo105

 

3.重新规划redologfile组

$sqlplus"/assysdba"SQL*Plus:Release9.2.0.4.0-ProductiononTueSep1410:02:472004Copyright(c)1982,2002,O RACleCorporation.Allrightsreserved.Connectedto:O RACle9iEnterpriseEditionRelease9.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"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>