使用srvctl工具管理Oracle RAC 数据库.docx
《使用srvctl工具管理Oracle RAC 数据库.docx》由会员分享，可在线阅读，更多相关《使用srvctl工具管理Oracle RAC 数据库.docx（13页珍藏版）》请在冰点文库上搜索。
使用srvctl工具管理OracleRAC数据库
使用srvctl工具管理OracleRAC数据库
（v1.0）
作者
颜超
审核
分类
数据库系统
子类
Oracle数据库
更新时间
2012-4-14
关键字
OracleRAC
摘要
srvctl即ServerControl,是一个命令行工具，用以管理Oracle的RAC环境，srvctl在Oracle9i中引入，Oracle10g对其功能进行了大大增强。
主要适用环境
Oracle10gRAC及以上版本
版本说明
版本号
拟制/修改责任人
拟制/修改日期
修改内容/理由
v1.0
颜超
2012-4-14
新建
srvctl即ServerControl,是一个命令行工具，用以管理Oracle的RAC环境，srvctl在Oracle9i中引入，Oracle10g对其功能进行了大大增强。
在命令行下，使用-h参数可以察看srvctl支持的命令及参数:
bash-2.05$srvctl-h
Usage:
srvctl[-V]
................
Usage:
srvctladdasm-n-i-o[-p]
Usage:
srvctlconfigdatabase
Usage:
srvctlconfigdatabase-d[-a][-t]
Usage:
srvctlconfigservice-d[-s][-a][-S]
Usage:
srvctlconfignodeapps-n[-a][-g][-o][-s][-l]
Usage:
srvctlconfigasm-n
Usage:
srvctlconfiglistener-n
Usage:
srvctldisabledatabase-d
.....................
常用的命令主要如下:
1.使用srvctlstatus查看数据库及实例状态
查看数据库的状态
bash-2.05$srvctlstatusdatabase-deygle
Instanceeygle1isrunningonnodedb210-rac1
Instanceeygle2isrunningonnodedb210-rac2
查看数据库实例的状态
bash-2.05$srvctlstatusinstance-deygle-ieygle1,eygle2
Instanceeygle1isrunningonnodedb210-rac1
Instanceeygle2isrunningonnodedb210-rac2
2.使用srvctlstop停止数据库或实例
停止实例使用srvctlstopinstance命令:
bash-2.05$srvctlstopinstance
PRKO-2001:
Invalidcommandlinesyntax
bash-2.05$srvctlstopinstance-h
Usage:
srvctlstopinstance-d-i""[-o][-c|-q]
-dUniquenameforthedatabase
-i""Commaseparatedinstancenames
-oOptionstoshutdowncommand（e.g.normal,transactional,immediate,orabort）
-cConnectstring（default:
/assysdba）
-qQueryconnectstringfromstandardinput
-hPrintusage
在命令行发出如下命令：
bash-2.05$srvctlstopinstance-deygle-ieygle2
在该节点的警告日志文件中就可以看到如下关闭信息:
ThuDec2814:
32:
042006
Shuttingdowninstance:
furtherlogonsdisabled
ThuDec2814:
32:
042006
StoppingbackgroundprocessQMNC
ThuDec2814:
32:
042006
StoppingbackgroundprocessCJQ0
ThuDec2814:
32:
062006
StoppingbackgroundprocessMMNL
ThuDec2814:
32:
072006
StoppingbackgroundprocessMMON
ThuDec2814:
32:
082006
Shuttingdowninstance（immediate）
Licensehighwatermark=11
ThuDec2814:
32:
082006
StoppingJobqueueslaveprocesses
ThuDec2814:
32:
082006
Jobqueueslaveprocessesstopped
ThuDec2814:
32:
152006
PMONfailedtoacquirelatch,seePMONdump
ThuDec2814:
32:
162006
ALTERDATABASECLOSENORMAL
ThuDec2814:
32:
162006
SMON:
disablingtxrecovery
SMON:
disablingcacherecovery
ThuDec2814:
32:
172006
Shuttingdownarchiveprocesses
Archivingisdisabled
Archiveprocessshutdownavoided:
0active
Thread2closedatlogsequence1
Successfulcloseofredothread2
ThuDec2814:
32:
172006
Completed:
ALTERDATABASECLOSENORMAL
ThuDec2814:
32:
172006
ALTERDATABASEDISMOUNT
Completed:
ALTERDATABASEDISMOUNT
ARCH:
Archivaldisabledduetoshutdown:
1089
Shuttingdownarchiveprocesses
Archivingisdisabled
Archiveprocessshutdownavoided:
0active
ARCH:
Archivaldisabledduetoshutdown:
1089
Shuttingdownarchiveprocesses
Archivingisdisabled
Archiveprocessshutdownavoided:
0active
ThuDec2814:
32:
202006
freeingrdom0
停止数据库使用srvctlstopdatabase命令；
bash-2.05$srvctlstopdatabase-h
Usage:
srvctlstopdatabase-d[-o][-c|-q]
-dUniquenameforthedatabase
-oOptionstoshutdowncommand（e.g.normal,transactional,immediate,orabort）
-cConnectstring（default:
/assysdba）
-qQueryconnectstringfromstandardinput
-hPrintusage
发出如下命令后，数据库停止:
bash-2.05$srvctlstopdatabase-deygle
日志文件记录如下过程:
ThuDec2814:
46:
222006
Shuttingdowninstance:
furtherlogonsdisabled
ThuDec2814:
46:
222006
StoppingbackgroundprocessCJQ0
ThuDec2814:
46:
222006
StoppingbackgroundprocessQMNC
ThuDec2814:
46:
242006
StoppingbackgroundprocessMMNL
ThuDec2814:
46:
252006
StoppingbackgroundprocessMMON
ThuDec2814:
46:
262006
Shuttingdowninstance（immediate）
Licensehighwatermark=15
ThuDec2814:
46:
262006
StoppingJobqueueslaveprocesses
ThuDec2814:
46:
262006
Jobqueueslaveprocessesstopped
ThuDec2814:
46:
332006
PMONfailedtoacquirelatch,seePMONdump
PMONfailedtoacquirelatch,seePMONdump
PMONfailedtoacquirelatch,seePMONdump
ThuDec2814:
46:
462006
PMONfailedtoacquirelatch,seePMONdump
ThuDec2814:
46:
472006
ALTERDATABASECLOSENORMAL
ThuDec2814:
46:
472006
SMON:
disablingtxrecovery
SMON:
disablingcacherecovery
ThuDec2814:
46:
472006
Shuttingdownarchiveprocesses
Archivingisdisabled
Archiveprocessshutdownavoided:
0active
Thread1closedatlogsequence16
Successfulcloseofredothread1
ThuDec2814:
46:
472006
Completed:
ALTERDATABASECLOSENORMAL
ThuDec2814:
46:
472006
ALTERDATABASEDISMOUNT
Completed:
ALTERDATABASEDISMOUNT
ARCH:
Archivaldisabledduetoshutdown:
1089
Shuttingdownarchiveprocesses
Archivingisdisabled
Archiveprocessshutdownavoided:
0active
ARCH:
Archivaldisabledduetoshutdown:
1089
Shuttingdownarchiveprocesses
Archivingisdisabled
Archiveprocessshutdownavoided:
0active
ThuDec2814:
46:
502006
freeingrdom0
3.使用srvctlstart命令启动数据库或实例
使用srvctlstartdatabase可以启动数据库的所有实例:
bash-2.05$srvctlstartdatabase-deygle
在第一个节点，警告日志记录了如下启动过程：
ThuDec2814:
54:
272006
StartingORACLEinstance（normal）
LICENSE_MAX_SESSION=0
LICENSE_SESSIONS_WARNING=0
Interfacetype1bge1192.168.18.0configuredfromOCRforuseasaclusterinterconnect
Interfacetype1bge2192.168.19.0configuredfromOCRforuseasaclusterinterconnect
Interfacetype1bge0172.16.19.0configuredfromOCRforuseasapublicinterface
Pickedlatch-freeSCNscheme3
UsingLOG_ARCHIVE_DEST_1parameterdefaultvalueas/opt/oracle/product/10.2.0/db/dbs/arch
Autotuneofundoretentionisturnedon.
LICENSE_MAX_USERS=0
SYSauditingisdisabled
ksdpec:
calledforevent13740priortoeventgroupinitialization
StartingupORACLERDBMSVersion:
10.2.0.1.0.
Systemparameterswithnon-defaultvalues:
processes=150
__shared_pool_size=301989888
__large_pool_size=16777216
__java_pool_size=16777216
__streams_pool_size=0
spfile=/dev/vx/rdsk/xxfdg/spfile
sga_target=1258291200
control_files=/dev/vx/rdsk/xxfdg/ctlfile1,/dev/vx/rdsk/xxfdg/ctlfile2
db_block_size=8192
__db_cache_size=905969664
compatible=10.2.0.1.0
db_file_multiblock_read_count=16
cluster_database=TRUE
cluster_database_instances=2
thread=2
instance_number=2
undo_management=AUTO
undo_tablespace=UNDOTBS2
remote_login_passwordfile=EXCLUSIVE
db_domain=
remote_listener=LISTENERS_EYGLE
job_queue_processes=10
background_dump_dest=/opt/oracle/admin/eygle/bdump
user_dump_dest=/opt/oracle/admin/eygle/udump
core_dump_dest=/opt/oracle/admin/eygle/cdump
audit_file_dest=/opt/oracle/admin/eygle/adump
db_name=eygle
open_cursors=300
pga_aggregate_target=418381824
Clustercommunicationisconfiguredtousethefollowinginterface（s）forthisinstance
192.168.18.12
192.168.19.12
ThuDec2814:
54:
292006
clusterinterconnectIPCversion:
OracleUDP/IP
IPCVendor1proto2
DIAGstartedwithpid=3,OSid=363
PMONstartedwithpid=2,OSid=361
PSP0startedwithpid=4,OSid=381
LMONstartedwithpid=5,OSid=393
ThuDec2814:
54:
302006
WARNING:
FailedtosetbufferlimitonIPCinterconnectsocket
OraclerequiresthattheSocketReceivebuffersizebetunableupto1MB
PleasemakesurethekernelparameterwhichlimitsSO_RCVBUFvaluesetby
applicationsisatleast1MB
LMD0startedwithpid=6,OSid=398
LMS0startedwithpid=7,OSid=405
LMS1startedwithpid=8,OSid=409
MMANstartedwithpid=9,OSid=413
DBW0startedwithpid=10,OSid=415
LGWRstartedwithpid=11,OSid=417
CKPTstartedwithpid=12,OSid=419
SMONstartedwithpid=13,OSid=433
RECOstartedwithpid=14,OSid=451
CJQ0startedwithpid=15,OSid=457
MMONstartedwithpid=16,OSid=459
MMNLstartedwithpid=17,OSid=462
ThuDec2814:
54:
312006
lmonregisteredwithNM-instanceid2（internalmemno1）
ThuDec2814:
54:
322006
Reconfigurationstarted（oldinc0,newinc2）
Listofnodes:
01
GlobalResourceDirectoryfrozen
*allocatedomain0,invalid=TRUE
Communicationchannelsreestablished
Masterbroadcastedresourcehashvaluebitmaps
Non-localProcessblockscleanedout
ThuDec2814:
54:
332006
LMS1:
0GCSshadowscancelled,0closed
ThuDec2814:
54:
332006
LMS0:
0GCSshadowscancelled,0closed
Setmasternodeinfo
Submittedallremote-enqueuerequests
Dwn-cvtsreplayed,VALBLKsdubious
Allgrantableenqueuesgranted
ThuDec2814:
54:
332006
LMS0:
0GCSshadowstraversed,0replayed
ThuDec2814:
54:
332006
LMS1:
0GCSshadowstraversed,0replayed
ThuDec2814:
54:
332006
SubmittedallGCSremote-cacherequests
Fixwriteingcsresources
Reconfigurationcomplete
LCK0startedwithpid=18,OSid=527
ThuDec2814:
54:
342006
ALTERDATABASEMOUNT
ThuDec2814:
54:
342006
Thisinstancewasfirsttomount
Settingrecoverytargetincarnationto1
ThuDec2814:
54:
392006
Successfulmountofredothread2,withmountid1429486954
ThuDec2814:
54:
392006
DatabasemountedinSharedMode（CLUSTER_DATABASE=TRUE）
Completed:
ALTERDATABASEMOUNT
ThuDec2814:
54:
402006
ALTERDATABASEOPEN
Thisinstancewasfirsttoopen
PickedbroadcastoncommitschemetogenerateSCNs
ThuDec2814:
54:
432006
Thread2advancedtologsequence2
Thread2openedatlogsequence2
Currentlog#4seq#2mem#0:
/dev/vx/rdsk/xxfdg/redo202
Successfulopenofredothread2
ThuDec2814:
54:
432006
MTTRadvisoryisdisabledbecauseFAST_START_MTTR_TARGETisnotset
ThuDec2814:
54:
432006
SMON:
enablingcacherecovery
ThuDec2814:
54:
452006
Instancerecovery:
lookingfordeadthreads
Instancerecovery
升级会员 