ITPub博客

首页 > 数据库 > Oracle > oracle11g RAC 启动归档模式

oracle11g RAC 启动归档模式

原创 Oracle 作者:q418441117 时间:2016-04-22 11:52:18 0 删除 编辑

根据客户要求,需要将归档日志存放在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 ~]$

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26655292/viewspace-2085972/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-09-11

  • 博文量
    203
  • 访问量
    418771