oracle RAC的常用维护操作

 

 

1. 查看各资源状态(nodeapps节点应用程序,ASM实例,数据库实例等)

[root@rac01 u01]# su - grid ITPUB个人空间/E6dV0Cu3dZ#q,d
[grid@rac01 ~]$ crs_stat -t   (命令兼容10g)ITPUB个人空间VNg7\6fej*Y%u
Name          Type          Target    State    Host       
"^}2VW.@?*Z;T0
------------------------------------------------------------
-E#Z `$i3R @%iw0ora....ER.lsnrora....er.type ONLINE    ONLINE   rac01      
o*Co OU1S;?0ora....N1.lsnrora....er.type ONLINE    ONLINE   rac01      ITPUB个人空间Sb


Wk7l­w
ora....VOTE.dg ora....up.type ONLINE    ONLINE   rac01      ITPUB个人空间


zv+cR0Br])O
ora.ORADATA.dg ora....up.type ONLINE    ONLINE   rac01      
C&} rg2t6c0
ora....LASH.dgora....up.type ONLINE    ONLINE   rac01      ITPUB个人空间Yw-j_


OM


w
ora.asm        ora.asm.type  ONLINE    ONLINE   rac01      ITPUB个人空间~ E"b#D%}
ora.eons       ora.eons.type ONLINE    ONLINE   rac01      
1L me&i{!Z.}4s0
ora.gsd       ora.gsd.type   OFFLINE  OFFLINE              ITPUB个人空间8o ]X"X/U
ora....network ora....rk.type ONLINE    ONLINE   rac01      ITPUB个人空间+A?'Xh$^
ora.oc4j       ora.oc4j.type OFFLINE  OFFLINE              
;V


~t x
tY@0ora.ons        ora.ons.type  ONLINE    ONLINE   rac01      
!f"W&C


ow-cYoN0ora....SM1.asm application   ONLINE    ONLINE   rac01      
4THQ"hv4n0ora....01.lsnrapplication    ONLINE    ONLINE   rac01      ITPUB个人空间


{[&U"X.a:e6oS
ora.rac01.gsd  application    OFFLINE   OFFLINE              ITPUB个人空间1Q?u+]cj)Aa
ora.rac01.ons  application    ONLINE   ONLINE    rac01      ITPUB个人空间h]1|/d!| ~
ora.rac01.vip  ora....t1.type ONLINE   ONLINE    rac01      ITPUB个人空间*D3Jaxr` IvnZ%|
ora....SM2.asm application    ONLINE   ONLINE    rac02      
A7s,t |8JuKA _/M0
ora....02.lsnrapplication    ONLINE    ONLINE   rac02      
@8wJ%w;o0ora.rac02.gsd application    OFFLINE  OFFLINE              
S Ai,L0miy0ora.rac02.ons application    ONLINE    ONLINE   rac02      
MpM4X lS0ora.rac02.vip ora....t1.type ONLINE    ONLINE   rac02      

z P~@[
M+`0ora.racdb.db   ora....se.type ONLINE   ONLINE    rac01      ITPUB个人空间\;Q‑eD ?-X+d
ora....ry.acfs ora....fs.type ONLINE    ONLINE   rac01      
)x]\[`*A0
ora.scan1.vip ora....ip.type ONLINE    ONLINE   rac01      

ITPUB个人空间 m1_#uv0p-\'yKt
11g R2中,默认 oc4jgsd资源是 disable 的;oc4j  是用于WLM 的一个
5v$o'Fa
xP*r0
资源, WLM 11.2.0.2 才可用;gsd CRS 用于跟 9i RAC 进行通信的一ITPUB个人空间u-h'`P? A7s2C.eV$M
个模块,是为了向后兼容才保留的,不影响性能;建议不要刪除, 也不要尝试开ITPUB个人空间yo bc6fw
启他们忽略即可。   

11g RAC常用的是下面的命令:crsctl stat  resource -t .

[root@rac01 u01]# su - grid ITPUB个人空间4@+AuW ^(r
[grid@rac01 ~]$ crsctl stat  resource -t

如果后面不带 -t , 那么可以看到相对详细的资源信息ITPUB个人空间o/V!?‑IgA
[grid@rac01 ~]$ crsctl stat  resource

 

2. 常用开关机命令

注意, 11g RAC 开启资源相对比较慢(即使命令后面显示的资源都start succeeded,
5g\'\ wL ~F­}'`&U(D2[0
通过crs_stat -t查看都不一定online), 请注意命令操作后观察crs log变化,以免出
+Jk


x Jn7O2s/e/v@0现还没有开启就怀疑启动有异常而采取重复动作  

ITPUB个人空间+x Z QaZ
以下命令供参考:ITPUB个人空间­s8G#Y E%c
---------------------------------------------------
7?}V4a:A/M2n%d0
在本地服务器上停止Oracle Clusterware 系统:

[root@rac01 ~]# /u01/grid/11.2.0/bin/crsctl  stop  cluster
q(h)`+B `0
注:在运行“crsctl stop cluster”命令之后,如果 Oracle Clusterware 管理
.u%zW+n7l8Qj0资源中有任何一个还在运行,则整个命令失败。使用 -f 选项无条件地停止所有资源
‑R$W


Y&|"ZS_L"M R Nd0并停止 Oracle Clusterware 系统。

[root@rac02 ~]# /u01/grid/11.2.0/bin/crsctl  stop cluster  -all
l)D1|&N"S f4R(]Ac0
停止所有节点上的clusterware系统。

在本地服务器上启动oralce clusterware系统:ITPUB个人空间4l k ax;JS
[root@rac01 ~]# /u01/grid/11.2.0/bin/crsctl start cluster

注:可通过指定 -all 选项在集群中所有服务器上启动 Oracle Clusterware 系统。
!{V|j


o.Z p
r$@0[root@rac02 ~]# /u01/grid/11.2.0/bin/crsctl start cluster –all

还可以通过列出服务器(各服务器之间以空格分隔)在集群中一个或多个指定的服务器上启动 Oracle Clusterware

统:ITPUB个人空间Q(O&W#x e*e7zgB
[root@rac01 ~]# /u01/grid/11.2.0/bin/crsctl start cluster -n rac01 rac02

使用 SRVCTL 启动/停止所有实例:

[oracle@rac01 ~]# srvctl stop database -d racdb
%T!f:tP0H0
[oracle@rac01 ~]#srvctl start database -d racdb


+xk Z UM-gn0参考顺序

关机顺序:先关闭Oracle实例(或数据库),然后关闭ASM实例,最后关闭节点应用ITPUB个人空间0[f-@/F:U]Q'J
程序(虚拟 IPGSDTNS 监听器和 ONS) .

手工开机顺序:先启动节点应用程序(虚拟 IPGSDTNS 监听器和 ONS)。当成功
C*l9lW‑I0D"_0启动节点应用程序后,启动 ASM 实例。最后,启动 Oracle 实例(相关服务)以及
K:[K:Kp b&Q{ uYb O0企业管理器数据库控制台。

 

例子:

关闭:

在节点1上关闭所有节点的clusterware(如果有资源不能被关闭,使用-f).ITPUB个人空间.[ h/z0^#\R
[root@rac01 bin]# /u01/grid/11.2.0/bin/crsctl  stop cluster  -all

节点1,2上都关闭后我们查看ITPUB个人空间_:@D,PIn
[grid@rac02 rac02]$ crsctl stat resource -t ITPUB个人空间'Op@


U r iB-tk
CRS-4535: Cannot communicate with Cluster Ready ServicesITPUB个人空间0I$rb,Jbp
CRS-4000: Command Status failed, or completed with errors.

开启:
-DJ DvP&B {


E$f0[root@rac01 bin]# /u01/grid/11.2.0/bin/crsctl start  cluster  -all

ITPUB个人空间$k f‑F_/oy
一般来说,开启上面一个命令就够用了,但是如果发现有异常,比如db等很长
‑P(W+}^#w5GQbp0r0时间都没有onine, 我们也可以手工开启数据库(任何一个节点执行)ITPUB个人空间 \Fq.d(S;d gM+U K
[root@rac02 ~]# /u01/grid/11.2.0/bin/srvctl  start  database  -d racdb  

备注:ITPUB个人空间i6o"e0M mI!j&b
如果有需要也可以一个一个实例开启。ITPUB个人空间IU%OQ x
[root@rac02 ~]# /u01/grid/11.2.0/bin/srvctl start instance -d racdb -i racdb1ITPUB个人空间MO9j Jg!Q6a
[root@rac02 ~]# /u01/grid/11.2.0/bin/srvctl start instance -d racdb -i racdb2

 

3.  常用建立表空间及加入数据文件 

ITPUB个人空间5K{


T3cL2r9\
参考http://space.itpub.net/?uid-7607759-action-viewspace-itemid-670722  

[root@rac01 bin]# su - oracle  
:`&T4`"ov+K0
[oracle@rac01~]$ sqlplus / as sysdba ITPUB个人空间t-FeWxJ:lH
SQL> create tablespace test  datafile'+oradata/racdb/datafile/test01.dbf'  size 50m ;ITPUB个人空间!r ^:d­W1R9[+\'u
Tablespace created.

[root@rac02 ~]# su - grid


Y3E&SR6[P-E4t7Cn0[grid@rac02 ~]$ asmcmd
(wQ~2E8a!aT‑K0ASMCMD>ITPUB个人空间C\v|7UJ


Y2d!L
ASMCMD> pwd
­~W


?`,]X#Z[/Y4x9y0+oradata/racdb/datafile
7E,y4m_8B


G


C+z0ASMCMD>
[,h)poN8H@0ASMCMD> lsITPUB个人空间T/Z


e.wy
SYSAUX.261.739387301ITPUB个人空间 K3]Vd v5l#F
SYSTEM.260.739387283ITPUB个人空间U,zO,Ld
TEST.340.740166807ITPUB个人空间?*M lZkT&YH
UNDOTBS1.262.739387315ITPUB个人空间P:M&K*S!L#pG0m
UNDOTBS2.264.739387351ITPUB个人空间Q,v@e*z
USERS.265.739387361
uf,r/sf,Yk0
test01.dbf

