oracle11gRAC启动归档模式的示例分析
今天就跟大家聊聊有关oracle11g RAC启动归档模式的示例分析，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。
创新互联建站主营麟游网站建设的网络公司,主营网站建设方案,成都app开发,麟游h5微信小程序开发搭建,麟游网站营销推广欢迎麟游等地区企业咨询
根据客户要求，需要将归档日志存放在ASM上。因此需要在ASM建归档路径
ASMCMD> mkdir arch
ASMCMD> cd arch
ASMCMD> pwd
+data1/kdcs/arch
修改归档路径参数
SQL> alter system set log_archive_dest_1='location=+data1/kdcs/arch' scope=spfile sid='*';
System altered.
关闭数据库，全部节点都要关闭
[grid@zhcs-db1 ~]$ srvctl stop database -d kdcs
检查数据库关闭后状态
[grid@zhcs-db1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.LISTENER.lsnr
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.OCR_DISK.dg
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.asm
ONLINE ONLINE zhcs-db1 Started
ONLINE ONLINE zhcs-db2 Started
ora.gsd
OFFLINE OFFLINE zhcs-db1
OFFLINE OFFLINE zhcs-db2
ora.net1.network
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.ons
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.registry.acfs
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE zhcs-db1
ora.cvu
1 OFFLINE OFFLINE
ora.kdcs.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.kdcs.ser_scanip.svc
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.oc4j
1 ONLINE ONLINE zhcs-db2
ora.scan1.vip
1 ONLINE ONLINE zhcs-db1
ora.zhcs-db1.vip
1 ONLINE ONLINE zhcs-db1
ora.zhcs-db2.vip
1 ONLINE ONLINE zhcs-db2
将一个节点数据库启动到mount状态
[grid@zhcs-db1 ~]$ srvctl start instance -d kdcs -i kdcs1 -o mount
修改数据库的归档模式并启动数据库
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
检查状态
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA1/kdcs/arch
Oldest online log sequence 86
Next log sequence to archive 87
Current log sequence 87
SQL>
启动2节点数据库
[grid@zhcs-db1 ~]$ srvctl start instance -d kdcs -i kdcs2
检查集群状态
[grid@zhcs-db1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.LISTENER.lsnr
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.OCR_DISK.dg
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.asm
ONLINE ONLINE zhcs-db1 Started
ONLINE ONLINE zhcs-db2 Started
ora.gsd
OFFLINE OFFLINE zhcs-db1
OFFLINE OFFLINE zhcs-db2
ora.net1.network
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.ons
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.registry.acfs
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE zhcs-db1
ora.cvu
1 OFFLINE OFFLINE
ora.kdcs.db
1 ONLINE ONLINE zhcs-db1 Open
2 ONLINE ONLINE zhcs-db2 Open
ora.kdcs.ser_scanip.svc
1 ONLINE ONLINE zhcs-db1
2 ONLINE ONLINE zhcs-db2
ora.oc4j
1 ONLINE ONLINE zhcs-db2
ora.scan1.vip
1 ONLINE ONLINE zhcs-db1
ora.zhcs-db1.vip
1 ONLINE ONLINE zhcs-db1
ora.zhcs-db2.vip
1 ONLINE ONLINE zhcs-db2
[grid@zhcs-db1 ~]$
看完上述内容，你们对oracle11g RAC启动归档模式的示例分析有进一步的了解吗？如果还想了解更多知识或者相关内容，请关注创新互联行业资讯频道，感谢大家的支持。
新闻名称：oracle11gRAC启动归档模式的示例分析
网站网址：http://myzitong.com/article/gccjjd.html