11gRAC 使用ASM存储归档文件的归档模式切换

最新推荐文章于 2021-10-03 12:34:00 发布

gltyi99

最新推荐文章于 2021-10-03 12:34:00 发布

阅读量1.2k

点赞数

分类专栏： RAC 文章标签： 11gr2 集群磁盘 archivelog switch

本文链接：https://blog.csdn.net/ora01555/article/details/24645163

版权

RAC 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

在前面的文章《oracle-归档和非归档模式》（http://blog.csdn.net/ora01555/article/details/22783289）演示了如何将数据库切换到归档模式，这篇文章只是进一步的延伸，演示一下RAC下如何调整。
在11gRAC中，将归档文件更多的放到了共享存储并且使用ASM来管理，这样的好处就是恢复归档的时候，不在集群的各个节点去找归档，降低了恢复难度，减少了维护量。

一、新建ASM磁盘组来存储归档文件

-->新建ASM的磁盘组，需要使用sysasm权限账户登录
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 28 14:47:53 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
-->检查未使用磁盘
SQL> select name,path,state from v$asm_disk;
NAME                           PATH                                     STATE
------------------------------ ---------------------------------------- ----------------
                               /dev/asm-diskf                           NORMAL
                               /dev/asm-diske                           NORMAL
                               /dev/asm-diskg                           NORMAL
DATA1_0000                     /dev/asm-diskc                           NORMAL
DATA1_0001                     /dev/asm-diskd                           NORMAL
OCR_VOTEDISK_0000              /dev/asm-diskb                           NORMAL
6 rows selected.
-->创建arch磁盘组
SQL> create diskgroup arch external redundancy disk '/dev/asm-diskg';
Diskgroup created.
-->检查磁盘组状态
SQL> col name for a30
SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;
NAME                           STATE                    TOTAL_MB    FREE_MB
------------------------------ ---------------------- ---------- ----------
OCR_VOTEDISK                   MOUNTED                      5120       4724
DATA1                          MOUNTED                      4096       1681
ARCH                           MOUNTED                      2048       1998
-->在其他节点检查磁盘组状态
SQL> set linesize 200
SQL> col name for a30
SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;
NAME                           STATE                    TOTAL_MB    FREE_MB
------------------------------ ---------------------- ---------- ----------
OCR_VOTEDISK                   MOUNTED                      5120       4724
DATA1                          MOUNTED                      4096       1681
ARCH                           DISMOUNTED                      0          0
-->新建磁盘组状态为dismounted，需要将该磁盘组修改为mount状态
SQL> alter diskgroup arch mount;
Diskgroup altered.
-->再次检查
SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;
NAME                           STATE                    TOTAL_MB    FREE_MB
------------------------------ ---------------------- ---------- ----------
OCR_VOTEDISK                   MOUNTED                      5120       4724
DATA1                          MOUNTED                      4096       1681
ARCH                           MOUNTED                      2048       1955

二、切换归档模式
其实RAC和单机的数据库调整归档模式是一致的。例如RAC有2个节点，我们需要先关闭一个，然后再另一个节点调整，这个和单机库的调整是一致的，然后再启动另一个节点即可。
首先、关闭集群2节点数据库

SQL> show parameter instance_name;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      csdb2
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

此次、在集群1节点将数据库设置为归档模式

-->检查现在归档模式
SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/11.2.0/db_1/dbs/arch
Oldest online log sequence     65
Current log sequence           66
-->检查归档日志存储路径
SQL> show parameter log_archive_dest_1;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
-->设置归档日志文件路径
SQL> alter system set log_archive_dest_1='location=+arch' scope=spfile sid='*';
System altered.
-->关闭数据库并将数据库启动到归档模式
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2228904 bytes
Variable Size            1073745240 bytes
Database Buffers          570425344 bytes
Redo Buffers                7118848 bytes
Database mounted.
-->再次检查归档日志文件路径
SQL> show parameter log_archive_dest_1;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      location=+arch
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
-->修改数据库归档模式并将数据库打开
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            +ARCH
Oldest online log sequence     65
Next log sequence to archive   66
Current log sequence           6

再次、将2节点数据库启动

SQL> startup mount
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2228904 bytes
Variable Size            1124076888 bytes
Database Buffers          520093696 bytes
Redo Buffers                7118848 bytes
Database mounted.
SQL> 
SQL> show parameter log_archive_dest_1;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      location=+arch
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +ARCH
Oldest online log sequence     8
Next log sequence to archive   9
Current log sequence           9

最后、检查集群状态

[root@rac2 u01]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.DATA1.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.OCR_VOTEDISK.dg
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.asm
               ONLINE  ONLINE       rac1                     Started             
               ONLINE  ONLINE       rac2                     Started             
ora.gsd
               OFFLINE OFFLINE      rac1                                         
               OFFLINE OFFLINE      rac2                                         
ora.net1.network
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
ora.ons
               ONLINE  ONLINE       rac1                                         
               ONLINE  ONLINE       rac2                                         
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                                         
ora.csdb.db
      1        ONLINE  ONLINE       rac1                     Open                
      2        ONLINE  ONLINE       rac2                     Open                
ora.cvu
      1        ONLINE  ONLINE       rac1                                         
ora.oc4j
      1        ONLINE  ONLINE       rac1                                         
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                                         
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                                         
ora.scan1.vip
      1        ONLINE  ONLINE       rac1                                         
[root@rac2 u01]#

到这里归档模式的切换就完成。切换完成后最好做一次数据库全备。

gltyi99

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
11gRAC 使用ASM存储归档文件的归档模式切换

在前面的文章《oracle-归档和非归档模式》（http://blog.csdn.net/ora01555/article/details/22783289）演示了如何将数据库切换到归档模式，这篇文章只是进一步的延伸，演示一下RAC下如何调整。在11gRAC中，将归档文件更多的放到了共享存储并且使用ASM来管理，这样的好处就是恢复归档的时候，不在集群的各个节点去找归档，降低了恢复难度，减少了维
复制链接

扫一扫

专栏目录