oracle11g RAC启动归档模式的示例分析

今天就跟大家聊聊有关oracle11g RAC启动归档模式的示例分析，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。

根据客户要求，需要将归档日志存放在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-1-work

               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-1-work

               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启动归档模式的示例分析有进一步的了解吗？如果还想了解更多知识或者相关内容，请关注行业资讯频道，感谢大家的支持。