在前面的文章《oracle-归档和非归档模式》(http://blog.csdn.net/ora01555/article/details/22783289)演示了如何将数据库切换到归档模式,这篇文章只是进一步的延伸,演示一下RAC下如何调整。
在11gRAC中,将归档文件更多的放到了共享存储并且使用ASM来管理,这样的好处就是恢复归档的时候,不在集群的各个节点去找归档,降低了恢复难度,减少了维护量。
二、切换归档模式
其实RAC和单机的数据库调整归档模式是一致的。例如RAC有2个节点,我们需要先关闭一个,然后再另一个节点调整,这个和单机库的调整是一致的,然后再启动另一个节点即可。
首先、关闭集群2节点数据库
此次、在集群1节点将数据库设置为归档模式
再次、将2节点数据库启动
最后、检查集群状态
到这里归档模式的切换就完成。切换完成后最好做一次数据库全备。
在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]#
到这里归档模式的切换就完成。切换完成后最好做一次数据库全备。