SQL> alter tablespace test add datafile '+oradata/racdb/datafile/test02.dbf' size 50m ; 
YS!t8{r `%F7^'tw.x0
Tablespacealtered.

SQL>

ASMCMD> ls
5o%X&V*q1R0
SYSAUX.261.739387301
4L.j:K*A2s3O$Ey0SYSTEM.260.739387283ITPUB个人空间[M7~[#b"F
TEST.340.740166807ITPUB个人空间;{hQWp z
TEST.341.740166937
Q1x0s'X3c D‑}e4\0
UNDOTBS1.262.739387315ITPUB个人空间 x‑e,X^'Uf­b"t#o8Ll
UNDOTBS2.264.739387351ITPUB个人空间‑D-IO


a$m}-ou
USERS.265.739387361ITPUB个人空间K8c:L#LW2Y;u
test01.dbf
1?(b ]y­G2R'q$`NC0
test02.dbfITPUB个人空间-_I^­pQ*P"Kk$]f/J
ASMCMD>


uj5tz L i;U0ASMCMD> ls -al
hkpH[B4o&D0Type     Redund  Striped Time            Sys  NameITPUB个人空间g%EScclD*wN-I6W
DATAFILE  UNPROT  COARSE   JAN 11 17:00:00 Y    none => SYSAUX.261.739387301
‑G@
k O


I$c0DATAFILE  UNPROT  COARSE   JAN11 17:00:00  Y    none => SYSTEM.260.739387283ITPUB个人空间U‑d8j\3Ax'o Wo K!E
DATAFILE  UNPROT  COARSE   JAN 11 17:00:00 Y    +ORADATA/RACDB/DATAFILE/test01.dbf =>

TEST.340.740166807
uisk%D Y5yd0
DATAFILE UNPROT  COARSE   JAN 11 17:00:00  Y   +ORADATA/RACDB/DATAFILE/test02.dbf =>

TEST.341.740166937


^wLY*F#m0DATAFILE  UNPROT  COARSE  JAN 11 17:00:00  Y    none => UNDOTBS1.262.739387315
%iMh*R4?v0DATAFILE UNPROT  COARSE   JAN 11 17:00:00  Y    none=> UNDOTBS2.264.739387351ITPUB个人空间+p5Ekl'l5H i
DATAFILE  UNPROT  COARSE   JAN 11 17:00:00 Y    none => USERS.265.739387361ITPUB个人空间t1S i*rmj o ch
                                           N    test01.dbf =>

+ORADATA/RACDB/DATAFILE/TEST.340.740166807ITPUB个人空间X


J0v
cFm/ME m
                                           N    test02.dbf =>

+ORADATA/RACDB/DATAFILE/TEST.341.740166937ITPUB个人空间J‑{B)}DRB
ASMCMD>

 

4. 查看ASM实例及用户数据库实例(注意分别是gridoracle用户)ITPUB个人空间m­xu/S8c
查看ASM实例(grid用户登入,通过查看初始参数可以看到instance_name=+ASM1)

[grid@rac01 ~]$ idITPUB个人空间*k#C.r[-e


g{_P;g
uid=501(grid) gid=501(oinstall)groups=501(oinstall),504(asmadmin),506(asmdba),507(asmoper)ITPUB个人空间T X} ^ dAqI0E
?

[grid@rac01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 400:58:52 2011ITPUB个人空间v!^ ~oN2|


m2Jm
Copyright (c) 1982, 2009, Oracle.  All rights reserved.ITPUB个人空间_o Am:Xn
Connected to:
*ih


p8I2N.R0Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - ProductionITPUB个人空间 x P~J7Z@MQ3r


Q*u
With the Real Application Clusters and Automatic Storage Management options

SQL> show parameter

NAME                                TYPE        VALUE
:_)K6n ^w0
----------------------------------------------- ------------------------------
X"|0`Am0asm_diskgroups                      string      ORADATA, ORAFLASHITPUB个人空间Q w^


h&Zt
a u"\ Jh
asm_diskstring                      stringITPUB个人空间BRX(K­r
asm_power_limit                     integer     1
)Q0\ ^u9z(Y-Y0
asm_preferred_read_failure_groups   stringITPUB个人空间Ey0uR W
audit_file_dest                     string      /u01/grid/11.2.0/rdbms/auditITPUB个人空间{0C,\/k8a­v{
.....

查看用户数据库实例(oracle用户登入,查看instance_name=racdb2,显然是用户实例) 

[root@rac02 u01]# su - oracle
C{bQf0
[oracle@rac02 ~]$ITPUB个人空间%u


v
U)L |4G}
[oracle@rac02 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 401:01:04 2011

Copyright (c) 1982, 2009, Oracle.  All rightsreserved.
_(AV(F


KN8k h/kY @0Connected to:ITPUB个人空间 [Z!j O+S,h
Ki­u L

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionITPUB个人空间v*J7fJ"Rw
With the Partitioning, Real Application Clusters, Automatic Storage Management,OLAP,ITPUB个人空间qgKP;m1n-\w
Data Mining and Real Application Testingoptions

SQL> show parameter

NAME                                TYPE        VALUE
.k)_9| N%@3ogF0
----------------------------------------------- ------------------------------
*c A4r+s)n
XI0O7_DICTIONARY_ACCESSIBILITY         boolean     FALSE
T'~bzS/N'`0active_instance_count               integerITPUB个人空间 Y'x(mW&[D O,G
aq_tm_processes                     integer     0ITPUB个人空间e3X6\"T6PlL:Q
archive_lag_target                  integer     0ITPUB个人空间w t0VN­Z
asm_diskgroups                      stringITPUB个人空间-o4^9u0n v)L
t

asm_diskstring                      stringITPUB个人空间R j\i$V+_9wM8G
asm_power_limit                     integer     1ITPUB个人空间TB
D,gE^}­E y#[z4Z

.......

5. 查看11g 数据库实例的alert logtrace  

[oracle@rac01 trace]$ pwdITPUB个人空间B;g0H­?{2zG4k
/u01/product/oracle/diag/rdbms/racdb/racdb1/traceITPUB个人空间o)gfP}
[oracle@rac01 trace]$
w­l%I,eR8R0
[oracle@rac01 trace]$vi  alert_racdb1.log

 

6. 查看11g RAC Clusterwarelog

[root@rac01 sbin]# su - gridITPUB个人空间{#E)~hv4T]J
[grid@rac01 ~]$
%|;u:Dz
E(k0
[grid@rac01 rac01]$ pwd
pp%G)ZN"mUr0/u01/grid/11.2.0/log/rac01


b$Ze


L{ r5}0[grid@rac01 trace]$ pwdITPUB个人空间A)o$T*F kG;C
/u01/grid/11.2.0/log/diag/tnslsnr/rac01/listener_scan1/trace
jM/k


z%M$J-]:Q0[grid@rac01 trace]$ ls
4B0U0f­y bwK-MV0listener_scan1.log


P1s/Z3OH7RH:a0[grid@rac01rac01]$ pwdITPUB个人空间V1F j w`7NX
/u01/grid/11.2.0/log/rac01
/Voc tu8w!V0
[grid@rac01 rac01]$ls
3PQ/vJ[ w0admin/ alertrac01.log  crsd/  ctssd/    evmd/  gnsd/   mdnsd/  racg/
.b&J(L2^8e0agent/  client/        cssd/  diskmon/  gipcd/  gpnpd/  ohasd/  srvm/

 

7. 常用集群命令

ITPUB个人空间 ?0Mf%g G#f/MD
[grid@rac02 ~]$ crs_stat -t 


1`e Jh(D]E0检查Oracle Clusterware 是否在线

[grid@rac02 ~]$ crsctl check crs
.`L\r$w's,o0
CRS-4638: OracleHigh Availability Services is online
4~^:|L"FE z0CRS-4537:Cluster Ready Services is online
B$RK"dt p0CRS-4529: ClusterSynchronization Services is online
2h.S O@s0CRS-4533: Event Manageris online


x2e,m6faf*v0检查cssd (Cluster Synchronization Services) 是否在线

[grid@rac02 ~]$ crsctl check cssdITPUB个人空间O+`'d-I4q VK7Y
CRS-272: This command remains for backward compatibility only
J(R T,X"^:x0
ClusterSynchronization Services is online


%G2~#wc7~P4`j,T0检查crsd (Cluster Ready Services) 是否在线

[grid@rac02 ~]$ crsctl check crsd  
d)n;GGV­[


Z2{I:F0CRS-272: This command remains for backwardcompatibility onlyITPUB个人空间 rU h‑G!x
Cluster Ready Services is online

ITPUB个人空间{I T;p:Y
检查evmd (Event Mananger)是否在线

[grid@rac02 ~]$ crsctl check evmdITPUB个人空间‑pL3X`
d

CRS-272: This command remains for backward compatibility only
D2J2D AAZC)u-a.J0
Event Manageris online

ITPUB个人空间H"a2e ^KY1q@2\
在节点间检查CSS的存活

[grid@rac02 ~]$ crsctl check cluster -n  rac01ITPUB个人空间­XE#n(Kr|A3J
**************************************************************
/^u@} P4C{V0
rac01:ITPUB个人空间AMm(Sb|x-r
CRS-4537: Cluster Ready Services is onlineITPUB个人空间 aS!d)Zc8[2u(D
CRS-4529: Cluster Synchronization Services is onlineITPUB个人空间4JC A{'I:y L
CRS-4533: Event Manager is onlineITPUB个人空间~!v9I
R \

**************************************************************

[grid@rac02 ~]$ crsctl check cluster -n  rac02ITPUB个人空间/WZ)Lf4?b
**************************************************************ITPUB个人空间6c­?*|f3X


|la
rac02:
‑T|Qj5] EtM0
CRS-4537: ClusterReady Services is online
;k!l(_‑A:xS Fm0CRS-4529: ClusterSynchronization Services is onlineITPUB个人空间$m2t$k k+U| R


n'A
CRS-4533: Event Manager is onlineITPUB个人空间3L$z
KniwJ

**************************************************************

ITPUB个人空间/LA(o U,H Z
开启数据库

[grid@rac02 ~]$ srvctl start database -d racdb

开启oc4j :

[grid@rac02 ~]$ ./srvctl enable oc4jITPUB个人空间%l3S2W\‑j e


v1s
[grid@rac02 ~]$ ./srvctl start oc4j
v5e6F^,c td3d0
[grid@rac02 ~]$./crs_stat -t

 


sz


Y


A/\)k5`S‑^w08.  vote disk 管理 

[grid@rac01 ~]$ ocrcheck    
3vD­im$j"['Y0
Status ofOracle Cluster Registry is as follows :ITPUB个人空间-uz#g3lJ2R`3jC
        Version                 :          3
8W*M&z[J^.t]0
        Total space (kbytes)     :     262120
S|VR^0        Used space (kbytes)     :       2720ITPUB个人空间 G


v!Q+^­S6Y4fA
         Available space (kbytes):     259400ITPUB个人空间‑\


z8?4}'V^V
        ID                      :  132900461ITPUB个人空间7K A6x? z \&P+~S a
         Device/FileName         :  +OCR_VOTE
;{v:Ov [0
                                   Device/File integrity check succeeded

                                   Device/File not configured

                                   Device/File not configured

                                   Device/File not configured

                                   Device/File not configured

         Clusterregistry integrity check succeeded

         Logicalcorruption check bypassed due to non-privileged user


H&V6v6vS+v|8N$X0Oracle11g R2中,不必备份voting disk, 当任何配置发生改变,voting disk
/j
?6gL[.n!G/`0
数据会自动备份OCR中,并自动恢复到任何加入的voting disk中。从下面可以看ITPUB个人空间,?!y.N!qK!le
OCRVotingDisk是一个文件。

ITPUB个人空间
c3I9D.Vo


g+h2O


O
[grid@rac01 ~]$ crsctl  query css votediskITPUB个人空间0|,r;K(AE0e-U‑F7U
##  STATE    File UniversalId               File Name Disk groupITPUB个人空间O4Z­RZy
--  -----    -----------------               --------- ---------
&L8GB `vi­| _W/q0
 1.ONLINE   095112005ec24f57bf98f6148818cc53 (ORCL:OCR_VOTE01)[OCR_VOTE]ITPUB个人空间cA!Y/S‑_I i2o
Located 1 voting disk(s).ITPUB个人空间7c9]:EXQ\J%Y


]
[grid@rac01 ~]$

ITPUB个人空间:dB‑c R6V q
[grid@rac01 ~]$ asmcmdITPUB个人空间6lj4e| XS
ASMCMD> lsITPUB个人空间7|k x-No­v AW-g
OCR_VOTE/ITPUB个人空间:|-X%@r#]$YU
ORADATA/ITPUB个人空间q&g,E Iq@b
ORAFLASH/
;Z


\V8euK0ASMCMD> cd ocr_vote
(c r:t&i(HM5J


Ez6z0ASMCMD> cd rac
v0X,M6R2_E0ASMCMD> ls
1x0{(o!z$\8lg0ASMPARAMETERFILE/
f0X_J7\y


y0OCRFILE/ITPUB个人空间


i _;Ip
`
ASMCMD> cd ocrfileITPUB个人空间0[ f6DvS­H2qp
ASMCMD> ls
^xs4\2_D%I0
REGISTRY.255.739337635

ITPUB个人空间hO\?;i
OCR 管理

[grid@rac01 ~]$ crsctl query crs activeversion
‑g-u,]‑[%sf'wFh0
OracleClusterware active version on the cluster is [11.2.0.1.0]


yysE%R ]i0[grid@rac01 ~]$ocrcheckITPUB个人空间_k%?­t_C2[ Ac~
Status of Oracle Cluster Registry is as follows :ITPUB个人空间"Jb‑C}B+|dO&c
        Version                 :          3ITPUB个人空间th­y


L d8}
         Total space (kbytes)    :     262120
"LF [4D[i%H‑Z0
        Used space (kbytes)     :       2720ITPUB个人空间!j9v!pN{`:f


n#b
         Available space (kbytes):     259400ITPUB个人空间+HCb(q­PIku*Z
x/\

        ID                      :  132900461ITPUB个人空间;_x q2}'g&N8E
         Device/FileName         :  +OCR_VOTEITPUB个人空间%jx-c'h:aat
                                   Device/File integrity check succeeded

                                   Device/File not configured

                                   Device/File not configured

                                   Device/File not configured

                                   Device/File not configured

         Clusterregistry integrity check succeeded

         Logicalcorruption check bypassed due to non-privileged user


4w­I+V9a:h/W0q2ZI [ W"x7x#]0使用下面命令(root登陆)使用 destination_file 或者 +ASM_disk_group取代现在的OCR Location:

# ocrconfig -replace current_OCR_location -replacementnew_OCR_location

如果只有一个OCR Location, 那么使用下面的命令:ITPUB个人空间)t‑Qe!zM,v


z R8S&z TJ)o
# ocrconfig -add  +new_storage_disk_group
R[5m5wh[k|hw-k0o0
# ocrconfig-delete  +current_disk_group


p/S/b1r&f+{(Q ST


A0运行下面的命令显示备份:

[grid@rac01 ~]$ ocrconfig   -showbackup 
w_*E‑s6^#^/~0
rac01    2011/01/08 17:54:51    /u01/grid/11.2.0/cdata/rac/backup00.ocrITPUB个人空间)Ov}p#a3g­y
rac01     2011/01/08 13:54:49    /u01/grid/11.2.0/cdata/rac/backup01.ocrITPUB个人空间9iIE"j'`.@
rac02     2011/01/08 06:34:46    /u01/grid/11.2.0/cdata/rac/backup02.ocr
c h c
B1WH


v6AAf'^0rac01     2011/01/0702:15:37     /u01/grid/11.2.0/cdata/rac/day.ocr
K­F4m%@g.R+w0rac01    2011/01/02 07:51:43     /u01/grid/11.2.0/cdata/rac/week.ocrITPUB个人空间'D}:z3Eu
PROT-25: Manual backups for the Oracle Cluster Registry are not available

 

Oracle Clusterware起来的时候,在一个节点上运行ocrconfig -manualbackup命令

[grid@rac01 ~]$ ocrconfig   -manualbackup
‑NN&s CB


LM­n+b l0 /u01/grid/11.2.0/cdata/rac/day.ocr下生成备份文件 backup_20100112_141900.ocr

然后使用 $ ocrconfig -showbackup 可以查看到备份信息。

运行下面的命令检验备份文件内容及完整性。
y*O:[%Zv?0$ ocrdump -backupfilebackup_file_name   

 

 

 

oracle rac日常基本维护命令 所有实例和服务的状态 $ srvctl status database -d orcl Instance orcl1 is running on node linux1 Instance orcl2 is running on node linux2 单个实例的状态 $ srvctl status instance -d orcl -i orcl2 Instance orcl2 is running on node linux2 在数据库全局命名服务的状态 $ srvctl status service -d orcl -s orcltest Service orcltest is running on instance(s) orcl2, orcl1 特定节点上节点应用程序的状态 $ srvctl status nodeapps -n linux1 VIP is running on node: linux1 GSD is running on node: linux1 Listener is running on node: linux1 ONS daemon is running on node: linux1 ASM 实例的状态 $ srvctl status asm -n linux1 ASM instance +ASM1 is running on node linux1. 列出配置的所有数据库 $ srvctl config database orcl 显示 RAC 数据库的配置 $ srvctl config database -d orcl linux1 orcl1 /u01/app/oracle/product/10.2.0/db_1 linux2 orcl2 /u01/app/oracle/product/10.2.0/db_1 显示指定集群数据库的所有服务 $ srvctl config service -d orcl orcltest PREF: orcl2 orcl1 AVAIL: 显示节点应用程序的配置 —(VIP、GSD、ONS、监听器) $ srvctl config nodeapps -n linux1 -a -g -s -l VIP exists.: /linux1-vip/192.168.1.200/255.255.255.0/eth0:eth1 GSD exists. ONS daemon exists. Listener exists. 显示 ASM 实例的配置 $ srvctl config asm -n linux1 +ASM1 /u01/app/oracle/product/10.2.0/db_1 集群中所有正在运行的实例 SELECT inst_id , instance_number inst_no , instance_name inst_name , parallel , status , database_status db_status , active_state state , host_name host FROM gv$instance ORDER BY inst_id; INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST -------- -------- ---------- --- ------- ------------ --------- ------- 1 1 orcl1 YES OPEN ACTIVE NORMAL rac1 2 2 orcl2 YES OPEN ACTIVE NORMAL rac2 位于磁盘组中的所有数据文件 select name from v$datafile union select member from v$logfile union select name from v$controlfile union select name from v$tempfile; NAME ------------------------------------------- +FLASH_RECOVERY_AREA/orcl/controlfile/current.258.570913191 +FLASH_RECOVERY_AREA/orcl/onlinelog/group_1.257.570913201 +FLASH_RECOVERY_AREA/orcl/onlinelog/group_2.256.570913211 +FLAS
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值