oracle 12C RAC 服务的启停
发布时间:2020-12-12 16:19:00 所属栏目:百科 来源:网络整理
导读:单节点数据库启停 srvctlstopinstance-dvmtoradb-ivmtoradb1 srvctlstopinstance-dvmtoradb-ivmtoradb2 srvctlstart instance-dvmtoradb-ivmtoradb1 srvctlstart instance-dvmtoradb-ivmtoradb2 启动/停止所有实例及其启用的服务 srvctlstartdatabase-dvmtor
单节点数据库启停
srvctlstopinstance-dvmtoradb-ivmtoradb1
srvctlstopinstance-dvmtoradb-ivmtoradb2
srvctlstart instance-dvmtoradb-ivmtoradb1
srvctlstart instance-dvmtoradb-ivmtoradb2
启动/停止所有实例及其启用的服务 srvctlstartdatabase-dvmtoradb srvctlstopdatabase-dvmtoradb 关闭所有PDB SQL> alter session set container=CDB$ROOT; SQL> alter pluggable database all close; 停止/启动节点集群服务,须要以root用户 [grid@vmtrac1bin]$pwd /u01/app/12.1.0/grid/bin ./crsctlstopcluster-all -----停止所有节点集群服务 ./crsctlstopcluster -------停止本节点集群服务 oracle 12C与11G一样默认开机自启动集群服务 关闭顺序 :关闭PDB----->关闭数据库------>关闭集群服务 ( 先关闭PDB 在关闭数据库实例,否则smon将有一个自动回复过程) 启动顺序:开机自启动集群服务查看集群服务器是否正常---------->打开数据库--------->启动PDB(默认是在mount状态下) SQL>selectname,open_modefromv$pdbs; NAMEOPEN_MODE ---------------------------------------- PDB$SEEDREADONLY SSMIS1MOUNTED SSMIS2MOUNTED SSMIS3MOUNTED 在CDB模式下启动PDB SQL>alterpluggabledatabaseSSMIS1open; Pluggabledatabasealtered. SQL>selectname,open_modefromv$pdbs; NAMEOPEN_MODE ---------------------------------------- PDB$SEEDREADONLY SSMIS1READWRITE SSMIS2MOUNTED SSMIS3MOUNTED 在PDB模式下启动 SQL>altersessionsetcontainer=ssmis2; SQL>alterpluggabledatabaSEOpen; SQL>selectname,open_modefromv$pdbs; NAMEOPEN_MODE ---------------------------------------- SSMIS2READWRITE SQL>altersessionsetcontainer=ssmis3; SQL>alterpluggabledatabaSEOpenreadonly;(read only 模式) SQL>selectname,open_modefromv$pdbs; NAMEOPEN_MODE ---------------------------------------- SSMIS3READONLY 关闭PDB SQL>altersessionsetcontainer=ssmis3; SQL>shutdownimmediate; PluggableDatabaseclosed. SQL>selectname,open_modefromv$pdbs; NAMEOPEN_MODE ---------------------------------------- SSMIS3MOUNTED 在CDB下以sys用户创建PDB开机自启动触发器 CREATETRIGGERopen_all_pdbs AFTERSTARTUPONDATABASE BEGIN EXECUTEIMMEDIATE'alterpluggabledatabaseallopen'; ENDopen_all_pdbs; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |